What This Template Is For
The best SaaS companies grow faster from existing customers than from new ones. Expansion revenue (upsells, cross-sells, seat additions, usage growth) compounds in a way that new logo acquisition cannot: it has lower CAC, higher margins, and faster close rates.
Yet most teams track expansion loosely. They know total MRR and maybe net revenue retention, but they cannot answer specific questions: Which expansion motion contributes the most? What is the average time from initial purchase to first upsell? Which customer segments expand fastest? Which do not expand at all?
This template gives you the framework to track expansion revenue across every dimension that matters: by motion (upsell, cross-sell, seat expansion, usage growth), by segment, by time, and against targets. It pairs with the Product Analytics Handbook for measurement methodology and the net revenue retention glossary entry for calculation standards.
The free-to-paid template covers the initial conversion that precedes expansion. Use the RICE Calculator to prioritize which expansion initiatives to invest in when resources are limited.
When to Use This Template
- When building a revenue dashboard. Expansion metrics belong alongside new business and churn metrics in every revenue review.
- When net revenue retention is below 110%. Sub-110% NRR means contraction and churn are eating more than expansion produces. This template helps diagnose where.
- When planning pricing changes. Understanding which expansion motions work reveals what customers value enough to pay more for.
- During annual planning. Expansion targets by segment and motion give the revenue team specific, measurable goals.
- When evaluating product-led growth. Self-serve expansion (seat adds, usage upgrades) is the engine of PLG. Track it separately from sales-assisted expansion.
How to Use This Template
Step 1: Define Expansion Motions
List every way a customer's revenue can increase: plan upgrades, seat additions, usage overage, add-on purchases, cross-sell of new products. Each motion has different triggers, economics, and growth potential.
Step 2: Calculate Current Expansion Metrics
Fill in the core metrics for the last 3-6 months. Many of these require pulling data from your billing provider and CRM. If you cannot calculate a metric, note the gap. Missing data is a finding.
Step 3: Segment the Data
Break expansion by customer segment: plan tier, company size, industry, tenure, acquisition channel. The average hides the segments that expand aggressively and the ones that never expand at all.
Step 4: Set Targets
For each expansion motion and segment, set monthly or quarterly targets based on historical performance and strategic priorities. Targets should be specific enough to evaluate.
Step 5: Identify Bottlenecks
Compare expansion rates across segments and motions to find the biggest gaps. A segment with high product usage but low expansion rate has an untapped upsell opportunity.
The Template
Expansion Motion Inventory
| Motion | Trigger | Mechanism | Avg Revenue per Event | Frequency |
|---|---|---|---|---|
| Plan upgrade | Customer needs features on higher plan | Self-serve upgrade flow / Sales-assisted | $[X]/mo | [Monthly / Quarterly] |
| Seat expansion | Customer adds team members | Self-serve seat add / Sales quote for bulk | $[X]/seat/mo | [Monthly / Quarterly] |
| Usage overage | Customer exceeds plan limits | Automatic billing / Notification + upgrade prompt | $[X]/overage unit | [Monthly] |
| Add-on purchase | Customer wants optional capability | Self-serve add-on toggle / Sales bundle | $[X]/mo | [Quarterly / Annual] |
| Cross-sell | Customer adopts second product | Sales-assisted / In-product recommendation | $[X]/mo | [Annual] |
Core Expansion Metrics
| Metric | Definition | Current | 3-Month Avg | Target | Status |
|---|---|---|---|---|---|
| Net Revenue Retention (NRR) | (Starting MRR + Expansion - Contraction - Churn) / Starting MRR | [%] | [%] | [%] | [Above / Below target] |
| Gross Revenue Retention (GRR) | (Starting MRR - Contraction - Churn) / Starting MRR | [%] | [%] | [%] | [Above / Below target] |
| Expansion MRR | Total revenue increase from existing customers this month | $[X] | $[X] | $[X] | [Above / Below target] |
| Expansion Rate | Expansion MRR / Starting MRR | [%] | [%] | [%] | [Above / Below target] |
| Contraction MRR | Revenue decrease from downgrades | $[X] | $[X] | $[X] | [Above / Below target] |
| Churn MRR | Revenue lost from cancellations | $[X] | $[X] | $[X] | [Above / Below target] |
| Net Expansion | Expansion MRR - Contraction MRR - Churn MRR | $[X] | $[X] | $[X] | [Positive / Negative] |
Expansion by Motion
| Motion | MRR Added This Month | % of Total Expansion | Customers Expanded | Avg Expansion / Customer | YoY Change |
|---|---|---|---|---|---|
| Plan upgrades | $[X] | [%] | [N] | $[X] | [+/-X%] |
| Seat expansion | $[X] | [%] | [N] | $[X] | [+/-X%] |
| Usage overage | $[X] | [%] | [N] | $[X] | [+/-X%] |
| Add-on purchases | $[X] | [%] | [N] | $[X] | [+/-X%] |
| Cross-sell | $[X] | [%] | [N] | $[X] | [+/-X%] |
| Total | $[X] | 100% | [N] | $[X] | [+/-X%] |
Expansion by Customer Segment
| Segment | Customers | Expansion Rate | NRR | Avg Time to First Expansion | Top Motion | Opportunity |
|---|---|---|---|---|---|---|
| [Plan: Starter] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Plan: Pro] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Plan: Enterprise] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Size: 1-10] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Size: 11-50] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Size: 51-200] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
| [Size: 200+] | [N] | [%] | [%] | [N months] | [Motion] | [Notes] |
Expansion Funnel
| Stage | Count | Conversion to Next | Avg Days in Stage |
|---|---|---|---|
| Eligible for expansion (current customers) | [N] | [%] | N/A |
| Showed expansion signal (hit usage limit, viewed pricing, asked sales) | [N] | [%] | [N days] |
| Entered expansion flow (started upgrade/add flow) | [N] | [%] | [N days] |
| Completed expansion (payment processed) | [N] | N/A | [N days] |
Expansion funnel conversion rate: [%] (eligible to completed)
Biggest drop-off: [Stage] to [Stage] at [%] conversion
Monthly Expansion Tracking
| Month | Starting MRR | New MRR | Expansion MRR | Contraction MRR | Churn MRR | Ending MRR | NRR |
|---|---|---|---|---|---|---|---|
| [Month 1] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
| [Month 2] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
| [Month 3] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
| [Month 4] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
| [Month 5] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
| [Month 6] | $[X] | $[X] | $[X] | $[X] | $[X] | $[X] | [%] |
Expansion Metrics Checklist
- ☐ Inventoried all expansion motions (upgrades, seats, usage, add-ons, cross-sell)
- ☐ Calculated NRR and GRR for the last 6 months
- ☐ Broken down expansion MRR by motion
- ☐ Segmented expansion by customer plan, size, and tenure
- ☐ Calculated average time from initial purchase to first expansion
- ☐ Built expansion funnel: eligible, signaled, entered flow, completed
- ☐ Identified the highest-potential expansion segment (high usage, low expansion rate)
- ☐ Set monthly expansion targets by motion and segment
- ☐ Configured alerts for NRR dropping below threshold
- ☐ Scheduled monthly expansion review in revenue meeting
Filled Example: B2B Workflow Automation Platform
Core Metrics (February 2026)
| Metric | Value | Target | Status |
|---|---|---|---|
| Net Revenue Retention (NRR) | 118% | 115% | Above target |
| Gross Revenue Retention (GRR) | 91% | 90% | Above target |
| Expansion MRR | $48,200 | $42,000 | Above target |
| Expansion Rate | 7.2% | 6.0% | Above target |
| Contraction MRR | $8,100 | < $10,000 | On target |
| Churn MRR | $12,300 | < $15,000 | On target |
| Net Expansion | $27,800 | $17,000 | Above target |
Expansion by Motion (February 2026)
| Motion | MRR Added | % of Total | Customers | Avg / Customer |
|---|---|---|---|---|
| Seat expansion | $22,400 | 46.5% | 134 | $167 |
| Plan upgrades | $14,800 | 30.7% | 28 | $529 |
| Usage overage | $6,200 | 12.9% | 87 | $71 |
| Add-on (advanced reporting) | $4,800 | 10.0% | 16 | $300 |
| Total | $48,200 | 100% | 265 | $182 |
Key Finding
Seat expansion drives 46.5% of all expansion revenue with no sales involvement. It is entirely self-serve. The average customer adds 1.8 seats in their first 6 months. However, customers on the Starter plan expand seats at half the rate of Pro customers (0.9 vs. 1.8 seats added per 6 months). The Starter plan's 5-seat limit creates friction: teams hit the limit and evaluate whether to upgrade plans rather than just adding seats. Recommendation: raise the Starter seat limit to 10 and capture seat expansion revenue earlier in the customer lifecycle.
Key Takeaways
- Track expansion by motion. Seat expansion, plan upgrades, usage overage, and cross-sell each have different economics and growth potential
- Segment expansion by customer type. The average hides segments with untapped expansion potential
- NRR above 110% means your existing customers grow your revenue even with zero new sales. This is the most powerful SaaS metric
- Self-serve expansion is the highest-margin growth. Invest in making it frictionless
- Declining expansion rate is an early warning of retention problems. Do not wait for churn to confirm it
About This Template
Created by: Tim Adair
Last Updated: 3/5/2026
Version: 1.0.0
License: Free for personal and commercial use