Skip to main content
Luca_Lattarini
Luca_Lattarini
Level 9
Jul 20, 2020 2:41 AM UTC
Solved

Approx Count Distinct vs Unique Vsitor

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.
isinhaAccepted solution
Adobe Employee
Jul 20, 2020 11:05 AM UTC

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 in thread

2 replies

PratheepArunRaj
Adobe Champion, Community Advisor, UG Leader
PratheepArunRajAdobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
Jul 20, 2020 4:21 AM UTC

Dear Luca,

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

Thanks, Arun.

Translate
Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
Adobe Employee
isinhaAdobe EmployeeAccepted solution
Adobe Employee
Jul 20, 2020 11:05 AM UTC

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!

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...