Firebase analytics for BigQuery

on YouTube ↗28m

" summary

Firebase Analytics exports raw event batches (events with up to 25 parameters and user properties) to BigQuery in near real time, storing nested JSON-like rows so queries use UNNEST to extract event params and user props. Demo shows achievements like coins500 and "daub" as top unlocks, a funnel built with LEAD/partition by to find sequences that lead to spend, and a sample cost of $0.72/month sample cost for a 20k MAU app; Data Studio reads custom SQL reports and the workflow works.

AI-written summary · about

" chapters (12)

1. 0:00Start
2. 3:13Automatic events
3. 3:31Suggested events
4. 3:56Custom events
5. 16:59Android Code: Log a custom event and parameter
6. 18:01Event Parameters - Results
7. 18:18Query: Custom Event Parameters
8. 20:03Query: Multiple User Properties - Part 1
9. 21:24Query: Combine iOS and Android data
10. 22:16Create Custom Funnel Reports - Part 1
11. 23:05Create Custom Funnel Reports - Part 2
12. 23:29What makes users spend money in your app!

" related talks

• 46mFirebase & BigQuery - Do Mobile App Analytics Easily & at Scale - Queries IncludedFelipe Hoffa, Chad Jennings, Eugene Girard · Google Cloud Next '18
• 44mA Crash Course in Google Analytics for Firebase and BigQueryTodd Kerpelman · 360iDev 2017
• 32mTurn Your App Data into Answers with Firebase and BigQueryTali Sason, Scott Brissenden · Google I/O 2019
• 29mCrash-reporting taken to next-levelTahsin Dane, Savan Ajamoglu · droidcon Berlin 2022
• 22mSupercharge your app with Firebase and BigQueryTali Sason, Scott Brissenden · Firebase Summit 2018
• 35mPowering Interactive Data Analysis with Google BigQueryMarton Kodok · GDG DevFest Ukraine 2017
• 07mAuto alerts for Firebase users with Functions, Logging, and BigQueryJaisen Mathai · Google I/O 2022
• 16mMeasure and debug performance with Google Analytics 4 and BigQueryPhilip Walton, Minhaz Kazi · Google I/O 2021