What a great KPI report includes
A KPI report answers one question at a glance: are the numbers we steer by where they should be? That takes two layers on one page: a scannable dashboard, and a short narrative for the metrics that moved. The rule the whole SERP agrees on and most reports break: 5 to 10 metrics, no more. Beyond ten, nothing is key any more.
| Per metric | Why it’s required |
|---|---|
| Current value | The reading |
| Target | A number without a target is trivia, not a KPI |
| Trend vs last period | Direction matters more than any single reading |
| Status (G/A/R) | Green at/ahead of target; amber behind but recoverable; red needs a decision |
How to choose 5 to 10 KPIs that matter
The filter is a single question per candidate metric: what would we do differently if this number changed? If there is a real answer (raise prices, hire, chase, stop a campaign), it is a KPI. If the honest answer is “note it with interest”, it is reporting furniture, and it goes.
A balanced small-business set usually spans money in (revenue, or bookings), the engine (leads, conversion, turnaround time), money out or capacity (a cost or utilisation line), and one customer-health line (repeat rate, complaints, reviews). Vanity metrics fail the filter instantly, which is the filter working.
KPI report example: the dashboard and the narrative
Both layers for a small electrical contractor’s July, on one page:
THE DASHBOARD · July Revenue £61k target £58k ↑ GREEN Qualified leads 38 target 35 ↑ GREEN Quote turnaround 9 days target 6 ↓ RED Win rate 31% target 30% → GREEN Jobs on schedule 7 of 8 target 8 of 8 → AMBER Repeat business 44% target 40% ↑ GREEN Overtime hours 61 target <40 ↑ AMBER Reviews (30d) 4.8 target 4.5+ → GREEN THE NARRATIVE Quote turnaround: 9 days and worsening; every quote is waiting on the same person. Decision below. Overtime: tracking the Hartwell rewire deadline; expected to drop by mid-Aug when it completes. Jobs on schedule: the one slip is client-side sign-off, already escalated. DECISIONS THIS RAISES - Quote turnaround red for a 2nd month: bring forward the estimator hire, or route small quotes to Dev?
Notice the shape: the dashboard is scannable in ten seconds, the narrative covers only the movers, and the report ends by asking for a decision, which is the difference between a KPI report and a screensaver.
Free KPI report and dashboard template (plain text, Google Docs, Notion)
Three ways to a living dashboard. The plain text pastes cleanly into Google Docs or Notion, and the row shape drops into a spreadsheet.
The plain-text template
Dashboard rows plus the narrative and decisions blocks.
KPI REPORT · [Business or team] · [Period] Prepared by: [name] · Date: [date] THE DASHBOARD (5-10 metrics, no more) [KPI] · value [x] · target [y] · trend [↑/↓/→ vs last period] · [G/A/R] [KPI] · value · target · trend · status [KPI] · value · target · trend · status … (Green = at or ahead of target. Amber = behind but recoverable this period. Red = off target, needs a decision.) THE NARRATIVE (one short line per metric that moved) [KPI]: [why it moved, in plain words, and what happens next] … DECISIONS THIS RAISES - [The one or two calls the numbers are asking someone to make] Ten metrics is the ceiling, not the target. Five you act on beat ten you admire.
The AI prompt
Prefer to use your own AI? Copy this into Claude or ChatGPT with your metrics and targets, and it builds both layers.
--- title: KPI Report Generator description: A prompt that builds a KPI report and dashboard: 5-10 metrics with value, target, trend and RAG, plus a one-line narrative each. author: readywhen source: https://readywhen.ai/kpi-report-template homepage: https://readywhen.ai license: CC BY 4.0 (free to use and share with attribution to readywhen) version: 1.0 updated: 2026-07-18 keywords: [kpi report template, kpi dashboard, key performance indicators, business metrics] --- # KPI Report Generator _By readywhen. Full guide + free template: https://readywhen.ai/kpi-report-template_ You are building a KPI report: a scannable dashboard of 5-10 metrics plus a short narrative. ## Principles - 5 to 10 metrics, hard ceiling. If more are offered, help choose: keep the ones a decision hangs on, cut the ones merely watched. - Every metric carries four things: current value, target, trend vs last period, and a green/amber/red status. A number without a target is trivia. - Use only the numbers provided; where a value or target is missing, mark it [NEEDED], never estimate. - The narrative is one plain line per metric that moved: why, and what happens next. No metric gets a paragraph. - End with the decisions the numbers raise. A KPI report that raises no decisions is a screensaver. ## What I need from you The metrics you steer by and their current values · targets for each · last period’s values for trend · who reads this and how often. I’ll build the dashboard block and the narrative, and flag any metric that lacks a target. --- _Made by readywhen. readywhen fills the dashboard from the numbers already tracked in your docs and report emails, and writes the so-what lines. https://readywhen.ai/kpi-report-template_
Let readywhen do itRecommended
Dashboards die on refresh day. readywhen fills every row from the numbers already in your tools, computes the trends, sets the colours and writes the so-what lines, period after period.
readywhen fills all four parts of every row from the numbers already tracked in your tools in ~45 seconds, so the dashboard stays alive instead of becoming last quarter’s spreadsheet.
Watch readywhen fill your KPIs from your connected numbers
KPI dashboards fail on refresh day: someone has to fetch eight numbers from four places, remember the targets, and work out the trends, every single period. readywhen takes that job: it reads the values from the numbers you already track in your docs and report emails, holds the targets, computes the trends, sets the colours, and writes the one-line so-what for each mover. When a metric goes red it also drafts the decision the number is raising, which is what the report was always for.
Works with your existing tools
KPI report FAQs
What is the difference between a KPI report and a dashboard?
A dashboard is the scannable grid: metrics with values, targets, trends and colours. A KPI report adds the narrative: why each mover moved and what happens next. The template on this page deliberately carries both on one page, because the grid without the why invites guesswork.
How many KPIs should a small business track?
Five to ten, and ten is the ceiling, not the target. Each must pass the action filter: something you would do differently if the number changed. Beyond ten, the dashboard stops being read and nothing on it is “key” any more.
What makes a metric a KPI rather than just a number?
A target and a consequence. A KPI has a value you want it to reach and an action that follows when it strays; a number you merely watch with interest is reporting furniture. The green/amber/red status only means something when the target does.
How often should a KPI report be updated?
Match the cadence to how fast the numbers move and decisions follow: weekly for pipeline-and-delivery metrics, monthly for the owner-level set. What kills KPI reporting is not the wrong cadence but the manual refresh, which is why automating the fill matters more than the format.
Is there a KPI report template for Google Docs or Excel?
Yes. Copy the plain-text template on this page into Google Docs, Word or Notion, or download it as a file; the row structure drops straight into a spreadsheet. All formats are free.
Can’t I just use ChatGPT or Claude to build my KPI report?
Yes. Paste your metrics and targets with the prompt above, and it builds the dashboard and narrative. readywhen is the version that fetches the values itself from the numbers already tracked in your tools, every period, which is the chore that kills most dashboards by month three.
More templates for numbers with a so-what
Monthly report
Objectives, results and next month’s plan, compiled from your tools.
Board report
The monthly pack: numbers, narrative and asks, drafted from your tools.
Weekly report
Completed, in progress and blockers, written from what actually happened.
Stop admiring metrics. Act on them.
Fill your KPIs free with readywhen
About the author and editorial standards
About the author. Sançar Şahin is co-founder and CMO of readywhen. readywhen catches everything you say you’ll do and helps you move it forward: drafted, chased or flagged, ready when you are. He builds readywhen in public on LinkedIn.
Editorial standards. No paid placements. The 5-10 metric cap and value-target-trend-status row reflect common performance-reporting practice rather than a single authority. How this page was made: Sançar built the multi-agent research and drafting system behind it, checks its work at several phases, and approves the final page himself. To flag an error, email hello@readywhen.ai.
Last updated: 19 July 2026.