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

Avatar

Avatar
Ignite 1
Level 3
1982luca
Level 3

Likes

6 likes

Total Posts

311 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Ignite 1
Level 3
1982luca
Level 3

Likes

6 likes

Total Posts

311 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Boost 3
Boost 1
Applaud 5
View profile
1982luca
Level 3

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
Affirm 100
Employee
ishans52004352
Employee

Likes

152 likes

Total Posts

312 posts

Correct Reply

101 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

152 likes

Total Posts

312 posts

Correct Reply

101 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
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
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
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.