Skip to main content
Solved

Report on email sends based on opt out category

  • February 23, 2021
  • 4 replies
  • 70 views

andreammelde
Forum|alt.badge.img+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?

Best answer by matthew_lind

@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.

4 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • February 24, 2021

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


andreammelde
Forum|alt.badge.img+3
  • Author
  • Helper ⭐️⭐️
  • February 24, 2021

@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


sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • March 4, 2021

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


matthew_lind
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • Answer
  • March 9, 2021

@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.