Define and structure KPIs for any team or business with targets, tracking methods, and actionable dashboards.
Copy & paste the prompt below into your preferred LLM. Unless a specific AI model is mentioned, you can use whichever you prefer.
You are a business intelligence consultant. Build a KPI framework for my team or business. My context: - Business/Team: [DESCRIBE YOUR BUSINESS OR TEAM FUNCTION] - Industry: [YOUR INDUSTRY] - Stage: [STARTUP / GROWTH / MATURE] - Current metrics: [WHAT DO YOU TRACK NOW? OR "NOTHING FORMAL"] - Pain point: [WHAT DON'T YOU HAVE VISIBILITY INTO?] - Reporting audience: [CEO / BOARD / TEAM LEADS / INVESTORS / SELF] - Tools: [GOOGLE SHEETS / LOOKER / TABLEAU / POWER BI / NOTION / OTHER] Deliver: 1. **KPI Selection:** 8-12 KPIs for your business/team, organized as: - Leading indicators (predict future performance) - Lagging indicators (confirm past performance) - Health metrics (things that should stay stable) For each KPI: name, formula, data source, update frequency, owner 2. **Target Setting:** For each KPI — realistic target, stretch target, red flag threshold. Method for setting targets (benchmark, historical, aspirational) 3. **KPI Hierarchy:** How team KPIs ladder up to company KPIs. North Star metric identification 4. **Dashboard Design:** Layout recommendation with KPIs grouped logically. Suggested chart type for each metric. Color coding and alert rules 5. **Data Collection:** Where each data point comes from and how to automate collection 6. **Review Cadence:** Daily, weekly, monthly, and quarterly review frameworks. Meeting agenda template for KPI reviews 7. **Action Triggers:** For each KPI — what to do when it's red. Specific investigation steps and intervention playbooks 8. **Anti-Metrics:** What NOT to track (vanity metrics for your business) and why Measure what matters. If a metric doesn't change behavior, stop tracking it.
"KPI Framework Builder" applies research-backed prompting principles: sequential task breakdown and output formatting. These are the same techniques used by professional prompt engineers to get predictable, high-quality results. You can expect actionable analytical insights with methodology documentation and visualization recommendations - the kind of result that normally requires several rounds of prompt refinement.
These data analysis tips will help you get stronger results when using "KPI Framework Builder" and similar prompts in this category.
"KPI Framework Builder" is particularly useful in these situations. If any of these scenarios sound familiar, this prompt will save you significant time.
When you use "KPI Framework Builder" with ChatGPT, Claude, or Gemini, here is what to expect in the AI output.
Adapt "KPI Framework Builder" to your specific situation by modifying these key areas. The more context you add, the better the results.