I pulled a list of unengaged subscribers that have not opened at least one of our last 3 monthly sends. I want to suppress these contacts from our filtered data extension which we use to send to. How do I do this? And how would I keep this automated to continuously remove unegaged contacts.
#Marketing Cloud #Filter Data Extension
Exclusion at send time and filtering at build time solve different problems, and you want the second one.
A filtered data extension re-evaluates its filter on its own, so if unengaged can be expressed as a filter on fields that live in the source DE, add it there and you are done. The catch is that open data lives in the tracking data views, not in your sendable DE, so a filter cannot see it.
That is why this usually becomes a SQL Query Activity in Automation Studio writing to a sendable DE, joining your audience against _Open for the last 90 days and keeping the non-matches. Put the query ahead of the send in the same automation so the list is never stale.
Decide one thing before building it: whether unengaged means no opens, or no opens and no clicks. Open tracking has been unreliable since Apple Mail Privacy Protection, and a suppression list built on opens alone will cut people who are reading.