How an Agency Builds a Quarterly Business Review Deck Across Five Channels

Every quarter, the agency quarterly business review reporting ritual used to consume two full days of an account lead's time. The retainer ran on five channels in three currencies, and the QBR deck was assembled by hand: seven exports, a workbook, a currency conversion half-remembered, and a deck rebuilt from screenshots the night before the client meeting. This is the story of one agency archetype that replaced that ritual with a single cross-channel view — and discovered the QBR meeting got better the moment the deck got easier to build.

The agency here is a composite drawn from common mid-market patterns, but every friction point is one real agencies hit at quarter's end. Northpath Media ran a flagship retainer across Meta, Google, TikTok, Taboola, and Snapchat, and the QBR for that account was the single most dreaded deliverable on the calendar.

The QBR That Ate Two Days

The problem was not that the data was hard to find. It was that it lived in seven places, in three currencies, with conversion definitions that did not agree.

The account lead's old process started with seven exports — one per platform, plus two cross-checks against the client's own analytics. Then came the workbook: paste, align columns, convert dollars, euros, and pounds at whatever exchange rate the lead pulled that morning, reconcile conversion windows that defined a "purchase" differently on each platform, and build the charts. Two days, every quarter, before the lead could even start thinking about what the numbers meant.

This is not an isolated complaint. Gartner reported in 2023 that marketing analysts spend a large share of their week wrangling and reconciling data before any analysis begins, and eMarketer noted in 2024 that the average mid-market advertiser now runs five or more ad channels in parallel — exactly the spread that makes manual quarter-end assembly so brittle. The more channels a retainer adds, the more the QBR collapses into stitching rather than thinking.

There was a second, quieter failure. Because the lead converted currency at the spot rate each quarter, last quarter's totals drifted when re-pulled. The Q1 deck and the Q2 deck disagreed about Q1 — and in a QBR, where the client's finance team is in the room, that drift is the kind of thing that quietly erodes trust in every number on the screen.

What They Changed: One Connected Source

Northpath moved the retainer's reporting onto a cross-channel layer. The shift was less about a prettier deck and more about killing the assembly step entirely. The full mechanics mirror our step-by-step cross-channel dashboard guide, but the QBR-specific change came down to three things.

Every channel connected once, through the official APIs

The client's Meta, Google, TikTok, Taboola, and Snapchat accounts were connected through OAuth and the official platform APIs. Structural and performance data then synced automatically on a roughly 15-minute cadence, so the QBR never again started with seven manual exports. The data was already in one place, already current, the moment the lead opened the view.

Currency locked at the day-of-transaction rate

This is the change the client's CFO cared about. Spend now converts at the exchange rate from the day it occurred, so a closed quarter stays fixed. Q1's totals read the same in the Q1 deck and the Q2 deck. The drift that had put every number in question was gone, and the finance portion of the QBR went from a defense to a reconciliation that simply matched.

One blended QBR view, exported as a branded deck

The lead now opens one cross-channel view for the retainer: a blended KPI strip showing total spend and ROAS, a channel-mix donut, a comparison matrix that puts normalized cost-per-result side by side across all five channels, and a quarter-over-quarter trend. Instead of building a deck from screenshots, the lead exports a single branded report with the agency's custom fields for client branding — the same Scheduled Reporting export our scheduled reporting guide describes, run on demand for the QBR. The two-day assembly became an export.

The Forward Budget Conversation

The most valuable change was not the time saved — it was what the lead did with it. With the comparison matrix showing normalized cost-per-result across five channels, the QBR's budget discussion stopped being a hunch and became evidence.

When the matrix showed TikTok delivering results at twice the cost of Google for this client, the cross-channel view proposed a reallocation with the reasoning attached. The account lead used that as the starting point for the next-quarter plan — not as a decision the tool made, but as a defensible proposal to discuss with the client.

That boundary mattered to Northpath's lead, who was skeptical of any tool that touched budget. The distinction settled it: the recommendation is a prepared proposal with its evidence, a starting point for the lead's judgment, not a substitute for it. No spend moves until the lead and the client agree and the team acts. The tool does the arithmetic and surfaces the evidence faster; the humans keep every decision. For the broader trade-offs between approaches, our cross-channel analytics approaches compared lays them side by side.

What Changed in the Review Meeting

The measurable shift was time: two days of assembly per QBR, per retainer, returned to analysis. But the meeting itself changed character.

Before, the QBR was a recap — the lead walking the client back through a quarter the client had largely already seen, defending totals that did not quite match the last deck. After, the QBR was a strategy session. The recap was a glance, because the blended view made the quarter legible at once, and the bulk of the hour went to the forward plan: where the channel mix should shift, which channel was earning more budget, what the next quarter's targets should be.

The client noticed. A QBR that opens with numbers everyone trusts and moves quickly to "where do we go next" is the QBR that renews a retainer. The deck got easier to build, and the relationship got stronger — because the lead's time moved from assembling data the client never values to interpreting it, which is the entire reason a client retains an agency. This is the same shift our five-platforms-in-one-view story traces for weekly reporting, compounded across a quarter.

Before and after, concretely

It helps to make the change tangible. Before, a single QBR for the retainer looked like this: pull seven exports across five ad managers and two analytics cross-checks, paste each into a master workbook, apply a currency conversion the lead reconstructed each quarter, align conversion windows that defined a purchase differently on every platform, rebuild a dozen charts, and assemble forty slides — two days when nothing broke, and something always broke. The error surface was enormous and entirely manual, and the deck the client finally saw carried whatever small mistakes survived the assembly.

After, the same QBR is: open the retainer's cross-channel view, confirm the connections synced, scan the comparison matrix and the quarter-over-quarter trend, and export the branded deck. The currency is already converted at the day-of-transaction rate and locked. The conversion definitions are already normalized to a single standard. The charts are already built. The lead's two days collapse into an afternoon, and that afternoon goes to the forward plan rather than the back-fill. The deck the client sees is the same data the agency trusts internally, because there is no second, hand-assembled copy to diverge from it.

Is This Your Agency?

The pattern repeats wherever a QBR spans multiple channels and more than one currency. If your quarter-end looks like Northpath's old one — a senior person lost for two days to assembly, totals that drift between decks, a budget conversation built on intuition — a cross-channel layer addresses all three at once: it removes the assembly, locks the currency, and grounds the forward plan in normalized evidence.

For the up-link to the full set of operations playbooks, the agency-tools hub collects the rest, and the scheduled reporting guide covers automating the recurring deliverables between QBRs.

The Bottom Line

A QBR should be where an agency demonstrates its judgment, not where it spends two days proving it can use a spreadsheet. A cross-channel layer that connects every channel through the official APIs, locks currency at the day-of-transaction rate, assembles one branded blended view, and proposes a defensible forward budget turns the QBR from an assembly job into a strategy session. Wevion's Cross-Channel Analytics and Scheduled Reporting are included across every plan: a permanent free tier (€0), Starter at €99/mo, Pro at €499/mo, and Plus at €1,499/mo (€1,199 annual, billed yearly at -20%), with Enterprise as a custom plan, and every paid tier includes a 14-day trial that coexists with the free plan. Build your next QBR deck from one connected source during the trial, and the quarter-end ritual becomes an export.