Analysis Overview
Analysis overview and configuration
| Parameter | Value | _row |
|---|---|---|
| plan_amount_divisor | 100 | plan_amount_divisor |
| include_trialing | FALSE | include_trialing |
| currency_symbol | USD | currency_symbol |
Purpose
This analysis examines the SaaS company's subscription revenue health through Stripe data, tracking Monthly Recurring Revenue (MRR) trends, subscriber growth, and churn patterns over an 11-month period (January–November 2024). Understanding these metrics is essential for assessing business sustainability and identifying growth inflection points.
Key Findings
- Current MRR: $2,901.75 with 0% month-over-month growth—indicating plateau after sustained expansion
- Active Subscribers: 41 customers generating $70.77 average revenue per user (ARPU)
- Growth Trajectory: MRR grew 549% from $447 (Jan) to peak of $2,901.75 (Oct), then stalled in November
- Churn Rate: 1.69% average monthly churn, with early months (Jan–May) showing zero churn before stabilizing at ~2.4–3.3%
- Plan Distribution: Enterprise tier dominates at 64% of MRR ($1,641.75) with 11 subscribers; Pro and Basic contribute 28.6% and 7.4% respectively
Interpretation
The company experienced explosive early-stage growth through mid-2024, adding 4–6 new subscribers monthly with minimal churn. However, growth de
Data preprocessing and column mapping
Purpose
This section documents the data cleaning process applied to the raw Stripe subscription dataset before MRR analysis. A 92% retention rate indicates selective but conservative filtering, which is critical for ensuring the reliability of subscription metrics like churn rate, ARPU, and revenue trends that directly inform business health assessment.
Key Findings
- Retention Rate: 92% (46 of 50 rows retained) - A healthy threshold suggesting minimal data loss while removing problematic records
- Rows Removed: 4 observations excluded based on documented criteria (trialing subscriptions and invalid records)
- Train/Test Split: Not applicable - This is descriptive analytics rather than predictive modeling, appropriate for subscription monitoring
Interpretation
The preprocessing strategy prioritizes data integrity over volume by excluding trialing subscriptions, which would artificially inflate subscriber counts and distort churn calculations. This decision directly supports the MRR analysis objective by ensuring that only active, revenue-generating subscriptions contribute to metrics like the current $2,901.75 MRR and 1.69% average churn rate. The 8% removal rate is proportional and justified.
Context
The documented assumptions (plan amounts in cents, annual-to-monthly conversion, trialing exclusion) are essential for interpreting downstream metrics. However, the small dataset size (46 final rows) may ampl
Executive Summary
Executive summary of MRR analysis findings and recommendations
| Metric | Value | Assessment |
|---|---|---|
| Current MRR | $2,902 | Current monthly baseline |
| MoM Growth | 0% | flat or declining |
| Avg Churn Rate | 1.7% | healthy churn rate |
| ARPU | $70.77 | Average revenue per active subscriber |
| Active Subscribers | 41 | Currently active paid subscribers |
Key Findings:
• MRR reached $2,902 at end of analysis period
• ARPU of $70.77 indicates average subscription value
• Churn rate of 1.7% is healthy churn rate
• Total of 5 subscribers have churned
Recommendations: Maintain current retention practices — focus on acquiring new subscribers to grow MRR.
Purpose
This executive summary synthesizes 11 months of Stripe subscription data to assess the SaaS company's revenue health and growth trajectory. The analysis evaluates whether the business is achieving sustainable MRR expansion and healthy unit economics through the lens of subscriber acquisition, retention, and pricing strategy.
Key Findings
- Current MRR: $2,902 from 41 active subscribers—representing 549% growth from the $447 baseline in January 2024, demonstrating strong early-stage expansion
- Growth Momentum: 0% month-over-month growth in November signals deceleration after consistent gains through October, with growth rates declining from 137.8% (Feb) to single digits by Q4
- Churn Rate: 1.7% average is healthy and well-controlled, with only 5 total churned subscribers across the period; churn remained zero through May before stabilizing at ~2-3% thereafter
- ARPU Trend: $70.77 current ARPU declined from $149-151 in early months, reflecting subscriber mix shift toward lower-tier plans (Basic at $19/sub vs. Enterprise at $149.25/sub)
- Plan Concentration: Enterprise plan dominates revenue at 64% of MRR despite representing only 27% of subscriber base, creating revenue concentration risk
###
MRR Growth Trend
Monthly Recurring Revenue trend over the analysis period
Purpose
This section measures the company's total predictable monthly subscription revenue and tracks its growth trajectory. MRR is the foundational metric for SaaS health, indicating both revenue stability and business momentum. Understanding MRR trends reveals whether the company is scaling sustainably and approaching revenue plateaus.
Key Findings
- Current MRR: $2,902 from 41 active subscribers—representing the baseline for forecasting and financial planning
- Total Growth: 549.2% expansion from $447 (January 2024) to peak of $2,902 (October 2024)—demonstrating strong early-stage scaling
- Growth Deceleration: Month-over-month growth declined from 137.8% (Feb) to 0% (Nov), indicating the company has reached a plateau after 10 months of expansion
- Subscriber-Revenue Alignment: Active subscribers grew from 3 to 41 (1,267% increase), slightly outpacing MRR growth, suggesting average revenue per user (ARPU) compression
Interpretation
The company achieved exceptional early growth but has stalled at $2,902 MRR with flat month-over-month performance in November. The divergence between subscriber growth and MRR growth—with ARPU declining from $149 to $70.77—suggests new customers are
MRR Movement
Monthly MRR movement: new subscription revenue vs cancelled subscription revenue
Purpose
This section isolates the components of MRR change by separating new revenue from cancellations. Understanding MRR movement is critical for diagnosing growth quality—distinguishing between strong acquisition momentum and offsetting churn reveals whether the company is building sustainable revenue or experiencing deteriorating retention.
Key Findings
- Total New MRR: $3,207 added across 11 months demonstrates consistent acquisition activity with an average of $291/month in new subscription revenue
- Total Churned MRR: $305 represents only 9.5% of new MRR, indicating strong net retention despite churn beginning in mid-2024
- Net MRR Growth: $2,902 reflects the cumulative impact, translating to the current $2,901.75 MRR baseline
- Best Growth Month: February 2024 ($616 net new MRR) established early momentum; subsequent months show declining acquisition velocity with increasing churn pressure
Interpretation
The company achieved substantial net growth through early 2024, but the pattern reveals a transition point around July when churn first appeared. While absolute churn remains modest (averaging 0.45 subscribers/month), the declining new MRR trend—from $616 to $19 by November—suggests acquisition may be slowing faster than churn is accelerating. This creates
MRR by Plan
Current MRR distribution across subscription plan tiers
Purpose
This section reveals how revenue concentration across pricing tiers shapes the company's MRR profile and growth trajectory. Understanding plan-level distribution is critical for identifying which customer segments drive profitability and whether the business relies too heavily on a single tier, which could create vulnerability if that segment churns.
Key Findings
- Enterprise Plan Dominance: Generates $1,641.75 MRR (64% of total) from only 11 subscribers, with the highest per-subscriber value at $149.25
- Pro Plan Balance: Contributes $735 MRR (28.6%) from 15 subscribers at $49 per subscriber—the largest subscriber base
- Basic Plan Underperformance: Represents only $190 MRR (7.4%) from 10 subscribers at $19 per subscriber
- ARPU Composition: The $70.77 average is heavily weighted upward by Enterprise customers, masking the lower monetization of Basic tier users
Interpretation
The revenue model exhibits significant concentration risk: two-thirds of MRR depends on just 11 Enterprise customers. While this demonstrates strong pricing power at the high end, the Basic tier's minimal contribution suggests either weak market positioning at that price point or limited adoption. The Pro Plan's larger subscriber count (15) indicates moderate market traction but lower per-
Subscriber Churn Rate
Monthly subscriber churn rate trend and analysis
Purpose
This section measures subscriber retention health by tracking the percentage of active subscribers who cancel each month. Churn rate is a critical SaaS metric that directly impacts MRR sustainability and growth trajectory—understanding churn patterns helps identify whether revenue growth is driven by genuine expansion or masked by underlying customer loss.
Key Findings
- Average Monthly Churn Rate: 1.39% — well below the 2% industry benchmark for healthy SaaS, indicating strong retention overall
- Peak Churn Month: June 2024 at 3.85% — a notable spike that coincides with the first churned subscriber appearing in the dataset
- Total Churned Subscribers: 5 over 11 months — concentrated churn with only 1 subscriber lost per month (May–October), then stabilization
- Trend Pattern: Zero churn during initial growth phase (Jan–May), then consistent single-subscriber monthly losses (Jun–Oct), followed by recovery to zero churn in November
Interpretation
The company demonstrates healthy retention relative to industry standards, with churn remaining manageable even as the subscriber base grew from 3 to 41 customers. The June spike appears isolated rather than systemic; subsequent months show declining churn rates (3.85% → 2.44%) despite continued subscriber growth, suggesting the organization adapted to early customer loss. The recent
Monthly SaaS Metrics
Comprehensive monthly SaaS metrics summary table
| month | active_subscribers | total_mrr | new_subscribers | churned_subscribers | churn_rate_pct | arpu |
|---|---|---|---|---|---|---|
| 2024-01 | 3 | 447 | 3 | 0 | 0 | 149 |
| 2024-02 | 7 | 1063 | 4 | 0 | 0 | 151.9 |
| 2024-03 | 12 | 1366 | 5 | 0 | 0 | 113.8 |
| 2024-04 | 16 | 1862 | 4 | 0 | 0 | 116.3 |
| 2024-05 | 20 | 2208 | 4 | 0 | 0 | 110.4 |
| 2024-06 | 26 | 2409 | 6 | 1 | 3.85 | 92.66 |
| 2024-07 | 30 | 2545 | 5 | 1 | 3.33 | 84.84 |
| 2024-08 | 33 | 2632 | 4 | 1 | 3.03 | 79.76 |
| 2024-09 | 38 | 2815 | 6 | 1 | 2.63 | 74.07 |
| 2024-10 | 41 | 2902 | 4 | 1 | 2.44 | 70.77 |
| 2024-11 | 41 | 2902 | 1 | 0 | 0 | 70.77 |
Purpose
This section tracks the month-to-month evolution of your SaaS subscription business across 11 months (January–November 2024). It reveals how MRR, subscriber base, churn, and unit economics changed over time, providing the temporal context needed to assess whether growth is accelerating, stabilizing, or declining—critical for understanding business trajectory and sustainability.
Key Findings
- Average MoM Growth: 24.9% — Strong early-stage growth, though this masks significant deceleration from 137.8% (Feb) to 0% (Nov)
- Total New Subscribers: 46 acquired across 11 months — Consistent acquisition averaging 4.2 per month
- MRR Trajectory: Grew from $447 to $2,901.75 — 549% total growth, but growth rate compressed from double-digit percentages to near-zero by month 11
- Churn Emergence: Zero churn for first 5 months; then 0–3.85% monthly churn appeared, indicating product-market fit challenges at scale
Interpretation
The business demonstrates classic early-stage SaaS growth: rapid initial expansion driven by new customer acquisition, followed by a plateau phase where growth rates compress despite absolute MRR gains. The emergence of churn (1.69% average)