In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
KPI Definitions That Don't Cause Arguments
Prompt
The metric name and what people currently think it means: {{METRIC_NAME_AND_CURRENT_MEANING}}
Business context and who uses the number: {{BUSINESS_CONTEXT}}
The source tables or sheets and columns available: {{SOURCE_FIELDS}}
Known disagreements or past discrepancies: {{PAST_DISAGREEMENTS}}
Write a metric definition card:
1. Name, one-sentence plain-English definition, and the question it answers.
2. Exact calculation, with numerator, denominator, filters, inclusions and exclusions, time window and time zone.
3. Edge cases and how each is handled (refunds, test accounts, partial periods, duplicates, late-arriving data).
4. The formula or query to calculate it from the fields I listed, using only fields I gave; if a needed field is missing, say so.
5. Why this metric can mislead, and a companion metric that guards against that.
6. Version history line: date, change, who approved (leave blank for me to fill).
Where the definition depends on a business choice, show the options with consequences and tell me who should decide. Do not state benchmarks.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“KPI Definitions That Don't Cause Arguments” is a free prompt for ChatGPT in the Business category, 169 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{METRIC_NAME_AND_CURRENT_MEANING}}, {{BUSINESS_CONTEXT}}, {{SOURCE_FIELDS}}, {{PAST_DISAGREEMENTS}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 6 times.
Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.