I would like to manage the commercial pressure in SFMC and to set a query that feed a DATA extension.
This DE will be used as exluded data extension when sending the email.
So some question :
1-is there a query for subscribers who receive an email in the last 7 days for one BU and alsso a query for all Business unit?
2- I set this query but marketing cloud doesn't recognize this syntax (issue with the dd - DAY in the query):
SELECT s.SubscriberKey, s.EventDate AS Sent_Date, 'False' AS Not_Opened FROM _Sent s LEFT JOIN _Open o ON s.SubscriberKey = o.SubscriberKey WHERE o.SubscriberKey IS NULL AND CAST(s.EventDate AS DATE) >= CAST(DATEADD(dd, -60, CURRENT_TIMESTAMP) AS DATE) AND CAST(s.EventDate AS DATE) < CAST(CURRENT_TIMESTAMP AS DATE)
Thanks for your help