Analysis overview and configuration
| Parameter | Value | _row |
|---|---|---|
| plan_amount_divisor | 100 | plan_amount_divisor |
| include_trialing | FALSE | include_trialing |
| currency_symbol | USD | currency_symbol |
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.
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
| Metric | Value |
|---|---|
| Initial Rows | 50 |
| Final Rows | 46 |
| Rows Removed | 4 |
| Retention Rate | 92% |
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.
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.
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
| 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 |
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.
###
Monthly Recurring Revenue trend over the analysis period
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.
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
Monthly MRR movement: new subscription revenue vs cancelled subscription revenue
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.
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
Current MRR distribution across subscription plan tiers
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.
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-
Monthly subscriber churn rate trend and analysis
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.
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
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 |
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.
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)