Data Analysis
KPIsmetricsanalyticsperformance measurementOKRsKPI Definition Framework
A structured KPI framework with formulas, owners, targets, and data sources that makes every metric unambiguous and accountable.
Prompt Template
Define a complete KPI framework for [TEAM_OR_FUNCTION — e.g., the customer success team / the product organization] at [COMPANY_NAME]. Business objective this framework serves: [BUSINESS_OBJECTIVE]. For each of the following proposed KPIs: [KPI_LIST], provide a structured definition containing: (1) KPI name and plain-English definition (what does it actually measure?), (2) Calculation formula — exact formula using available data fields, (3) Data source — which system or table this comes from, (4) Measurement frequency — how often it should be calculated (daily, weekly, monthly), (5) Target — current baseline: [CURRENT_BASELINE], target value: [TARGET], and timeframe, (6) Owner — who is accountable for moving this number, (7) Leading vs. lagging — classify each KPI and explain why, (8) Relationship to other KPIs — does this metric drive or correlate with another? After defining all KPIs, add a "KPI hierarchy" section showing how the individual KPIs roll up to the top-level business objective. Flag any KPIs where data is not currently available or reliable.
How to use this prompt
- Copy the prompt template using the button above.
- Paste it into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.).
- Replace all bracketed placeholders like
[TOPIC]with your specific details. - Send the prompt and refine the output as needed.
Advertisement