As a SQL beginner, slow explanations are great.

koonbus80936273

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

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

GA4 Data Extraction Learned Through Basic BigQuery SQL Syntax

BigQuery SQL Syntax Learned Through Session Count Extraction - UNNEST

Extracting user, session, and event-level traffic source/medium

Querying BigQuery Data - Events

View product performance/sales analysis data

Handling 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

Organizing query statements and checking precautions

BigQuery Data Analysis and Insight Generation Using ChatGPT