How to remove duplicates created through SFDC

Anonymous
Not applicable

How to remove duplicates created through SFDC

We have over 45000 duplicate records created due to the sync from sales force and mannual data upload in Marketo.

What's the best way to avoid this in future. Also, is there any tool that can automate the merge of these duplicates foolproof or do we have to do that mannually?
Tags (1)
2 REPLIES 2
Josh_Hill13
Level 10 - Champion Alumni

Re: How to remove duplicates created through SFDC

There is no amazingly awesome way to dedupe automatically here. You need to do this:
  1. Get Marketo Easy Merge or Demand Tools or RingLead to merge your records.
  2. add Dupeblocker to your SFDC to stop sales from creating dupes
  3. upload leads only into Marketo 

See more ideas here
http://www.marketingrockstarguides.com/six-principles-data-cleanliness-1566/
Delinda_Tinkey1
Level 5

Re: How to remove duplicates created through SFDC

In the future, do all of your uploading through Marketo and not through Salesforce.

No automated de-duper is 100% fool proof. I think RingLead has or is close to having a tool that can clean up this scenario, but I haven't been able to closely research it myself yet.