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,