Skip to main content Besuchen Sie uns auf der TDX in San Francisco oder bei Salesforce+ vom 5. bis 6. März, um die Entwicklerkonferenz für die Ära der AI-Agenten zu erleben. Jetzt registrieren.

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 Antworten
  1. 21. März 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,

Ladevorgang läuft
0/9000