My last post talks about the initial work to create a real user analytics system based on the UI Telemetry event data collected in Firefox on Mobile. I’m happy to report that we’ve had much forward progress since then. Most importantly, we are no longer using the DIY setup on one of my Mac Minis. Working with the Mozilla Telemetry & Data team, we have a system that extracts data from UI Telemetry via Spark, imports the data into Presto-based storage, and allows SQL queries and visualization via Re:dash.
With data accessible via Re:dash, we can use SQL to focus on improving our analyses:
- Track Active users, daily & monthly
- Explore retention & churn
- Look into which features lead to retention
- Calculate user session length & event counts per session
- Use funnel analysis to evaluate A/B experiments
Roberto posted about how we’re using Parquet, Presto and Re:dash to create an SQL based query and visualization system.
Also published on Medium.