Approx Count Distinct vs Unique Vsitor | Community
Skip to main content
Luca_Lattarini
Luca_Lattarini
New Participant
July 20, 2020
Solved

Approx Count Distinct vs Unique Vsitor

  • July 20, 2020
  • 2 replies
  • 1135 views

Hello everyone,

 

I am comparing Approx count Distinct Visitor that is calculate on Customer ID with Unique Visitor. When I compare these two values I expect a Unique Visitor > Approx count Distinct but in some cases, it is smaller. Any suggestion?

Thanks

 
 
 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isinha

Hi @luca_lattarini ,

Are the number of customer ID crossing the uniques exceeded limit? In that case, it will be counted as 1 item. Also, please note that the function uses the HyperLogLog (HLL) method of approximating distinct counts.  It is configured to guarantee the value is within 5% of the actual value 95% of the time. So, it's not 100% accurate always.

Thanks!

2 replies

I
isinhaAccepted solution
Employee
July 20, 2020

Hi @luca_lattarini ,

Are the number of customer ID crossing the uniques exceeded limit? In that case, it will be counted as 1 item. Also, please note that the function uses the HyperLogLog (HLL) method of approximating distinct counts.  It is configured to guarantee the value is within 5% of the actual value 95% of the time. So, it's not 100% accurate always.

Thanks!

    PratheepArunRaj
    PratheepArunRaj
    New Participant
    July 20, 2020

    Dear Luca,

    What if the same Laptop is used for multiple logins? One Unique Visitor and multiple Customer IDs. Not possible?

    Thanks, Arun.

    Terms & ConditionsAccessibility statement

    Loading footer...