The in result and not in result filters allow you to compare your target Data Extension (DE) against another DE—without doing a full data join. Think of them like subqueries that help include or exclude records based on their presence in another segment result.
These filters are key for exclusion logic, targeting based on past engagement, and suppressing previously contacted audiences.
In Result
The in result filter includes only those records in your target DE that also appear in the result of another DESelect Selection.
How it works?
You compare a field (usually an ID or email address) from your main DE to the same field in another DE or Selection.
Example: You want to target users who opened a specific email last week.
Not in Result
The not in result filter does the opposite—it excludes records from your current segment if they appear in another DE or Selection.
Example: You want to send a campaign to all customers except those who have already received it.
Common cases for In Result and Not in Result
| Filter Type | Use Case Example |
|---|---|
| In Result | Target contacts who completed a survey, clicked a specific link, or made a purchase |
| Not in Result | Exclude users who already received a campaign, unsubscribed, or are on a DNC list |
Comments
0 comments
Please sign in to leave a comment.