How to Track SaaS Unit Economics in Google Sheets (Free Template)

Why Unit Economics Matter More Than ARR

Every SaaS founder knows the big numbers, but most miss the micro-metrics that predict failure 12 months in advance.

The #1 reason SaaS startups fail? Poor unit economics masked by growing revenue.

The 6 KPIs That Matter

1. CAC (Customer Acquisition Cost) — Total sales & marketing ÷ new customers
2. LTV (Lifetime Value) — Average monthly GM per customer ÷ churn rate
3. LTV:CAC Ratio — The gold standard: 3:1 is healthy, <1:1 is burning money
4. Payback Period — Months to recover CAC (target < 12 months)
5. Gross Margin % — Above 70% for most SaaS
6. Monthly Churn % — Below 5% for growth-stage companies

The Template I Built

I got tired of building these from scratch every month. So I created a Google Sheets dashboard that:

• Auto-calculates all 6 KPIs from raw data
• Color-codes red/yellow/green against targets
• Includes sample data from real SaaS scenarios
• Tracks cohort retention curves

Grab the full template here: https://microtoolsb2b.gumroad.com/l/saas-unit-economics-dashboard-sheets

Quick Setup

1. Copy your monthly customer/MRR data
2. Paste into the Inputs tab
3. Dashboard auto-updates
4. Share with your board

Try it out and let me know what metrics you track!