Churned MRR: MRR lost from customers who cancelled their subscriptions.
Formula
Churned MRR = Sum of (MRR from customers who churned this period)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
-sum(field.mrr_change where field.event_type = 'churn')Unit: currency
Breakdowns
by_segment: one row persegmentvalue
Notes: Churn events carry a negative mrr_change; the metric reports a positive amount. by_segment returns one row per customer segment, so churn concentrated in one segment is visible.
Data requirements
Grain: Per event, aggregate monthly · Frequency: Daily sync · Aggregation: aggregate (month) · Staged: no · Main source: Billing.
| Field | Dataset | Type |
|---|---|---|
event_date | revenue_event | date |
event_type | revenue_event | string |
mrr_change | revenue_event | decimal |
Example SQL (Postgres)
SELECT (-(SELECT COALESCE(SUM(mrr_change), 0) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'churn')) AS churned_mrr Access: recommended
sensitivity tier confidential,
access scope unscoped.
Guidance your policy engine enforces.
From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Churned MRR" }) or generate_query({ "metric": "Churned MRR", "adapter": "<your adapter JSON>" }).
What It Tells You
The leakage in your revenue bucket from customer attrition.
Related Metrics
Connected in the GASP relationship graph.
Upstream: what drives this
- NPS predicts Churned MRR (Core)
- Logo Churn Rate drives Churned MRR (Core)
- Churned Customers drives Churned MRR (Core)
Downstream: what this drives
- Churned MRR component of GRR (Core)
- Churned MRR component of Net New MRR (Core)
- Churned MRR component of NRR (Core)
- Churned MRR component of Revenue Churn Rate (Core)
- Churned MRR measures Customer (Entity)
- Churned MRR measures Subscription (Entity)