QUERY: ANY EMAIL RECEIVED OVER THE PAST 90 DAYS

[bcollado]

Hi,

how can I create the query for the following requierement?:

"All recipients who have received any email over the past 90 days"

Could it work like this? 

But then how can I introduce that date?

Thank you very much for your help!!

[bcollado]

and leaving it like this?

[costa_n11 · Accepted solution]

Hi @bcollado 

the field on the broadlog that gets the date is eventDate

Be aware that in your query you would ahve only recipients that at least opened the email or click on the email, as such you won't need the status as Sent,

If you want just the actial sent, you need to select Recipient Delivery Logs instead...

Thanks

Denis

[bcollado]

This is really helpful thank you very much Denis

Kind regards,

Blanca