Skip to main content Join us at TDX in San Francisco or on Salesforce+ on March 5-6 for the Developer Conference for the AI Agent Era. Register now.

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?

3 answers
  1. Mar 21, 2024, 4:21 PM

    Hi,@Lena Almalki

    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,

  2. Mar 20, 2024, 10:28 PM
    How you obtained email deliveries ? No of sent is not delivered it includes bounces as well.
  3. Mar 20, 2024, 5:35 PM

    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.

0/9000