KPI Report Builder

Builds structured KPI reports with RAG status indicators, trend analysis, root cause analysis, and executive narratives for performance tracking.

Data & Analytics · intermediate · ChatGPT

Prompt template

Create a KPI report for {{department_or_team}} covering {{time_period}}.

Business type: {{business_type}}
Key metrics to track:
{{metrics_list_with_current_values}}

Previous period values:
{{previous_period_values}}

Targets/Goals:
{{target_values}}

Please generate:
1. KPI dashboard summary with RAG status (Red/Amber/Green)
2. Period-over-period comparison with percentage changes
3. Trend analysis for each metric
4. Root cause analysis for underperforming metrics
5. Correlation between related KPIs
6. Executive narrative (3-4 paragraphs)
7. Recommended actions for next period
8. Risks and opportunities outlook

Example output

KPI Dashboard - Marketing Team Q4 2025

| KPI | Target | Actual | Status | Change |
|-----|--------|--------|--------|--------|
| MQLs | 500 | 620 | GREEN | +24% |
| CAC | $45 | $52 | AMBER | +16% |
| Conv. Rate | 3.5% | 3.2% | AMBER | -8.6% |

Narrative: Marketing exceeded lead generation targets by 24%, driven by strong performance from the webinar series and organic search improvements. However, CAC increased by 16% due to rising paid media costs.

Use cases

  • Department heads preparing monthly reviews
  • Analysts building automated report templates
  • Executives tracking business health metrics

Tags

KPI, reporting, dashboards, performance-tracking