QUERY: ANY EMAIL RECEIVED OVER THE PAST 90 DAYS | Community
Skip to main content
B
bcollado
Level 3
January 4, 2024
Solved

QUERY: ANY EMAIL RECEIVED OVER THE PAST 90 DAYS

  • January 4, 2024
  • 2 replies
  • 778 views

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!!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by costa_n11

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

2 replies

B
bcolladoAuthor
Level 3
January 4, 2024

and leaving it like this?

 

 

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
January 4, 2024

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

    B
    bcolladoAuthor
    Level 3
    January 4, 2024

    This is really helpful thank you very much Denis 🙂

     

    Kind regards,

     

    Blanca

    Terms & ConditionsAccessibility statement

    Loading footer...