Скачать или смотреть GA4 + BigQuery Tutorial - How to Access Any Date Period (#2)

Having trouble working with nested tables in the Big Query? Here is a simple tutorial to access any dates in the table.

Timecodes:
00:00 Introduction
00:32 How dates impact tables
01:25 All Date Ranges
02:20 Using Table Suffix
03:12 Custom Date Ranges
04:20 Excluding streaming events
05:15 Checking your filters

SQL Function: PARSE_DATE("%Y%m%d", _TABLE_SUFFIX)

Useful links:
1. Create Google Console here: https://console.cloud.google.com/?pli=1
2. Open BigQuery here: https://console.cloud.google.com/bigq...
3. Great guide on how to connect GA4 with BigQuery: https://online-metrics.com/ga4-bigquery/
4. Great article on GA4 + BigQuery for beginners: https://www.simoahava.com/analytics/b...
5. Firebase Ga4 Tutorial: https://www.bounteous.com/insights/20...

Add me on LinkedIn:   / rpetrochenkov  
Read me on Medium:   / rpetrochenkov  

📌 Want to discuss your project?
Me on UpWork: http://bit.ly/3b9FLw2-MWH
Me on Fiverr: http://bit.ly/3oiAeac-MWH

Google Ads into BigQuery Playlist:    • Complete Guide To BigQuery for Google Ads ...  

My other Google Ads Scripts tutorials:    • GAS #1: Create Your First Report via Ads (...