blog
- google tag manager scripts exploration
Overview of a research repo that pairs prettified GTM container JavaScript with Markdown notes on how browser and server-side containers load, route events, and run built-in Google tags.
- from google sheets to bigquery
Step-by-step guide to transferring data from Google Sheets to BigQuery via external tables, without third-party tools or custom code. Covers linking a sheet, loading it into an internal table for performant querying, and scheduling daily updates.
- creating google ads data transfer in bigquery
Guide to setting up a custom Google Ads data transfer in BigQuery using the Data Transfer Service and GAQL. Covers the new custom report option (one table and view per transfer), configuration, scheduling, and backfilling historical data.
- server-side gtm q&a – common sense version
Structured Q&A on server-side Google Tag Manager (sGTM): benefits and drawbacks, typical costs (GCP and Stape), setup process, and when client-side GTM is still required. Covers cookie lifespan, common issues, and real-world use cases.
- updating data in sharded tables
How to update data across BigQuery sharded tables (e.g. GA4 export) using a scripting loop, with an example that anonymizes user_id over a date range.