Creating duplication (dupe) rules in Marketo

Anonymous
Not applicable

De-Duplication in Marketo

By default, Marketo will dedupe new records by email address. If there already is a record in Marketo with the same email address, that record will be updated with the new information. If no matching email is found, a new record is created.

If you set up a custom dupe rule, Marketo will match on email as primary key, and another field as a secondary key. For example, if you add Last Name as a secondary dupe field, Joe Smith (smithenterprises@comcast.net) will create a new record, even though Catherine Doe with the same email address is already in the database. This is because both email address and last name need to match to update the existing record. So if Joseph Smith (smithenterprises@comcast.net) is entered, the first name will be changed from Joe to Joseph, because both email and last name match.

Custom dupe rules apply to list uploads, form submissions and to most API calls. It does not apply to the native CRM sync, which matches on CRM ID instead of email.

Common scenarios

Custom dupe rules are typically used for a limited number of scenarios.

Dupe by Lead Partition

The most common scenario is if the Marketo instance has multiple partitions that need to be independent from each other. Normally, the same Lead can exist in only one partition, not in multiple. However, when you add “Lead Partition” as a custom dupe rule, a record with the same email address can exist in multiple partitions. This can be useful if two completely separate business units are on the same Marketo instance.

Dupe by First Name

If multiple members of a household use the same email address, dupe by first name ensures that all members get their own record in Marketo. However, if multiple household members are part of the same email send, only 1 email will be sent (to the first created record). Trigger emails can be sent to both records individually. Communication Limits apply to each record separately, so with a  limit of 5 emails and 2 records with the same email address, the email address can receive up to 10 emails per week. If someone uses multiple variations of the first name (e.g. Beth & Elizabeth), this creates unintentional duplicates.

Dupe by Last Name

Dupe by Email and Last Name is often used if multiple employees of the same company use the same email address. The same caveats as for “first name” apply. Also, it is less and less common that people don’t have their own email address.

Dupe by Foreign Lead Key

Some companies maintain their own unique lead key, which allows multiple records with the same email address. To be able to replicate this in Marketo, this lead key can be added as a custom dupe field. However, all form submissions and list uploads will also need to include this Lead Key, otherwise additional duplicates are created. This scenario is therefore often not advisable.

7399
5
5 Comments
TBouscal
Level 1

This says nothing about creating duplication rules in Marketo as the title clearly suggests.
Thanks for the why, where's the how?

I'm tired of Marketo dumping duplicates into our sf org.

Jo_Pitts1
Level 10 - Community Advisor

@TBouscal ,

what is the scenario in which you are getting duplicates in your sf org?

Cheers

Jo

 

SanfordWhiteman
Level 10 - Community Moderator

@TBouscal I recommend creating a new thread in Products with your question. @Jo_Pitts1 will get to it there and it’ll also have more visibility.

TBouscal
Level 1

Hi @Jo_Pitts1 the duplicates were being blocked by Salesforce rules with the expectation that a match on email address would update the existing contact or lead.  Once those were deactivated the push from Marketo is creating duplicates.  

Jo_Pitts1
Level 10 - Community Advisor

@TBouscal ,

mate can you create a new thread in the discussions forum detailing the problem you are having from start to finish.  From that, we'll see what we can work out.