dmug june 2017 - wordpress.com...records as master and merge prm records over. • in the same...
TRANSCRIPT
![Page 1: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/1.jpg)
1
Marketo DMUGJune2017Topic:DataIntegritytoMaximizePipelinePerformance
![Page 2: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/2.jpg)
Copyright2015TrendMicroInc.2
CRMCleanup
IPMigrationPlan
SmartFormsandWebhooks
![Page 3: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/3.jpg)
Copyright2015TrendMicroInc.3
![Page 4: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/4.jpg)
Copyright2015TrendMicroInc.4
StateoftheCRM
• OutdatedContactsonAccounts:Sellersdon’tfeelownership
• Emailmetricsskewed:Lowopenratesduetopoordata,segmentation
![Page 5: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/5.jpg)
Copyright2015TrendMicroInc.5
Contact/AccountCleanup:StateofAffairs– Oldrecordsaremuddyingthewaters
• InactiveUSEnterpriseContacts– 13,204(exclusivecountsbelow)
– MarkedasInactive:818– InvalidEmail:9,785– Emailbounce4x:2,599
• 30krecordsmarkedasInactivebyData.com– NoactivityloggedafterJanuary1,2014– Roughly12,700areEnterpriseContacts
» Overlapwithotherinactive13kisunknown
![Page 6: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/6.jpg)
Copyright2015TrendMicroInc.6
Contact/AccountCleanup:Solution– Suggestion:PartialDelete,Partial“Hide”
• Inactiveflagto“Hide”records– InactiveContactswithactivityhistoryorcampaignspost-2014– Updatereports/viewsforSalestoincludeinactiveflag.Pushinactive
downtobottom,maybeappend“z-”atfronttopushtobottomofviews.
• Delete“empty”records– Harddeleterecordswithnoactivityorcampaigns(Jigsawimports)– Excludethosewhohaveunsubscribed,ortiedtoOpportunity
![Page 7: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/7.jpg)
Copyright2015TrendMicroInc.7
2016Q2DataCleanup– USEnterpriseStep1:MergeDuplicateRecords
Step2:DeleteInactiveContactRecords
Step3:AdjustAccountContactViews
![Page 8: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/8.jpg)
Step1:MergeNABUDuplicateRecords
Lead->Lead Lead->Contact Contact->Contact
Duplicateidentifier=exactEmailAddressmatch• IfanemailexistinginbothCRMrecordsandPRMrecords,takeCRM
recordsasmasterandmergePRMrecordsover.• Inthesamerecordtype,takelatestactivitydateasthemaster.• Inthesamerecordtype,takelatestmodifieddateasthemaster.• KeephighestLifecycleStatusasmaster(WON>OPP>SQL>MQL>
AQL>Prospect>Suspect)
Duplicateidentifier=exactEmailAddressmatchonSameAccount• Inthesamerecordtype,take
latestactivitydateasthemaster.
• Inthesamerecordtype,takelatestmodifieddateasthemaster.
• KeephighestLifecycleStatusasmaster
Initialdatacleanse:*LeadMergeswillbeforallCRMNA/PRMNAcontactandleadrecords*ContacttoContactMergewillbeonlyforUSCRMNARecords
![Page 9: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/9.jpg)
Copyright2015TrendMicroInc.9
Step2:DeleteInactiveContactRecords• Batch1:LegacyEnterprisewithNoActivity
– CurrentCount:24,000Records– FilteredBy:1AND2AND3AND(4OR5)LinktoSFDCReport1. LastActivity equalsNULL2. Region equals EnterpriseWest,EnterpriseCentral,EnterpriseSouth,Enterprise
Northeast,EnterpriseWestInside,EnterpriseNortheastInside,EnterpriseSouthInside
3. ContactRecordType equals CRMNAContact4. LifecycleStatus equals Suspect,Prospect5. LifecycleStatus equalsNULL
ExcludingContacts:• TiedtoOpportunities• CreatedbyTechSupport• TiedtoCases• LeadSource=Order• RenewalContact
![Page 10: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/10.jpg)
Copyright2015TrendMicroInc.10
Step2:DeleteInactiveContactRecords• Batch2:Active=FalseRecords
– CurrentCount:1,200Records– FilteredBy:1AND2AND3AND(4OR5)LinktoSFDCReport1. Region equals EnterpriseWest,EnterpriseCentral,EnterpriseSouth,Enterprise
Northeast,EnterpriseWestInside,EnterpriseNortheastInside,EnterpriseSouthInside
2. ContactRecordType equals CRMNAContact3. ActiveequalsFalse4. LifecycleStatus equals Suspect,Prospect5. LifecycleStatus equalsNULL
ExcludingContacts:• TiedtoOpportunities• CreatedbyTechSupport• TiedtoCases• LeadSource=Order• RenewalContact
![Page 11: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/11.jpg)
Copyright2015TrendMicroInc.11
Step3:AdjustAccountContactLayout• Goal:MakedefaultContactlayoutonAccounts“UserFriendly”forSales– SortAlphabeticallybyFIRSTNAME– ForCRMNARecordswith“Active=False”
• Marketo toappend“ZZ-”toFirstName• BasedonAlphabeticalview,Inactiverecordspushtobottomoflist
![Page 12: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/12.jpg)
Copyright2015TrendMicroInc.12
ProposedDataCleanupTimeline
Step1:MergeDuplicateRecordsProposedCompletion:June3Completedby:USMarketing,CorporateBATeam
Step2:DeleteInactiveContactRecordsProposedCompletion:June10Completedby:USMarketing,CorporateBATeam
Step3:AdjustAccountContactViewsProposedCompletion:JuneSFDCRelease(June9)Completedby:USBATeam
![Page 13: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/13.jpg)
Copyright2015TrendMicroInc.13
GroupQuestions
• WhatchallengeshaveyoufacedwithyourCRM?
• Howareyouaddressingtheseissues?• Whattools/solutionshaveyoufoundtobemosthelpful?
![Page 14: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/14.jpg)
Copyright2015TrendMicroInc.14
![Page 15: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/15.jpg)
IPwarm-upfreezedates(approximately20-50kemailsperday)
IPramp-updays(doubleemaildropsdaily)
RegionalEDMdropplansdue
Datagovernance&“freeze”datesannounced
Datacleanuptriggersactivated
IPwarm-upcalendarfinalized
Prop
osed
Tim
eline
![Page 16: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/16.jpg)
Copyright2015TrendMicroInc.16
IPAddressWarm-upPROPOSED DATE:December26– 30th orJanuary2– 6th
• SuspendsendsfromanyoneexceptaregionalGuru/lead
• ReviewEDMcommunicationsschedulefor eachregion forDec18throughJanuary13 (duedateDec12)
• Createcentralcalendarwithscheduleofemaildropsandestimatedcount(GoogleDocsviaSlack)
• Suspendnurtureprograms(mostlyimpactsNABU)
à QuestionsforMarketo: Howdoweekendsimpactwarm-upschedule?Canthe“IPswitch”bescheduledforacertaindate/time?
à QuestionsforTrend:Anyautomatedemailsthatwillcauseimpact?
![Page 17: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/17.jpg)
Copyright2015TrendMicroInc.17
CommunicationPlantoRegions• FirstRoundCommunication
– Communicatethechangeandwhy– Requestupcomingemailschedule
• SecondRoundCommunication– “Freeze”datesandpermissionchanges(Jan1– Jan10)– Newdatagovernance/clean-up rules– Useofexclusionlists
![Page 18: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/18.jpg)
Copyright2015TrendMicroInc.18
DataCleanup&GovernanceAUTOMATEDCAMPAIGNS
• BounceduetoSPAMMarketingSuspend=True
• OngoingSoftBounce4xin60days, EmailInvalid=True
• TriggerEmailAddressChangedEmailInvalid =False(SherlockRefresh)
• InactiveUsers(RegionDefined)MarketingSuspend=True
MANUAL PROGRAMS• QuarterlyInactiveDeletions
DeleteLeadsthathavenotengaged;tobedefinedandownedbyRegions
• “WaketheDead”ProgramsRe-engagementcampaignswithprovocativeCTAs(regiondefined)
• MasterExclusionListsReviewrules,ensureimplementedacrosseveryregion.
1 2
![Page 19: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/19.jpg)
Copyright2015TrendMicroInc.19
MarketingSuspendedCampaigns
![Page 20: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/20.jpg)
Copyright2015TrendMicroInc.20
Marketing“Un-Suspend”Campaigns
![Page 21: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/21.jpg)
6/27/17 21
Prop
osed
Tim
eline
Confidential | Copyright 2016 Trend Micro Inc.
![Page 22: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/22.jpg)
Copyright2015TrendMicroInc.22
IPLaunchSuccess
• Improveddeliveryratesduetoremovalofthe“garbage”• Betterabilitytoanalyzecontentacrosssegments• USdeliveryratescontinuetoaverage97%orhighersinceIPlaunch
![Page 23: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/23.jpg)
Copyright2015TrendMicroInc.23
GroupQuestions
• AreyouonaDedicatedorSharedIP?• Ifyou’reonaDedicatedIP,howdidthemigrationgo?
• HowareyoumanagingOOObounce-backs?• Howareyoumanaging“inactive”namesinyourdatabase?
![Page 24: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/24.jpg)
Copyright2015TrendMicroInc.24
![Page 25: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/25.jpg)
Copyright2015TrendMicroInc.25
RichFormsviaHiddenDataAppends
25GetWhiteWalkerreportnow
Hiddendatafields:
![Page 26: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/26.jpg)
Copyright2015TrendMicroInc.26
DataWebhooks
26
![Page 27: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/27.jpg)
Copyright2015TrendMicroInc.27
DataWebhooks – Marketo View
27
![Page 28: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/28.jpg)
Copyright2015TrendMicroInc.28
AutomatedListManagement
FULLTIMEJOB!
5mediavendorsx2listsperweek,x52weeks=520lists(formediabuys
alone)
Standardizationoflists,validationofemail,
validationofcampaigncriteria
Reportingbacktomediavendorforcredits/new
leads.
Savealotoftimeandmoneywiththisstepalone!
![Page 29: DMUG June 2017 - WordPress.com...records as master and merge PRM records over. • In the same record type, take latest activity date as the master. • In the same record type, take](https://reader033.vdocuments.us/reader033/viewer/2022041908/5e65b4163492bf304a3f1643/html5/thumbnails/29.jpg)
Copyright2015TrendMicroInc.29
GroupQuestions
• Howareyouappendingmissingdataonyourrecords?
• Doyouhavespecificrulesforappendingversusoverwritingdata?
• Whattoolshaveyoufoundtobethemosthelpfulinyourappendingprojects?