Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Complete startup metrics command center — from raw data to investor-ready dashboards. Covers every stage (pre-seed to Series B+), every model (SaaS, marketpl...
Complete startup metrics command center — from raw data to investor-ready dashboards. Covers every stage (pre-seed to Series B+), every model (SaaS, marketpl...
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run.
Your complete system for tracking, diagnosing, and communicating startup health — not just formulas, but the thinking behind what to measure, when, and what to do when numbers go wrong.
Before tracking anything, classify yourself: Business Model: model_type: saas: sub_type: # self-serve | sales-led | PLG | hybrid pricing: # per-seat | usage-based | flat | tiered contract: # monthly | annual | multi-year marketplace: type: # managed | unmanaged | SaaS-enabled unit: # GMV | take-rate | transaction consumer: type: # subscription | ad-supported | freemium | transactional engagement_model: # DAU/MAU | session-based | content hardware_plus_software: type: # device + subscription | IoT | embedded Stage (determines what matters): StageARR RangeNorth Star FocusBoard Cares AboutPre-seed$0-$50KEngagement + retention signalProblem-solution fit evidenceSeed$50K-$500KCohort retention + early revenueProduct-market fit signalsSeries A$500K-$3MGrowth efficiency + unit economicsLTV:CAC, NDR, growth rateSeries B$3M-$15MScalability + operating leverageRule of 40, magic number, burn multipleGrowth$15M+Capital efficiency + market shareNet margins, NRR, competitive moat
MRR = Σ(active_subscriptions × monthly_price) ARR = MRR × 12 Net New MRR = New MRR + Expansion MRR - Churned MRR - Contraction MRR MRR Components: new_mrr: First-time customer revenue this month expansion_mrr: Upsell + cross-sell from existing customers churned_mrr: Revenue lost from customers who left contraction_mrr: Revenue lost from downgrades (customer stayed) reactivation_mrr: Revenue from returning churned customers MoM Growth = (MRR_current - MRR_previous) / MRR_previous CMGR (Compound Monthly Growth Rate) = (MRR_end / MRR_start)^(1/months) - 1 Why CMGR > MoM: Monthly growth is noisy. CMGR smooths 6-12 month periods for real trend.
CAC = Total_Sales_Marketing_Spend / New_Customers_Acquired - Include: salaries, commissions, tools, ads, events, content costs - Exclude: product/engineering, CS (post-sale) - Time-lag adjustment: match spend to cohort it generated (typically 1-3 month lag) Blended CAC vs Channel CAC: blended_cac = total_spend / total_new_customers channel_cac = channel_spend / channel_new_customers # Always track both — blended hides channel problems LTV = ARPU × Gross_Margin% × Average_Customer_Lifetime # Or: LTV = ARPU × Gross_Margin% × (1 / Monthly_Churn_Rate) # Cap at 5 years for conservative estimates LTV:CAC Ratio — THE ratio: > 5.0 → Under-investing in growth (spend more!) 3.0-5.0 → Excellent efficiency 1.5-3.0 → Healthy but watch payback period 1.0-1.5 → Marginal — fix churn or reduce CAC < 1.0 → Burning cash per customer — STOP and fix CAC Payback = CAC / (Monthly_ARPU × Gross_Margin%) < 6 months → Elite (PLG companies) 6-12 months → Great 12-18 months → Acceptable for enterprise > 18 months → Danger zone (unless >130% NDR)
Logo Churn Rate = Customers_Lost / Customers_Start_of_Period Revenue Churn Rate = MRR_Lost / MRR_Start_of_Period # Revenue churn > logo churn = losing big customers (very bad) # Revenue churn < logo churn = losing small customers (less bad) Net Dollar Retention (NDR) = (Starting_MRR + Expansion - Contraction - Churn) / Starting_MRR > 130% → World-class (Snowflake, Twilio territory) 110-130% → Excellent 100-110% → Good 90-100% → Acceptable but concerning < 90% → Leaky bucket — growth can't outrun churn Gross Dollar Retention (GDR) = (Starting_MRR - Contraction - Churn) / Starting_MRR # NDR without expansion — shows your floor > 90% → Sticky product 80-90% → Normal for SMB < 80% → Product or market problem
Burn Multiple = Net_Burn / Net_New_ARR < 1.0 → Amazing (rare at early stage) 1.0-1.5 → Great 1.5-2.0 → Good 2.0-3.0 → Mediocre > 3.0 → Bad — inefficient growth Rule of 40 = Revenue_Growth_Rate% + Profit_Margin% > 40 → Healthy SaaS (IPO-ready) # Example: 60% growth + -20% margin = 40 ✓ # Example: 20% growth + 20% margin = 40 ✓ Magic Number = Net_New_ARR_This_Quarter / Sales_Marketing_Spend_Last_Quarter > 1.0 → Efficient, invest more in S&M 0.5-1.0 → OK, optimize before scaling < 0.5 → Inefficient — fix before spending more Hype Ratio = Valuation / ARR # Reality check on fundraising expectations # Median SaaS multiples: 6-12x ARR (varies by growth + retention)
Monthly Burn = Total_Monthly_Expenses - Total_Monthly_Revenue Gross Burn = Total_Monthly_Expenses (ignoring revenue) Net Burn = Gross_Burn - Revenue Runway = Cash_Balance / Monthly_Net_Burn > 18 months → Comfortable 12-18 months → Start planning next raise 6-12 months → Urgently fundraising < 6 months → Default alive or dead calculation needed Default Alive? = Can_Current_Growth_Rate_Make_Revenue > Expenses_Before_Cash_Runs_Out # Paul Graham's test — if growing, project the intersection
Sales Cycle Length = Avg_Days(First_Touch → Closed_Won) Pipeline Coverage = Total_Pipeline_Value / Revenue_Target # Need 3-4x for predictable revenue Win Rate = Deals_Won / Total_Deals_in_Stage By stage: SQL→Opp (30-40%), Opp→Proposal (50-60%), Proposal→Close (60-70%) ACV (Annual Contract Value) = Total_Contract_Value / Contract_Years ASP (Average Selling Price) = Total_Revenue / Deals_Closed Quota Attainment = Actual_Bookings / Quota_Target # Healthy org: 60-70% of reps hitting quota Sales Efficiency = Net_New_ARR / Fully_Loaded_Sales_Cost > 1.0 → Scalable
When a metric is off, don't just report it — diagnose it.
Every metric has upstream drivers. Trace back: Revenue declining? → ├── New MRR down? → Lead volume? → Conversion rate? → Channel performance? ├── Expansion down? → Upsell attempts? → Product adoption? → CSM activity? └── Churn up? → Which segment? → Voluntary vs involuntary? → Reasons? CAC increasing? → ├── Spend up? → Which channels? → CPM/CPC changes? ├── Volume same but cost up? → Market saturation? → Competition? └── Conversion down? → Funnel stage? → Lead quality? → Sales process?
diagnostic_experiment: hypothesis: "[Metric] is declining because [upstream cause]" test: "[Specific action] for [time period]" success_metric: "[Metric] improves by [X%] within [timeframe]" sample: "[Segment/cohort to test on]" kill_criteria: "Stop if [negative signal] within [days]"
Aggregate metrics lie. Cohorts tell the truth.
cohort_engagement: week_1_activation: # % completing key action within 7 days week_4_habit: # % using product 3+ days in week 4 month_3_retention: # % still active at 90 days # Leading indicators of revenue retention # If engagement drops, revenue follows 1-3 months later
🚩 Each new cohort retains worse → product-market fit eroding 🚩 Large cohorts churn more → scaling quality issues 🚩 Specific channel cohorts churn fast → bad-fit leads 🚩 Expansion only in old cohorts → pricing/packaging problem
investor_update: subject: "[Company] — [Month] Update: [One-line headline]" # 1. TL;DR (3 bullets max) highlights: - "ARR: $X (+Y% MoM) — [context]" - "Key win: [biggest achievement]" - "Challenge: [biggest problem + what you're doing]" # 2. Key Metrics Table metrics: arr: {current: "", prior_month: "", delta: ""} mrr: {current: "", growth_mom: ""} customers: {total: "", new: "", churned: ""} ndr: "" burn_rate: "" runway_months: "" cash_balance: "" # 3. What Happened (5-7 bullets) wins: [] challenges: [] # 4. What's Next (3-5 bullets) next_month_priorities: [] # 5. Asks (be specific!) asks: - intro: "Looking for intro to [person/company] for [reason]" - advice: "Would love 15 min on [specific topic]" - hiring: "Seeking [role] — know anyone?"
Quick Ratio = (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR) > 4.0 → Very healthy growth 2.0-4.0 → Good 1.0-2.0 → Sustainable but slow < 1.0 → Shrinking Logo-to-Revenue Retention Gap: If logo retention 85% but revenue retention 95% → upsell compensates If logo retention 85% and revenue retention 85% → no expansion = problem Expansion Revenue % = Expansion MRR / Total New MRR > 30% → Healthy at scale # Best SaaS: expansion > new revenue (Twilio was 170% NDR)
GMV (Gross Merchandise Value) = Total value of transactions on platform Take Rate = Platform Revenue / GMV 5-15% → Typical for most marketplaces 15-30% → Managed/full-service marketplaces Supply-side metrics: supply_liquidity = listings_with_transaction / total_listings time_to_first_match = avg_days_from_listing_to_sale Demand-side metrics: search_to_fill = completed_transactions / searches repeat_purchase_rate = returning_buyers / total_buyers
DAU/MAU Ratio: > 50% → Exceptional (messaging apps) 25-50% → Strong habit (social, productivity) 10-25% → Good (media, entertainment) < 10% → Weak engagement Viral Coefficient (K-factor) = Invites_per_User × Conversion_Rate > 1.0 → Viral growth (each user brings >1 new user) 0.5-1.0 → Amplified growth < 0.5 → Not viral — need paid acquisition Free-to-Paid Conversion: PLG benchmark: 2-5% of free users convert Freemium benchmark: 1-3% Enterprise self-serve: 5-15% Time to Value = Time from signup to "aha moment" # Reduce this aggressively — strongest lever for activation
Vanity (Avoid)Real (Track)Total signupsActivated users (completed key action)Page viewsEngaged sessions (>2 min or action taken)"Pipeline"Qualified pipeline (met ICP criteria)Gross revenueNet revenue (after refunds + credits)Total customersActive customers (logged in last 30d)DownloadsWAU/MAU"Partnerships"Revenue from partnerships
🚩 Counting annual contracts as MRR at signing (vs. monthly recognition) 🚩 Excluding "one-time" churns from churn rate 🚩 Using gross revenue instead of net 🚩 Measuring CAC without fully-loaded costs 🚩 Cherry-picking best cohort as "representative" 🚩 Counting reactivations as new customers 🚩 Using "committed ARR" (signed but not live) 🚩 Trailing-12-month NDR when recent cohorts are worse
1. Audit channel efficiency — kill bottom 20% channels 2. Improve activation rate (reduces wasted spend) 3. Increase conversion at each funnel stage (+10% each = compound effect) 4. Shift mix: more organic/PLG, less paid 5. Reduce sales cycle length (lower cost per deal) 6. Tighten ICP — stop selling to bad-fit customers
1. Segment: which customers churn? (Size, channel, use case) 2. Time: when do they churn? (Month 1-3 = onboarding, 6-12 = value, 12+ = competition) 3. Reason: exit survey + CS interviews (top 3 reasons) 4. Fix activation if month 1-3 churn 5. Fix value delivery if month 6-12 churn 6. Fix switching cost / competitive moat if 12+ churn
1. Check: is TAM exhausted in current segment? → Expand to adjacent 2. Check: conversion rates declining? → Product or message fatigue 3. Check: CAC rising with flat volume? → Channel saturation 4. Check: expansion revenue flat? → Packaging/pricing problem 5. Check: sales cycle lengthening? → Market conditions or competition
Metrics investors care about BY STAGE: Pre-seed: Engagement, retention curves, market size Seed: MoM growth (15%+), retention cohorts, early unit economics Series A: $1M+ ARR, 3x+ YoY growth, LTV:CAC > 3, NDR > 100% Series B: $5M+ ARR, path to Rule of 40, burn multiple < 2, sales efficiency
"Set up metrics for [stage] [model] startup" → Full metric stack recommendation "Diagnose [metric]" → PULSE diagnostic framework "Build investor update for [month]" → Template with guidance "Cohort analysis on [data]" → Retention curve analysis "Compare us to benchmarks" → Gap analysis vs stage-appropriate benchmarks "What metrics for Series [A/B] raise?" → Investor-ready checklist "Calculate unit economics from [data]" → Full LTV, CAC, payback analysis "Red flag check" → Scan metrics for warning signs "Board deck metrics" → Generate slide-ready metric views
Track metrics per product line AND blended. Watch for cross-subsidization where one product's margins mask another's losses.
MRR is estimated, not contracted. Track committed vs consumed. Expansion is automatic (usage growth), so NDR is naturally higher — compare to usage-based peers, not seat-based.
If NDR > 100% only because of price increases (not organic expansion), this is fragile. Separate price-driven vs usage-driven expansion.
Track leading indicators: activation rate, engagement frequency, NPS, waitlist growth, organic traffic, time-to-value. Revenue metrics come later — don't force them.
Use YoY comparisons, not MoM. Adjust cohort analysis for seasonal patterns. Build seasonal forecast models. Built by AfrexAI — turning data into revenue.
Data access, storage, extraction, analysis, reporting, and insight generation.
Largest current source with strong distribution and engagement signals.