A Crash Course in Google Analytics for Firebase and BigQuery
summary
Shows that Google Analytics for Firebase is free, mobile‑centric, and exports raw event trees to BigQuery so developers can run real SQL on every event. Demonstrates limitations (50 custom params, nonretroactive audiences), gives concrete results from a Bingo app (average score, a stddev larger than the mean, a 0.17 correlation between score and XP), and builds queries that surface the most common three‑event sequences leading to spend_virtual_currency.
AI-written summary · about
chapters (33)
- 0:00Intro
- 3:15Events
- 3:57Automatic Events
- 5:08Suggested Events
- 5:40Custom Events
- 6:19User Properties
- 7:24Firebase Dashboard
- 10:15Events Panel
- 17:14Funnels
- 18:46Street View
- 22:54Limitations
- 23:21Firebase Analytics
- 24:12RealTime Analytics
- 24:52BigQuery Analytics Data
- 25:15BigQuery Analytics Events
- 25:47BigQuery User Info
- 25:58BigQuery User Properties
- 27:26BigQuery Events
- 28:43Open BigQuery
- 30:52Unnecessary
- 31:35CrewMember
- 32:10Score
- 33:20Unit Value
- 34:03Standard Deviation
- 35:37Correlation
- 36:40Spend Virtually
- 37:18App Instance ID
- 38:21User Journey
- 39:04Future Row
- 39:43Next Row
- 40:17Spring Events
- 41:12Triplet Events
- 42:49Recap
related talks
46mFirebase & BigQuery - Do Mobile App Analytics Easily & at Scale - Queries Included
28mFirebase analytics for BigQuery
29mCrash-reporting taken to next-level
32mTurn Your App Data into Answers with Firebase and BigQuery
16mMeasure and debug performance with Google Analytics 4 and BigQuery
33mAnalytics Data Driven Testing
22mSupercharge your app with Firebase and BigQuery
46mSimple and Cheap Business Analytics with Google BigQuery