Simo Ahava Query GA4 Data In Google BigQuery | DDA7ADCE124ADA0FA286478868115F68C75ACE11

Simo Ahava Query GA4 Data In Google BigQuery

Name	Simo Ahava – Query GA4 Data In Google BigQuery	DOWNLOAD Copy Link
Total Size	4.1 GB
Total Files	248
Hash	DDA7ADCE124ADA0FA286478868115F68C75ACE11

/.../01-Event Exploration/Module Resources/
00-Event Exploration.rtf	19.0 KB
01-Count Sessions Of A Single Day.rtf	370.8 KB
01-Materials.rtf	7.3 KB
02-About Query Costs.rtf	43.8 KB
02-Materials.rtf	11.7 KB
03-Count Sessions Across A Static Date Range.rtf	385.4 KB
03-Materials.rtf	7.3 KB
04-Count Sessions Across A Dynamic Date Range.rtf	700.8 KB
04-Materials.rtf	10.2 KB
05-Count Sessions Across Event And Intraday Tables.rtf	1.4 MB
05-Materials.rtf	13.1 KB
06-Count Sessions By Part Of Week.rtf	432.2 KB
06-Materials.rtf	14.6 KB
07-Count Sessions By Part Of Day.rtf	219.0 KB
07-Materials.rtf	39.4 KB
08-Key Takeaways.rtf	45.3 KB
/.../02-User Dimensions/Module Resources/
00-User Dimensions.rtf	39.4 KB
01-About GA4 Users.rtf	36.5 KB
01-Materials.rtf	19.0 KB
02-Count Unique Users.rtf	611.7 KB
02-Materials.rtf	7.3 KB
03-Group Users By Year Of Their First Visit.rtf	340.2 KB
03-Materials.rtf	45.3 KB
04-Group Users By Acquisition Campaign.rtf	348.9 KB
04-Materials.rtf	14.6 KB
05-Group Users By Geographical Location.rtf	414.6 KB
05-Materials.rtf	14.6 KB
06-Group Users By Technology.rtf	43.8 KB
06-Materials.rtf	38.0 KB
07-Key Takeaways.rtf	42.3 KB
/.../03-User Properties/Module Resources/
00-User Properties.rtf	52.6 KB
01-Materials.rtf	10.2 KB
01-Query User Properties.rtf	379.6 KB
02-Materials.rtf	7.3 KB
02-Unnest All User Properties.rtf	378.1 KB
03-Materials.rtf	8.8 KB
03-Unnest A Specific User Property.rtf	440.9 KB
04-Access A User Property With A Scalar Subquery.rtf	344.6 KB
04-Materials.rtf	7.3 KB
05-Access Multiple Properties With Scalar Subqueries.rtf	42.3 KB
05-Materials.rtf	40.9 KB
06-Combine User Properties With Other User Data.rtf	335.8 KB
06-Materials.rtf	42.3 KB
07-Key Takeaways.rtf	17.5 KB
/.../01-(Engaged) Sessions/Module Resources/
00-(Engaged) Sessions.rtf	35.0 KB
01-Materials.rtf	13.1 KB
01-Query Event Parameters.rtf	45.3 KB
02-Count Regular Sessions Using ga_session_id.rtf	36.5 KB
02-Materials.rtf	10.2 KB
03-Explore Engagement Using session_engaged.rtf	32.1 KB
03-Materials.rtf	13.1 KB
04-Count Engaged Sessions Using session_engaged.rtf	2.0 MB
04-Materials.rtf	5.8 KB
05-Count Engaged Users Using engagement_time_msec.rtf	39.4 KB
05-Materials.rtf	36.5 KB
06-Explore Session Traffic Sources.rtf	303.7 KB
06-Materials.rtf	40.9 KB
07-Key Takeaways.rtf	40.9 KB
/.../02-Page Tracking/Module Resources/
00-Page Tracking.rtf	20.4 KB
01-Count Page Views By Pages And Titles.rtf	38.0 KB
01-Materials.rtf	7.3 KB
02-Count Unique Page Views.rtf	39.4 KB
02-Materials.rtf	42.3 KB
03-Identify Most Visited Landing Pages.rtf	35.0 KB
03-Materials.rtf	45.5 KB
04-Identify The Exit Page Of A Single Session.rtf	338.7 KB
04-Materials.rtf	35.0 KB
05-Identify Most Popular Exit Pages.rtf	39.4 KB
05-Materials.rtf	39.4 KB
06-Identify Page Pathing For A Single Session.rtf	283.2 KB
06-Materials.rtf	42.3 KB
07-Identify Most Popular Pathing For Any Page.rtf	32.1 KB
07-Materials.rtf	40.9 KB
08-Key Takeaways.rtf	42.3 KB
/03-Events/Module Resources/
00-Events.rtf	33.6 KB
01-Count Scroll Interactions.rtf	20.4 KB
01-Materials.rtf	39.4 KB
02-Count Outbound Clicks.rtf	43.8 KB
02-Materials.rtf	10.2 KB
03-Materials.rtf	10.2 KB
03-Track Site Search.rtf	43.8 KB
04-Explore Video Engagement.rtf	33.6 KB
04-Materials.rtf	35.0 KB
05-Count File Downloads.rtf	39.4 KB
05-Materials.rtf	10.2 KB
06-Count Events Per User With A Pivot Table.rtf	362.1 KB
06-Materials.rtf	13.1 KB
07-Key Takeaways.rtf	40.9 KB
/04-Retention/Module Resources/
00-Retention.rtf	43.8 KB
01-Count New And Returning Users.rtf	32.1 KB
01-Materials.rtf	40.9 KB
02-Calculate User Retention 1-2.rtf	39.4 KB
02-Materials.rtf	38.0 KB
03-Calculate User Retention 2-2.rtf	306.6 KB
03-Materials.rtf	30.7 KB
04-Calculate User Retention By Cohort.rtf	289.1 KB
04-Materials.rtf	39.4 KB
05-Key Takeaways.rtf	40.9 KB
/01-Ecommerce/Module Resources/
00-Ecommerce.rtf	43.8 KB
01-Calculate Ecommerce Metrics By Date.rtf	354.8 KB
01-Materials.rtf	8.8 KB
02-Calculate Conversion Rate By Engaged Sessions.rtf	45.3 KB
02-Materials.rtf	39.4 KB
03-Add Refund, Tax, And Shipping Data.rtf	217.5 KB
03-Materials.rtf	19.0 KB
04-Key Takeaways.rtf	23.4 KB
/02-Items/Module Resources/
00-Items.rtf	23.4 KB
01-Explore Items Data.rtf	43.8 KB
01-Materials.rtf	21.9 KB
02-Count Items And Revenue.rtf	33.6 KB
02-Materials.rtf	11.7 KB
03-Build An Items Funnel With Events.rtf	40.9 KB
03-Materials.rtf	40.9 KB
04-Key Takeaways.rtf	43.8 KB
/.../03-Lifetime Value/Module Resources/
00-Lifetime Value.rtf	30.7 KB
01-Calculate User Lifetime Revenue.rtf	43.8 KB
01-Materials.rtf	13.1 KB
02-Calculate Average Lifetime Revenue.rtf	33.6 KB
02-Materials.rtf	45.3 KB
03-Key Takeaways.rtf	43.8 KB
/.../01-Setup Google BigQuery/
00-Setup Google BigQuery.rtf	43.8 KB
01-Create The BigQuery Environment.mp4	20.4 MB
01-Create The BigQuery Environment.rtf	40.9 KB
02-Setup The BigQuery Link In GA4.mp4	23.0 MB
02-Setup The BigQuery Link In GA4.rtf	45.8 KB
03-Additional Configurations.mp4	13.4 MB
03-Additional Configurations.rtf	39.4 KB
04-Key Takeaways.mp4	10.5 MB
04-Key Takeaways.rtf	20.4 KB
/.../02-Explore GA4 Data/
00-Explore GA4 Data.rtf	36.5 KB
01-Access The Course Dataset.mp4	8.3 MB
01-Access The Course Dataset.rtf	43.8 KB
01-Materials.rtf	46.2 KB
02-Explore The GA4 Export Schema.mp4	54.2 MB
02-Explore The GA4 Export Schema.rtf	46.7 KB
03-Materials.rtf	8.8 KB
03-The First SQL Query.mp4	26.9 MB
03-The First SQL Query.rtf	348.9 KB
04-Key Takeaways.mp4	9.4 MB
04-Key Takeaways.rtf	39.4 KB
/.../03-Overview And Quiz/
Overview And Quiz.png	46.7 KB
Overview And Quiz.rtf	40.9 KB
QUIZ Getting Started.png	35.0 KB
/.../01-Event Exploration/
01-Count Sessions Of A Single Day.mp4	43.6 MB
02-About Query Costs.mp4	46.7 MB
03-Count Sessions Across A Static Date Range.mp4	64.3 MB
04-Count Sessions Across A Dynamic Date Range.mp4	27.7 MB
05-Count Sessions Across Event And Intraday Tables.mp4	49.6 MB
06-Count Sessions By Part Of Week.mp4	32.2 MB
07-Count Sessions By Part Of Day.mp4	39.3 MB
08-Key Takeaways.mp4	25.7 MB
/.../02-User Dimensions/
01-About GA4 Users.mp4	46.1 MB
02-Count Unique Users.mp4	27.6 MB
03-Group Users By Year Of Their First Visit.mp4	45.0 MB
04-Group Users By Acquisition Campaign.mp4	45.2 MB
05-Group Users By Geographical Location.mp4	45.7 MB
06-Group Users By Technology.mp4	26.6 MB
07-Key Takeaways.mp4	22.6 MB
/.../03-User Properties/
01-Query User Properties.mp4	43.1 MB
02-Unnest All User Properties.mp4	52.3 MB
03-Unnest A Specific User Property(1).mp4	21.8 MB
04-Access A User Property With A Scalar Subquery.mp4	54.7 MB
05-Access Multiple Properties With Scalar Subqueries.mp4	22.3 MB
06-Combine User Properties With Other User Data.mp4	46.4 MB
07-Key Takeaways.mp4	32.2 MB
/.../04-Overview And Quiz/
Overview And Quiz.png	96.4 KB
Overview And Quiz.rtf	38.0 KB
QUIZ Events & Users.png	16.1 KB
/.../01-(Engaged) Sessions/
01-Query Event Parameters.mp4	49.1 MB
02-Count Regular Sessions Using ga_session_id.mp4	52.2 MB
03-Explore Engagement Using session_engaged.mp4	63.5 MB
04-Count Engaged Sessions Using session_engaged.mp4	49.9 MB
05-Count Engaged Users Using engagement_time_msec.mp4	47.3 MB
06-Explore Session Traffic Sources.mp4	56.9 MB
07-Key Takeaways.mp4	11.9 MB
/.../02-Page Tracking/
01-Count Page Views By Pages And Titles.mp4	44.0 MB
02-Count Unique Page Views.mp4	74.2 MB
03-Identify Most Visited Landing Pages.mp4	65.7 MB
04-Identify The Exit Page Of A Single Session.mp4	91.2 MB
05-Identify Most Popular Exit Pages.mp4	49.8 MB
06-Identify Page Pathing For A Single Session.mp4	66.1 MB
07-Identify Most Popular Pathing For Any Page.mp4	83.4 MB
08-Key Takeaways.mp4	14.8 MB
/03-Events/
01-Count Scroll Interactions.mp4	69.4 MB
02-Count Outbound Clicks.mp4	40.1 MB
03-Track Site Search.mp4	28.2 MB
04-Explore Video Engagement.mp4	62.4 MB
05-Count File Downloads.mp4	39.4 MB
06-Count Events Per User With A Pivot Table.mp4	35.2 MB
07-Key Takeaways.mp4	12.7 MB
/04-Retention/
01-Count New And Returning Users.mp4	34.6 MB
02-Calculate User Retention 1-2.mp4	47.0 MB
03-Calculate User Retention 2-2.mp4	67.1 MB
04-Calculate User Retention By Cohort.mp4	65.3 MB
05-Key Takeaways.mp4	14.7 MB
/.../05-Overview And Quiz/
Overview And Quiz.png	102.2 KB
Overview And Quiz.rtf	38.0 KB
QUIZ Engagement & Retention.png	43.8 KB
QUIZ Engagement & Retention.rtf	45.7 KB
/01-Ecommerce/
01-Calculate Ecommerce Metrics By Date.mp4	37.9 MB
02-Calculate Conversion Rate By Engaged Sessions.mp4	44.8 MB
03-Add Refund, Tax, And Shipping Data.mp4	55.4 MB
04-Key Takeaways.mp4	17.2 MB
/02-Items/
01-Explore Items Data.mp4	55.9 MB
02-Count Items And Revenue.mp4	27.1 MB
03-Build An Items Funnel With Events.mp4	82.8 MB
04-Key Takeaways.mp4	14.0 MB
/.../03-Lifetime Value/
01-Calculate User Lifetime Revenue.mp4	61.3 MB
02-Calculate Average Lifetime Revenue.mp4	77.7 MB
03-Key Takeaways.mp4	16.0 MB
/.../04-Overview And Quiz/
Overview And Quiz.png	100.7 KB
Overview And Quiz.rtf	36.5 KB
QUIZ Monetization & Lifetime Value.png	52.6 KB
/Module Resources/
00-Advanced Queries.rtf	42.3 KB
01-Custom Engaged Sessions.rtf	299.3 KB
01-Materials.rtf	40.9 KB
02-Flatten GA4 Schema For Relational Databases.rtf	211.7 KB
02-Materials.rtf	19.0 KB
03-Join GA4 With Public Weather Data.rtf	480.3 KB
03-Materials.rtf	43.8 KB
04-Configure And Query Billing Export.rtf	46.7 KB
04-Materials.rtf	7.3 KB
05-Optimize BigQuery And Data Studio Connection.rtf	43.8 KB
06-Default And Custom Channel Grouping.rtf	19.0 KB
06-Materials.rtf	48.2 KB
07-Clean URLs With UDFs.rtf	48.2 KB
07-Materials.rtf	17.5 KB
08-Fuzzy Matching With UDFs.rtf	1.5 MB
08-Materials.rtf	16.1 KB
09-APPENDIX- BigQuery Workbook.rtf	24.4 MB
/01-INTRODUCTION/
01-Introduction.mp4	56.1 MB
01. Introduction.rtf	43.8 KB
02.Curriculum.mp4	90.6 MB
02.Curriculum.rtf	42.3 KB
03.Requirements.mp4	13.9 MB
03.Requirements.rtf	27.7 KB
/06- ADVANCED QUERIES/
00-Advanced Queries.mp4	32.8 MB
01-Custom Engaged Sessions.mp4	169.1 MB
02-Flatten GA4 Schema For Relational Databases.mp4	139.2 MB
03-Join GA4 With Public Weather Data.mp4	143.6 MB
04-Configure And Query Billing Export.mp4	93.5 MB
05-Optimize BigQuery And Data Studio Connection.mp4	60.9 MB
06-Default And Custom Channel Grouping.mp4	119.6 MB
07-Clean URLs With UDFs.mp4	97.3 MB
08-1-Fuzzy Matching With UDFs.mp4	124.8 MB
08-2-Fuzzy Matching With UDFs.mp4	49.5 MB
/07-FINAL QUIZ Query GA4 Data In Google BigQuery/
FINAL QUIZ Query GA4 Data In Google BigQuery.rtf	43.8 KB
FINAL QUIZ Query GA4 Data In Google BigQuery - Simmer.png	43.8 KB
Total files 248