As a SQL beginner, slow explanations are great.

koonbus80936273

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 BigQuery SQL Basic Syntax

Learning BigQuery SQL Syntax Through Session Count Extraction - UNNEST

Extracting User, Session, and Event Level Traffic Source/Medium

Bigquery Data Query - Events

Viewing Product Performance/Sales Analysis Data

Handling GA4 and BigQuery from a Marketer/Planner Perspective

Conversion Rate Analysis Using WITH Clause - Open Funnel

Conversion Rate Analysis Using WITH Clause - Closed Funnel

Organize queries well for reusability

Check and organize query statements and precautions

Using ChatGPT for BigQuery Data Analysis and Insight Generation