Project overview
- Organisation
- Burda Luxury, Asia Pacific
Subscription MRR, Churn & Reactivation Intelligence
Subscription measurement covering active subscribers, new, churned, reactivated and net MRR, subscription orders, take rate, churn and reactivation, built to explain recurring-revenue movement and support commercial planning.
Context
Subscription brands need to understand why recurring revenue moved, not just what it is. Net MRR hides the churn and reactivation underneath it.
Measurement
- Active subscribers
- New MRR, churned MRR, reactivated MRR and net MRR
- Subscription orders and take rate
- Churn and reactivation
Approach
Decompose recurring-revenue movement into its components so that leadership can see the contribution of acquisition, churn and reactivation each period, with definitions governed in the semantic layer.
Purpose
A consistent explanation of recurring-revenue movement that supports commercial planning across subscription brands.
Technology
- Governed semantic models
- SQL
- dbt
Related work
- Burda Luxury, Asia Pacific
Customer Cohort & LTV Framework
Cohort retention, repurchase and lifetime-value measurement that quantifies long-term customer economics.
View project - Burda Luxury
Acquisition vs Retention Revenue
Separating new-customer growth from returning-customer performance to explain the composition of revenue.
View project - Burda Luxury, Asia Pacific
APAC Unified Commerce Analytics Platform
Governed commerce analytics across 8 brands and 5 APAC markets, built on 22+ source-specific transformation layers.
Read case study