Data Clean Up and SFDC sync

[Anonymous]

We have Salesforce and Marketo synced, but I am trying to clean up my Marketo database without affecting my SFDC database. For example, we have thousands of leads that were synced over to Marketo that do not have email addresses. I want to remove them, but I need to assure that the SFDC record will stay intact. If I remove the leads from Marketo, won't Marketo simply sync them back up again (since they will still exist in SFDC)? 

Also, I'm being asked to remove all of the records with invalid (undeliverable) email address and duplicates. Can anyone give me some tips on best practices for cleaning up your database in general?

Thank you!

[Anonymous]

Hello Crystal, 

Here are some answers to your questions. 

Deleting leads in mkto:
Step 1: Create smart lists to isolate the records you want to delete (e.g. "Email Address is Empty")--i recommend keeping these together in a folder in a data management program. CAUTION: Be sure you DO NOT delete anyone from your database who is unsubscribed--otherwise, if they re enter your database via web form or list upload, they won't be set as unsubscribed and you may email them, thus violating can-spam laws.
Step 2: Hit "Select All" in the leads view of your smart list and select "Delete Lead" (deep breaths :))--this will bring up a window that asks you if you ALSO want to delete them from the CRM (Delete from CRM = True/False). Set it to FALSE and hit delete. This will remove the leads from your MARKETO database, but not SFDC. The records in SFDC that you just deleted in Marketo will NOT sync back over into Marketo unless they are manually pushed into Marketo from Salesforce. 

Duplicate management
Use the Marketo system smart list Possible Duplicates to view your duplicate records. Sort them by Email address (that's the field Marketo uses to define duplicate records). Rather than deleting the duplicates, it's better to merge them--select the records you'd like to merge, and hit Merge leads. This will bring you to a window that lets you pick what field values you keep and which you discard. 

General best practices
1) Well begun is half done: Instate a data management process immmediately for all means of record creation in both Marketo and Salesforce. Define the key fields you need for audience segmentation, routing/ownership assignment, reporting and contacting and set up processes to protect and populate them. This means working with your sfdc admin to make key fields required and picklisted to keep data standardized, ensuring that all Marketo forms built require the appropriate fields and use pick lists (NOT open text fields) for your internal processes or trigger data management processes that do populate those key areas, AND making sure that anybody uploading lists into Marketo or Salesforce is doing so with the correct fields populated correctly.
2) Automate: if there are areas of data that are difficult to keep clean, set up smart campaigns to standardize or populate them. Example: Smart list: if Country is US, U.S. USA, U.S.A, (continue with varations on United states), then (FLOW) change Country value to "United States." Make these smart campaigns a part of a larger Data Management program.
3) Watch: Databases tend towards entropy, so be sure to regularly review your duplicates, white space, and data standardization. I like to create a set of smart lists geared to my key dirty areas, as well as a report to see the higher level. The report is a Lead Performance report, and under set up I group the records by either Original Source Type, Source, Lead owner or another meaningful and consistently populated field. Then, i add my dirty smart lists in as custom columns so that wen i hit "report" i can see which Source is responsible for creating the most dirty leads each week. 

Hope this helps!
Elizabeth 

[Anonymous]

Hey Crystal,

For the Leads you remove from Mkto but want to keep in SFDC, one approach is to mark them so that if they are ever synched over, you can have a trigger campaign remove them. You can do this by placing a value in an existing field or by creating a custom field in SFDC and having it sync to Mkto. 

When you say remove, do you mean from Mkto or completely? We have set up a trigger campaign to watch for when an email is marked invalid. When this happens, they are marked Dead and are unsubscribed for good measure. When they are marked Dead, another trigger campaign picks them up and removes them completely from the database 6 months later (this is for internal reporting purposes). For the duplciates, you can outsource that to a vendor or you can alphabetize your Possible Duplicates list by email and start merging. Depending on the number of duplicates, it might make more sense to do it yourself, but there are vendors who do this. 

There are a number of other trigger/recurring batch campaigns you can create to manage the data. You can standardize State/Country or change any Lead without an Activity in 3 months, change status to Nurture. It all depends on what you are looking to do and what your biggest issues are.

[Michelle_Tizian]

For us what we did was create a check box field in SFDC for contacts and leads called sync to Marketo.  We identified the types of records we do not want to sync over to Marketo such as those who are missing email addresses, inactive (dead or no longer in business), those we do not or can't email market.  Once that's set up, we tell Marketo support that we created this sync to Marketo field and once they're done, on the Marketo end, we delete all of the records we don't want in Marketo.  

On a weekly basis, on Mondays, I check the system smart list in the leads database of records that are duplicates and merge any records.  Our duplicate records are really small and they are purposeful duplicates, it's only 32.  

[Anonymous]

Thanks everyone! Helpful info from all, I appreciate it very much. 
🙂

[Anonymous]

Hello all:

It's almost three years later and we have the same problem - thousands of SFDC imported contacts with no email address. Do the instructions given above still apply? If so, this looks pretty manageable.

All comments welcome.

Thanks.