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.
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
Session modeling in BigQuery SQL (using GA4 data and a trip to Paris)
What is a session? And how can I use SQL to express that.
Track, Store and Analyze granular Page Performance data: a practical guide
This is a guide on how to track Navigation Timing data of all your pages using the Google Stack: Google Tag Manager, Google Analytics (App + Web), Big Query, and Data Studio.
You will get unsampled page-level data of almost all Navigation Timing API requests in a nice and easy to query table.