MRR Changes: See Which Customers Drive Revenue Growth or Decline

Total MRR is one number. It can rise while the base underneath it weakens. A month that closes up three percent might be a burst of new installs covering forty merchants who quietly left. The total cannot tell you which.

The fix is to look at MRR changes by customer. Instead of asking whether MRR went up, ask which merchants moved it, and in which direction. That turns a status figure into something you can act on.

This is different from ranking merchants by how much they pay, which is covered in the top customers dashboard. A ranking shows level. This guide is about change. It covers the five MRR movements, how to attribute each one to specific merchants, how to read the result, and the rules a Shopify app needs to decide first.

TL;DR: MRR Changes by Customer

‍

Why Total MRR Hides the Story

Two months can post the same net change and describe completely different businesses. The difference sits in what came in and what leaked out.

‍

Both months added $1,000. Month X had to win $2,000 of new and expansion revenue to get there, because $1,000 leaked out. Month Y kept almost everything it won. A dashboard showing only the total treats them as identical.

This is why net new MRR alone is a weak guide. The same point runs through the Shopify app performance dashboard: every top-line number needs a segmented view behind it.

The Five MRR Movements

Guidance on MRR converges on the same set of categories. One MRR guide breaks recurring revenue into new, expansion, reactivation, contraction, and churned MRR. Each answers a different question.

‍

Contraction deserves a note. Chargebee's definition counts downgrades, removed add-ons, and even discounts as contraction. It often signals a pricing or packaging issue, so it deserves attention before merchants cancel outright.

The formula that combines them is short. Net new MRR equals new plus expansion plus reactivation, minus contraction and churn. One-time fees never belong in any of the five.

5 Steps to See MRR Changes by Customer

1. Snapshot each merchant's MRR at the start and end of the period

Use one normalised figure per merchant. An annual plan should be spread across twelve months, so a $1,200 annual plan contributes $100 a month. Keep usage charges out of this figure.

2. Calculate each merchant's difference

Subtract starting MRR from ending MRR for every merchant, including those who did not change. A zero is information too.

3. Classify each difference into exactly one movement

A widely used method assigns every merchant to one bucket. No prior MRR means new. Ending above a positive start means expansion. Ending below start but above zero means contraction. Ending at zero from a positive start means churn. A zero start for a merchant who existed before means reactivation.

4. Rank merchants inside each movement

Sort each bucket by dollar size. The top five merchants in expansion and the top five in churn usually explain most of the month.

5. Reconcile to the total

Beginning MRR plus new, expansion, and reactivation, minus contraction and churn, must equal ending MRR exactly. If it does not, a rule is missing or a merchant is misclassified.

A worked example

Six merchants, one month. The figures are illustrative.

Starting MRR across these six is $506. Add $99 new, $120 expansion, and $49 reactivation. Subtract $120 contraction and $149 churn. The result is $505, which matches the ending total.

Total MRR moved by minus one dollar. It looks flat. Underneath, $268 came in and $269 went out, and the quick ratio is 0.8. Merchant D is the largest single loss. Merchant C shows a downgrade worth a closer look. Only the customer-level view shows either.

Rules to Decide Once

Classification is not automatic. Guidance on building a waterfall warns that without agreed rules, two analysts produce two different waterfalls from the same data. Settle the edge cases before the first report.

These rules are suggestions, not standards. The point is that whichever rule you pick is applied the same way every period.

What Is Specific to Shopify Apps

Shopify's own billing documentation explains why these rules matter. Shopify App Pricing supports fixed recurring charges, monthly or yearly, usage-based pricing, and combinations of the two. Usage charges must be billed monthly and cannot be combined with yearly-only plans.

The event data to do this properly exists. Shopify's Active Subscription and Historical APIs report subscription status, including active, pending, cancelled, and frozen, and keep a full log of installs, uninstalls, subscription changes, charges, credits, and usage.

Two further details help. An app can have only one active subscription per merchant, per the subscription billing documentation. A plan change is therefore best treated as one movement, classified by the net change. Shopify-specific MRR guides from SaaS Insights and Baremetrics explain the calculation, and Baremetrics spells out the annual-plan normalisation used above.

Reading the Result: Net New MRR and the Quick Ratio

The quick ratio compresses the waterfall into one figure. The formula, per Baremetrics, divides new plus expansion by contraction plus churn. It shows how many dollars you add for every dollar that leaks out. Some versions add reactivation to the numerator.

‍

The bands above are commonly cited, for example on one MRR calculator site. Treat them as rough guides. Chargebee notes a lower ratio is not automatically a warning, since it depends heavily on scale and stage. The direction matters more than the level.

Look at the denominator first

When the ratio falls, the instinct is to buy more acquisition. Fiscal Lion's guidance argues that is usually wrong. A falling ratio more often comes from rising churn or shrinking expansion than from too few new customers. If churn plus contraction has grown as a share of the prior month's base over 90 days, the problem is retention.

That is where the customer-level view earns its keep. It shows whether the losses come from one plan, covered in churn rate by pricing plan, or from a handful of large merchants.

What to Do With the Names

A list of merchants behind each movement is only useful if it points to an action. Each bucket calls for a different response.

The links between them are direct. Expansion signals are covered in revenue opportunities in existing customers. Contraction feeds plan-level churn data and pricing strategy. Churn connects to finding at-risk customers. A large loss on a top-plan merchant belongs in the queue described in churn signals for sales.

Cadence matters too. The waterfall is a monthly review, while failed payments and new cancellations belong on the daily view covered in daily SaaS metrics.

Seeing It Without Rebuilding It Each Month

Building this by hand means exporting subscription events, normalising plans, classifying every merchant, and reconciling to the total. It is doable once. Repeating it monthly is where it tends to lapse.

Elevate reads subscription data from your Shopify Partner account. Its MRR changes view is built for the question in this guide: which customers are driving revenue growth, and which are driving decline. A move in the total leads straight to the merchants behind it.

General SaaS guides explain the categories and the quick ratio thoroughly. The Shopify-specific MRR pages reviewed focus mostly on the calculation itself. None of them walk through attributing each movement to individual merchants, which is the gap this page addresses.

Frequently Asked Questions

How do I see MRR changes by customer?
Compare each merchant's normalised MRR at the start and end of the period. Classify every difference into new, expansion, reactivation, contraction, or churn, then rank merchants within each movement.

What is net new MRR?
New MRR plus expansion MRR plus reactivation MRR, minus contraction MRR and churned MRR. It is the total change in MRR over the period, before you look at what caused it.

What is the difference between contraction and churn?
Contraction is a merchant paying less but still subscribed, through a downgrade, a removed add-on, or a discount. Churn is a merchant whose MRR falls to zero.

How do I calculate the SaaS quick ratio?
Divide new MRR plus expansion MRR by churned MRR plus contraction MRR. Some versions add reactivation to the top. A ratio of four or more is generally seen as healthy, though the right level depends on scale.

How should annual plans and usage charges be treated?
Spread annual plans across twelve months so a $1,200 plan contributes $100 a month. Report usage charges separately, so metered revenue does not distort the recurring line.

How do I know my MRR waterfall is correct?
Beginning MRR plus new, expansion, and reactivation, minus contraction and churn, must equal ending MRR exactly. If it does not, a classification rule is missing or a merchant is misclassified.

‍