7 Replies Latest reply on Sep 24, 2018 12:26 PM by Grégoire Michel

    SFDC-to-Marketo Sync question

    Andrew Seidman

      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?





        • Re: SFDC-to-Marketo Sync question
          Kevin Weisenberger

          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.

          • Re: SFDC-to-Marketo Sync question
            Sanford Whiteman
            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.

              • Re: SFDC-to-Marketo Sync question
                Andrew Seidman

                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?



                  • Re: SFDC-to-Marketo Sync question
                    Grégoire Michel

                    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.



                • Re: SFDC-to-Marketo Sync question
                  Pavel Plachky

                  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,