What problem does it solve?
Manual revenue reporting and fragmented billing data hide true subscription health, causing incorrect MRR, LTV, and churn decisions for SaaS teams. This Skill centralizes Stripe subscription and invoice data, normalizes billing intervals, applies discounts, and produces accurate recurring revenue metrics and diagnostics that finance and growth teams can act on.
Core Features & Use Cases
- MRR Calculation: Normalize subscription prices across billing intervals, apply coupon/discount logic, and aggregate active (including trialing and past_due) subscription MRR.
- Cohort Revenue Analysis: Build monthly cohort revenue tables, normalized retention curves, and visualizations to reveal retention quality and expansion/contraction patterns.
- LTV & CAC Insights: Compute simple, margin-adjusted, cohort-based, and probabilistic LTV estimates plus CAC payback and channel-segmented LTV:CAC ratios.
- Churn Diagnostics & Webhook Tracking: Classify voluntary vs. involuntary churn, implement dunning/pre-dunning workflows, and track MRR movements via subscription webhooks.
- Use Case: Run a monthly revenue audit to detect hidden churn, quantify expansion revenue, and prioritize fixes to improve payback period and LTV.
Quick Start
Connect your Stripe account and run a revenue audit to compute normalized MRR, generate cohort revenue tables, calculate LTV and payback period, and surface top churn drivers.