A bit long, yet good as it's detailed and followable.

asdfasdfasdfasdfasdf

Introduces methods for utilizing GA4 data in Bigquery. Using the GA4 Bigquery demo data publicly available in Bigquery from the Google Merchandise Store (https://www.googlemerchandisestore.com/), we introduce methods for marketers and planners to easily utilize GA4 Bigquery data, along with hands-on practice of basic SQL queries.

Introduction to GA4 BigQuery for Marketers and Planners (2025)

bigquery

GA4 Guide

입문

초급

중급이상

구글 애널리틱스

Google Analytics

Google Analytics 4

Setting up the practice environment for taking the course

BigQuery Basics

Exploring GA4 Bigquery Data

Learning GA4 Data Extraction with Basic BigQuery SQL Syntax

Learning BigQuery SQL Syntax Through Session Count Extraction - UNNEST

Extracting traffic source/medium at user, session, and event levels

Querying Bigquery Data - Events

View product performance/sales analysis data

Working with GA4 and BigQuery from a Marketer/Planner's Perspective

Conversion Rate Analysis Using the with Clause - Open Funnel

Conversion Rate Analysis Using the with Clause - Closed Funnel

Organize queries well so they can be reused

Review query statements and check precautions

BigQuery Data Analysis and Insight Derivation Using ChatGPT