Monthly KPI Variance Review with Drivers and Action Plan for Leadership

Converts pasted monthly KPI results and targets into a variance analysis, driver hypotheses, and prioritized actions that a leadership team can decide on in one meeting.

You get: Executive summary, data quality notes and KPI variance table

More like this

The prompt

monthly-kpi-variance-review-with-drivers-and-action-plan-for-leadership.md
ROLE: You are a business performance analyst preparing a monthly review for a leadership team. You are precise, skeptical of causal claims, and concise.

CONTEXT: The user is reviewing performance of {business_unit} for {period}. Job to be done: decide which variances need action, which need monitoring, and what to commit to before next month. Audience: {audience}. Meeting date: {meeting_date}.

TASK: Analyze the supplied KPI data, explain variances against target and prior period, separate evidence from hypotheses about causes, and recommend prioritized actions.

CONSTRAINTS: Use only the data provided. Do not invent benchmarks, causes, or figures. Describe correlation as correlation. Round numbers consistently and show variance as both absolute and percent. Keep the executive summary under 150 words.

Inputs
Required from the user:
- KPI table with actual, target, and prior period values: {kpi_data}
- KPI definitions and any known data quality issues: {kpi_definitions}
- Known events in the period (launches, outages, promotions, staffing changes): {known_events}
- Priorities and strategic goals for the quarter: {priorities}
- Decisions the leadership team can make this month: {available_decisions}
If inputs are missing or the data is unclear, ask up to 6 numbered questions first. If proceeding without answers, list assumptions separately and flag affected conclusions.

Workflow
1. Validate the data: check for missing values, inconsistent units, and definitions that may have changed. List issues found.
2. Compute variance versus target and versus prior period for each KPI. Show formulas for any derived metric.
3. Classify each KPI as On track, Watch, or Off track using thresholds the user supplies, or propose thresholds and mark them as assumptions.
4. For Watch and Off track KPIs, list up to 3 driver hypotheses each, the evidence from the data or events that supports it, and the check needed to confirm.
5. Prioritize actions by impact on {priorities}, effort, and confidence. Link each action to the decision leadership can make.
6. Identify risks, missing information, and next actions with owner roles and dates.

Output format
1. Executive summary (under 150 words)
2. Data quality notes
3. KPI variance table: KPI, actual, target, variance vs target, prior, variance vs prior, status
4. Driver hypotheses table: KPI, hypothesis, supporting evidence, confirming check, confidence
5. Prioritized action table: action, linked KPI, impact, effort, confidence, owner role, due date
6. Decisions requested from leadership (numbered list)
7. Risks, missing information, and next actions checklist

Acceptance criteria
- Every status label is traceable to a computed variance and a stated threshold.
- Hypotheses are labeled as hypotheses and each has a confirming check.
- Each action ties to a KPI and a decision the leadership team can make.
- The summary can be read in under one minute and names the top 3 issues.

Quality checks
- Recalculate three variance figures and confirm they match the table.
- Confirm percent and absolute variances use the same sign convention.
- Check that no cause is stated as fact without supporting data.
- Verify the action list is no longer than 7 items and that none duplicate each other.

Tool notes: In ChatGPT or Microsoft Copilot, attach the spreadsheet and ask for calculations to be performed from the file, then show the formulas. In Claude, paste the table in <kpis> tags and ask for the variance table in Markdown. In Gemini, specify the exact column order you want for tables.

Example output

AI-written example

Mid-Market Sales, North America | September 2025 | Leadership review, 7 Oct 2025

1. Executive summary
New MRR missed target by 8.4% and is trending down. Top 3 issues: (1) win rate is 3 pts below target, (2) sales cycle is 6 days longer than target, (3) logo churn is 0.3 pts above target. Pipeline coverage is healthy at 3.4x, so the gap is conversion, not lead volume. The 1 Sept price increase and two AE departures in August coincide with the decline, but causation is unconfirmed. Leadership is asked to decide on a pricing exception pilot and backfill timing.

2. Data quality notes

  • Churn definition changed in August (now excludes paused accounts), so the prior-period comparison is not like-for-like.
  • Win rate counts only opportunities closed in-month.

3. KPI variance (variance = actual − target; thresholds are assumptions: Watch 5–10% adverse, Off track >10%)

KPIActualTargetvs targetPriorvs priorStatus
New MRR$412k$450k−$38k (−8.4%)$430k−$18k (−4.2%)Watch
Win rate21%24%−3 pts (−12.5%)23%−2 pts (−8.7%)Off track
Sales cycle58 d52 d+6 d (+11.5%)55 d+3 d (+5.5%)Off track
Logo churn2.1%1.8%+0.3 pts (+16.7%)1.9%+0.2 pts (+10.5%)Off track
Pipeline coverage3.4x3.0x+0.4x (+13.3%)3.1x+0.3x (+9.7%)On track

4. Driver hypotheses

KPIHypothesisEvidenceConfirming checkConfidence
Win ratePrice increase raised losses on priceIncrease began 1 SeptReview loss reasons on deals closed after 1 SeptMedium
Sales cycleReduced AE capacity slowed dealsTwo AE departures in AugustCompare cyc
Generated from this prompt by AI. Your results will vary.

Tips and common edits

Use the same KPI definitions each month so trends stay comparable. Supply status thresholds if your team has them. Treat driver hypotheses as a to-do list for validation, not conclusions, and check key figures against the source system before presenting.

Questions about this prompt

More in Business

Business Idea Validation Sprint with a $100 Two-Week Test

Turn a business idea and target customer into a ranked list of risky assumptions, five interview questions and a $100 test to run in two weeks.

Competitor Landscape Research Plan with Source Discovery and Citation Table

Builds a source discovery plan, evidence review, citation table, and decision-ready synthesis for a competitor or market question, without pretending live browsing occurred.

Debt Payoff Comparison: Avalanche vs Snowball with Interest Totals

Compare the avalanche and snowball methods on months to debt-free and total interest using your own debts and extra payment, as education only.

Freelance Hourly and Project Rate Calculator with Tax and Admin Math

Calculate a sustainable hourly and project rate from your income target and billable hours, covering tax, unpaid admin time and expenses with the math shown.

Likely Interview Questions with STAR Model Answers from Your CV

Get 8 predicted interview questions for a specific job, each with a STAR model answer built only from facts in your CV.

Live Mock Interviewer That Scores Each Answer 1-5

Run a realistic one-question-at-a-time mock interview for your role and company, with a score and one concrete fix after every answer.

Build a zero-based monthly budget from typed income and spending amounts, flag overspending and get three realistic cuts, with no account access.

Operations Bottleneck Diagnosis and 30-Day Process Fix Plan

Diagnoses where a workflow slows down using your process steps and metrics, then ranks causes and produces a 30-day improvement plan with owners, measures, and risks.

Pricing Change Decision Memo with Scenario Math and Test Plan

Turns current pricing, cost, and customer data into a decision memo comparing hold, adjust, and repackage options, with scenario math, risks, and a controlled pricing test plan.

Salary Counteroffer Email, Call Script and Pushback Replies

Turn your job offer and target number into a polite counteroffer email, phone talking points and replies to the three likeliest pushbacks.

Side Hustle Matcher Ranked by Cost, Speed and Realism

Get five side hustles matched to your skills and weekly hours, ranked by startup cost, time to first $100 and realism, each with a first step.

Trending

Developmental Edit Memo for an Essay Draft With Revise-or-Cut Decisions

Gives a draft essay a structured developmental edit: thesis check, paragraph-by-paragraph audit, and a prioritized revision plan so you can decide what to keep, rewrite, or cut before line editing.