DD15 Subscriptions: MRR & Churn: how it was built
Is recurring revenue growing, and is churn under control after the price change? Rebuild this dashboard step by step in the Data Canvas.
DD15 · Subscriptions: MRR & Churn
Code in this build: 5 widgets written in SQL, and no settings written as code.
The question: Is recurring revenue growing, and is churn under control after the price change?
Who asks, and when: The head of subscriptions, monthly.
The decision: Whether recurring revenue is growing, and whether churn is under control after the price change.
What the dashboard shows: February 2026 was the worst month of the year for retention - every cohort kept less of itself, and price is the reason 86 subscribers gave when they left - yet MRR is at a new high of 99,781.43, with 8,102.58 of it won back by expansion over the last 12 months.
Follow the pictures below, in order, and you end up with the same dashboard. Every step is one thing you do in the Data Canvas, on the demo data that installs with DataPallas.