Expand my Community achievements bar.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Approx Count Distinct vs Unique Vsitor

Avatar

Level 9

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

 
 
 

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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!

View solution in original post

2 Replies

Avatar

Community Advisor and Adobe Champion

Dear Luca,

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

Thanks, Arun.

Avatar

Correct answer by
Employee Advisor

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!