Reporting : miscalculation with the reactivity rate | Community
Skip to main content
H
hugo_vdk
March 13, 2023
Solved

Reporting : miscalculation with the reactivity rate

  • March 13, 2023
  • 1 reply
  • 914 views

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

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

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)

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
March 13, 2023

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)

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...