Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

Reporting : miscalculation with the reactivity rate

Avatar

Level 1

Hello experts, 

I ran into a problem in the reporting part of Adobe Campaign Classic. If we refer to the definition, the reactivity rate is supposed to be "the ratio of the number of targeted recipients who clicked in a delivery at least once compared to the estimated number of targeted recipients who opened a delivery at least once." But after some calculations, it looks like it's the ratio between the targeted recipients who clicked in a delivery at least once compared to the success deliveries. Is that normal ? Is the definition false or a problem of calculations in the reporting of Adobe Campaign Classic ?

Best regards, 
Hugo

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @hugo_vdk ,

Reactivity rate is the Ratio between the number of recipients who have clicked at least once in the mail and the number of recipients who have opened the mail. Clicks on the opt-out and mirror page links are ignored.
It is calculated based on the expression "Percent(@recipientClick, @estimatedRecipientOpen)"

Where,
recipientClick is the Distinct number of clicks by recipients (same recipient clicks twice, counted once)
estimatedRecipientOpen is the Estimation of the distinct opens, taking into account the proportion of text mails sent. And it is calculated based on below expression

expr="Iif(([../properties/@toDeliver] - [../properties/@text]) = 0, 0, round(toDouble(@recipientOpen) * [../properties/@toDeliver] / ([../properties/@toDeliver] - [../properties/@text]), 0))"


Where,
[../properties/@toDeliver] is the Total count of messages to be delivered
- [../properties/@text] is the Number of messages in text format
recipientOpen is the Number of distinct recipients who have opened the mail

(You can find more about this expression and definition in nms:delivery schema's Preview tab)

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @hugo_vdk ,

Reactivity rate is the Ratio between the number of recipients who have clicked at least once in the mail and the number of recipients who have opened the mail. Clicks on the opt-out and mirror page links are ignored.
It is calculated based on the expression "Percent(@recipientClick, @estimatedRecipientOpen)"

Where,
recipientClick is the Distinct number of clicks by recipients (same recipient clicks twice, counted once)
estimatedRecipientOpen is the Estimation of the distinct opens, taking into account the proportion of text mails sent. And it is calculated based on below expression

expr="Iif(([../properties/@toDeliver] - [../properties/@text]) = 0, 0, round(toDouble(@recipientOpen) * [../properties/@toDeliver] / ([../properties/@toDeliver] - [../properties/@text]), 0))"


Where,
[../properties/@toDeliver] is the Total count of messages to be delivered
- [../properties/@text] is the Number of messages in text format
recipientOpen is the Number of distinct recipients who have opened the mail

(You can find more about this expression and definition in nms:delivery schema's Preview tab)