Skip to main content Unisciti a noi al TDX, a San Francisco o su Salesforce+, il 5-6 marzo per la conferenza degli sviluppatori sull'era degli Agenti IA. Registrati ora.

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 risposte
  1. 21 mar 2024, 16:21

    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,

Caricamento in corso
0/9000