How to use In Result and Not in Result filter types?

the in result and n ot 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 https //vimeo com/683707869 https //support deselect com/hc/en us/articles/360005239378 filter types in deselect segment