Expansion ARR
Annualized recurring revenue added during the period from existing customers — through upsell (more seats / higher tier), cross-sell (additional products), or price increases. The "farm" line of the ARR waterfall. Boards read this as the leading indicator that product-market fit has translated into product-account fit and that the post-sale motion is creating compound growth. Common pitfall: classifying contractual price-step-ups (CPI escalators baked into the original contract) as expansion overstates new selling motion. Expansion CAC Ratio and Net Revenue Retention are derived from this number. — Sales KPI, I'mBoard-authored (editorial tier).
I'mBoard-authored (editorial tier)
No public third-party standard anchors this KPI yet, so I'mBoard authors and maintains the definition — transparently labeled as editorial tier. See the ontology methodology for the published vs editorial tier system and the back-attribution workstream.
Rogue ID: sales.expansion
Type: Currency
Domain: Sales
Definition
Annualized recurring revenue added during the period from existing customers — through upsell (more seats / higher tier), cross-sell (additional products), or price increases. The "farm" line of the ARR waterfall. Boards read this as the leading indicator that product-market fit has translated into product-account fit and that the post-sale motion is creating compound growth. Common pitfall: classifying contractual price-step-ups (CPI escalators baked into the original contract) as expansion overstates new selling motion. Expansion CAC Ratio and Net Revenue Retention are derived from this number.
Formula
Expansion ARR = (ARR from existing customers at period close) − (ARR from those same customers at period start) for the subset where the delta is positive. Excludes downgrades (tracked separately) and excludes new-logo bookings. Pre-contracted CPI escalators may or may not be treated as expansion — pick one convention per the company and apply it consistently.Why it matters
A high expansion line is the single best predictor of capital-efficient compounding growth — the SaaS playbook depends on existing customers expanding faster than new ones churn. Drives NRR, which is the metric public-market investors weight most heavily on the retention side of the model.
How to interpret
Expansion ARR ≥ Churned + Downgrade ARR means NRR ≥ 100% (the "leaky bucket gets refilled by upsell" condition). Per KBCM/Sapphire SaaS Survey 2024 §Net Revenue Retention, median NRR is roughly 105–110% for $5M+ ARR SaaS — below 100% is a yellow flag at any stage; above 120% signals a category-leading account-expansion motion.
Calculation policy
How an AI agent should compute this KPI from messy company data. Free-text rules consumed at reasoning time — not a deterministic DSL. The most common ways to get this wrong are listed under Common miscomputations.
Inclusion rules
- Sum of (end-of-period ARR − start-of-period ARR) per customer, restricted to existing customers and to the subset where the delta is positive.
- Includes upsell (more seats, more capacity), cross-sell (additional products/modules), tier upgrades, and discretionary price increases negotiated mid-term.
- Disclose handling of contractual CPI escalators baked into the original contract — pick a convention (count or don't) and apply consistently.
Exclusion rules
- New-logo ARR — those are in
sales.new_business. - Customers who started the period with zero ARR (they're new logos, not expansions, even if they upgraded the same period).
- Negative deltas (downgrades) — those go in
sales.downgrades. - Renewals at the same price — those are retention, not expansion.
Required inputs
- Customer-level ARR snapshot at period start.
- Customer-level ARR snapshot at period end.
- Convention flag: are contractual CPI escalators counted as expansion?
Data-source priority
- Customer-level ARR ledger keyed by stable account ID (same source as NRR/GRR).
- CRM contract changelog as a fallback when the ledger isn't available.
Edge cases
- Customer who upgraded AND downgraded different products in the same period: net the per-customer delta; if positive, count in expansion (only).
- Mid-period contract amendment: take the period-end ARR vs period-start ARR for the customer; don't double-book intermediate changes.
- Account mergers (parent acquires sub-customer): treat the consolidated entity as the new cohort; don't count the consolidation as expansion.
- Price-pack upgrade (Pro→Enterprise) at renewal: count the delta as expansion, not as renewal.
Validation checks
- Expansion ARR ≥ 0 always.
- Per-customer expansion ≤ their period-end ARR (you can't expand by more than the customer pays).
- Sum of all expansion line items reconciles to the aggregate expansion number within 1%.
Common miscomputations
- Counting price-step-ups that were pre-contracted (CPI escalators) as expansion — inflates the selling-motion narrative without any actual sales activity.
- Including new-logo upsells (customer signed Tier 1 then upgraded to Tier 2 in the same period) as expansion — they're part of the new-logo motion.
- Netting downgrades against expansion at the customer level and reporting the net as "expansion" — they're different lines for a reason.
- Cohort drift: counting expansion from customers who weren't in the starting-period cohort. The cohort must be closed at period start.
- Counting renewal value as expansion — renewal at the same price is retention, not expansion.
Related KPIs
sales.arrsales.new_businesssales.churn_arrsales.downgradessales.expansion_cac_ratiocustomers.net_revenue_retentioncustomers.gross_revenue_retention
Source
I'mBoard editorial — authored and maintained by I'mBoard, first published 2026-04-01. No third-party standard is cited for this KPI; when one emerges, the definition is back-attributed and promoted to the published tier (a minor version bump). Read the ontology methodology for the published vs editorial tier system, attribution rules, and dispute process.
Stage relevance
| Company stage | Priority |
|---|---|
| Series A | Core |
| Series B | Core |
| Series C+ | Recommended |
| Public | Recommended |
Suggested for stages: Series A, Series B, Series C+, Public.
Default owning functions
- Sales
Machine-readable
- This KPI as JSON:
/api/ontology/sales/expansion.json - All Sales KPIs:
/api/ontology/sales.json - Full catalog:
/api/ontology/index.json
Downgrade ARR
Annualized recurring revenue lost from existing customers who reduced spend mid-term or at renewal (seat reductions, tier downgrades, removed modules) — without leaving entirely. The "contraction" line of the ARR waterfall, distinct from full churn. Often a more sensitive leading indicator than churn because customers tend to contract before they cancel. Common pitfall: lumping downgrades into churn obscures the early-warning signal — boards looking only at logo churn miss the slow-bleed pattern. Surfaces in the KpiVarianceTable widget alongside expansion and churn so the net-retention math is auditable. — Sales KPI, I'mBoard-authored (editorial tier).
Expansion CAC Ratio
Fully-loaded S&M plus Customer Success expense attributable to expansion divided by expansion CARR generated in the period. Per SMSB, the efficiency read on the upsell / cross-sell / land-and-expand motion. Distinct from the new-logo CAC ratio because the cost base often includes CSMs whose primary metric is retention but whose secondary metric is expansion — boards expect to see that allocation called out. Common pitfall: excluding CS comp entirely understates the true cost of expansion; including all of CS overstates it. The SMSB standard prescribes a documented allocation rule (typically tied to expansion-quota OTE share). — Sales KPI anchored to SaaS Metrics Standards Board.