Simo Ahava – Google Analytics 4 in Big Query

Curriculum (Google Drive Proof)

My Drive

Data

Simo Ahava – Google Analytics 4 in Big Query

Name

Owner

Last modified

File size

01-Introduction

me

Jun 01, 2023 me

—

02-Getting Started

me

Jun 01, 2023 me

—

03-Events & Users

me

Jun 01, 2023 me

—

04-Engagement & Retention

me

Jun 01, 2023 me

—

05-Monetization & Lifetime Value

me

Jun 01, 2023 me

—

06-Advanced Queries

me

Jun 01, 2023 me

—

07-Office Hours sessions

me

Jun 01, 2023 me

—

My Drive

Data

Simo Ahava – Google Analytics 4 in Big Query

01-Introduction

01-Introduction.mp4

me

Jun 01, 2023 me

23.8 MB

02-Curriculum.mp4

me

Jun 01, 2023 me

67.3 MB

03-Requirements.mp4

me

Jun 01, 2023 me

9.3 MB

My Drive

Data

Simo Ahava – Google Analytics 4 in Big Query

02-Getting Started

Name

Owner

Last modified

File size

01-Setup Google BigQuery

me

Jun 01, 2023 me

—

02-Explore GA4 Data

me

Jun 01, 2023 me

—

Show All

Getting Began

Setup the BigQuery atmosphere
Hyperlink Google (*4*) 4 and Google BigQuery
Entry the course dataset
Discover the Google (*4*) 4 export schema
Run your first SQL question
Occasions & Customers

Perceive GA4’s session and person knowledge fashions
Sessionize the occasion knowledge stream in BigQuery
Group knowledge by customers and totally different user-based dimensions
Entry person properties
Learn to unnest knowledge
Find out about question prices (and optimization)
Engagement & Retention

Replicate and customise GA4’s sessionization logic
Use “engagement” as a approach to section knowledge
Construct customized pathing experiences to indicate how customers navigate your web site
Construct complete occasion experiences and occasion funnels
Replicate and customise GA4’s retention mannequin
Combine Google BigQuery with Google Knowledge Studio
Monetization & Lifetime Worth

Discover the ecommerce occasion schema in the GA4 knowledge
Calculate ecommerce metrics
Discover how GA4 makes use of “objects” in ecommerce occasions
Construct a complete objects funnel report
Calculate and visualize the lifetime worth of customers
Superior Queries

Study superior methods for working with Google BigQuery and Google (*4*) 4
Craft your personal idea of an “engaged session”
Mix GA4 knowledge with different public datasets
Flatten the GA4 schema to work with relational databases
And lots of extra…this part is consistently up to date with new content material