Data Modeling for Google Analytics 4 with Activity Schema
You can learn how to model Google Analytics 4 data in BigQuery by using the Activity Schema model. Activity Schema is designed for event data and sequence analysis and, therefore, provides you with a foundation to enable more insights and better data quality. And all with the free Google Analytics 4 raw data but in the dashboards that you create.
Skill Level
Intermediate
Time to Complete
1,5 hours
OVERVIEW
About this course
The free raw data export is still the best new feature in Google Analytics 4 - Period. It unlocks plenty of new use cases that were not possible before and bonus: you can build your own UI for the GA data.
So, you start with well-crafted ad-hoc queries on top of the GA data to produce useful dashboards. But then happens the usual analyst's daydream and nightmare - the business teams are asking for more: "Can we have the data refreshed every morning by the way, here is our list of other insights we would love to have."
This is exactly the point in time when you should think about data modeling.
This course gives you an introduction to data modeling, especially for event data froms, Google Analytic by using the Activity schema data model approach, which is designed for event data in the first place.
Learn how to abstract away from the GA data to enable an easily scalable data model for your Google Analytics 4 data, that can serve all the business needs for insights.
Trailer
WHO
Who is this course for
1
Marketing Analyst
You are like a secret agent, using your spy-like skills to analyze campaign performance. They comb through mountains of data to tell us what's working, what's not, and how we can improve our marketing strategies.
2
Analytics Engineer
You are the ones who bring all our data to life and turn it into valuable insights. The ones who turn data into gold, like a modern-day alchemist.
3
Product Analyst
You are the product data detective (Mrs. or Mr. Holmes), using your analytical skills to uncover insights from your products. You help businesses make strategic decisions and drive growth by identifying trends and patterns in the data.
CURRICULUM
LEARN-BY DOING WITH LESSONS
The choice is yours - you can either immerse yourself and complete the course in one go, or take a more gradual approach by repeating and skipping between lessons at your own pace.
Trailer
SHOW MORE
KEY TAKEAWAYS
WHAT YOU LEARN
The best way to learn is by taking action, so it's time to get ready to work.
Here are some of the things you'll get out of doing this course:
Here are some of the things you'll get out of doing this course:
Learn when a data model for GA4 data makes sense
Learn ActivitySchema
Learn how to model activities with GA4 raw data
DEEPSKYDATA TEACHERS
LEARN WITH EXPERIENCED DATA EXPERTS
Teacher
Timo Dechau
Founder & Data Engineer
Teacher
Janko Thyson
Founder Kaosmaps