Google Analytics session data showing improperly
I have a card to show how many sessions one of our company sites had the previous month. In Google Analytics I see it has approximately 2,000 sessions on Feb. 1st, but in Domo it has 6,000 sessions for the same day.
I've double checked my card and I've filtered it to show the same web domain, beyond that I'm not sure which other filters would be relevant or why the number would be so different from the source, Google Analytics.
I'd like to know what might cause the session data to inflate in Domo and how to fix it. Thanks in advance!
Best Answer
-
It is difficult to know for sure, but for Google Analytics there is one main gotcha that will cause exactly what you are seeing. I'd bet you have Dimensions that are inflating the number. This applies to Visits or Users as well.
Short Answer:
The same session is counting more than once and you need to simplify your connector in Domo to match the display in the card.
Long Answer:
Sessions can have many interactions and still count as a single session. For example, in one session I may visit 100 pages of your website, but this is still just one session.
I can pull the data for my site, where I visited 100 pages, and it may look like this:
Site Sessions
mysite.com 1Now, for that same session if I want to see it by page it will look like this:
Site Page Sessions
mysite.com /home 1
mysite.com /contact 1
mysite.com /pricing 1
mysite.com /products 1That is really just ONE session. But each page literally had ONE session in which it was visited, this is true. I cannot however add up the `Sessions` column because it will become 4 when there really was only 1.
That is why you have to pull the data from Google specific to the card analysis. Given the example above if you want the card to show by website and page, then you do the second example. If you want it rolled up by site you do the first example.
A common occurance of this is daily sessions and users. Then using Domo's quick card settings to show 'By Month' and Domo will conveniently aggregate the whole month for you but it will not match the monthly total in Google Analytics. You have to pull by month to get the monthly number.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
It is difficult to know for sure, but for Google Analytics there is one main gotcha that will cause exactly what you are seeing. I'd bet you have Dimensions that are inflating the number. This applies to Visits or Users as well.
Short Answer:
The same session is counting more than once and you need to simplify your connector in Domo to match the display in the card.
Long Answer:
Sessions can have many interactions and still count as a single session. For example, in one session I may visit 100 pages of your website, but this is still just one session.
I can pull the data for my site, where I visited 100 pages, and it may look like this:
Site Sessions
mysite.com 1Now, for that same session if I want to see it by page it will look like this:
Site Page Sessions
mysite.com /home 1
mysite.com /contact 1
mysite.com /pricing 1
mysite.com /products 1That is really just ONE session. But each page literally had ONE session in which it was visited, this is true. I cannot however add up the `Sessions` column because it will become 4 when there really was only 1.
That is why you have to pull the data from Google specific to the card analysis. Given the example above if you want the card to show by website and page, then you do the second example. If you want it rolled up by site you do the first example.
A common occurance of this is daily sessions and users. Then using Domo's quick card settings to show 'By Month' and Domo will conveniently aggregate the whole month for you but it will not match the monthly total in Google Analytics. You have to pull by month to get the monthly number.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Thanks for that example, it is very helpful! Could you also give an example of how to 'simplify' the connector? (In my experience, the connectors get temperamental if I edit them and I don't own this dataset, so I want to be sure before I adjust it).
0 -
Sure!
When I say 'simplify' I mean pick as few "Dimensions" as possible. Here is a screenshot of the selected dimensions for a Google Analytics connector:
Google Analytics Connector
There are 3 Dimensions selected.
- Date: like 1/1/2019
- Medium: organic/social/referral/etc...
- Source: website where they clicked the link to come to my website.
This means that in order to use the user/session values I need to display a card that shows the Sum() By Day and separates the values for Medium AND Source without combining the numbers for them.
To Simplify By Day:
If I just want to see the User/Session totals by day then I need to remove the Medium and Source dimensions from the setup. If my only dimension is Date then I will get ONE row of data per day and the Users/Sessions will match Google Analytics.
Note: per Google's terms/conditions, sampling may apply. You can tell if sampling was applied by checking for a column in the dataset named: `Sampled Data`
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Hello,
I'm having a similar issue. I'd like to track session-level metrics (Pages/Session, Avg. Session Duration, etc...) using the utm_campaign, utm_souce, and utm_content dimensions. For the purpose of this use case, I am required to use more than 1 dimension.
Domo is returning different values for these than GA is actually reporting, because Domo is averaging each row with no regard to how each dimension's values should be weighted.
Any ideas?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive