Duplicate Lead Created in Salesforce When Contact Already Exists | Community
Skip to main content
January 9, 2018

Duplicate Lead Created in Salesforce When Contact Already Exists

  • January 9, 2018
  • 14 replies
  • 9245 views

Issue


Marketo is creating duplicate Lead records when a Contact record is already synced.

 

 


Solution


This happens when a Smart Campaign using the Sync Person to SFDC flow step qualifies a SFDC Contact record and attempts to assign the record to a Queue in Salesforce. When a SFDC Contact runs through the Sync Person to SFDC flow step, since Salesforce does not allow "Contacts" to be assigned to Lead Queues, Marketo will create an intentional duplicate "Lead" record in Salesforce and add the new Lead record to the queue.

If you want to prevent this behavior in your Smart Campaigns, add the filter "SFDC Type is not Contact" to the Smart List. This will disqualify SFDC Contact records from the campaign.

Another option: Add Choice options for the Sync Person to SFDC flow step and have the first choice be SFDC Type is Contact Do Nothing. This will cause SFDC Contact records to Do Nothing for the flow step but Lead or Marketo only records will process normally.

 

 

 

Who This Solution Applies To
Customers integrated with Salesforce

 

 


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

14 replies

Nina_Gonzalez1
Level 3
January 9, 2018

i actually need Marketo to create a duplicate lead. Can you provide more information about how to force a duplicate lead to be created.

Roxann_McGlump1
Level 5
January 9, 2018

It would depend on the circumstances in which you wanted to create a duplicate. Can you provide more detail on what you are trying to do?

Nina_Gonzalez1
Level 3
January 9, 2018

Yes, our marketing and sales process happens on the lead object. Even returning clients get "enrolled" from the Lead object. We actually plan to change this in the future by implementing Opportunities, but for now, when a returning client is interested in purchasing our services again (there is usually 1 to 3 years between return enrollments), we need to create a Lead for the returning client.

Roxann_McGlump1
Level 5
January 9, 2018

Marketo will accept duplicate leads from Salesforce, so if you create the duplicate leads in Salesforce and then sync them to Marketo, that would be one way to do it.  Another option would be to work with support to set up custom deduplication rules, so that Marketo will only deduplicate leads that have the same email + other field you designate.

February 8, 2018

Correct me if I'm wrong. (Marketo/SFDC integration) My understanding is by default, a new lead is created in Salesforce when someone fills out a form with the same email as an existing contact. But for some reason, our instance isn't doing this. If someone fills out a marketo form using the same email as an existing contact, it will be merged in the same contact inside Salesforce. We actually prefer to have a new lead created and synced => auto assigned to the queue. Any suggestions?

Nina_Gonzalez1
Level 3
February 8, 2018

We solved this by creating a workflow in Marketo and in SF that creates the duplicate lead. If a contact in Marketo completes a form, Marketo updates a field on the Contact called "Create New Lead" to true. When this syncs with SF, a workflow in SF creates a new lead. It also updates a field on the Contact to stop ongoing sync with Marketo, so all new Marketo activity is on the new lead. We also plan to move to Opportunities, so we don't have to create leads for returning clients, in the future.

Roxann_McGlump1
Level 5
February 8, 2018

Hi Bobby,

If someone submits a Marketo form with an email that already exists in Marketo's database, it will update the existing record regardless of whether that record is a lead or a contact in Salesforce, and update that existing record in Salesforce. If you want form fillouts to create new Marketo records that would be sent to Salesforce as leads, you would need to work with Marketo support to set up custom de-duplication rules.

Stephanie_Byng
Level 1
March 1, 2018

"This will disqualify SFDC Contact records from the campaign." What does this mean? Does this mean that if a contact fills out a form on a campaign, Marketo won't allow it? Or that Marketo won't sync to Salesforce the contact's updated status? I'm trying to get Marketo to stop creating duplicate leads for contacts already in our database. In my situation I'm using Marketo for RSVP forms. A big chunk of my events only go out to known contacts, so all I need Marketo to do is update the person's campaign member record to "registered" when they rsvp. The people are already in the campaign as "invited." The link to the RSVP form includes a query string with the person's email address. This is prefilled into a hidden "email address" field on the form. For some reason, for every event, a handful people will register for our events using the URL with the query string and Marketo will treat them like a new lead. I've removed SFDC sync from the Marketo Program and updated my flow steps to update the marketo program status to registered on form fill, and also change the salesforce campaign member status to registered. I had hoped this would stop all the other SFDC flows that could cause contacts to flow through the queue. Even so, some people are still going through an SFDC insert and Marketo is adding them to the campaign as a new lead.  Why would Marketo see an email address on a form that matches an existing contact and still decide to create a new lead? Could it be an issue with the munchkin tracking?

Nina_Gonzalez1
Level 3
March 1, 2018

It is my experience that the new activities will log to the existing contact and any use of the existing email address should automatically link. The only time I have seen Marketo create a new lead is when a new lead is created in SF. So if you have new activity in Marketo which is set to sync with SF but the existing record is set to not sync with Marketo, then SF will create a new lead record. Is that consistent with your experience.

August 12, 2019

Hi Nina - We are dealing with the exact same problem. Would you be able to share the exact implementation that you have done. Both @ Marketo end and SFDC end..