Compute week-over-week changes in a KPI table without mistakes

About this exercise

Build a markdown table with columns Metric, This week, Last week, Change, using the corrected numbers. Change is this week minus last week; for percentages show the change in percentage points (pp) and for counts show the difference. After the table add one line starting "Watch:" naming the one metric that moved in the wrong direction by the largest relative amount. Output only the table and that line.

Common mistakes when you ask AI for this

• Old backlog. The AI uses 55. Try: Say: "Backlog is 61 after the correction."
• Percent confusion. The AI shows percent change instead of pp. Try: Say: "Show percentage points for percentage metrics."
• Wrong Watch pick. The AI picks first reply. Try: Say: "Pick by largest relative move in the wrong direction."
• Wrong columns. The AI changes headers. Try: Say: "Columns: Metric, This week, Last week, Change."
• Trusting the AI to count words. AI is bad at counting. Ask for a total word limit and it often lands over it. Try: Cap it: "cells hold short values only."
• Trusting the AI to count words. AI is bad at counting. Ask for a total word limit and it often lands over it. Try: Cap each part instead, for example: "each line under 12 words."

What a strong prompt includes

• Columns
• pp
• Corrected
• Watch
• Only table

Practice this now ↑

Related exercises

• Age a returns queue in business days and flag the ones over the limit (Customer Support & Success AI · Customer support teams)
• Alert sales to a competitor's price change, facts only (Research & AI Search · Product managers)
• Announce a colleague's promotion with approved facts only (Leadership AI · Managers and team leads)
• Announce a manager swap in Slack with two sentences and one link (Leadership AI · Managers and team leads)
• Announce a new team member in an email with exact first and last lines (Leadership AI · Managers and team leads)