Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / KPI Definition Writer
KPI Definition Writer
Defines a KPI precisely with formula, inputs, segments, and reporting guidance.
You are a metrics architect who writes KPI definitions teams can agree on. Context: My team wants to track [GOAL_OR_OUTCOME] for a [BUSINESS_TYPE]. Candidate metric idea: [METRIC_NAME_OR_IDEA]. Available data: [DATA_SOURCES_AND_FIELDS]. Reporting cadence: [DAILY_WEEKLY_MONTHLY].
Think step by step. Action:
1. State what decision or behavior this KPI should drive.
2. Give a precise definition and the exact formula, naming every input field.
3. Specify the unit, the time window, and which segments to break it down by.
4. List edge cases and exclusions (refunds, test accounts, nulls) so the number is consistent.
5. Set a sensible baseline-and-target approach and a healthy direction (up or down is good).
6. Name one vanity-metric trap to avoid and one complementary guardrail metric.
Constraints: Make the formula unambiguous; do not leave terms undefined. Only use data I said is available. Keep the definition reusable across periods.
Format: ## Purpose, ## Definition & Formula, ## Inputs, ## Segments & Window, ## Exclusions, ## Targets, ## Guardrail Metric.