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
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
Tags