Articles

Marketing Agency Reporting: The Report That Hides the Number the CFO Wants.

6 min read

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.

What the report is built from.

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.

The number the CFO wants.

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.

What the missing number costs.

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.

Why the agency cannot be asked to fix it.

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 one table.

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.

Who can produce it.

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.

Where to start.

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.

See the AI Marketing OS run a marketing function before you commit to it.

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.

Watch the demo, then book a walkthrough

More on the same problem:

See the AI Marketing OS run a marketing function before you commit to it.

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.

Watch the demo, then book a walkthrough

More on the same problem:

Where we're not the right answer

We'll tell you if we're a fit. If we're not, we'll tell you that too.

  • Your current stack works and nobody wants to change it
  • You want licences resold at a discount and nothing else
  • Your internal team owns the operating model and is not handing it over
  • You want hours of configuration work and nothing run for you: that is on our services pages, and it is not a managed solution
How we start

Most of our best clients come to us with a feeling, not a plan.

"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.

Talk to us

Have a question about this?

Say who you are and ask. A person replies within one business day.

The rest of the form follows your answer.

A new client, or thinking about becoming one

Never shared. Never sold.

A solution, a service, or not sure yet.

Platforms you run today

Pick every one that applies. Choosing one is an answer too.