Prompts / Data & Spreadsheets / KPI Definition And Formula Specification Sheet

KPI Definition And Formula Specification Sheet

Data & Spreadsheets
#kpi#metrics#analysis

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.
Get PromptJectManager Browse more