GA4 Connector Settings Best Practices

Those of us who work with Google Analytics 4 data understand getting the data to accurately pull into Domo is at best tricky and really does take closely studying the settings and creating ETLs. I thought it would be a good idea to collect our best practices in one place.
For example, if you want to get an accurate user count over a period of time, you really need to be pulling separate datasets for every possible period of time. It's not a perfect solution (we can't get an accurate count of users for a two-week period, or a quarter), but it will get you most of the way there. So make sure you set up separate datasets for users by:
Day
Week
Month
Year
You could include sessions in this dataset as well, but if you're okay with your data being slightly off (a session might span two days), users really is the most critical and most noticeable part.
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 665 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 488 APIs & Domo Developer
- 97 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive