SOLVED

How to Prevent Salesforce Duplicate in Marketo

Go to solution
Charlotte_Berth
Level 2

How to Prevent Salesforce Duplicate in Marketo

Hello,
Our emails addresses in Marketo are not all synchronized with Salesforce and we don't want that to change. However, we want leads and contacts in Salesforce to be synchronized to Marketo. But we want to prevent duplicates from Salesforce in Marketo. How can we do this given the fact that even by preventing the duplicates, we need some fields from Salesforce to be added to the contact in Marketo (ex: SFDC Type,..)? Could we merge the Salesforce contact with the Marketo contact?

Any idea?

Many thanks
Best regards,

Charlotte Berthoud
1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to Prevent Salesforce Duplicate in Marketo


Could we merge the Salesforce contact with the Marketo contact?

Yes, You certainly can merge records in Marketo! In fact, CRM (SFDC, MS Dynamic) is one of the input sources where Marketo doesn't auto-de-duplicate on record creation, unlike other input sources like form fill, list import, etc. Check out this article on finding and merging duplicate people in Marketo on the experience league product documentation. By default, the winning person record would persist and its data values would take precedence in case of conflict (i.e. if the losing record also has a value for a field). Also, when a Marketo-only and a CRM synced records are merged, the CRM synced record is always persisted and considered as the winning record. See this Marketing Nation article on understanding merges in Marketo that explains it well with illustrations.

 

Possible Duplicate System Smart List 

Darshil_Shah1_1-1697127937168.png

Smart List filter: Duplicate Fields

Darshil_Shah1_0-1697127907268.png

As a bonus tip, you could create a recurring batch campaign in Marketo to look for possible duplicates (reference the Possible Duplicates standard system smart list available in the Database section or just pull the Duplicate Fields filter in the campaign's smart list) based on the email address with the person source as CRM and add those people to the static list for you to evaluate later.

View solution in original post

1 REPLY 1
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to Prevent Salesforce Duplicate in Marketo


Could we merge the Salesforce contact with the Marketo contact?

Yes, You certainly can merge records in Marketo! In fact, CRM (SFDC, MS Dynamic) is one of the input sources where Marketo doesn't auto-de-duplicate on record creation, unlike other input sources like form fill, list import, etc. Check out this article on finding and merging duplicate people in Marketo on the experience league product documentation. By default, the winning person record would persist and its data values would take precedence in case of conflict (i.e. if the losing record also has a value for a field). Also, when a Marketo-only and a CRM synced records are merged, the CRM synced record is always persisted and considered as the winning record. See this Marketing Nation article on understanding merges in Marketo that explains it well with illustrations.

 

Possible Duplicate System Smart List 

Darshil_Shah1_1-1697127937168.png

Smart List filter: Duplicate Fields

Darshil_Shah1_0-1697127907268.png

As a bonus tip, you could create a recurring batch campaign in Marketo to look for possible duplicates (reference the Possible Duplicates standard system smart list available in the Database section or just pull the Duplicate Fields filter in the campaign's smart list) based on the email address with the person source as CRM and add those people to the static list for you to evaluate later.