Skip to main content
A
Andrew_Seidman
Level 2
September 21, 2018
Question

SFDC-to-Marketo Sync question

  • September 21, 2018
  • 3 replies
  • 5239 views

We have a lot of leads/contacts in SFDC that are NOT synced to Marketo. We have a custom Sync Rule -> in order for any SFDC lead/contact to sync to Marketo, they need a true/false box "Sync" to equal TRUE.

Some of our leads/contacts in SFDC have records in Marketo that are not Synced (e.g. John Smith exists in SFDC with Sync = FALSE; then, John Smith gets added to Marketo as a separate record). When we click SFDC-John's checkbox to TRUE, he gets added as a duplicate to Marketo (so now there are two John Smith's in Marketo). Is there a way to avoid this and sync the two records together, rather than create these duplicates?

Thanks,

Andrew

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Kevin_Weisenber
Kevin_Weisenber
Level 4
September 21, 2018

Do you have advanced de-duplication rules enabled? If so this could be affecting it. Example -if you have Partition AND Email for de-duplication and the contact exists in a different partition that your assignment rules for your Salesforce contact this would result in a duplicate being created.

SanfordWhiteman
SanfordWhiteman
Level 10
September 22, 2018
Is there a way to avoid this and sync the two records together, rather than create these duplicates?

Not without another layer, i.e. RingLead or similar, continually mediating and merging.

The situation you're describing here is only "duplication" in the sense that you want First Name, Last Name and (though you didn't mention it, I assume) Email address to be used a compound primary key for new leads. But that isn't something that the Marketo ←→ SFDC sync enforces on its own.

Also, when you use a custom sync rule, it suggests that SFDC is your system of record, ergo you shouldn't be adding people on the Marketo side first.

A
Andrew_SeidmanAuthor
Level 2
September 23, 2018

Thanks for the response; the issue is this:

We have 190k records in SFDC but only want to keep 40k records synced to Marketo. So, if a new record is created in Marketo by someone filling out a Marketo form on-page, they are created in Marketo first, then synced to SFDC. There, duplicate rules currently allow them to be created as a Lead even if another Lead is present with the same email address.

Conversely, if a lead is in SFDC AND in Marketo but they are NOT synced (two separate records), when we sync from SFDC into Marketo it creates a duplicate as well. The infrastructure is a mess, do you have any recommendations? ringlead?

Andrew

Grégoire_Miche2
Grégoire_Miche2
Level 10
September 23, 2018

Hi Andrew,

Marketo database should be a superset of SALESFORCE database, not the opposite. I understand the fact that you might not want 190k records in Marketo because of the license cost, but you maybe you could at least try to have all the records that are potentially active in SFDC to be in Marketo as well. Sales contact tend to pay a visit to your web site. That‘s a given  

Ringlead provides an interesting technology, as it can hook both to Marketo and Salesforce and fix the duplicate almost immediately. So it’s an alternative to opening the sync more broadly.

there is a metric I use when discussing duplicate issues and budgets:

if preventing duplicate  creation costs 1, fixing it afterwards costs 10 and living with duplicates costs 100.

-Greg

pavel_plachky
pavel_plachky
Level 5
September 24, 2018

Hi Andrew,

there is no out of the box solution to prevent duplicates in this situation. I heard of people having a good experience with RingLead. If you would like to implement a custom solution, it could look like this:

1. Create a web service that uses Marketo REST API to merge two or more records

2. Create a trigger campaign with the following smart list: When a person is created from Salesforce.com and the person is member of possible duplicates smart list:

3. The trigger campaign created in (2) will have a flow step to call a webhook to web service you created in (1)

Kind regards,

Pavel

Terms & ConditionsAccessibility statement

Loading footer...