@dana @nico Anything you would recommend?

Claude says 'Aggregated Tables' are the way to go. But looking forward for your thoughts ????

I did a presentation on this at Tech SEO Connect. Slides here: <https://speakerdeck.com/samtorres/tech-seo-connect-2024-bigquery-for-seos|https://speakerdeck.com/samtorres/tech-seo-connect-2024-bigquery-for-seos> video: <https://www.youtube.com/live/dzYtcm1yfq4|https://www.youtube.com/live/dzYtcm1yfq4>

If you get stuck anywhere, feel free to ping me on it.

that's a good one ????

 

So, aggregated tables is the way to go.

 

I will have to start with querying the data I want from GA4, store it in a new table, and then append the future data to it.

 

It feels like the same process @noahlearner shared for GSC.

yep!

Thing about GA4, definitely watch what events you're sending over - you're limited to 1M events per day per stream, so it can get a lil weird

Got it. Thanks

This is <https://github.com/google-marketing-solutions/ga4_dataform|also a great resource>. It took me a while to get my head around it, but you need a sessionized table for general purpose reporting in Looker Studio. The TL;DR version is that rolling up session and user counts by day will inflate both metrics and a lot of other metrics are based on those, so they will get messed up too. <https://datatovalue.blog/ga4-sessionization-and-traffic-source-handling-in-bigquery-eb0235959078|This article> explains why in more detail.

Also, <https://www.teamsimmer.com/all-courses/query-ga4-data-in-google-bigquery/?ref=ga4bigquery.com|Johan van de Werken's course> is the best learning resource I've found by far.

Another important gotcha that has been <https://theseocommunity.slack.com/archives/C05HC70HNLF/p1728587228262609|pointed out here> by @tony270 and @dave940 is the fact that the export data can change after it has been written. They have seen changes for up to 72 hours - some people say more than that, but I think it's pretty settled after 72. Since you probably don't want to wait 72 hours to see data, you can solve for this with a <https://cloud.google.com/dataform/docs/incremental-tables|Dataform incremental update>.

Thanks for the resources, Nico. I’ll give them a read.

I was going to say Johan's course is the way to go. I believe they're working on a new one though!

In the Simmer newsletter, Simo said "_The new courses will *not* be a *free upgrade*, but we will offer a discount to enrollees of the original Google BigQuery course,"_ so that's definitely a consideration. Hopefully it will be a big discount ????