- Регистрация
- 26.05.2022
- Сообщения
- 26 731
- Реакции
- 160
- Баллы
- 63
Курс от гуру веб-аналитики SimoAhava. На английском языке, но видео короткие и понятные, а нам в основном нужны только запросы для получения нужных данных в GA4. Так как скоро переход на GA4 неминуем. Нужны начальные знания SQL.
Google BigQuery is a data warehouse solution running on the Google Cloud Platform. But it’s not just for storing data – as its name implies, BigQuery is all about querying the data in order to answer your most burning analytics questions. Once you get the hang of it, you’ll prefer it to anything that the analytics platforms themselves offer natively in their user interfaces!
We designed this course to cater to a number of different student profiles. The course has a linear ramp-up progression, beginning with very straightforward introductory lessons, before diving into the different aspects of BigQuery using real-world data and real-world use cases.
->, If you work in an organization where GA4 is the leading web and app analytics tool, this course is for you.
->, If you want to leverage GA4 data outside of the GA user interface, to join and enrich it with other marketing, CRM and contextual data, this course is for you.
->, If you want to learn SQL in a meaningful way in the context of relevant marketing use cases, this course is for you.
->, If you want to perform advanced analysis on your GA4 data, this course is for you.
->, If you want to store your GA4 data in BigQuery (Google Cloud) and/or send it to your data warehouse in other cloud services like AWS, Azure, or Snowflake, this course is for you.
->, If you want to visualize your GA4 data in tools like Data Studio, Tableau, Looker, or PowerBI, this course is for you.
1. Getting Started
Setup the BigQuery environment
Link Google Analytics 4 and Google BigQuery
Access the course dataset
Explore the Google Analytics 4 export schema
Run your first SQL query
2. Events & Users
Understand GA4’s session and user data models
Sessionize the event data stream in BigQuery
Group data by users and different user-based dimensions
Access user properties
Learn how to unnest data
Learn about query costs (and optimization)
3. Engagement & Retention
Replicate and customize GA4’s sessionization logic
Use “engagement” as a way to segment data
Build custom pathing reports to show how uses navigate your website
Build comprehensive event reports and event funnels
Replicate and customize GA4’s retention model
Integrate Google BigQuery with Google Data Studio
4. Monetization & Lifetime Value
Explore the ecommerce event schema in the GA4 data
Calculate ecommerce metrics
Explore how GA4 utilizes “items” in ecommerce events
Build a comprehensive items funnel report
Calculate and visualize the lifetime value of users
5. Advanced Queries
Learn advanced techniques for working with Google BigQuery and Google Analytics 4
Craft your own concept of an “engaged session”
Combine GA4 data with other public datasets
Flatten the GA4 schema to work with relational databases
And many more… this section is constantly updated with new content
Google BigQuery is a data warehouse solution running on the Google Cloud Platform. But it’s not just for storing data – as its name implies, BigQuery is all about querying the data in order to answer your most burning analytics questions. Once you get the hang of it, you’ll prefer it to anything that the analytics platforms themselves offer natively in their user interfaces!
We designed this course to cater to a number of different student profiles. The course has a linear ramp-up progression, beginning with very straightforward introductory lessons, before diving into the different aspects of BigQuery using real-world data and real-world use cases.
->, If you work in an organization where GA4 is the leading web and app analytics tool, this course is for you.
->, If you want to leverage GA4 data outside of the GA user interface, to join and enrich it with other marketing, CRM and contextual data, this course is for you.
->, If you want to learn SQL in a meaningful way in the context of relevant marketing use cases, this course is for you.
->, If you want to perform advanced analysis on your GA4 data, this course is for you.
->, If you want to store your GA4 data in BigQuery (Google Cloud) and/or send it to your data warehouse in other cloud services like AWS, Azure, or Snowflake, this course is for you.
->, If you want to visualize your GA4 data in tools like Data Studio, Tableau, Looker, or PowerBI, this course is for you.
1. Getting Started
Setup the BigQuery environment
Link Google Analytics 4 and Google BigQuery
Access the course dataset
Explore the Google Analytics 4 export schema
Run your first SQL query
2. Events & Users
Understand GA4’s session and user data models
Sessionize the event data stream in BigQuery
Group data by users and different user-based dimensions
Access user properties
Learn how to unnest data
Learn about query costs (and optimization)
3. Engagement & Retention
Replicate and customize GA4’s sessionization logic
Use “engagement” as a way to segment data
Build custom pathing reports to show how uses navigate your website
Build comprehensive event reports and event funnels
Replicate and customize GA4’s retention model
Integrate Google BigQuery with Google Data Studio
4. Monetization & Lifetime Value
Explore the ecommerce event schema in the GA4 data
Calculate ecommerce metrics
Explore how GA4 utilizes “items” in ecommerce events
Build a comprehensive items funnel report
Calculate and visualize the lifetime value of users
5. Advanced Queries
Learn advanced techniques for working with Google BigQuery and Google Analytics 4
Craft your own concept of an “engaged session”
Combine GA4 data with other public datasets
Flatten the GA4 schema to work with relational databases
And many more… this section is constantly updated with new content
