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

Monthly Unique Visitors for each Operating System

Avatar

Avatar
Level 1
tapinos87
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
tapinos87
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
tapinos87
Level 1

25-02-2021

Hi,

I need to extract the number of Unique Visitors using an app with each Operating System in a given Month. In other words, if user A uses the app with Operating System iOS 14.0 twice in the same month, I want the total for iOS 14.0 to increase ONLY by one.

 

In order to obtain this result:

 

  • I created a freeform table
  • I set the time interval to Jan 1, 2021 - Jan 31, 2021
  • I added Unique Visitors as the Metric
  • I added Operating Systems as the Dimesion

The problem is that the total for the Unique Visitors is 1,618,175 while adding up all of the rows related to the different Operating System I get 2,482,990.

 

I tried to replace the Operating System Dimesion with the Month Dimension: the total for the Unique Visitors remains 1,618,175 and the value for January is exactly the same.

 

My question is: why there is a 864,815 difference in Unique Visitors between the total for January and total for all the Operating Systems used in January?

 

Thanks in advance for your answer,

Fabrizio

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

183 likes

Total Posts

550 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

183 likes

Total Posts

550 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile
yuhuisg
MVP

25-02-2021

Unique Visitors, as the metric implies, counts the number of visitors, which for all intents and purposes is the number of people.

It is entirely possible for the same person to be tracked with different operating systems, and people could be updating their OSes regularly (e.g. through automatic updates).

Try including the Visits metric in your table. Do the rows' Visits add up to the total? It is unlikely that a person's OS could update midway while browsing your website.