Articles tagged bigquery
- 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
- 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.
- 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.