Net New MRR: The net change in MRR after accounting for all movements.
Formula
Net New MRR = New MRR + Expansion MRR + Reactivation MRR - Churned MRR - Contraction MRRComputable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
metric.new_mrr + metric.expansion_mrr + metric.reactivation_mrr - metric.churned_mrr - metric.contraction_mrrUnit: currency
Notes: Five movements: carry MRR plus new, expansion and reactivation MRR is ending MRR.
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 = 'new')) + ((SELECT COALESCE(SUM(mrr_change), 0) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'expansion'))) + ((SELECT COALESCE(SUM(mrr_change), 0) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'reactivation'))) - ((-(SELECT COALESCE(SUM(mrr_change), 0) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'churn')))) - ((-(SELECT COALESCE(SUM(mrr_change), 0) FROM revenue_event WHERE event_date >= :period_start AND event_date <= :period_end AND event_type = 'contraction')))) AS net_new_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": "Net New MRR" }) or generate_query({ "metric": "Net New MRR", "adapter": "<your adapter JSON>" }).
What It Tells You
Whether MRR grew or shrank over the period and by how much, after every movement is counted.
Related Metrics
Connected in the GASP relationship graph.
Upstream: what drives this
- Churned MRR component of Net New MRR (Core)
- Contraction MRR component of Net New MRR (Core)
- Expansion MRR component of Net New MRR (Core)
- New MRR component of Net New MRR (Core)
- Reactivation MRR component of Net New MRR (Core)
Downstream: what this drives
- Net New MRR drives MRR (Core)
- Net New MRR measures Customer (Entity)
- Net New MRR measures Subscription (Entity)