saas-metrics-health-checklisted

Performs a diagnostic on a SaaS product's revenue and retention metrics from a CSV or spreadsheet of customers/subscriptions/events. Computes MRR, ARR, churn (gross/net), LTV, CAC, payback period, quick ratio, and cohort retention; flags anomalies; identifies the single highest-leverage fix. Invoked when the user asks "are my SaaS metrics healthy", "compute LTV for my data", "is my churn high", "review my MRR breakdown", or shares a billing/customer CSV.
hotak92/vibecoded-orchestrator · ★ 3 · Data & Documents · score 72

Install: claude install-skill hotak92/vibecoded-orchestrator

# SaaS Metrics Health-Check (Opus) **Purpose**: Turn a messy customer/subscription CSV into a defensible SaaS health report with a single recommended action. **Model**: Opus 4.7. ## When to invoke Use this skill when the user: - Hands over a billing export (Stripe, Lemon Squeezy, Paddle) and asks for a diagnostic - Asks "is my churn high" or "what should LTV/CAC be at my stage" - Wants a monthly metrics dashboard for the first time - Is preparing a fundraise update or YC application and needs defensible numbers - Shares MRR figures and asks "is this healthy" Don't use this skill for: - "What is MRR" — point to a tutorial; this skill assumes founder-literacy - Real-time dashboards — this is a one-shot diagnostic; for ongoing tracking recommend Baremetrics / ChartMogul / a self-built dashboard - Pre-revenue products (<5 paying customers) — sample size too small; do customer interviews instead ## What this skill does ### 1. Data validation Given a CSV, first verify: - **What's in the file**: customers, subscriptions, charges, invoices, events? - **Date range covered** and granularity (daily/monthly) - **Currency** (assume one; if multi-currency flag for normalisation) - **Missing fields** that block analysis (no churn timestamps, no plan info, no MRR field — request them) - **Deduplication issues** (test customers, refunded charges, $0 transactions) If the data is unusable, stop and ask for the right export. Don't fabricate fields. Common providers and their exports: