Firebase & BigQuery - Do Mobile App Analytics Easily & at Scale - Queries Included
summary
Firebase exports Firebase Analytics to BigQuery with a nested, repeated schema (example: Bingo Blast events), so queries show how to unnest arrays into tables, extract event params like score, and cast user properties to correlate score with experience. The demos use subqueries as tables to aggregate by game type, use the LEAD window function to build funnels that end in spend_virtual_currency, and show how to embed custom SQL into the Data Studio template and where the GitHub query repo lives.
AI-written summary · about
chapters (22)
- 0:00Introduction
- 1:04Agenda
- 1:31Presenters
- 1:59Firebase Google Analytics
- 2:44Firebase BigQuery
- 6:00Firebase Schema
- 7:36Firebase User ID
- 9:00Firebase Devices
- 9:23Bingo Blast Example
- 10:53Questions
- 11:47Demo
- 14:49Event param
- 14:59Unnecessary code
- 18:56Slide
- 19:07Demo Continued
- 24:15Score by Game Type
- 29:01Back to Demo
- 29:12Cutting to the Money
- 30:58Peek Ahead
- 32:20Example
- 36:07Recap
- 39:02Running Queries
related talks
28mFirebase analytics for BigQuery
44mA Crash Course in Google Analytics for Firebase and BigQuery
36mSending events to Google Analytics for Firebase to support data-driven decisions
31mAction-Packed Analytics
32mTurn Your App Data into Answers with Firebase and BigQuery
29mCrash-reporting taken to next-level
22mSupercharge your app with Firebase and BigQuery
07mAuto alerts for Firebase users with Functions, Logging, and BigQuery