In Salesforce Pardot we have dynamic list which behaves as below:
When the criteria matches, Pardot adds them to the list for you. When the criteria no longer matches, Pardot takes them off the list for you.
Similar thing I want to implement in salesforce marketing cloud.
Means a dynamic suppression list which will work with email frequency capping.
A subscriber should not get more than 2 email in a week.
Used below sql for automation
select tde.SubscriberKey, tde.EmailAddress, 'False' as FrequencyCappingFlag from FrequecyCappingTargetedDE tde inner join _sent sdv on tde.SubscriberKey = sdv.SubscriberKey where sdv.EventDate > DateAdd(day, -(convert(int, (select value from Configs cs where cs.[key] = 'DaysForCapping'))) , getdate()) Group by tde.SubscriberKey, tde.EmailAddress having count(tde.EmailAddress) > convert(int, (select value from Configs cs where cs.[key] = 'EmailFrequencyCapping'))