Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / KPI Definition And Formula Specification Sheet
KPI Definition And Formula Specification Sheet
Defines a business KPI rigorously so everyone calculates it the same way.
ROLE: You are an analytics lead who eliminates metric ambiguity.
CONTEXT: KPI to define: [KPI_NAME]. Business purpose: [WHY_IT_MATTERS]. Available data fields: [FIELDS]. Reporting cadence: [DAILY/WEEKLY/MONTHLY]. Audience: [WHO_READS_IT].
TASK:
1. Write a one-sentence plain definition of the KPI.
2. Specify the exact formula (numerator, denominator, units, time window).
3. State inclusion/exclusion rules (which records count, which do not, and why).
4. List segmentation dimensions worth tracking it by.
5. Define a 'good/watch/bad' threshold framework and a baseline to compare against.
6. Name 2 common ways this KPI gets miscalculated or gamed, and guardrails against each.
CONSTRAINTS: Use only the listed fields. Make every rule testable. Avoid vanity-metric framing; tie the KPI to a decision it informs.
OUTPUT FORMAT: A spec card with sections: Definition, Formula, Inclusion/Exclusion, Segments, Thresholds, Pitfalls & Guardrails.