Complete Google Sheets dashboard for SaaS founders tracking MRR, ARR, churn rate, CAC, LTV, burn rate, runway, customer acquisition, and conversion funnel. Auto-calculating charts.
SaaS Founder's KPI Dashboard: Real-Time Business Metrics (Google Sheets)
## Tab 1: Executive Summary
- MRR (Monthly Recurring Revenue): Current, previous, MoM growth, 3-month trend
- ARR (Annual Recurring Revenue): MRR x 12 with YoY comparison
- Total Customers: Active paying, net new, churned
- ARPA (Average Revenue Per Account): MRR divided by total customers
- NRR (Net Revenue Retention): Existing customer revenue growth rate
- Quick Ratio: (New + Expansion MRR) divided by Churned MRR (target > 4)
- Cash Position: Current balance and months of runway
- Health Score: Composite of 10 metrics (green/yellow/red)
- Automated sparkline charts for every metric
## Tab 2: Revenue Deep Dive
- MRR Breakdown: New, Expansion, Churned, Contraction
- MRR by Plan: Per pricing tier (Starter, Pro, Business, Enterprise)
- MRR by Cohort: Monthly cohort analysis (12-month view)
- ARR Growth Rate: Monthly and annualized growth
- Revenue Forecast: 3-month forward projection
- ACV (Average Contract Value): Annual value per customer
- 24-month MRR trend chart with trendline
- Revenue mix pie chart by plan
- Growth rate waterfall chart with components
## Tab 3: Customer Acquisition
- New customers by source per month
- CAC (Customer Acquisition Cost): Total S&M spend divided by new customers
- CAC by Channel: Organic, Paid, Referral, Partner, Direct
- Payback Period: CAC divided by (ARPA x Gross Margin)
- Magic Number: (New MRR x 4) divided by Previous S&M spend
- Lead-to-Customer Funnel: Visitors to Leads to MQLs to SQLs to Opportunities to Customers
- Conversion rates at each stage with industry benchmarks
- Visual funnel chart with conversion percentages
- 12-month CAC trend chart with target line
## Tab 4: Retention & Churn
- Logo Churn Rate: Monthly customer loss percentage
- Revenue Churn Rate: MRR lost to churn divided by beginning MRR
- NRR (Net Revenue Retention): Growth from existing customers
- GRR (Gross Revenue Retention): Retention excluding expansion
- Customer Lifetime
Installation Guide
1. Download the product
2. Unzip the files
3. Follow the included documentation
4. Configure for your use case
5. Start using immediately!
Requirements: Free Google account. Basic spreadsheet skills helpful.
0โโโโโ(0 reviews)
No reviews yet. Be the first!
What is this product?
Complete Google Sheets dashboard for SaaS founders tracking MRR, ARR, churn rate, CAC, LTV, burn rate, runway, customer acquisition, and conversion funnel. Auto-calculating charts.
How do I install it?
Download the files and follow the included documentation. Most products require no technical skills.
Do I get updates?
Yes! All products include updates (currently v1.0).
What if I have issues?
Contact the creator directly or use the Ask Hermes feature for instant support.
