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
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
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 like this
Summarize Pasted Spreadsheet Data into Key Findings and Trends
Paste rows from Excel or Google Sheets and get numbered findings tied to exact figures, a trend table, data quality flags and the gaps that limit conclusions.
Build an Excel Sales Forecast Comparing Moving Average and FORECAST.ETS
You get a tested Excel sales forecast with paste-ready formulas for two methods, a MAPE comparison on held-out months, and a clear pick of the better method.
Calculate Year-over-Year and Month-over-Month Growth in Excel Without Misleading Percentages
You get a growth table, exact Excel formulas that handle zero and negative baselines and partial months, plain-language takeaways, and a list of percentages that would mislead.
Write SQL Queries from a Plain-English Question and Your Table Schema
Paste your schema and ask a question in plain English. You get a working SQL query, a line-by-line explanation, and a row-count check query to verify the results.
Plan a Pivot Table That Answers a Specific Business Question
Get a pivot table plan mapping your fields to rows, columns, values and filters, with aggregation choices, data shape fixes and build steps.
Build a Power Query Workflow That Combines and Cleans Monthly Excel Files
You get numbered Power Query steps with paste-ready M code, a full query, and a flag on every step that breaks when column names change.