Project overview
- Organisation
- Burda Luxury, Asia Pacific
Customer Cohort, Repurchase & LTV Framework
A customer measurement framework covering cohort retention, repurchase behaviour, customer lifetime value, order behaviour and customer value, quantifying long-term customer economics beyond first-order revenue.
Context
First-order revenue understates the value of a customer. Commercial decisions on acquisition and retention need a view of how cohorts behave over time.
Measurement
- Cohort retention
- Customer repurchase
- Customer lifetime value
- Order behaviour
- Retention and customer value
Approach
Define cohorts, retention and lifetime value once in the governed semantic layer so that every brand and market measures customer economics the same way.
Purpose
Long-term customer economics quantified beyond first-order revenue, informing acquisition and retention decisions.
Technology
- Governed semantic models
- SQL
- dbt
Related work
- Burda Luxury, Asia Pacific
Subscription MRR & Churn Intelligence
Recurring-revenue measurement explaining MRR movement, churn and reactivation for subscription brands.
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
Customer Behaviour Forecasting
Customer-behaviour forecasting and audience analytics that improved targeted-advertising precision by approximately 25%.
View project