I'm wondering if there is a way to create a suppression list that looks at data and adds or removes contacts to that suppression list based on whether a person meets that particular criteria at the time of send. Pardot does this through a dynamic list. Is there something similar for Marketing Cloud or does this have to be done through SQL?
You are looking for an Audience Exclusion Script. Essentially, there is the option in your interaction to add some ampscript logic that will exclude subscribers who are in the sendable DE that also meet the criteria outlined in the script.
does the send happen at predictable time intervals?
If so, you could:
- Step 1: write a SQL query activity (if you have the technical knowledge) or a DESelect "selection" (if you prefer a UI and don't mind introducing a third party tool)
- Step 2: create an automation and put the query / selection in it and schedule this so that the Data Extension is refreshed on an hourly/daily/... basis