Leads ands Contacts in SFDC

[Anonymous]

Hi All,

I have a quick question. I set up a campaign in Marketo and I have set it up to not send to contacts within Salesforce. I only wish to send to leads. I have done this by applying the filter in the smart list of SFDC type is not contact. What I have found though, is that some contacts also have leads with exact same email address and details. These contacts ended up receiving these emails. Has anyone else encountered this problem before? Is the reason that the contact is receiving the email because there is lead? if anyone can help me answer this it would be greatly appreciated.

Cheers,

Nick

[Grégoire_Miche2]

Hi Nick,

I gather from what you write that your smart campaign is sending emails and that have lead/contact duplicates (with the same email address) and therefore they receive the email since the SFDC Type = contact filter does not exclude the leads.

There is not much you can do about it as Marketo does not allow easily to cross reference records. You could create a smart list of duplicates that are also contacts, export the list of email addresses and add them to an excluding list (email address is not ...) but this will require and export each time you want to shoot your campaign. Not very convenient...

The truth is that having lead/contact duplicates is something you need to address through revision of your lead management process + the addition of duplicate control in SFDC to prevent this from happening. In the same time, you should consider merging them in SFDC (through a conversion of the leads). You can also consider investing into a duplicate cleansing tool that can work in SFDC and merge these duplicates automatically.

The last thing that can be done is an SFDC trigger on leads that checks the database for existing contacts with the same email and flags the leads in that case in a dedicated field that you sync to Marketo. Then you filter out these leads on this fields.

-Greg