Data & Analytics

Business Question to KPI Narrative

Turn a messy business question plus metrics into a clear analytical readout and recommendation.

Use case

Translating business questions into measurable KPIs with narrative context

Works best with

ClaudeChatGPT

Input needed

The business question (e.g., 'Are we growing fast enough?'), available data sources, and the audience for the narrative

Output format

KPI definitions, measurement methodology, benchmark context, current state narrative, and recommended targets

Example use

Ask 'Is our customer acquisition efficient?' Get back definitions for CAC, LTV/CAC ratio, payback period, with industry benchmarks, a narrative explaining what your numbers mean, and suggested targets for next quarter.

Editor’s Note

Good at the framework level — it knows standard KPIs and benchmarks. Weak on your specific business context. The narrative quality improves dramatically when you provide actual numbers rather than asking generically. Best used to structure your thinking, then fill in with real data.

Full Prompt

Act as a senior business analyst. Answer the question below using the provided metrics and context.

Business Question:
[INSERT QUESTION]

Metrics / Data:
[PASTE KPI TABLES, METRICS, OR NOTES]

Context:
[OPTIONAL BUSINESS CONTEXT]

Output:
1. Direct Answer
- Answer the question in 2-4 sentences

2. Key Evidence
- 3-6 bullets pointing to the most relevant metrics

3. What Is Driving The Result
- Explain the likely drivers

4. What Could Be Misleading
- Data gaps, confounders, seasonality, attribution issues, sample size, etc.

5. Recommended Next Action
- One immediate action
- One follow-up analysis

Rules:
- Do not just restate the data
- Prioritize decision usefulness over dashboard-style summary
- If evidence is insufficient, say so clearly