Subscription change analysis

Subscription change analysis is the practice of breaking the period over period change in recurring revenue into its component movements: new business, expansion, contraction, churn and reactivation. A single headline number, such as a 40,000 pound rise in MRR, hides a great deal. That rise could be 50,000 pounds of new business masking 10,000 pounds of churn, or it could be steady new business with strong expansion. The movements look identical on a top line chart and demand completely different responses.

The analysis matters because each movement is owned by a different part of the business and is fixed by a different action. New business sits with sales and marketing. Expansion and contraction sit with customer success and product. Churn sits with retention and support. When you only watch the net number, you cannot tell whose work moved it. Decomposing the change turns one ambiguous figure into a set of specific, accountable signals.

The net change in recurring revenue between two periods equals the sum of the positive movements minus the negative ones. Calculate each movement by comparing every active subscription at the start of the period with its state at the end. A customer who was not present at the start and is present at the end contributes new business. A customer present in both periods at a higher amount contributes expansion. A lower amount is contraction, and a customer who left entirely is churn.

Worked through a simple example: you start a month at 200,000 pounds of MRR. You add 30,000 pounds of new business, 12,000 pounds of expansion and 3,000 pounds of reactivation, while losing 8,000 pounds to contraction and 14,000 pounds to churn. Net change is 30,000 plus 12,000 plus 3,000 minus 8,000 minus 14,000, which is a positive 23,000 pounds. The month closes at 223,000 pounds. The net looks healthy, but 22,000 pounds of revenue was working against you under the surface.

1. 1

   New business MRR

   Recurring revenue from customers who were not subscribed at the start of the period and are subscribed at the end. This is the engine of growth from the top of the funnel.

2. 2

   Expansion MRR

   Added recurring revenue from existing customers who upgraded tiers, bought more seats or adopted paid add-ons during the period.

3. 3

   Reactivation MRR

   Recurring revenue from previously churned customers who returned during the period. Track it separately from new business because the playbook to win them back differs.

4. 4

   Contraction MRR

   Lost recurring revenue from existing customers who downgraded or reduced seats but did not cancel. A warning sign that often precedes full churn.

5. 5

   Churn MRR

   Recurring revenue from customers who cancelled entirely during the period. The most visible loss and the most expensive to replace.

A metric tree turns subscription change analysis from a static waterfall chart into a living model of cause and effect. The net change sits at the root. Beneath it sit the five movements, and beneath each movement sit the operational drivers that the responsible team can actually influence. Expansion is not a mystery; it is seat growth plus tier upgrades plus add-on attach. Churn is not a single force; it is voluntary cancellation plus failed payments plus contract non-renewal.

KPI Tree lets you model this decomposition and connect each branch to the team that owns it. Contraction sits with customer success, failed-payment churn sits with finance and billing, and new business sits with sales. With RACI ownership on every node, the accountable owner is pushed an alert when their specific movement deviates, so a spike in contraction reaches the customer success lead the same week it happens, not in a quarterly review. The gap between the dashboard and the decision closes because the number arrives next to the person who can act on it.

There is no single benchmark for net MRR change, because the healthy mix of movements depends on company stage and motion. What you can benchmark is the relationship between the movements. A well-run SaaS business wants expansion to grow faster than contraction and wants churn held to a low single-digit monthly rate. The table below gives indicative monthly ranges for subscription-based businesses, expressed as a percentage of starting MRR.

The clearest summary signal sits one level up. When expansion plus reactivation exceeds contraction plus churn, your existing customer base grows revenue on its own, before a single new logo is added. That condition produces net revenue retention above 100 percent, and it is the trait investors look for most closely. Read more in net revenue retention.

You cannot improve the net number directly. You improve it by moving the components, and the discipline of the analysis is knowing which component to attack first. Always start with the largest negative movement, because a pound recovered from churn is worth the same as a pound won in new business but usually costs far less to capture.

1. 1

   Netting expansion against churn

   Reporting only net change hides the size of both forces. A business with 10 percent expansion and 9 percent churn looks like the same 1 percent grower as one with 2 percent expansion and 1 percent churn. They are not remotely the same business.

2. 2

   Mixing one-time revenue into the movements

   Including setup fees or services revenue inflates new business and breaks the reconciliation to MRR. Keep the scope strictly recurring.

3. 3

   Counting reactivation as new business

   Returning customers behave differently from first-time customers. Folding them into new business overstates top-of-funnel performance and hides your win-back rate.

4. 4

   Ignoring contraction

   Downgrades feel minor next to cancellations, so teams often skip them. Contraction is the earliest warning that an account is slipping and the cheapest moment to act.