---
name: saas-metrics-dashboard
description: "สกิลสำหรับ SAAS Metrics Dashboard ใช้เมื่อต้องการแนวทาง ขั้นตอน Template หรือคำแนะนำเชิงปฏิบัติสำหรับงานวิเคราะห์ข้อมูล วิจัย AI ฐานข้อมูล วิทยาศาสตร์ข้อมูล และรายงานเชิงลึก ในหัวข้อนี้"
allowed-tools: Read Write Glob
metadata:
  author: matthewhitcham
  version: "1.0"
---

# SAAS Metrics Dashboard

## When to Use This Skill

Use this skill when you need to:
- Define and track core SaaS metrics for a subscription business
- Design a metrics dashboard layout with KPIs and visualizations
- Set up cohort retention analysis and revenue tracking
- Create a reporting cadence for stakeholders or personal review

**DO NOT** use this skill for financial forecasting models, investor reporting decks, or marketing analytics dashboards. This is for core SaaS business health metrics.

---

## Core Principle

TRACK THE METRICS THAT DRIVE DECISIONS — A DASHBOARD WITH 50 METRICS IS A DASHBOARD NOBODY USES. FOCUS ON THE 8-12 NUMBERS THAT TELL YOU IF YOUR BUSINESS IS HEALTHY.

---

## Phase 1: Brief

### Required Inputs

| Input | What to Ask | Default |
|-------|------------|---------|
| **Product and pricing** | "What is your SaaS product and what are the plan prices?" | No default — must be provided |
| **Current MRR** | "What is your current monthly recurring revenue?" | Unknown — establish tracking |
| **Billing model** | "Monthly, annual, or both? Any usage-based component?" | Monthly subscriptions |
| **Data sources** | "Where does your billing data live? Stripe, Paddle, custom?" | Stripe |
| **Team size** | "Who reviews this dashboard? Just you, or a team?" | Solo founder |
| **Current tracking** | "What metrics do you currently track, if any?" | Revenue only |

**GATE: Confirm the brief before defining the metrics framework.**

---

## Phase 2: Define Metrics

### Tier 1: Must-Track (Daily/Weekly Review)

| Metric | Formula | Why It Matters |
|--------|---------|---------------|
| **MRR** | Sum of all active subscription revenue | Core health indicator |
| **MRR Growth Rate** | (MRR this month - MRR last month) / MRR last month | Velocity of growth |
| **Churn Rate** | Customers lost / Customers at start of period | Retention health |
| **Net Revenue Retention** | (MRR start + expansion - contraction - churn) / MRR start | Growth without new sales |

### Tier 2: Strategic (Monthly Review)

| Metric | Formula | Why It Matters |
|--------|---------|---------------|
| **LTV** | ARPU / Monthly churn rate | Customer lifetime value |
| **CAC** | Total acquisition spend / New customers acquired | Cost to acquire |
| **LTV:CAC Ratio** | LTV / CAC | Unit economics health (target 3:1+) |
| **Expansion MRR** | Revenue from upgrades and add-ons | Growth from existing customers |
| **ARPU** | MRR / Active customers | Average revenue per user |

### Tier 3: Deep Dives (Quarterly)

| Metric | Formula | Why It Matters |
|--------|---------|---------------|
| **Cohort Retention** | % of cohort still active at month N | True retention over time |
| **Revenue Churn vs. Logo Churn** | Revenue lost vs. customers lost | Reveals whether big or small accounts leave |
| **Payback Period** | CAC / (ARPU x Gross Margin) | Months to recoup acquisition cost |

**GATE: Confirm which metrics to include before designing the layout.**

---

## Phase 3: Design the Dashboard

### Layout Recommendations

**Top row (KPI cards):** MRR, MRR Growth Rate, Active Customers, Churn Rate
**Second row (charts):** MRR trend (line chart, 12 months), Revenue breakdown (stacked bar: new, expansion, contraction, churn)
**Third row:** Cohort retention table (heatmap), LTV:CAC trend
**Bottom row:** Recent activity feed (new signups, churns, upgrades)

### Dashboard Specifications

For each metric, document:
- Metric name and definition
- Data source and calculation method
- Visualization type (number, chart, table)
- Update frequency (real-time, daily, monthly)
- Alert threshold (e.g., churn exceeds 5%)

### Tool Recommendations

| Tool | Best For | Price Range |
|------|----------|-------------|
| **Stripe Dashboard** | Basic MRR and churn | Free with Stripe |
| **Baremetrics/ChartMogul** | Full SaaS metrics | $50-250/month |
| **Google Sheets** | Custom calculations | Free |
| **Notion** | Manual tracking for early stage | Free-$10/month |

---

## Phase 4: Polish

### 1. Reporting Cadence

```
## Review Schedule

- **Daily:** MRR, new signups, churns (glance at KPI cards)
- **Weekly:** MRR growth rate, trial conversions, support ticket volume
- **Monthly:** Full dashboard review, cohort analysis, LTV:CAC check
- **Quarterly:** Deep dive on retention cohorts, CAC trends, pricing evaluation trigger
```

### 2. Alert System

Define automated alerts:
- MRR drops more than 5% month-over-month
- Churn rate exceeds target threshold
- LTV:CAC ratio drops below 3:1
- No new signups for 3+ consecutive days
- Large account cancels or downgrades

### 3. Quality Checklist

```
## Dashboard Checklist

- [ ] MRR is tracked and updated daily
- [ ] Churn rate is calculated correctly (logo and revenue)
- [ ] LTV and CAC are defined with clear formulas
- [ ] Net revenue retention is tracked monthly
- [ ] Cohort retention table is set up (minimum 6-month view)
- [ ] Dashboard loads quickly and is not cluttered
- [ ] Alerts are configured for critical thresholds
- [ ] Review cadence is documented and followed
- [ ] All metrics have clear definitions (no ambiguity)
- [ ] Data source is reliable and automated (not manual entry)
```

---

## Example

**Product:** Project management SaaS, $19/$49/$99 plans
**MRR:** $12,400
**Customers:** 340 active

**KPI Card Layout:**
```
| MRR: $12,400 (+8.2%) | Active: 340 (+12) | Churn: 3.2% | ARPU: $36.47 |
```

**Alert example:**
"Alert: Monthly churn rate hit 4.1% (target: under 3.5%). Three accounts on the $99 plan canceled this week. Review cancellation reasons in exit surveys."

---

## Anti-Patterns

- **Vanity metrics on the dashboard** — total signups (all-time) tells you nothing. Track active customers and MRR.
- **Manual data entry** — if metrics require manual updates, they will go stale. Automate the data pipeline.
- **Too many metrics** — 8-12 core metrics maximum. Everything else is a report, not a dashboard.
- **No definitions** — if two people calculate churn differently, the metric is useless. Document every formula.
- **Ignoring cohorts** — aggregate churn hides whether retention is improving over time. Cohort analysis reveals the truth.

---

## Recovery

- **No billing data access:** Start with a manual Google Sheet tracker. Log MRR, new customers, and churns weekly until you can automate.
- **Too early for meaningful metrics:** Track MRR and customer count. Add churn and LTV once you have 3+ months of data.
- **Multiple pricing models:** Break metrics down by plan tier. Blended averages hide tier-specific problems.
- **Metrics look bad:** That is the point. A dashboard that only shows good numbers is not doing its job. Identify the worst metric and focus improvement there.
