How do i need set up my Contact Model in oder to check a DE of email_address.
I am working with the following constraints/rules.

1) CRM (Salesforce) allows for multiple records to have the same email_address

2) Using Salesforce Entry event to inject records in real-time.

3) I need to put duplication email address down a new Journey Path, so that the customer can take a real-time action on these duplicate records. For example, if email is found my SFMC DE, then create a task in the CRM for the sales team Admin to merge the record.

ContactKey Look-ups fail b/c the new record has a new contactkey.

all solutions I have come up with result in automation running hourly, and break my real-time requirement.

Thanks Pat

enter image description here

1 Answer 1


You can't add your synchronised data extensions back into the contact model, as they're already part of it, so you'd need to create some sort of reference table, "email_duplicates", to do your lookup against. Here are the fields:

enter image description here

Create yourself an Automation with an SQL Query Activity to update this table periodically. The query's body should look like this:

  COUNT(1) AS address_count

Add your reference table to Contact Builder's attribute groups and link your reference table based on Contact.EmailAddress = email_duplicates.email.

enter image description here

Use your reference table for decision splits based on email_duplicates.email_count is not null.

enter image description here

Observe how new contacts with email addresses already in your Contact_Salesforce synchronised data extension go down one path and totally new contacts (based on email address) go down another:

enter image description here

  • Macca - i appreciate your detailed answer, i did everything listed and the Decision is not working. I am going to add more details in comments below in a minute Commented Jun 8, 2020 at 18:09
  • "Not Working" in what way?
    – Macca
    Commented Jun 9, 2020 at 0:57
  • Hi @macca i just added a picture.. all of the contacts are failing the look up when they should be matching. I have confirmed the data, its loading and the email address are there Commented Jun 9, 2020 at 1:39
  • Thanks for your help! Commented Jun 9, 2020 at 1:40
  • 1
    Yes. That'd make sense. These are brand new contacts we're evaluating. Try changing the relationship in Contact Builder by relating your email_duplicates.email to your Journey Data Extension's email address.
    – Macca
    Commented Jun 10, 2020 at 22:41

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .