There’s a wealth of info on it at https://www.ga4bigquery.com/. Some very helpful free content, and some available via an annual subscription. The sub is well worth the fee IMO if you’re new to the data model and all of its idiosyncrasies.
One warning: if you are using events_ and events_intraday, prior day data can exist in both datasets for a certain amount of time. Had to build in logic to prefer full day export if exists (was not needed in GA UA)
Random cookie issue. Closed my browser, cleared cache, logged in again and I was able to create a link. Will be fun logging into like 20 cloud services again 🫠
Comments
BigQuery or if you just want to see how they model the data.
https://github.com/fivetran/dbt_ga4_export
Yes, for events_ and events_intraday (not accurate)
Have fun modelling sessions. The schema has also changed over time with new fields added