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