Analytics
4.2K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Number of total Users different than sum of individual parts

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

In Analytics we use custom dimensions to define different customer roles on our website such as not logged in, subscriber, free account and such. Now when i go to the custom report we created to see the amount of users per role the total given to me differs from when I add up the sum of each individual role manually.

 

In some cases the total given is more than the manually calculated total and in other cases it is the other way around. When i export the data to Excel the total given in Excel does match the total of the indivual parts. The difference is never more than 5%.

 

Can anyone explain why there is a difference in both numbers and which I should use? 

1 Expert replyverified_user

Number of total Users different than sum of individual parts

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

How have you got your dimensions set up? 

 

And are you referring to total users as in the default metric used in GA? 

 

Kind Regards

Abbie Roberts

PPC Specialist & Marketing Consultant

Website | Facebook | Twitter | LinkedIn |Google+| Email |

 

Number of total Users different than sum of individual parts

Rising Star
# 3
Rising Star

It would be helpful to know the dimension scope used for it, but one way the total can differ from when lines are added up is:

 

- I visit the site and am labelled freeAccount

- I visit again and am labelled subscriber

 

If you create a custom report, choose Users as metric and a date range that includes my two visits, you'll see 1 user for freeAccount and 1 user for subscriber, but just 1 total (unique) user.

 

Let me know if the above helps.

 

Number of total Users different than sum of individual parts

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

The dimension scope is session. Should this be user as well?

 

I have considered your suggestion and it makes sense for the situations in which the lines add up to more than the total. However, In certain periods the total given by Analytics is more than the sum of each line.

 

Thanks in advance.

 

Number of total Users different than sum of individual parts

Rising Star
# 5
Rising Star

"The dimension scope is session. Should this be user as well?"

 

Not necessarily. You should just be aware of what the data is telling you when combining dimensions and metrics.