Re: Deduping by SFDC Account ID

Stephen_Moore
Level 2

Deduping by SFDC Account ID

I want to deduplicate a list of people in Marketo using the SFDC Account ID.  This isn't possible using the Marketo Duplicate Fields filter.  Does anyone know of a good workaround?

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: Deduping by SFDC Account ID

Export to spreadsheet, dedupe, and reimport is going to be the sanest approach.  (I'm assuming you aren't/don't have a developer, though for a one-off the API isn't much better here.)

Stephen_Moore
Level 2

Re: Deduping by SFDC Account ID

This wasn't the answer I was hoping for.
I was looking for a solution within Marketo.

SanfordWhiteman
Level 10 - Community Moderator

Re: Deduping by SFDC Account ID

Sorry, not possible.

If you wanted to get close-to-crazy I suppose you could [1] create a custom String field, [2] copy the First Name to that field using Change Data Value, [3] copy the Account ID to the First Name, [4] dedupe on First Name, [5] set everything back.