Funnel Analysis In Mobile Gaming: Leveraging Approximation Algorithms For Low Latency Analytics
summary
GameAnalytics runs on Apache Druid and Imply to serve ~200 million daily active users and ingest ~600 billion events per month (peak ~280k events/sec), claiming average query latency ~150 ms and ~30 million UI queries per month. A funnel analysis feature uses Theta Sketch sketches and their intersection operator to approximate user overlaps instead of scanning raw IDs, producing 10‑step queries in ~1–2s for typical games and ~2s on a 20M‑DAU title while 50‑step queries can reach ~26s, showing the approach scales with an acceptable error bound.
AI-written summary · about
chapters (8)
- 0:00Introduction to talk
- 1:02About Game Analytics
- 4:14Platform growth and scale
- 7:48Game Analytics features
- 9:37Data flow and Druid overview
- 12:26HyperLogLog algorithm
- 15:55Funnel analysis feature
- 24:26Q&A session
related talks
27mBig Data in Mobile Games
29mA New Kind of Analytics: Actionable Performance Analysis
21mPutting big data self-service analytics in the hands of business people
27mBatching Was Yesterday: Real-Time Tracking & Analysis For 100+ Million Visitors
53mResearch in mobile games: finding insights from idea to release
17mDissecting and Streamlining the Interactive Loop of Mobile Cloud Gaming
22mSituational Intelligence with Analytics in Motion
01h 03mMonitoring Performance on Massive Games.