Hi all,
I am currently working on a daily send and need to make sure the user would only receive it (if qualified) once every 15 days.
I was thinking of using the _Sent table but there is no field-specific enough, as I am looking for a specific email. should I load it into another DE and then create a query for that one?
thanks!
Just looking at high level on requirement
1. If you want to use _Sent data view to get list of subscribers who received specific email in past 15 days, u can use JobID column to filter out for specific email. If you do not know JobID of your email, you can join _Sent with _Job data views. Please look at following documentation for all available data views and fields -
https://help.salesforce.com/s/articleView?id=sf.mc_as_data_views.htm&type=52. Your requirement might also get solved using Measures. Following is the link to documentation -
https://help.salesforce.com/s/articleView?id=sf.mc_es_measures.htm&type=53. If you aren’t sending multiple emails using same data extension or if you do not want to suppress users from other email sends except for the specific email that you need to send out. The solution proposed by Gary would work best
@Naama Assa#Marketing Cloud
