Email address de-duplication at the segment level

(0) Share

Report

Posted on by SW-29051408-0

We have the Email De-duplication feature turned on in our Customer Insights Journeys settings which helps when we send the email.

The issue is that when we are creating a segment for a Journey, we do not have an accurate idea of the send volume because the duplicated addresses are in the segment. Is there a way that we can de-dupe at the segment level rather than at the journey level so that we know how many UNIQUE people will be sent our communication?

Categories:

Dynamics 365 Customer Insights - Journeys

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Muhammad Shahzad Sh... 2,336 Most Valuable Professional on at

Like (0)

Report
Email address de-duplication at the segment level

Pre-filter in Segment Definition (Recommended)
1. Create a custom segment with deduplication logic:
   - Use "Contact Point - Email" entity as your base
   - Add filter: `EmailAddress1 (State) = Active` (or your primary email status field)
   - Include additional conditions to identify preferred/primary emails

2: Temporary Workaround
Add a calculated column to your segment view:
-- Example SQL for segment view ROW_NUMBER() OVER(PARTITION BY EmailAddress ORDER BY CreatedOn DESC) AS EmailRank

Then filter where `EmailRank = 1`

Was this reply helpful? Yes No