0

Scenario: Salesforce connector is in place and there are contacts associated to accounts that have a unique contactId but have the same email address. If I have a data extension build off a query and the journey has a no-reentry criteria, will 1 email address receive 2 emails since the subscriberkey's are unique?

Desired result is for 1 email address to be entered into journey.

2

Correct, in this scenario you would be sending the Journey email twice to that Email address.

This actually is one of the core reasons why there exists a unique identifier for contacts, so that you could, if needed, send multiple emails to the same Email address.

Whether a subscriber appears multiple times on a list, group, or data extension to be sent a message. Subscriber key allows an email address to be included multiple times related to different subscriber key values.

In order to send to only one Contact as you've described as the desirable result, you can pick either solution below:

1) Set the Email field as Primary Key in your target Data Extension, this way only unique Email addresses are allowed to be added.

2) You modify the SQL query to update the target Data Extension by using PARTITION BY command.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.