Write a Weekly or Monthly KPI Report Narrative from Your Excel Numbers

Turns your pasted KPI numbers into a report narrative where each metric states the change, the likely driver and a next action, with every claim tied to a figure.

You getHeadline, summary table and one section per KPI

Prompt

Prompt
Act as a business analyst who writes KPI commentary for a leadership team.

I will paste my KPI numbers right after this prompt (a table or list from Excel, with current period, prior period and target where I have them). Before writing, ask me up to 3 short numbered questions in one message: the reporting period (weekly or monthly), who reads the report, and any known events that period (launches, outages, holidays). Wait for my answers.

Then write the report narrative. Rules:
1. Every claim cites a figure from my data: the value, the change versus prior period in absolute and % terms, and versus target if given.
2. Each KPI section states three things in order: what changed, the likely driver, and one next action with an owner role.
3. Label each driver "Confirmed" if my data or answers show it, or "Likely" if it is your inference. Never invent numbers or causes.
4. Lead with the 3 biggest movements, not the order I pasted.
5. Plain sentences of 25 words or fewer.

Output format:
- Headline (one sentence)
- Summary table: KPI | This period | Prior | Change | vs Target | Status (On track / Watch / Off track)
- One section per KPI: Change, Driver (Confirmed/Likely), Next action
- Data gaps: metrics missing or inconsistent

End with one line listing the assumptions you made about the data.

Example output

At a glanceMarch KPI headlines vs FebruarySmall online clothing store, monthly report
Revenue
$184,200
+7.4%, $4,200 over target
Sessions
188,600
+18.8% after paid social launch
Conversion rate
2.1%
Down from 2.4%, target 2.5%
Return rate
6.8%
Up 1.7 pts, target under 6%

Example for: a small online clothing store, March vs February monthly report for the founder and ops lead; paid social campaign started 10 March.

Headline

Revenue beat target by 2.3% on an 18.8% traffic jump, but conversion and returns moved the wrong way.

Summary

KPIThis periodPriorChangevs TargetStatus
Sessions188,600158,800+29,800 (+18.8%)No targetOn track
Conversion rate2.1%2.4%-0.3 pts (-12.5%)Target 2.5%Off track
Return rate6.8%5.1%+1.7 ptsTarget under 6%Off track
Revenue$184,200$171,500+$12,700 (+7.4%)Target $180,000On track
Orders3,9603,810+150 (+3.9%)Target 4,100Watch
Avg order value$46.52$45.01+$1.51 (+3.4%)No targetOn track

Sessions

  • Change: Sessions rose 29,800 to 188,600, up 18.8%.
  • Driver (Likely): The paid social campaign from 10 March; channel split was not in the data.
  • Next action: Marketing lead to add sessions by channel to next month's table.

Conversion rate

  • Change: Conversion fell from 2.4% to 2.1%, 0.4 pts below the 2.5% target.
  • Driver (Likely): New paid social visitors convert lower than returning visitors.
  • Next action: Marketing lead to compare conversion for paid social versus other traffic before raising spend.

Return rate

  • Change: Returns rose 1.7 pts to 6.8%, above the 6% limit.
  • Driver (Likely): The spring collection launch; return reasons were not provided.
  • Next action: Ops lead to pull return reasons by product for March.

Revenue

  • Change: Revenue reached $184,200, up $12,700 (7.4%) and $4,200 over target.
  • Driver (Confirmed): Both orders (+3.9%) and average order value (+3.4%) grew.
  • Next action: Founder to check net revenue after returns before calling the month a win.

Orders

  • Change: Orders rose 150 to 3,960, still 140 short of the 4,100 target.
  • Driver (Confirmed): Higher traffic was offset by lower conversion.
  • Next action: Ops lead to review checkout drop-off for March.

Avg order value

  • Change: AOV rose $1.51 to $46.52.
  • Driver (Likely): Higher spring collection prices.
  • Next action: Founder to track AOV by collection in April.

Data gaps

  • No channel split for sessions or conversion.
  • No return reasons or net revenue after returns.

Assumptions: revenue is gross before returns; conversion is orders divided by sessions.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • The change, driver, next action order stops the report from just restating numbers and forces a decision for each metric.
  • Labeling drivers Confirmed or Likely separates what the data proves from the model's guesses.
  • Ranking by biggest movement puts the problems readers need first at the top, not buried in paste order.

Use at the end of each week or month when you need commentary fast. Copy your KPI table from Excel with prior period and targets, then paste it into ChatGPT, Claude or Gemini after the prompt.

Common edits

  • Ask for a 5-bullet version for a Slack or email update instead of full sections.
  • Add a rule to compare against the same period last year as well as the prior period.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Excel & Spreadsheets