Marketing QBR Template and Workbook

Why your marketing QBR template needs two documents, not one

You're sitting in the meeting the night before, and the slide says spend is on track. The workbook, if anyone opened it, says three channels are over plan and one is sitting on a quarter of its budget with six weeks left. Nobody built the deck from the numbers — someone built the numbers to match the deck they'd already started. Then the VP of Finance asks why paid social is 40% over plan, and the honest answer is "I'll have to check," in a room where checking should have happened Tuesday.

This is the failure mode of most marketing QBR templates: a narrative deck built separately from the budget-vs-actual tracking, stitched together under deadline. The fix isn't a better slide design. It's treating the QBR as two linked documents — a roll-up workbook that computes the numbers, and a narrative outline that explains them — built from the same source so they can't drift apart. This piece walks through how to build both, in what order, and how to keep them in sync every quarter after this one.

What a marketing QBR template actually needs to do

A marketing QBR template has one job: let you walk into the room and answer "why" before anyone asks "what." That means the template needs three things a slide deck alone can't provide:

• A budget-vs-actual roll-up at the channel level, not just a total spend number.
• A variance calculation — planned minus actual, flagged over or under — done ahead of the meeting, not during it.
• A narrative structure that maps directly onto that roll-up, so every claim in the deck traces to a line in the workbook.

If your current process is a spreadsheet you eyeball and a deck you write from memory, you have half of this. The workbook is the harder half to build well, so start there.

Build the roll-up workbook first

The workbook is the source of truth. It should hold, at minimum, one row per channel or initiative with planned spend, actual spend logged to date, and the variance between them for the quarter you're reviewing.

Here's a worked example — treat these numbers as placeholders for your own:

Say your paid social line was planned at $12,000 for the quarter and actual spend logged so far is $16,800. Variance = actual − planned = $16,800 − $12,000 = $4,800 over plan. Your content line was planned at $8,000 and actual is $5,200 — variance = −$2,800, or $2,800 under plan. Roll those lines up against your fiscal-year start (say, a Q1 that begins in April rather than January) and you have a quarter-level picture: which channels are running hot, which are running cold, and what the net variance looks like once they offset.

That roll-up is the whole workbook. It doesn't need charts or commentary yet — it needs to be right, and it needs to be built from actuals you've actually logged, not actuals you're reconstructing the morning of the review.

If you're building this by hand, a quarterly business review marketing template walks through the exact row structure — channel, planned, actual, variance, note — so you're not designing the layout from scratch every quarter.

Build the narrative outline that matches the numbers

Once the workbook is correct, the deck's job is to explain it, not repeat it. A narrative outline for a QBR typically follows the same order as the roll-up: start with the quarter's objective, move to the budget picture, then to the calendar of what actually ran, then to what's ahead.

The mistake to avoid is writing the narrative before the numbers are final. If the deck says "spend is on track" and the workbook says three lines are over, one of them is wrong, and it's usually the deck — because it was written to a target, not to the actual. Build the outline after the roll-up, slide by slide, pulling the language directly from what the workbook shows.

A quarterly marketing review deck outline gives you the slide order — objective, budget roll-up, campaign calendar against the plan, variance explanation, next-quarter ask — so the narrative structure doesn't have to be reinvented alongside the numbers.

Walk the room through variance, not just totals

The single most common QBR failure is presenting a total spend number without the channel-level variance behind it. A total that looks "on track" can hide a channel 40% over and another 40% under, netting to zero — which tells leadership nothing about where the money actually went or why.

Present the variance, not just the total — the total tells the room nothing about where the money actually moved.

Walk each flagged line in order of size, not order of the deck. Lead with the largest over-plan variance, explain the cause in one sentence, state the correction if there is one. Same for under-plan lines — underspend isn't automatically good news if it means a planned campaign didn't run.

For the leadership-facing framing specifically — what to include, what to leave out, how much detail a board-level audience wants versus an internal one — see how to present a marketing plan to leadership and, if the review reports up to a board, a board report marketing budget template built for that shorter, higher-level format.

Tie the campaign calendar to the budget lines you're reviewing

A QBR that reports spend without reporting what that spend bought is half a review. Pull in a view of what actually ran that quarter — which campaigns launched, which were pushed, which pulled mid-flight — and tie each one back to the funding line the workbook is showing. If a campaign was cut because a channel ran over, say so; it's the explanation the variance line is missing.

This is also where a monthly cadence pays off at the quarterly review. If you've been checking budget-vs-actual monthly rather than reconstructing it once a quarter, the QBR becomes a summary of three months you already understand rather than a scramble to explain three months at once. A monthly marketing report template is worth building alongside the QBR workbook for exactly this reason — it feeds the quarterly roll-up instead of competing with it.

Keep the template ready for next quarter, not just this one

The workbook and the outline you build this quarter should be the same shell you fill in next quarter — same row structure, same slide order, same fiscal-year-start logic. Rebuilding either from scratch every quarter is where the drift creeps back in.

If you're doing this manually, a QBR template and workbook you can reuse — pre-built roll-up rows, a matching narrative outline, and a worked variance example to check your formulas against — removes the rebuild step entirely. The Marketing QBR Deck Outline & Workbook is a standalone spreadsheet and outline document built for exactly this: download it once, reuse it every quarter.

If you're already tracking budget-vs-actual variance continuously rather than reconstructing it quarterly, that roll-up and the monthly/quarterly rollup view are part of the core MarketPlans workspace, computed automatically as actuals are logged rather than assembled the night before. Scheduled check-in prompts and email/in-app variance alerts, along with plan revision history, are available on the Growth tier and above for teams who want the check-in cadence enforced rather than remembered. You can see the full workbook-and-outline pairing in the store, or try the live budget-vs-actual workflow yourself before your next review.