Approx Count Distinct vs Unique Vsitor

Avatar

Avatar

1982luca

Avatar

1982luca

1982luca

19-07-2020

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

 
 
 

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

ishans52004352

Employee

Avatar

ishans52004352

Employee

ishans52004352
Employee

20-07-2020

Hi @1982luca ,

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!

Avatar

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

PratheepArunRaj
Moderator

19-07-2020

Dear Luca,

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

Thanks, Arun.