ServicesIndustriesWhy UsContactBlogGet free audit
Back to blog

AI Reporting: Why Your Dashboard Should Match Your Ad Account to the Cent

Most agency reporting is a story typed into a slide the night before the call. Here is what live, reconciled reporting looks like, why numbers drift, and the questions that expose the difference.

AI MarketingReportingTransparencyAutomation

There is a test you can run on any agency in about thirty seconds. Open the dashboard they gave you. Open the ad account itself. Same date range, same metric. Compare.

If those two numbers do not match, one of them is a story. You are entitled to know which.

AGENCY DECKSPEND 18,000CPA 38ROAS 4.1AD ACCOUNTSPEND 18,400CPA 52ROAS 2.9MISMATCHONE NUMBER, PULLED LIVENO BLACK BOXES

Why numbers drift, legitimately and otherwise

Not every mismatch is a problem. Some are unavoidable and easy to explain. The distinction is whether your agency can tell you which kind you are looking at without checking first.

Cause of mismatchLegitimate?What it should look like
Attribution window differs from platform defaultYesStated on the report, same window every month
Account timezone vs reporting timezoneYesPinned once, disclosed, never changed mid-quarter
Currency converted on a fixed dateYesThe FX date is on the report
Platform restating conversions within 72 hoursYesReports past a settling window, or flagged as provisional
Numbers typed in by handNoShould not exist
"Test" campaigns excluded from spendNoSpend is spend
Management fee blended into media spendNoTwo separate lines, always
Conversions counted on a different model than the accountNoOne model, named on the report

The pattern is simple. Legitimate differences are decided once, written down, and applied consistently. The others move around depending on how the month went.

Blended spend is where the money hides

The single most common reporting trick is not a fake number, it is an ambiguous one. A report says "spend: $84,000." Does that include the management fee? Platform fees? Creative production? If the answer changes between a good month and a bad one, your CPA is not a metric, it is an opinion.

Media spend, fees, and production belong on separate lines. Every derived number, CPA and ROAS included, should say which line it was calculated from.

What live reporting actually requires

Very little of this is exotic. It is mostly the decision to remove the human retyping step.

  • Direct API pulls. Numbers come from the platforms, not from a spreadsheet somebody maintains.
  • One source of truth. The dashboard the client sees and the dashboard the team optimizes against are the same dashboard.
  • Timezone and currency pinned. Decided at setup, disclosed, and not quietly changed.
  • No manual entry anywhere in the chain. If a person can type a number, a person can adjust a number.
  • A settling window for provisional data. Yesterday's conversions are an estimate. Say so rather than reporting them as final.

The change log matters more than the chart

Charts tell you what happened. They do not tell you why, and "why" is where the trust lives. Every automated change our systems make gets logged: what changed, when, which rule triggered it, and what the state was before.

That log is the thing that makes automation auditable. Budget moved 15% toward one campaign on a Tuesday, and six weeks later you can see exactly which threshold fired and what the numbers looked like at the time. Without it, "the algorithm decided" is indistinguishable from "we forgot."

Vanity metrics and decision metrics

A report full of impressions, reach, and engagement rate is usually a report avoiding a harder conversation. Those numbers are inputs. They belong in a diagnostic view, not on the front page.

The front page should carry the numbers you would actually change a decision over: cost per acquisition, return on ad spend, contribution margin where you can get it, and spend pacing against the month. If a metric on page one would not change what you do next, it is decoration.

Five questions to ask your current agency

  1. "Can I open the ad account myself?" Any hesitation here answers most of the other questions.
  2. "Does the spend figure on this report include your fee?" The answer should be immediate.
  3. "What attribution window and timezone is this report on?" If nobody knows, nobody set it deliberately.
  4. "Show me why budget moved on this specific day." A change log answers in seconds.
  5. "Is this dashboard the same one your team optimizes against?" Two dashboards means one is for you.

Why we are strict about this

Automated systems make a lot of small decisions quickly. That is the entire benefit, and it only works if you can inspect what they did. Reporting that reconciles to the cent is not a courtesy, it is the thing that makes handing decisions to software defensible in the first place.

If you want to see how your current reporting holds up, the free audit includes a reconciliation pass: we pull your platform data directly and compare it to what you have been shown.

Get a free growth audit

We will analyze your ad accounts, identify waste, and show you exactly where to improve — within 48 hours.

Get my free audit