Hello,
I've noticed that Salesforce counts user clicks uniquely, which means even if one user clicks multiple times, each click is counted separately. So, I'm trying to calculate the total click-through rate (CTR) where every click, regardless of the user, contributes to the overall rate.
Currently, I've created a measurement formula: CTR = (Email_Total_Clicks / Email_Deliveries) * 100. However, I'm encountering an issue where the percentage sometimes exceeds 100%, which doesn't seem accurate.
Could anyone help me understand how to correct this issue and ensure the calculation provides a reliable CTR percentage?
CTR values exceeding 100%, there might be duplicate clicks being counted in your calculation.
you can calculate CTR using unique clicks:
CTR = (Unique_Clicks / Email_Deliveries) * 100
Unique_Clicks: The total number of unique clicks on the email.
Email_Deliveries: The total number of emails delivered.
Thanks,
How you obtained email deliveries ? No of sent is not delivered it includes bounces as well. There is a parameter called is unique for opens or clicks which differentiate the unique and duplicate clicks. If u mention is unique=1 it will fetch only unique activities. If u don't mention it or put is unique=0, it will fetch all the duplicate activities.