SaaS Metrics Dashboard

The SaaS metrics your investors ask about. In one spreadsheet.

Tracks every subscription metric: MRR, ARR, growth rate, gross churn, net revenue retention, LTV, CAC, LTV:CAC ratio, payback period, cohort retention, revenue by pricing plan, and churn reasons — all auto-calculated.

7 Professionally Designed Tabs

📊 Monthly Data — 10 input rows + 12 auto-calculated metrics per month. 12 months of sample data.
📈 Cohort Analysis — Customer retention by monthly cohort. Retention rates + average curve. 12 cohorts.
💰 Revenue Breakdown — Subscribers per plan, revenue per plan, plan mix %. 3 pricing tiers.
📉 Churn Log — Customer cancellations: reason (8 categories), plan, MRR lost. 20 entries.
🎯 Dashboard — 12 KPIs + MRR trend line + plan pie + churn reasons bar + customer growth + unit economics with health labels.

Key Features

• 12 auto-calculated metrics — MRR, ARR, churn, NRR, ARPU, CAC, LTV, LTV:CAC, payback, net new MRR.
• Cohort retention — Monthly survival rates with average curve.
• Revenue by plan — 3 configurable pricing tiers.
• Churn analysis — 8 reason categories with distribution chart.
• Health indicators — LTV:CAC “Healthy/Needs improvement,” Churn “Healthy/Watch/High,” NRR “Healthy/Below 100%.”
• Sample data — “TaskFlow” SaaS, 135→417 customers, $9.5K→$31.7K MRR over 12 months.

ChartMogul costs $100+/month. This costs $29 once.