Skip to main content
andreammelde
andreammelde
Helper ⭐️⭐️
Feb 23, 2021 9:28 PM UTC
Solved

Report on email sends based on opt out category

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?

matthew_lind
matthew_lindAnswer
VIP ⭐️⭐️⭐️⭐️⭐️
Mar 9, 2021 9:26 PM UTC

@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?
View in thread

4 replies

sai_ram
sai_ram
Expert ⭐️⭐️
Feb 24, 2021 5:53 PM UTC

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

Translate
andreammelde
andreammeldeAuthor
Helper ⭐️⭐️
Feb 24, 2021 5:57 PM UTC

@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

Translate
Andrea Carroll
    sai_ram
    sai_ram
    Expert ⭐️⭐️
    Mar 4, 2021 11:03 AM UTC

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

    Translate
    matthew_lind
    matthew_lindAnswer
    VIP ⭐️⭐️⭐️⭐️⭐️
    Mar 9, 2021 9:26 PM UTC

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

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