Measure and debug performance with Google Analytics 4 and BigQuery

on YouTube ↗16m

" summary

Shows how Google Analytics 4 sends custom web‑vitals events into BigQuery export, with data arriving within 24 hours and queries computing site 75th‑percentile LCP/CLS and event counts. Demonstrates instrumenting pages with the Web Vitals JS, running SQL to find problem pages and debug identifiers that point to specific components, and creating a materialized table plus a Data Studio dashboard (uses 1 TB/month free BigQuery sandbox). Includes a prepackaged connector that builds a working dashboard end to end.

AI-written summary · about

" chapters (6)

1. 0:00Measuring site performance
2. 2:20Implementing GA4 tracking
3. 4:35Setting up BigQuery
4. 5:46Analyzing performance data
5. 9:04Visualizing metrics
6. 14:35Conclusion

" related talks

• 38mMeasure performance with web-vitals.js, Google Analytics, and BigQueryTony Conway · Google I/O 2022
• 35mScaling Interactive and Insightful Dashboards with Data Studio and BigQueryMinhaz Kazi, Felipe Hoffa · Google Cloud Next '18
• 33mAnalytics Data Driven TestingSlavik Pashanin · QA Fest 2018
• 44mA Crash Course in Google Analytics for Firebase and BigQueryTodd Kerpelman · 360iDev 2017
• 01mGoogle Core Web VitalsIsabelle Cosar · HUSTEF 2023
• 48m3 Very Practical Applications of Google Analytics 4Krzysztof Marzec · Digital Marketing Europe 2024
• 27mCrash Course in CrUXRick Viscomi · #PerfMatters Conference 2019
• 28mFirebase analytics for BigQueryArun Venkatesan, Todd Kerpelman · Google Cloud Next '17