Skip to main content
Solved

Report on email sends based on opt out category

  • February 23, 2021
  • 4 replies
  • 65 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.

View original
Did you find this topic helpful?

4 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • 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 ⭐️⭐️
  • 368 replies
  • 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 ⭐️⭐️
  • 3727 replies
  • March 4, 2021
andreammelde wrote:

@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 ⭐️⭐️⭐️⭐️⭐️
  • 651 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings