SFDC/MKTO Duplicate Records (Best Way to Dedup) | Adobe Higher Education
Skip to main content
Jason_Kaiser
Level 1
October 4, 2018
質問

SFDC/MKTO Duplicate Records (Best Way to Dedup)

  • October 4, 2018
  • 1 の返信
  • 1678 ビュー

So, after a year and a half, we finally connected our CRM to Marketo (I know, I know ... late). While we were waiting to get these connected, we've been uploading lists from SFDC into Marketo in order to send emails. Just this past week, we were able to get our CRM hooked up (yay) but now we have thousands and thousands of duplicate records. Email is the same, but we want to match up the MKTO record to the SFDC record.

Questions:

1. We do not have the budget for a paid solution, so are there other methods we could that would work in this case?

2. One of our partitions hasn't been filled. Is there something we can append the SFDC record before syncing that would make Marketo go "oh, I know who you're reaching to ... I'll magically match that for you."

I just find it strange that there's no simple-ish solution for the dups, or a rule that I could say "take lead score but update all the other data with what SFDC brings over."

Any help would be greatly appreciated. We really don't want to manually go through thousands of records one by one.

Thanks!

このトピックへの返信は締め切られました。

1 の返信

SanfordWhiteman
Level 10
October 5, 2018

You don't need a "paid" solution per se, but you're going to need some level of technical effort.

What I would do is

  • save the Probable Duplicates list as a CSV
  • group by Email Address in Excel, determine the primary lead
  • update Marketo using the REST API Merge Lead endpoint