Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Number of recipients who unsubscribed in cube reports

Avatar

Level 1

How do I count the number of recipients who clicked the opt-out link (at least once) on an e-mail delivery? The cube report for Delivery and tracking statistics measure unsubscriptions as "sum @optOut". However, this does not measure the number of recipients who unsubscribed, but rather the sum of all clicks on the opt-out link (and for some reason some people seem to click this multiple times...). I have tried using "Distinct Count", but this also gives a wrong result (counting less than the actual number of recipients who unsubscribed). 

2 Replies

Avatar

Employee Advisor

Hi Rodshagen,

 

Have you checked out the indicators section of the documentation below?

https://experienceleague.adobe.com/docs/campaign-classic/using/reporting/reports-on-deliveries/indic...

 

The above does detail out a specific indicator that you can examine to understand the recipients that unsubscribed (@_unsubscribe). For opt-outs you can use @optOut.

 

Now its important to note that you may need to do a distinct or dedupe as its possible for a recipient to click on the same URL twice.

Avatar

Level 1

Thank you for answering. Yes, I have read the documentation, and @optOut is the only available option in the Delivery and tracking (DeliverLogStats) table. When setting up the cube report, one can choose "distinct count", but this gives a very wrong number.

 

An example: I have an e-mail where 401 recipients clicked the opt-out link at least once (found by using a query on the tracking log table). The cube report shows sum @optOut = 489 which is the total number of clicks. But  distinct count @optOut shows 14... Which is a number that makes no sense to me. I would have excpected the distinct count to be 401, but clearly I am missing something...