Expand my Community achievements bar.

SOLVED

Newsletter tracking data - distinct clicks, cumulated clicks and recipient clicks

Avatar

Level 2

Within the newsletter tracking we receive the same values for distinct clicks and cumulated clicks which we wouldn't expect. Recipient clicks are lower. Please help to explain the values and the setup.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi JK.

 

Without seeing the data specifically, it's hard to say with certainty whether there is an issue.


I would recommend reviewing the indicator calculation section within the Campaign documentation which will give some insight into how these metrics are formed.

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

Logic:

Distinct clicks:
@distinctClicks Ratio of the number of distinct people who clicked in a delivery at least once compared to the number of messages delivered with success.
percent([indicators/@personClick], [indicators/@success])


Cumulated clicks:
@totalClicks Ratio of the total number of clicks by targeted recipients compared to the number of messages delivered with success.
percent([indicators/@totalRecipientClick], [indicators/@success])

 

If we look at the logic between these two indicators we can see that it is possible to get the same total if you only get distinct clicks from your originally targeted recipients. If, however, you are seeing non-distinct clicks, or clicks from non-recipients (persons) then this would require additional investigation.

 

Now let us look at the Recipient Click logic:
Recipient clicks:
@recipientClick Distinct count of the @broadLog-ids with a URL type that equals "Email click".
Countdistinct(Iif([url/@type]=1, @broadLog-id, 0))

 

While the name of the indicators may seem like they should be the same, the logic reveals otherwise. We can see that, again, this is based on "recipients," not "persons," meaning anyone who has a profile in your Campaign database. Persons in Campaign mean anyone, whether they exist or not, in the Campaign DB and whether they were originally targeted (this is one way to estimate forwards). With that said, we would not expect this number to be higher than Distinct Clicks and because of the additional logic where we can see that this is looking at URLs of type "email click" we would also expect equal or less than Cumulated clicks as Cumulated clicks takes Opt-outs, mirror pages, and other URL types into account

 

All of this to say, based on what you have reported, and what is documented, your results are entirely possible and could even be expected for refined targets typically associated with newsletter emails. If you should see any further discrepancies, I would recommend reaching out to Campaign Support with the specific delivery and we can take a look.

 

Regards,

Craig

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi JK.

 

Without seeing the data specifically, it's hard to say with certainty whether there is an issue.


I would recommend reviewing the indicator calculation section within the Campaign documentation which will give some insight into how these metrics are formed.

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

Logic:

Distinct clicks:
@distinctClicks Ratio of the number of distinct people who clicked in a delivery at least once compared to the number of messages delivered with success.
percent([indicators/@personClick], [indicators/@success])


Cumulated clicks:
@totalClicks Ratio of the total number of clicks by targeted recipients compared to the number of messages delivered with success.
percent([indicators/@totalRecipientClick], [indicators/@success])

 

If we look at the logic between these two indicators we can see that it is possible to get the same total if you only get distinct clicks from your originally targeted recipients. If, however, you are seeing non-distinct clicks, or clicks from non-recipients (persons) then this would require additional investigation.

 

Now let us look at the Recipient Click logic:
Recipient clicks:
@recipientClick Distinct count of the @broadLog-ids with a URL type that equals "Email click".
Countdistinct(Iif([url/@type]=1, @broadLog-id, 0))

 

While the name of the indicators may seem like they should be the same, the logic reveals otherwise. We can see that, again, this is based on "recipients," not "persons," meaning anyone who has a profile in your Campaign database. Persons in Campaign mean anyone, whether they exist or not, in the Campaign DB and whether they were originally targeted (this is one way to estimate forwards). With that said, we would not expect this number to be higher than Distinct Clicks and because of the additional logic where we can see that this is looking at URLs of type "email click" we would also expect equal or less than Cumulated clicks as Cumulated clicks takes Opt-outs, mirror pages, and other URL types into account

 

All of this to say, based on what you have reported, and what is documented, your results are entirely possible and could even be expected for refined targets typically associated with newsletter emails. If you should see any further discrepancies, I would recommend reaching out to Campaign Support with the specific delivery and we can take a look.

 

Regards,

Craig