sfmc // SQLPRODUCTION

Anti-Join / Exclusion Audience

Find records in a source population that do not have a qualifying event or membership.

sqlleft joinexclusionaudience

Trust & provenancePRODUCTION

Evidence tierPRODUCTIONOfficial sources0Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

SELECT
    s.SubscriberKey,
    s.EmailAddress
FROM [Eligible_Audience] s
LEFT JOIN [_Open] o
    ON o.SubscriberKey = s.SubscriberKey
    AND o.EventDate >= DATEADD(day, -30, GETDATE())
WHERE o.SubscriberKey IS NULL

Operational notes

Keep the date predicate in the JOIN when the business rule means “no matching recent event”.

Use indexed/compact join keys whenever possible.

Subscriber Engagement — 120 Day Flags

Create recent-open/recent-click flags and last engagement dates for an audience.

→

Deterministic Deduplication — Latest Record

Keep the most recent row for each logical identity using ROW_NUMBER().

→

Anti-Join / Exclusion Audience

Keep following the context.