2 of 2 people found this helpful
Actually, Unsubscribes DO COUNT against your total.
Here are some other good tips from our friend, Josh: http://developers.marketo.com/blog/how-to-clean-your-marketo-database/
4 of 4 people found this helpful
Thanks Dan. I vaguely recall Marketo now saying that unsubscribes do count against you...or maybe that was Invalids who were not unsubbed.
@Colby, anyway, you have the right idea. But consider what I say in the post too:
- focus on non Customers and non SFDC Contacts to avoid removing legally required information.
- try removing 180day inactives or have a plan to reactivate and then remove non respondents.'
- anyone who hard bounced twice.
- Anyone who is email invalid=true
- anyone marked Invalid or Junk
- inactive unsubscribes - I guess I'd be a bit careful about these.
- archive these with all columns someplace safe. There are particular laws for the storage of such information, so ask IT to help you find an encrypted location to store this data.
Side note as to processing this all. Should I delete in MKTO and then also in SFDC? Which should happen first so as to avoid re-syncing? With that, do I perhaps run a campaign that sets all of the 'to-be' deleted leads to not sync to SFDC, delete in SFDC, and then delete in MKTO?
If you choose to delete leads you'll want to do it in Marketo with the Delete Lead flow action, and the Delete From CRM/Salesforce option set to true. If you delete them in Marketo only, and they still exist in SFDC, then they will be synced back down as soon as any update is made to them in SFDC.
Let's say the records are only deleted in Marketo and kept in SFDC. What you're saying is, as soon as an update is made in SFDC to those SFDC-only records, it would be synced back to Marketo, correct? What constitutes as an update? Like visited webpage? Fills out form?
If that is the case, then wouldn't that be acceptable? Because that means that previously inactive/unsubscribed lead has engaged again, so what would be the problem with being synced back to Marketo again? I realize the Marketo record would not have the majority of the history in the activity log (except for the activity that's in Sales Insight, right?) so it would still look like a new lead to Marketo.
Also, what happens if a previously deleted lead DOES become engaged again and they still have an existing SFDC record? Would the newly created Marketo record be attached to the existing SFDC record based on email address/cookie? OR would the "new" Marketo record create a duplicate SFDC record? Is there a workflow you can suggest to keep "new" Marketo records with existing SFDC records as clean as possible? Ie, lead is created + sfdc id is not empty or sfdc created date is not empty, then... merge? I know there's no "merge" action, but is there a comparable action?
For duplication, I think you can try TIBCO Clarity. It has a really powerful and robust de-duplication function.
You can customize your match strategies by columns or by swappable columns or by columns against to a thesaurus table, and then use them to discover duplicate records from any incomplete or partially similar records, even from records in different languages.
In addition, It has deep integration with both Salesforce and Marketo. It can help you directly update and remove duplication data in your salesforce and Marketo account.
you can try TIBCO Clarity for free. https://clarity.cloud.tibco.com/landing/index.html
says the principal engineer of TIBCO...