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.
Making Sense of the GA4 Configuration Tag
No tag so crucial as the GA4 Configuration Tag. It can make or break or silently kill your implementation without warning. Sounds scary? It is! But I’ll try to explain some quirks, and a solution for all your worries.
Using Big Query to calculate DAU / MAU
This post shows you how to calculate unique Daily Users per Monthly Users. Or: DAU/MAU – a measure of stickyness.
It uses GA4 data and BigQuery SQL