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