Tag: Google Analytics

BigQuery Google Analytics Oct. 28, 2024

Incredible BigQuery Extract Performance - Improving BigQuery export of Google Analytics data to Snowflake.

BigQuery dbt Google Analytics Oct. 21, 2024

How to standardize GA4 data with dbt - This article provides a guide to transforming raw GA4 data into a polished data mart using dbt. It covers setting up the GA4 to BigQuery connection, applying data transformations, and building refined tables for marketing insights.

BigQuery Google Analytics Aug. 19, 2024

Creating a Pageviews-Based Recommendation System Using GA4 Data in BigQuery - Introduction.

BigQuery Google Analytics Paywall June 24, 2024

Understanding the GA4 BigQuery Export Schema and Structure - A qualitative investigation into one of the weirdest data structures ever forced upon millions of innocent, unsuspecting analysts.

BigQuery Google Analytics Nov. 27, 2023

How to Flatten the GA4 BigQuery Export Schema for Usage in Relational Databases - This article aims to guide you through the process of flattening the GA4 export schema, making it compatible for use in relational databases outside of BigQuery.

BigQuery Google Analytics Nov. 20, 2023

GA4 Sessionization and Traffic Source handling in BigQuery - Answering questions like which acquisition channel the user came from, how to handle multiple sources within the same session.