How to remove duplicates created through SFDC

[Anonymous]

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?

[Josh_Hill13]

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]

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.