Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Approx Count Distinct vs Unique Vsitor

1982luca
Level 8
Level 8

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

 
 
 

 

2 Replies
PratheepArunRaj
Moderator
Moderator

Dear Luca,

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

Thanks, Arun.

ishans52004352
Employee
Employee

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!