Between 2024-07-15 and 2024-07-24 a quiet gradual change took place: it looks like the collected_traffic_source column is now only filled on the first batch of events.
srsltid parameter, GA4 and Big Query
Today I learned that when you use the srsltid parameter (Shopping Free + autotagging will add this parameter), it messes up the GA4 bq page location. Blogging this, because hopefully it helps someone save some time. What is stored is not what you send (if you send srsltid) When you request a page like https://stuifbergen.com/?srsltid=foo […]
Analyze AB tests in GA4 via Big Query
Here’s a query that will help you get started answering the question: “How can I tie experiment events to conversions?”
How to make sure your GA4 events tables do not expire
When you have GA4 to Big Query set up in a sandbox, your table will expire after 60 days.
Here’s how to un-set that expiry. Manual instructions and a SQL code generator tool.