The number of Total Users does not match the number of total users based on device categories

289 views
Skip to first unread message

camn...@ringier.com.vn

unread,
Jun 16, 2018, 12:18:57 AM6/16/18
to google-analytics-spreadsheet-add-on

Hi,

I want to report an issue that I can't understand,

As can be seen from the screenshot, the number of total users is even smaller than that of total users based on device categories( desktop+mobile+tablet)

My data is fetching from google analytics

Thanks for helping

Best,

Nhung



Screen Shot 2018-06-16 at 11.13.22 AM.png
Screen Shot 2018-06-16 at 11.18.22 AM.png

Mike Sullivan

unread,
Jun 27, 2018, 2:10:12 PM6/27/18
to google-analytics-spreadsheet-add-on
You should NEVER add up Users numbers -- the result will likely include double-counting since Users can have multiple sessions and each session could have different parameters in any dimension you include (like ga:month).  Simple example: 1 user visits in month 1, 2 and 3. Total is 3, but there is actually only 1 user. If you query Users for months 1-3 WITHOUT the ga:month dimension, the number would be 1, which is correct.

Next anomaly occurs at midnight -- if a session cross midnight, the user is counted in both days, but the session and some of the parameters that go with it may only be counted in the first period.  You may end up with users that do not have a device category, or they do and they are double-counted.
Reply all
Reply to author
Forward
0 new messages