Number of recipients who unsubscribed in cube reports | Community
Skip to main content
T
TormodRø
October 17, 2022
Question

Number of recipients who unsubscribed in cube reports

  • October 17, 2022
  • 1 reply
  • 645 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
October 17, 2022

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/indicator-calculation.html?lang=en

 

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.

    T
    TormodRøAuthor
    October 18, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...