Create A Reusable KPI Report Template
Builds a fill-in-ready KPI report template for a business area, its KPI list, reporting frequency, and audience, meant to be generated once and reused every period. Includes a header section, a red/yellow/green scorecard, per-KPI detail with trend and variance from target, a commentary section, action items for underperforming metrics, and a data-definitions appendix explaining how each number is calculated.
Prompt
Build a reusable KPI report template for {business_area} reporting. KPIs to include: {kpi_list} Reporting frequency: {reporting_frequency} Audience: {audience} The template needs: 1. A header section (period, prepared by, distribution list) 2. A scorecard with status indicators for every KPI (green/yellow/red) 3. Detail per KPI: current value, trend, variance from target, root cause for any red/yellow status 4. A commentary section on key events affecting the metrics 5. Action items for underperforming KPIs 6. An appendix of data definitions and calculation methods Make it fill-in-ready — I should be able to plug in new numbers each {reporting_frequency} and have a complete report.
