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
Solved! Go to Solution.
Views
Replies
Total Likes
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!
Dear Luca,
What if the same Laptop is used for multiple logins? One Unique Visitor and multiple Customer IDs. Not possible?
Thanks, Arun.
Views
Replies
Total Likes
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!
Views
Likes
Replies