I will build retention, churn and funnel analytics dashboards for your app
About this Gig
STOP GUESSING WHY USERS LEAVE.
I turn raw app and streaming events into the four numbers that actually run a subscription business: activation, retention, churn and lifetime value.
WHAT YOU GET
- Cohort retention curves - by signup week, plan, channel, device or content type
- Funnel analysis: install to signup to first play to subscribe, with the exact drop-off step
- Churn analysis: which behaviours in week 1 predict cancellation in week 6
- Engagement and content: watch time, completion rate, binge sessions, dead catalogue
- Revenue view: LTV, ARPU, trial-to-paid conversion, win-back rates
- Automated refresh, so the dashboard is right every morning without you touching it
BUILT ON
Metabase, Tableau, Superset, Looker Studio or Power BI over Athena, Redshift, Snowflake, BigQuery or Postgres. Modelling in SQL or dbt.
EXPERIENCE
3.5+ years on the analytics platform for a European telecom's OTT TV and broadband apps, serving millions of users across 8 countries.
You get the dashboards plus the SQL models underneath, documented so your team can extend them instead of re-hiring for every new question.
Message me with your data source and the decision you're trying to make.
