Simo Ahava – Google Analytics 4 in Big Query

Simo Ahava – Google Analytics 4 in Big Query
  • learnonline-icon Learn online (no require download), easy download (Google Drive)
  • ensure-icon Ensure to get all files in the file list
  • update-icon Get free update course through your email
  • cheapprice-icon If you find a website cheaper than us, send it to us and we'll offer a cheaper price.
  • lastupdatedate-icon Last Updated Date: 06-01-2023
  • size-icon Course Size: 9.7 GB
$999- 96%
Simo Ahava – Google Analytics 4 in Big Query

Google Drive Proof

My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
Name
Owner
Last modified
File size
folder icon
01-Introduction
me
Jun 01, 2023 me
folder icon
02-Getting Started
me
Jun 01, 2023 me
folder icon
03-Events & Users
me
Jun 01, 2023 me
folder icon
04-Engagement & Retention
me
Jun 01, 2023 me
folder icon
05-Monetization & Lifetime Value
me
Jun 01, 2023 me
folder icon
06-Advanced Queries
me
Jun 01, 2023 me
folder icon
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
01-Introduction.mp4
me
Jun 01, 2023 me
23.8 MB
02-Curriculum.mp4
02-Curriculum.mp4
me
Jun 01, 2023 me
67.3 MB
03-Requirements.mp4
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
folder icon
01-Setup Google BigQuery
me
Jun 01, 2023 me
folder icon
02-Explore GA4 Data
me
Jun 01, 2023 me
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
02-Getting Started
01-Setup Google BigQuery
01-Create The BigQuery Environment.mp4
01-Create The BigQuery Environment.mp4
me
Jun 01, 2023 me
61.3 MB
pdf icon
01-Resources.pdf
me
Jun 01, 2023 me
36.6 KB
02-Setup The BigQuery Link In GA4.mp4
02-Setup The BigQuery Link In GA4.mp4
me
Jun 01, 2023 me
29.2 MB
03-Additional Configurations.mp4
03-Additional Configurations.mp4
me
Jun 01, 2023 me
42.2 MB
04-Key Takeaways.ts
04-Key Takeaways.ts
me
Jun 01, 2023 me
1.4 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
02-Getting Started
02-Explore GA4 Data
01-Access The Course Dataset.mp4
01-Access The Course Dataset.mp4
me
Jun 01, 2023 me
14 MB
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
55.2 KB
02-Explore The GA4 Export Schema.mp4
02-Explore The GA4 Export Schema.mp4
me
Jun 01, 2023 me
33.4 MB
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
57 KB
txt icon
03-Final Query.txt
me
Jun 01, 2023 me
125 B
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
112.2 KB
03-The First SQL Query.mp4
03-The First SQL Query.mp4
me
Jun 01, 2023 me
29.1 MB
04-Key Takeaways.mp4
04-Key Takeaways.mp4
me
Jun 01, 2023 me
9.2 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
03-Events & Users
Name
Owner
Last modified
File size
folder icon
01-Event Exploration
me
Jun 01, 2023 me
folder icon
02-User Dimensions
me
Jun 01, 2023 me
folder icon
03-User Properties
me
Jun 01, 2023 me
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
03-Events & Users
01-Event Exploration
01-Count Sessions Of A Single Day.mp4
01-Count Sessions Of A Single Day.mp4
me
Jun 01, 2023 me
32.5 MB
txt icon
01-Final Query.txt
me
Jun 01, 2023 me
145 B
txt icon
01-Initial Query.txt
me
Jun 01, 2023 me
163 B
pdf icon
01-Resources.pdf
me
Jun 01, 2023 me
148.5 KB
02-About Query Costs.mp4
02-About Query Costs.mp4
me
Jun 01, 2023 me
60.5 MB
txt icon
02-Final Query.txt
me
Jun 01, 2023 me
270 B
txt icon
02-Initial Query.txt
me
Jun 01, 2023 me
145 B
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
43.6 KB
03-Count Sessions Across A Static Date Range.mp4
03-Count Sessions Across A Static Date Range.mp4
me
Jun 01, 2023 me
83.9 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
460 B
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
153.1 KB
04-Count Sessions Across A Dynamic Date Range.mp4
04-Count Sessions Across A Dynamic Date Range.mp4
me
Jun 01, 2023 me
47.1 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
637 B
pdf icon
04-Resources.pdf
me
Jun 01, 2023 me
98.6 KB
05-Count Sessions Across Event And Intraday Tables.mp4
05-Count Sessions Across Event And Intraday Tables.mp4
me
Jun 01, 2023 me
28.8 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
683 B
pdf icon
05-Resources.pdf
me
Jun 01, 2023 me
122.6 KB
06-Count Sessions By Part Of Week.mp4
06-Count Sessions By Part Of Week.mp4
me
Jun 01, 2023 me
70.1 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
828 B
pdf icon
06-Resources.pdf
me
Jun 01, 2023 me
132 KB
07-Count Sessions By Part Of Day.mp4
07-Count Sessions By Part Of Day.mp4
me
Jun 01, 2023 me
67.1 MB
txt icon
07-Initial & Final Query.txt
me
Jun 01, 2023 me
1.3 KB
pdf icon
07-Resources.pdf
me
Jun 01, 2023 me
83.5 KB
08-Key Takeaways.mp4
08-Key Takeaways.mp4
me
Jun 01, 2023 me
14.8 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
03-Events & Users
02-User Dimensions
01-About GA4 Users.mp4
01-About GA4 Users.mp4
me
Jun 01, 2023 me
24.1 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
252 B
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
41.1 KB
02-Count Unique Users.mp4
02-Count Unique Users.mp4
me
Jun 01, 2023 me
29.9 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
231 B
pdf icon
02-Resources.pdf
me
Jun 01, 2023 me
89.3 KB
03-Group Users By Year Of Their First Visit.mp4
03-Group Users By Year Of Their First Visit.mp4
me
Jun 01, 2023 me
28.4 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
435 B
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
103.1 KB
04-Group Users By Acquisition Campaign.mp4
04-Group Users By Acquisition Campaign.mp4
me
Jun 01, 2023 me
46.8 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
403 B
pdf icon
04-Resources.pdf
me
Jun 01, 2023 me
111.6 KB
05-Group Users By Geographical Location.mp4
05-Group Users By Geographical Location.mp4
me
Jun 01, 2023 me
26 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
473 B
pdf icon
05-Resources.pdf
me
Jun 01, 2023 me
85.9 KB
06-Group Users By Technology.mp4
06-Group Users By Technology.mp4
me
Jun 01, 2023 me
28.4 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
1 KB
pdf icon
06-Notes.pdf
me
Jun 01, 2023 me
36.6 KB
07-Key Takeaways.ts
07-Key Takeaways.ts
me
Jun 01, 2023 me
1.4 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
03-Events & Users
03-User Properties
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
258 B
01-Query User Properties.mp4
01-Query User Properties.mp4
me
Jun 01, 2023 me
25.9 MB
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
91.8 KB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
442 B
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
130.7 KB
02-Unnest All User Properties.mp4
02-Unnest All User Properties.mp4
me
Jun 01, 2023 me
111.8 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
584 B
pdf icon
03-Resource.pdf
me
Jun 01, 2023 me
99.5 KB
03-Unnest A Specific User Property.mp4
03-Unnest A Specific User Property.mp4
me
Jun 01, 2023 me
27.4 MB
04-Access A User Property With A Scalar Subquery.mp4
04-Access A User Property With A Scalar Subquery.mp4
me
Jun 01, 2023 me
36.9 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
570 B
pdf icon
04-Resources.pdf
me
Jun 01, 2023 me
101.3 KB
05-Access Multiple Properties With Scalar Subqueries.mp4
05-Access Multiple Properties With Scalar Subqueries.mp4
me
Jun 01, 2023 me
12.2 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
735 B
06-Combine User Properties With Other User Data.mp4
06-Combine User Properties With Other User Data.mp4
me
Jun 01, 2023 me
27.9 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
1.2 KB
pdf icon
06-Resource.pdf
me
Jun 01, 2023 me
94.9 KB
07-Key Takeaways.ts
07-Key Takeaways.ts
me
Jun 01, 2023 me
1.9 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
04-Engagement & Retention
Name
Owner
Last modified
File size
folder icon
01-(Engaged) Sessions
me
Jun 01, 2023 me
folder icon
02-Page Tracking
me
Jun 01, 2023 me
folder icon
03-Events
me
Jun 01, 2023 me
folder icon
04-Retention
me
Jun 01, 2023 me
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
04-Engagement & Retention
01-(Engaged) Sessions
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
299 B
01-Query Event Parameters.mp4
01-Query Event Parameters.mp4
me
Jun 01, 2023 me
55.5 MB
02-Count Regular Sessions Using ga_session_id.mp4
02-Count Regular Sessions Using ga_session_id.mp4
me
Jun 01, 2023 me
108.8 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
472 B
03-Explore Engagement Using session_engaged.mp4
03-Explore Engagement Using session_engaged.mp4
me
Jun 01, 2023 me
130 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
468 B
pdf icon
03-Resource.pdf
me
Jun 01, 2023 me
34.1 KB
04-Count Engaged Sessions Using session_engaged.mp4
04-Count Engaged Sessions Using session_engaged.mp4
me
Jun 01, 2023 me
100.7 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
1 KB
pdf icon
04-Resource.pdf
me
Jun 01, 2023 me
128 KB
05-Count Engaged Users Using engagement_time_msec.mp4
05-Count Engaged Users Using engagement_time_msec.mp4
me
Jun 01, 2023 me
52 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
1.5 KB
06-Explore Session Traffic Sources.mp4
06-Explore Session Traffic Sources.mp4
me
Jun 01, 2023 me
77.5 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
2.1 KB
pdf icon
06-Resource.pdf
me
Jun 01, 2023 me
100.4 KB
07-Key Takeaways.ts
07-Key Takeaways.ts
me
Jun 01, 2023 me
2.1 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
04-Engagement & Retention
02-Page Tracking
01-Count Page Views By Pages And Titles.mp4
01-Count Page Views By Pages And Titles.mp4
me
Jun 01, 2023 me
27 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
524 B
02-Count Unique Page Views.mp4
02-Count Unique Page Views.mp4
me
Jun 01, 2023 me
43.7 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
1.2 KB
03-Identify Most Visited Landing Pages.mp4
03-Identify Most Visited Landing Pages.mp4
me
Jun 01, 2023 me
37.6 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
1.2 KB
04-Identify The Exit Page Of A Single Session.mp4
04-Identify The Exit Page Of A Single Session.mp4
me
Jun 01, 2023 me
53.5 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
1.1 KB
pdf icon
04-Resource.pdf
me
Jun 01, 2023 me
156.6 KB
05-Identify Most Popular Exit Pages.mp4
05-Identify Most Popular Exit Pages.mp4
me
Jun 01, 2023 me
25.7 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
1.5 KB
pdf icon
05-Note.pdf
me
Jun 01, 2023 me
42.9 KB
06-Identify Page Pathing For A Single Session.mp4
06-Identify Page Pathing For A Single Session.mp4
me
Jun 01, 2023 me
78.8 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
1.4 KB
pdf icon
06-Resource.pdf
me
Jun 01, 2023 me
111 KB
07-Identify Most Popular Pathing For Any Page.mp4
07-Identify Most Popular Pathing For Any Page.mp4
me
Jun 01, 2023 me
193.9 MB
txt icon
07-Initial & Final Query.txt
me
Jun 01, 2023 me
2 KB
08-Key Takeaways.ts
08-Key Takeaways.ts
me
Jun 01, 2023 me
2.5 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
04-Engagement & Retention
03-Events
01-Count Scroll Interactions.mp4
01-Count Scroll Interactions.mp4
me
Jun 01, 2023 me
105.3 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
1 KB
02-Count Outbound Clicks.mp4
02-Count Outbound Clicks.mp4
me
Jun 01, 2023 me
25.6 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
797 B
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
36.1 KB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
447 B
pdf icon
03-Resource.pdf
me
Jun 01, 2023 me
44 KB
03-Track Site Search.ts
03-Track Site Search.ts
me
Jun 01, 2023 me
3.1 MB
04-Explore Video Engagement.mp4
04-Explore Video Engagement.mp4
me
Jun 01, 2023 me
48.7 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
1.1 KB
05-Count File Downloads.mp4
05-Count File Downloads.mp4
me
Jun 01, 2023 me
80.9 MB
txt icon
05-Initial & Final Query.txt
me
Jun 01, 2023 me
867 B
pdf icon
05-Resource.pdf
me
Jun 01, 2023 me
39.5 KB
06-Count Events Per User With A Pivot Table.mp4
06-Count Events Per User With A Pivot Table.mp4
me
Jun 01, 2023 me
25 MB
txt icon
06-Initial & Final Query.txt
me
Jun 01, 2023 me
625 B
pdf icon
06-Resources.pdf
me
Jun 01, 2023 me
130 KB
07-Key Takeaways.ts
07-Key Takeaways.ts
me
Jun 01, 2023 me
803.4 KB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
04-Engagement & Retention
04-Retention
01-Count New And Returning Users.mp4
01-Count New And Returning Users.mp4
me
Jun 01, 2023 me
21.1 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
1.6 KB
02-Calculate User Retention 1-2.mp4
02-Calculate User Retention 1-2.mp4
me
Jun 01, 2023 me
38.1 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
1.7 KB
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
52.6 KB
03-Calculate User Retention 2-2.mp4
03-Calculate User Retention 2-2.mp4
me
Jun 01, 2023 me
146.7 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
2.5 KB
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
98.7 KB
04-Calculate User Retention By Cohort.mp4
04-Calculate User Retention By Cohort.mp4
me
Jun 01, 2023 me
92.8 MB
txt icon
04-Initial & Final Query.txt
me
Jun 01, 2023 me
3.7 KB
pdf icon
04-Resource.pdf
me
Jun 01, 2023 me
86 KB
05-Key Takeaways.ts
05-Key Takeaways.ts
me
Jun 01, 2023 me
2.6 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
05-Monetization & Lifetime Value
Name
Owner
Last modified
File size
folder icon
01-Ecommerce
me
Jun 01, 2023 me
folder icon
02-Items
me
Jun 01, 2023 me
folder icon
03-Lifetime Value
me
Jun 01, 2023 me
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
05-Monetization & Lifetime Value
01-Ecommerce
01-Calculate Ecommerce Metrics By Date.mp4
01-Calculate Ecommerce Metrics By Date.mp4
me
Jun 01, 2023 me
38.9 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
625 B
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
80 KB
02-Calculate Conversion Rate By Engaged Sessions.mp4
02-Calculate Conversion Rate By Engaged Sessions.mp4
me
Jun 01, 2023 me
27.2 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
1.9 KB
03-Add Refund, Tax, And Shipping Data.mp4
03-Add Refund, Tax, And Shipping Data.mp4
me
Jun 01, 2023 me
129.3 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
3.2 KB
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
85.2 KB
04-Key Takeaways.ts
04-Key Takeaways.ts
me
Jun 01, 2023 me
3 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
05-Monetization & Lifetime Value
02-Items
01-Explore Items Data.mp4
01-Explore Items Data.mp4
me
Jun 01, 2023 me
35.1 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
273 B
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
59.6 KB
02-Count Items And Revenue.mp4
02-Count Items And Revenue.mp4
me
Jun 01, 2023 me
51.4 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
382 B
pdf icon
02-Note.pdf
me
Jun 01, 2023 me
42.8 KB
03-Build An Items Funnel With Events.mp4
03-Build An Items Funnel With Events.mp4
me
Jun 01, 2023 me
112.7 MB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
1.1 KB
04-Key Takeaways.ts
04-Key Takeaways.ts
me
Jun 01, 2023 me
6.5 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
05-Monetization & Lifetime Value
03-Lifetime Value
01-Calculate User Lifetime Revenue.mp4
01-Calculate User Lifetime Revenue.mp4
me
Jun 01, 2023 me
39.6 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
703 B
02-Calculate Average Lifetime Revenue.mp4
02-Calculate Average Lifetime Revenue.mp4
me
Jun 01, 2023 me
87.2 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
2.8 KB
03-Key Takeaways.ts
03-Key Takeaways.ts
me
Jun 01, 2023 me
1 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
06-Advanced Queries
00-Advanced Queries.mp4
00-Advanced Queries.mp4
me
Jun 01, 2023 me
7.4 MB
01-Custom Engaged Sessions.mp4
01-Custom Engaged Sessions.mp4
me
Jun 01, 2023 me
111.6 MB
txt icon
01-Initial & Final Query.txt
me
Jun 01, 2023 me
3.5 KB
pdf icon
01-Resource.pdf
me
Jun 01, 2023 me
151.9 KB
02-Flatten GA4 Schema For Relational Databases.mp4
02-Flatten GA4 Schema For Relational Databases.mp4
me
Jun 01, 2023 me
161.6 MB
txt icon
02-Initial & Final Query.txt
me
Jun 01, 2023 me
4.1 KB
pdf icon
02-Resource.pdf
me
Jun 01, 2023 me
140 KB
txt icon
03-Initial & Final Query.txt
me
Jun 01, 2023 me
4.5 KB
03-Join GA4 With Public Weather Data.mp4
03-Join GA4 With Public Weather Data.mp4
me
Jun 01, 2023 me
189.4 MB
pdf icon
03-Resource.pdf
me
Jun 01, 2023 me
111.7 KB
04-Configure And Query Billing Export.mp4
04-Configure And Query Billing Export.mp4
me
Jun 01, 2023 me
121.2 MB
txt icon
04-Final Query.txt
me
Jun 01, 2023 me
550 B
pdf icon
04-Resources.pdf
me
Jun 01, 2023 me
45.8 KB
05-Optimize BigQuery And Data Studio Connection.mp4
05-Optimize BigQuery And Data Studio Connection.mp4
me
Jun 01, 2023 me
80.4 MB
pdf icon
05-Resource.pdf
me
Jun 01, 2023 me
50.3 KB
txt icon
06-2 Initial Queries & 2 Final Queries.txt
me
Jun 01, 2023 me
8.5 KB
06-Default And Custom Channel Grouping.mp4
06-Default And Custom Channel Grouping.mp4
me
Jun 01, 2023 me
187.3 MB
pdf icon
06-Resource.pdf
me
Jun 01, 2023 me
40 KB
07-Clean URLs With UDFs.mp4
07-Clean URLs With UDFs.mp4
me
Jun 01, 2023 me
220.1 MB
txt icon
07-Initial & Final Query.txt
me
Jun 01, 2023 me
1.8 KB
pdf icon
07-Notes.pdf
me
Jun 01, 2023 me
59.4 KB
txt icon
08-Initial, Final, & Bonus Query.txt
me
Jun 01, 2023 me
3.7 KB
pdf icon
08-Resources.pdf
me
Jun 01, 2023 me
178.5 KB
08a-Fuzzy Matching With UDFs.mp4
08a-Fuzzy Matching With UDFs.mp4
me
Jun 01, 2023 me
284.6 MB
08b-Bonus - Using Soundex.mp4
08b-Bonus - Using Soundex.mp4
me
Jun 01, 2023 me
36.9 MB
pdf icon
09-APPENDIX - BigQuery Workbook.pdf
me
Jun 01, 2023 me
2.5 MB
My Drive
Data
Simo Ahava – Google Analytics 4 in Big Query
07-Office Hours sessions
01-December 15, 2022.mp4
01-December 15, 2022.mp4
me
Jun 01, 2023 me
95.3 MB
pdf icon
01-Resources.pdf
me
Jun 01, 2023 me
179.2 KB
txt icon
01-SQL Snippet #1.txt
me
Jun 01, 2023 me
581 B
txt icon
01-SQL Snippet #2.txt
me
Jun 01, 2023 me
805 B
02-November 24, 2022.ts
02-November 24, 2022.ts
me
Jun 01, 2023 me
1.3 GB
pdf icon
02-Resources.pdf
me
Jun 01, 2023 me
157.2 KB
txt icon
02-SQL Snippet #1.txt
me
Jun 01, 2023 me
1.1 KB
03-October 27, 2022.mp4
03-October 27, 2022.mp4
me
Jun 01, 2023 me
349.9 MB
pdf icon
03-Resources.pdf
me
Jun 01, 2023 me
141.2 KB
txt icon
03-SQL Snippet #1.txt
me
Jun 01, 2023 me
1 KB
04-June 29, 2022.mp4
04-June 29, 2022.mp4
me
Jun 01, 2023 me
124.9 MB
pdf icon
04-Resources.pdf
me
Jun 01, 2023 me
177.2 KB
txt icon
04-SQL Snippet #1.txt
me
Jun 01, 2023 me
506 B
txt icon
04-SQL Snippet #2.txt
me
Jun 01, 2023 me
1 KB
txt icon
04-SQL Snippet #3.txt
me
Jun 01, 2023 me
1.2 KB
05-May 25, 2022.ts
05-May 25, 2022.ts
me
Jun 01, 2023 me
637.7 MB
pdf icon
05-Resources.pdf
me
Jun 01, 2023 me
91.6 KB
06-April 26, 2022.mp4
06-April 26, 2022.mp4
me
Jun 01, 2023 me
191.4 MB
pdf icon
06-Resource.pdf
me
Jun 01, 2023 me
103.2 KB
07-March 30, 2022.mp4
07-March 30, 2022.mp4
me
Jun 01, 2023 me
89.5 MB
pdf icon
07-Resource.pdf
me
Jun 01, 2023 me
125.8 KB
txt icon
07-SQL Snippet #1.txt
me
Jun 01, 2023 me
921 B
08-February 23, 2022.mp4
08-February 23, 2022.mp4
me
Jun 01, 2023 me
91.4 MB
pdf icon
08-Resource.pdf
me
Jun 01, 2023 me
104.6 KB
09-January 26, 2022.mp4
09-January 26, 2022.mp4
me
Jun 01, 2023 me
176.6 MB
pdf icon
09-Timestamps.pdf
me
Jun 01, 2023 me
104 KB
10-December 22, 2021.mp4
10-December 22, 2021.mp4
me
Jun 01, 2023 me
418.3 MB
pdf icon
10-Timestamps.pdf
me
Jun 01, 2023 me
112.7 KB
11-November 17, 2021.mp4
11-November 17, 2021.mp4
me
Jun 01, 2023 me
232.2 MB
pdf icon
11-Resources.pdf
me
Jun 01, 2023 me
115.7 KB
txt icon
11-SQL Snippet #1.txt
me
Jun 01, 2023 me
1.2 KB
pdf icon
12-Resource.pdf
me
Jun 01, 2023 me
124.8 KB
txt icon
12-SQL Snippet #1.txt
me
Jun 01, 2023 me
369 B
12-September 6, 2021.mp4
12-September 6, 2021.mp4
me
Jun 01, 2023 me
375.7 MB
13-August 30, 2021.mp4
13-August 30, 2021.mp4
me
Jun 01, 2023 me
189.1 MB
pdf icon
13-Resource.pdf
me
Jun 01, 2023 me
122.7 KB
txt icon
13-SQL Snippet #1.txt
me
Jun 01, 2023 me
622 B
14-August 23, 2021.mp4
14-August 23, 2021.mp4
me
Jun 01, 2023 me
217.5 MB
pdf icon
14-Resources.pdf
me
Jun 01, 2023 me
199.6 KB
txt icon
14-SQL Snippet #1.txt
me
Jun 01, 2023 me
1 KB
txt icon
14-SQL Snippet #2.txt
me
Jun 01, 2023 me
283 B
txt icon
14-SQL Snippet #3.txt
me
Jun 01, 2023 me
375 B
txt icon
14-SQL Snippet #4.txt
me
Jun 01, 2023 me
414 B
txt icon
14-SQL Snippet #5.txt
me
Jun 01, 2023 me
603 B
15-August 16, 2021.mp4
15-August 16, 2021.mp4
me
Jun 01, 2023 me
781.9 MB
pdf icon
15-Resources.pdf
me
Jun 01, 2023 me
160.4 KB
txt icon
15-SQL Snippet #1.txt
me
Jun 01, 2023 me
788 B
txt icon
15-SQL Snippet #2.txt
me
Jun 01, 2023 me
361 B

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

More courses you might like

- 93%

Simplertrading – OVERNIGHT PROFIT STRATEGY PRO

​Simplertrading - OVERNIGHT PROFIT STRATEGY PRO Overnight Profit Strategy Allison designed this strategy to literally...

$697
- 97%

Chris Rempel – Masterclass 7-Figure Consulting

​The Chris Rempel – Masterclass 7-Figure Consulting course is a transformative course designed to equip...

$999
- 92%

ALGOHUB 2023 Full Completed

​MECHANICAL TRADING APPROACH The AlgoHub mentorship program is designed to teach a mechanical trading approach...

$999
- 94%

CopyHackers – CopySchool 2020

​CopyHackers - CopySchool 2020 CopyHackers - CopySchool 2020 Cheap CopyHackers - CopySchool 2020 Download CopyHackers...

$999