Unlock advanced insights with Google BigQuery and Google Analytics 4
Query GA4 Data In Google BigQuery
Get started with Google BigQuery, learn to utilize the GA4 data export by building basic and advanced queries, and tackle real life digital marketing use cases.
Get the most out of your raw GA4 event data and immerse yourself in the world of queries.
This course is designed for marketing professionals who want to dive into the world of queries, and for data professionals who need to skill up on GA4-specific knowledge.
It is meant for beginner, intermediate, and advanced Google Analytics 4 users who don’t necessarily have any knowledge of data warehouses, SQL, or of querying GA4 data. It is also appropriate for data professionals (analysts, engineers) who need GA4-specific domain knowledge to be able to extract the export data in a meaningful way.
The course will cover all you need to know about designing, writing and executing queries for your organization’s needs.
What Is A "Task-Based" Approach?
In this context, “task-based” means that every single topic, lesson, and section has been designed for immediate application.
Rather than spend time on theory and background, the lessons will tackle the subject matter with pragmatism, and the theoretical component will emerge as a by-product of actually doing the tasks.
How Does The Course Work?
Enrollment is open until 22nd August 2021.
You will have access to course content from 9th August 2021 onwards. Before this date, you will be able to watch the introductory videos, and you will be able to see the full curriculum.
Once you have enrolled, you will have lifetime access to the course, including any updates to the course material.
The course is self-paced, but there will be a schedule you can optionally follow. The schedule will include a weekly email containing additional tips and resources for attendees, and there will also be a weekly office hours live video conference where your questions will be answered.
Once you enroll, you will receive an onboarding package in your email with all the information you need.
This course is for you if..
The course comprises six sections, containing 14 lessons in total. Each lesson is typically 3–4 short videos, each tackling a single, practical aspect of the subject matter. All the sections (apart from Introduction and Advanced Queries) end in a quiz, with a final quiz waiting at the very end. Once the final quiz is complete, the student will receive a certificate.
- Lesson 1: Introduction – Learn what this course is about
What is the overall structure of the course and what tools, access, and knowledge are required.
- Lesson 2: Setup – Enable the GA4 data export
How to create a Google Cloud Platform account, create a BigQuery (sandbox) environment, and setup the GA4 data export.
- Lesson 3: Explore GA4 Data – Getting used to the GA4 dataset
Everything you need to know in order to perform your first GA4 query.
- Lesson 4: Event Exploration – Identify peak days and hours on your site
Counting GA4 sessions on multiple days using a combination of static and dynamic date ranges.
- Lesson 5: User Dimensions – Get to know your users
Definitions of users in GA4 and how to query user dimensions such as traffic source, geolocation, device, and browser info.
- Lesson 6: User Properties – Get the most out of custom user characteristics
Combine unnested user properties with user data.
- Lesson 7: (Engaged) Sessions – Build a basic traffic acquisition report
Count engaged sessions, and explore session traffic sources.
- Lesson 8: Page Tracking – Get insights in (landing) page performance
Calculate (unique) pageviews for (landing / exit) pages, and identify previous and next pages.
- Lesson 9: Events – Monitor enhanced measurement interactions
How to deal with events, event parameters, and event values to explore interactions.
- Lesson 10: Retention – Create a user retention table
Count new and returning users, and calculate user retention by cohort.
- Lesson 11: Ecommerce – Build a basic ecommerce report
All metrics you need to extract and calculate to build a basic ecommerce report.
- Lesson 12: Items – Create an item funnel from view to purchase
How to build an item funnel based on GA4 event data.
- Lesson 13: Lifetime Value – Identify your most valuable customers
Count user lifetime revenue and purchase frequency.
- Lesson 14: Advanced Queries – Customize your GA4 event data and perform advanced analysis
Advanced queries to sessionize your GA4 dataset, create your own channel groupings, perform path analysis, create your own definition of engaged sessions, combine GA4 with other (public) data sources, and more…
Quiz of everything covered in the course. A certificate will be awarded upon quiz completion.