View, filter, and analyze active subscriptions in Stripe — spot at-risk subs, track trial conversions, and understand plan distribution.
Navigate to Billing → Subscriptions. The default view shows active subscriptions. Each row shows the customer, plan/price, status, current period, and next billing date. The count at the top is your total active subscriber base — the foundation of your recurring revenue.
Stripe subscriptions have several statuses beyond just “active.” Filter to see: Active (paying normally), Trialing (free trial, no payment yet), Past due (payment failed, retrying), Canceled (ended). Pay special attention to Past due — these are at-risk subscriptions where the customer hasn’t explicitly churned but their payment is failing.
Filter by Past due status to see subscriptions with failed payments. These are your most urgent retention targets. The average SaaS loses 20-40% of past-due subscriptions to involuntary churn. Sort by amount to prioritize high-value accounts. Check how many retry attempts remain before Stripe marks them canceled.
Filter by Trialing to see upcoming trial expirations. A healthy trial-to-paid conversion rate is 15-25% for opt-in trials and 50-70% for opt-out (card required). Compare your trialing count against recent conversions: if 50 trials started last month and 12 converted, that’s 24%. Below 15% suggests your trial experience needs work.
Export active subscriptions as CSV. In your spreadsheet, create a pivot table by plan.id or price.id. This shows you: how many customers are on each plan, revenue concentration (is 80% of MRR from one plan?), and whether your pricing tiers are working. If your cheapest plan has 70% of customers, consider whether you’re underpricing.
Record these numbers monthly: total active, new subscriptions, upgrades, downgrades, churned, net change. After 3+ months, you’ll see patterns: seasonal trends, the impact of pricing changes, and whether your growth is accelerating or decelerating. Net subscription growth of 5-10% monthly is strong for early-stage SaaS.
Install Coby on Stripe and ask anything — like a teammate who never sleeps.
Install Coby on your Stripe account in 30 seconds. Free to start, no credit card required.