Solved

Report on email sends based on opt out category

  • 23 February 2021
  • 4 replies
  • 58 views

Userlevel 5
Badge +3

I am trying to pull a report based on how many times we have sent a Newsletter template via JO. We tag these with a an opt out. How can I pull what opt out the email template has? I am not seeing how it joins in the data management.

 

Or is there a way to pull what folder the email template is in?

icon

Best answer by matthew_lind 9 March 2021, 22:26

View original

4 replies

Userlevel 7
Badge +1

@andreammelde basically you want to know how many times an email template has been used? and what are those programs?

Userlevel 5
Badge +3

@sai_ram 

I can figure out how many times an email template has been used - i need to figure what the opt out is associated with an email send

Userlevel 7
Badge +1

@sai_ram

I can figure out how many times an email template has been used - i need to figure what the opt out is associated with an email send

@andreammelde understood your requirement. Redirecting this to the product team. Thanks!! 

Userlevel 7
Badge +10

@andreammelde - One potential route to solve this: 

  • Use the AO Emails object
  • Show me COUNT of GSID
  • By Email Template and Unsubscribed (bonus points for pivoting on the Unsubscribed field)

That will give you the number of emails sent utilizing each template, with a tally where true = the recipient unsubscribed using the unsubscribe link within that particular email.

Reply