Reporting : miscalculation with the reactivity rate

[hugo_vdk]

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

[ParthaSarathy · Accepted solution]

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)