GA4 BigQuery SQL: Datasets for Our Course

Updated: 2023-09-13

Welcome to our GA4 BigQuery SQL Course! In this section, we’ll introduce you to the datasets we’ll be using throughout the course. These datasets are sourced from GA4 sample exports and Firebase sample exports, providing us with real-world data to analyze and gain valuable insights. Let’s dive into the datasets that will serve as the foundation for your learning journey.

Datasets Overview

Google Merchandise Store Dataset

Description: The Google Merchandise Store is an online platform dedicated to selling Google-branded merchandise. The website utilizes Google Analytics 4’s standard web e-commerce implementation and enhanced measurement features.
Dataset Source: The ga4_obfuscated_sample_ecommerce dataset is available through the BigQuery Public Datasets program. It contains a sample of obfuscated BigQuery event export data spanning three months from 2020-11-01 to 2021-01-31.
Relevance: This dataset offers a real-world e-commerce scenario for analysis, allowing you to explore how GA4 data can be leveraged to gain insights into user behavior, online sales, and customer interactions on an e-commerce platform.

Flood-It! Dataset

Description: Flood-It! is a popular puzzle game accessible on both Android and iOS platforms. The app employs Google Analytics 4’s standard gaming app implementation through Firebase.
Dataset Source: The flood_it dataset is accessible via the firebase-public-project BigQuery project. It encompasses a sample of obfuscated BigQuery event export data spanning 114 days from 2018-06-12 to 2018-10-03.
Relevance: This gaming dataset presents an opportunity to explore how GA4 is applied to mobile gaming applications. You’ll gain insights into user engagement, in-game actions, and performance metrics within the gaming industry.

Practical Learning

Throughout the GA4 BigQuery SQL Course, we’ll use these datasets to demonstrate various SQL techniques, analysis methodologies, and reporting practices. You’ll have the chance to apply your skills to real-world data scenarios, reinforcing your understanding of GA4 data analysis.

For each code snippet, we will add SQL comment in the first line to indicate more clearly from which dataset the query should be ran against.

-- firebase-public-project.analytics_153293282
SELECT *  
FROM `firebase-public-project.analytics_153293282.events_20181003` 
LIMIT 1000

-- bigquery-public-data.ga4_obfuscated_sample_ecommerce
SELECT *
FROM `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_20210131` 
LIMIT 1000

By the end of this course, you’ll not only be well-versed in GA4 BigQuery SQL but also have a profound grasp of how to extract meaningful insights from diverse datasets. So, let’s embark on this data-driven journey, using these datasets as our guiding stars in the world of GA4 analytics.