段階的な説明
Define Your Period and Customer Cohort
Choose your reporting period (e.g., March 1st to March 31st). Then, identify *all* customers active at the *very beginning* of this period. This initial group is your "customer cohort." New customers acquired *after* this date are not included.
Calculate Initial Cohort MRR
Determine the total Monthly Recurring Revenue (MRR) generated by your customer cohort at the *exact start* of your reporting period. This is your baseline. * **Example**: For a March calculation, this is the total MRR from your cohort on February 28th.
Calculate End-of-Period Cohort MRR
Now, calculate the total MRR from the *exact same customer cohort* at the *end* of your reporting period. * Include increases from upgrades/add-ons and decreases from downgrades. * If a cohort customer churned, their MRR becomes $0. * *Do not include MRR from new customers acquired during the period.* * **Example**: For March, this is the total MRR from your cohort on March 31st.
Apply the Expansion Revenue Formula
Plug your two MRR figures into the formula: `Expansion Revenue = (End-of-Period Cohort MRR) - (Initial Cohort MRR)`
Interpret Your Results
A positive result means your existing customers are growing in value, indicating successful engagement. A negative result suggests revenue contraction from your existing base, signaling a need to investigate customer satisfaction or product value.
Welcome! Understanding how much extra revenue you're generating from your existing customers is crucial. This is "Expansion Revenue," reflecting successful upsells, cross-sells, and upgrades. Learning to calculate it manually provides deep insight into your business's health. Let's get started!
Understanding Expansion Revenue & Prerequisites
Expansion Revenue is the additional Monthly Recurring Revenue (MRR) generated from your existing customer base over a specific period. It includes revenue from upsells, cross-sells, and add-ons, but excludes revenue from new customers acquired during that period. It's a key indicator of customer satisfaction and sustainable growth.
To calculate it, you'll need:
- A Defined Reporting Period: Typically a month (e.g., March 1st to March 31st).
- Initial Cohort MRR: The total MRR from all customers active at the very beginning of your period. This group is your "customer cohort."
- End-of-Period Cohort MRR: The total MRR from the exact same customer cohort at the end of your period, accounting for upgrades, downgrades, or churn within this specific group.
The Expansion Revenue Formula
The formula is straightforward:
Expansion Revenue = (End-of-Period Cohort MRR) - (Initial Cohort MRR)
A positive result means growth from existing customers; a negative result means contraction.
Worked Example: "TechGrow Solutions"
Let's calculate Expansion Revenue for "TechGrow Solutions" for March.
Step 1: Period & Cohort
- Period: March 1st to March 31st.
- Cohort: All customers active on February 28th.
Step 2: Initial Cohort MRR (February 28th)
- Customer X: $200 MRR
- Customer Y: $150 MRR
- Customer Z: $300 MRR
- Customer W: $100 MRR
Initial Cohort MRR = �KINL0�150 + �KINL1�100 = $750
Step 3: End-of-Period Cohort MRR (March 31st for Same Cohort)
- Customer X: Upgraded to $300 MRR
- Customer Y: Added extra user, now $180 MRR
- Customer Z: Downgraded to $200 MRR
- Customer W: Remained at $100 MRR
End-of-Period Cohort MRR = �KINL2�180 + �KINL3�100 = $780
Step 4: Apply the Formula
Expansion Revenue = �KINL4�750 = $30
Result: TechGrow Solutions generated $30 in expansion revenue for March!
Common Pitfalls to Avoid
- Including New Customer Revenue: Only count revenue from customers active before your period began. New customers are a separate growth metric.
- Inconsistent Cohort: Ensure you're tracking the exact same group of customers from start to end. Don't accidentally drop or add customers to the cohort mid-calculation.
- Ignoring Downgrades/Churn: Revenue lost from existing customers (due to downgrades or churn within the cohort) must be fully accounted for. Expansion revenue isn't just about the upsides.
- Incorrect Time Periods: Be precise and consistent with your start and end dates. A slight mismatch can lead to inaccurate results.
When to Use an Expansion Revenue Calculator
While manual calculation builds a deep understanding, for larger customer bases, it becomes complex and time-consuming. Online calculators or dedicated SaaS metrics dashboards automate data aggregation and calculation, ensuring accuracy and freeing you to focus on strategic decisions. Use them for efficiency, but always understand the foundational math!
Conclusion: You've mastered the manual calculation of expansion revenue! This metric is a powerful gauge of your business's health and customer success. Keep applying these principles to understand and grow your revenue effectively!