✅ 1️⃣ KPI Selection (With Definitions & Use Cases) 1. CAC (Customer Acquisition Cost) Definition: Total marketing + sales cost to acquire 1 customer. Why it matters: Shows how expensive your growth is. Use when: Running ads, sales outreach, or scaling acquisition. 2. LTV (Customer Lifetime Value) Definition: Total revenue expected from a customer during their lifecycle. Why it matters: Helps decide how much to spend on acquiring customers. Use when: Pricing, ad scaling, strategic decisions. 3. MRR (Monthly Recurring Revenue) Definition: Predictable subscription revenue per month. Why it matters: Core metric for SaaS health + growth. Use when: Tracking growth, forecasting revenue. 4. Churn Rate Definition: % of customers who cancel in a period. Why it matters: High churn kills SaaS growth. Use when: Monitoring product satisfaction. 5. Activation Rate Definition: % of users who complete “key action” inside product. Why it matters: Shows product onboarding success. Use when: Improving onboarding or UI/UX. 6. Lead-to-Customer Rate Definition: % of leads who convert into paying. Why it matters: Measures funnel efficiency. Use when: Improving sales workflow. 7. Retention Rate Definition: % customers still active after X time. Why it matters: Higher retention = higher profit. Use when: Evaluating stickiness of product. --- ✅ 2️⃣ Dashboard Layout (Beginner-Friendly) KPI How to Track Data Source Update Frequency How to Interpret CAC Total cost ÷ customers Sheets, Ads manager Weekly If CAC rising → optimize ads MRR Sum of monthly subscription revenue Payment dashboard Weekly Steady rise = good growth Churn (Cancelled ÷ Total users) CRM, Billing Weekly >5% = improve product Activation Rate Activated users ÷ signups Product analytics Weekly Low rate → fix onboarding LTV ARPU × avg. months Sheets Monthly Must be 3× CAC Lead→Customer Customers ÷ leads CRM Weekly Low = sales issues ARPU Total revenue ÷ active users Billing Monthly Shows revenue quality --- ✅ 3️⃣ KPI Calculation Guide (Easy Formulas) CAC = Total Acquisition Cost ÷ New Customers LTV = ARPU × Average Customer Lifetime (months) MRR = Sum of all active monthly subscription payments Churn Rate = Cancelled Customers ÷ Total Customers Retention Rate = 1 – Churn Rate AOV (for SaaS upsells) = Total revenue ÷ Number of transactions --- ✅ 4️⃣ Metrics by Funnel Stage Awareness Impressions Website visitors Social reach Acquisition Signups CAC Lead quality Activation Activation rate Time-to-activate Onboarding completion Revenue MRR ARPU Conversion rate Retention Monthly retention Churn Product usage frequency Referral Referral rate NPS Reviews generated --- ✅ 5️⃣ Leading vs Lagging Indicators Leading (early signals) Activation rate Product usage Website clicks Demo requests 👉 Track weekly Lagging (results) MRR LTV Revenue Churn 👉 Track monthly --- ✅ 6️⃣ Data Source Suggestions CRM: leads, conversions, demos Website analytics: traffic, behavior Payment dashboard: MRR, churn, LTV Product usage logs: activation, feature usage Campaign performance: CAC, CTR, CPA Sheets/Notion: combined dashboard --- ✅ 7️⃣ Weekly & Monthly Review Process 🔹 Weekly Review CAC trend Activation rate New signups Product usage Lead→customer rate 🔹 Monthly Review MRR Churn LTV Net revenue growth ARPU 🔹 Quarterly Review Pricing changes Roadmap alignment Feature performance Strategic decisions --- ✅ 8️⃣ Alerts & Threshold Ideas CAC > LTV/3 → Ads overspending Churn > 5–7% monthly → Fix product issues Activation < 40% → Onboarding problem MRR growth < 5% → Sales slowdown Lead→Customer < 10% → Weak funnel --- ✅ 9️⃣ 30-Day KPI Setup Plan Week 1 – KPI Selection Choose 8–10 core KPIs Define success benchmarks Create metric glossary Week 2 – Dashboard Setup Build Sheets/Notion table Add automated formulas Connect CRM + payment data Week 3 – Data Input Workflow Set weekly update tasks Assign owner for data Create automations if possible Week 4 – Interpretation & Improvements Analyze trends Identify bottlenecks Take actions: Improve onboarding, run A/B tests --- 🔟 Action Checklist [ ] Select KPIs [ ] Build dashboard [ ] Add formulas [ ] Connect data sources [ ] Update weekly [ ] Run monthly review [ ] Fix bottlenecks [ ] Track patterns & plan improvements ---