What is the expansion revenue rate formula?
Expansion revenue rate equals expansion ARR from existing customers divided by beginning ARR, times 100.``` Expansion Rate = Expansion ARR / Beginning ARR x 100 ```
A company opening the quarter with $12,000,000 in ARR that books $240,000 of upsell, cross-sell, and renewal uplift from existing accounts has a quarterly expansion rate of 2.0 percent. Compounded across four quarters that is 8.2 percent of annual expansion contribution, assuming the rate holds.
Beginning ARR is the base on day one of the period, before any new logo lands. Expansion is every recurring increase from a customer already in that base. Both halves have to reference the same cohort or the ratio measures nothing.
What counts as expansion revenue and what does not?
Expansion is a recurring increase from a customer who was already paying at the start of the period.| Movement | Counts as expansion | Reason |
|---|---|---|
| Seat or license adds | Yes | Recurring increase on an existing contract |
| New product sold to an existing customer | Yes | Recurring, and the account was already in the base |
| Contractual price uplift at renewal | Yes | Recurring increase, though it reflects pricing rather than adoption |
| Usage overage that persists | Yes, once normalized | Annualize the sustained level, not the peak month |
| One-time services, training, or setup | No | Not recurring revenue |
| New logo signed this period | No | New business, tracked on its own line |
| Reactivated account that churned earlier | No | Count as won back, not as expansion of the current base |
How is expansion rate different from net revenue retention?
Expansion rate counts only the increases, while NRR nets them against contraction and churn.The two numbers answer different questions and can move in opposite directions. Consider a base of $20,000,000:
| Component | Amount | Effect |
|---|---|---|
| Beginning ARR | $20,000,000 | Denominator for both metrics |
| Expansion ARR | $2,400,000 | Expansion rate 12.0% |
| Contraction ARR | $900,000 | Reduces NRR |
| Churned ARR | $2,300,000 | Reduces NRR |
| Ending ARR from base | $19,200,000 | NRR 96.0% |
How do you calculate expansion rate by segment?
Run the same formula against each segment's own beginning ARR, then compare contribution to weight.Segment expansion rates rarely match. Enterprise accounts expand through new products and seat growth across departments, while the volume segment expands through plan upgrades that cap out. Calculating one blended rate across both averages away the decision.
Compare each segment's share of expansion dollars against its share of beginning ARR. A segment holding 30 percent of the base and producing 55 percent of expansion is where the next customer success hire and the next product attach should go. A segment holding 40 percent of the base and producing 8 percent of expansion has either no expansion path in the product or no one working it.
How much pipeline does expansion revenue require?
Expansion needs its own coverage ratio because expansion deals close at different rates than new business.Across ORM customer accounts, pipeline coverage runs between 1.4x and 5x, with most companies sitting near 3.5x. Applying that same multiple to expansion without checking your own conversion is a guess. Expansion deals into a happy account convert far higher than new logo deals, so a coverage figure imported from the new business motion overbuilds the target and wastes capacity.
Build coverage from your own expansion win rate instead. Total pipeline coverage without context is the most misleading number in a revenue review, since it makes executives feel informed while hiding what the pipeline is made of. The same problem shows up in the 3x coverage rule applied to any motion it was not measured on.
How do you forecast expansion revenue?
Forecast it as pipeline with stages and close dates, not as a percentage of the base. Forecast accuracy on new business and expansion combined usually lands around 90 percent when teams build it by hand, and that accuracy costs significant effort and goes stale as conditions change. ORM targets 95 percent without manual adjustments and holds it from day 1 through day 90 of the quarter, updating as the quarter progresses.The reason the manual version drifts is that expansion responds to the same market changes that move new business. Pricing pressure from a new competitor lowers uplift at renewal. A budget freeze delays a seat expansion that was modeled as certain. Percentage-of-base assumptions carry none of that, which is why the expansion line is often the first part of a plan to break.
Frequently Asked Questions
What is the expansion revenue rate formula?
Expansion revenue rate equals expansion ARR from existing customers divided by beginning ARR, times 100. Beginning ARR is the base on day one of the period, and expansion counts only recurring increases from customers who were already in that base. New logos and one-time fees stay out of both halves.
Does expansion revenue rate include price increases?
Yes, when the increase is contractual and recurring. A renewal uplift of 5 percent on a 100,000 dollar contract is 5,000 dollars of expansion ARR. Track it as a separate component from seat growth and cross-sell, because uplift is a pricing decision while the other two reflect product adoption.
What is the difference between expansion rate and net revenue retention?
Expansion rate counts only increases, so it never falls below zero. Net revenue retention nets expansion against contraction and churn, so it can fall below 100 percent while expansion is strong. A company can post a 12 percent expansion rate and 96 percent NRR at the same time, which means the expansion motion is working and the retention motion is not.
Should expansion revenue have its own pipeline?
Yes. Expansion opportunities have owners, stages, amounts, and close dates the same way new business does, and forecasting them as a fixed percentage of the base hides both the upside and the risk. Teams that carry expansion in a separate pipeline can see coverage against the expansion target rather than assuming it appears.
How often should you calculate expansion rate?
Monthly, against the same beginning ARR definition used in the ARR waterfall. Quarterly reporting hides the month a large cross-sell landed and makes a single deal look like a trend. A monthly series shows whether expansion is a repeatable motion or a handful of outsized accounts.
See how ORM turns these insights into action
ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.
Schedule a Demo