Skip to main content

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?

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


@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

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


@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