Skip to main content
andreammelde
andreammelde
Helper ⭐️⭐️
February 23, 2021
Solved

Report on email sends based on opt out category

  • February 23, 2021
  • 4 replies
  • 104 views

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
sai_ram
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
andreammeldeAuthor
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

Andrea Carroll
    sai_ram
    sai_ram
    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
    matthew_lindAnswer
    VIP ⭐️⭐️⭐️⭐️⭐️
    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.

    Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
      Terms & ConditionsAccessibility statement