analytics
- analyze ga4 bigquery data locally with duckdb
Workflow for analyzing GA4 BigQuery exports on your own machine with DuckDB: export Parquet from BigQuery to GCS, then query via CLI, VS Code Interactive Window, or Jupyter. Includes a uv-based project template.
- rfm and rfe analysis in practice
Introduction to RFM (Recency, Frequency, Monetary) and RFE (Recency, Frequency, Engagement) customer segmentation. Free web app to run RFM/RFE on your own CSV data.
- ga4::bq kit — chrome extension
GA4::BQ Kit is a Chrome extension that provides a searchable library of SQL snippets for Google Analytics 4 data in BigQuery. It integrates directly into the BigQuery UI to speed up writing accurate, complex queries for GA4 export tables.
- ga4 event parameters data checker
A BigQuery Studio Notebook that automates the inspection and summarization of GA4 event parameters. It aggregates top parameter values into a structured HTML report to streamline data validation and GTM debugging within BigQuery exports