Design a KPI Tracking System
Define a comprehensive KPI tracking framework with data sources, calculation logic, and alert thresholds.
The Prompt
Design a KPI tracking system for the following business function. Provide: 1. North Star metric and reasoning 2. Primary KPIs (5-7): definition, formula, data source, frequency, owner 3. Secondary metrics: supporting indicators that explain primary KPI movement 4. Alert thresholds: when to be concerned vs. when to escalate 5. SQL queries to calculate each KPI 6. Dashboard layout recommendation 7. Weekly review cadence: what questions to ask when reviewing KPIs Function: [GROWTH / PRODUCT / ENGINEERING / CUSTOMER SUCCESS / FINANCE] Company stage: [SEED / SERIES A / SERIES B / MATURE] Business model: [B2B SaaS / B2C / MARKETPLACE / E-COMMERCE] Key business questions to answer: [LIST 3-5]
Example Output
North Star: Weekly teams sending >100 API calls (proxy for activated users). 6 primary KPIs: trial-to-paid rate, activation rate (API key added within 7 days), logo churn, NRR, CAC, and median time-to-value. Each with formula, source table, threshold (green/yellow/red), and a weekly review question to ask.
FAQ
Which AI model is best for Design a KPI Tracking System?
Claude Sonnet 4 — builds thoughtful metric frameworks that connect to business decisions.
How do I use the Design a KPI Tracking System prompt?
Copy the prompt, replace the [BRACKETED] placeholders with your specific information, and paste into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.). North Star: Weekly teams sending >100 API calls (proxy for activated users). 6 primary KPIs: trial-to-paid rate, activation rate (API key added within 7 days), logo churn, NRR, CAC, and median time-to-value. Each with formula, source table, threshold (green/yellow/red), and a weekly review question to ask.
Model Recommendation
Claude Sonnet 4 — builds thoughtful metric frameworks that connect to business decisions.