GA4 Sessions & Total Users Ingesting Incorrectly
I am trying to ingest Sessions (Sessions and Engaged Sessions) and Total Users into Domo via the GA 4 Connector.
We can get New Users and Events to ingest into Domo correctly.
I have tried to bring the data in alone (no dimensions) and with additional information (2-9 dimensions). I have also tried each metric separately, again with both no dimensions and multiple dimensions. In addition to those I have tried to bring it in with additional metrics to see the affects (IE Total Users and New Users together). I have also tried both of the above approaches with only 1 day of data to 30 days worth of data.
At all variations of ingestion I have never gotten a correct number. The number ingested by Domo ranges from 6 - 16 times higher than the number displayed in GA. The multiplier is also not consistent (one day will be 10.5 times higher and the next will be 15.8 times higher), so I can't just divide every value by a multiplier.
Has anyone found a solution or work around to get these metrics into Domo accurately?
Thanks in advance.
Comments
-
Due to design decisions by Google the exported data won't align with the exact numbers from the UI. It will show you the same directionality of you data however.
Here's some helpful articles on GA4 and sampling:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I am having the same issue with one of my properties. The data in the UI for sessions, users and engaged sessions does match the data pull from the GA4 connector. I understand there could be some discrepancies, but this issue is only happening for one of my properties. Not all of them. I find that if I limit the pull to 90 days, the data aligns.
@GrantSmith, have any thoughts on this?
0 -
Is the discrep possibly due to timezones?
0 -
I figured out a workaround to this.
I am bringing in GA4 data in multiple datasets. I figured out that there is a unique key that Google uses to join tables in GA that doesn't come through Domo, without that key numbers get inflated very quickly. There are some metrics that can be brought in together with out issue because they come from the same table, but if you have to cross tables thats where issues come in. I found that the "Categories" in the connector are pretty much the tables, so as long as you don't try to bring in data from multiple categories, its accurate. I found that items in the Time category can be brought in with any other fields without issues.
@sarahdoesdomo I hope this solutions helps.2 -
Total Users - I have not gotten accurate results for Total Users, no matter how I try.
Sessions and Engagement - I will provide screenshots below of the settings I used. If I recall correctly, these are not necessarily accurate when rolled up to the total, but when filters are applied, they are generally quite close, if not spot-on.
NOTE: You can NOT include Geography dimensions with Session data and get accurate results.
Page/Screen:
Session:
Time:
Traffic Source:
User:
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive