Marketing Agency Reporting: The Report That Hides the Number the CFO Wants.
The monthly report from the agency is forty pages and well designed. Impressions by channel, clicks, click-through rates, engagement, followers, sessions, leads, cost per lead, with month-on-month arrows. It takes an hour to present and everyone leaves agreeing that marketing is working. Then the CFO asks, in the budget meeting, what the company got for the money, and nobody in the room can answer from the report.
That is not the agency hiding anything. The report is built from the numbers the agency has, and the number the CFO wants is not among them.
An agency reports from the channels' own dashboards: the ad platforms, the analytics property, the email tool, the social accounts. Those systems count what happened inside them, which is impressions, clicks, opens, sessions and form submissions, and they count it well. They are also the systems the agency controls, which is why the report is built from them. The agency can show that it did the work and that the work produced activity, and it can show it without asking the client for anything.
Leads is where the report ends, because leads is the last thing the channels can see. A form submission is a lead. Whether sales called it, whether it was a real company, whether it became an opportunity and whether that opportunity closed are facts that live in the CRM and the books, and the agency has access to neither.
So the report measures marketing up to the point where it hands over, and stops. The CFO's question starts at exactly that point.
It is one number per source: qualified pipeline created per dollar spent, over a window long enough for the pipeline to form. Not leads, because leads are free to generate and sales ignores most of them. Not revenue, yet, because at this size the sales cycle is longer than the reporting month. Qualified pipeline, meaning opportunities that sales accepted and valued, attributed to the source that produced the first contact, against the spend on that source in the same window.
That number requires three systems joined: the ad and channel spend by source, the CRM's leads and opportunities with their source and their qualification state, and the books for the fully loaded cost including the agency's fee. The agency has the first. The company has the other two. The join is the company's to make, and almost no company makes it, because the agency's report arrives looking complete.
We argued the general point in an AI digital marketing agency versus a marketing system: an agency optimises what it can see, and what it can see stops at the form.
A budget renewed on activity. The channel with the most leads is funded again; the channel with the most qualified pipeline, which is often a different one, is not, because the report does not distinguish them.
Leads nobody calls. When the report counts leads and sales counts opportunities, the gap between them is nobody's number, and it is where the marketing budget actually goes to die. Sales says the leads are poor; marketing says sales does not follow up; the CFO sees the invoice.
And a marketing cost with no denominator at the board. Spend is on the ledger as a line. Pipeline is in the CRM as a report. The two have never been in one table, so marketing is discussed as a cost and sales as a result, and the question of whether one produced the other is answered with the forty pages.
The reflex is to ask the agency for the number, and the agency will try, which produces a second report with the CRM's lead count pasted in beside the channel's. That is not the join. The join needs the opportunity, its qualification state and its value, carried from the lead with the source intact, and it needs the spend from the books rather than from the ad platform, so that the agency's own fee is in the denominator. An agency reporting on its own fee against the pipeline it produced is being asked to grade itself, and the honest agencies will say so.
So the table has to be the company's, built from the company's systems, and the agency's report becomes an input to it. That division is healthier for both sides: the agency is judged on the column it controls and the company on the join it owns.
The report the CFO would sign is one table, by source, with five columns. Spend, fully loaded, including fees and the people. Leads, from the channel. Qualified opportunities, from the CRM, attributed to the source of first contact. Pipeline value of those opportunities. Pipeline per dollar, which is the last column divided by the first.
Everything else in the forty pages is diagnostic detail behind that table, useful to the people running the channels and irrelevant to the person funding them. We published our own version of the first column, the all-in cost of running marketing as a system, in what it costs to run a marketing function as a system, because a fully loaded spend figure is the half of the table most companies have never computed either.
The table has two honest limits. Attribution to first contact is a convention, not a truth, and it should be stated as one. And the window has to be long enough: a source judged on this month's spend against this month's pipeline will look bad in the month it starts and good in the month it is cut.
Not the agency, because the agency does not have the CRM, and should not. The company produces it, which means the company has to own the join: the source carried from the first click through the form into the CRM lead, kept on the opportunity when sales qualifies it, and matched to the spend by source in the books. That is plumbing, and it is the same plumbing we described as the decisions in a marketing week in the five decisions AI can make in your marketing: every one of them depends on the source surviving the handoff to sales.
Once the join exists, the table is a report that runs itself, and the agency's forty pages become the appendix.
Take last quarter. For each source, pull the spend from the invoices and the qualified opportunities from the CRM, by hand if necessary, and build the table once. It will be wrong in the attribution and right in the shape, and it will change the budget conversation immediately, because for the first time spend and pipeline are in the same place.
Then make the join permanent: the source on the lead, the source on the opportunity, the spend by source in the books. That is what we build and run as a managed subscription for companies that want marketing reported from the CFO's side of the table, with the table as the thing we are measured on. Discovery is no-risk: we build the table for your last quarter with you, and you pay only if you go ahead.
Watch the 6-minute guided demo, then book a walkthrough: we read your CRM, ad accounts and content and show what a governed system would do differently. You pay only if you proceed. Or see how we approach it.
More on the same problem:
What an AI Digital Marketing Agency Sells You, and What a System Does Instead. (article)
What It Costs to Run a Marketing Function as a System: Our All-In Numbers. (article)
Zoho Marketing Automation Is a Tool, Not a Marketing System (video)
Watch the 6-minute guided demo, then book a walkthrough: we read your CRM, ad accounts and content and show what a governed system would do differently. You pay only if you proceed. Or see how we approach it.
More on the same problem:
"Something isn't working." "We're outgrowing our tools." "We're afraid to make the wrong move." No-Risk Discovery is a short, practical conversation that gets you clarity before you commit to anything big. We'll tell you if we're a fit. If we're not, we'll tell you that too.
Say who you are and ask. A person replies within one business day.