Marketing reporting when you use several agencies, brands and ad accounts

A good marketing report tells the business three things: what it spent, what that spend returned in real sales and gross profit, and what changes next month. When you use several agencies, brands or ad accounts, the hard part is not the template. It is getting every agency's numbers onto one set of definitions, checked against your own sales records, and then automating the pack so nobody rebuilds it by hand.

This guide covers digital marketing reporting for exactly that position: what to include, a monthly and a board-level structure, one set of numbers from several agencies, and the options for automating it.

Why marketing reporting breaks when you use several agencies

Each agency reports the channel it runs, from the platform it runs it in. The search agency sends a Google Ads report, the social agency sends a Meta report, the SEO agency sends rankings and traffic. Each is accurate on its own terms. Put side by side, they rarely add up to the sales your business actually recorded.

That is rarely dishonesty. The platforms count differently:

• Different dates. Google Ads reports a conversion against the date of the ad, while most sales systems record the date of the sale. Google's own help page on data discrepancies lists this as a common cause of mismatches.
• Different windows. Meta credits conversions that happen within its attribution setting, which by default is 7 days after a click or 1 day after a view (Meta Business Help).
• The same sale, claimed twice. A customer who clicks a Meta ad on Monday and a Google ad on Thursday can be counted by both platforms.
• Different meanings of "conversion". One account counts purchases, another counts form fills, a third counts add to basket.

Marketers know this. In Affinity Solutions' 2026 survey of more than 200 senior marketers, mainly in the US, 91% said they believe platform results are overstated (Affinity Solutions, 2026). The sales data needed to check those results is often out of reach too: only 51% of the 250 UK marketers in Salesforce's 2026 State of Marketing survey have complete access to sales data (Salesforce, 2026).

An example, with made-up figures:

The two reports claim 450 more sales than the business recorded from every source combined. The real cost per sale is at least £26.09, and higher once organic and repeat orders are taken out. If each order earns £32 of gross profit, the agency view says every sale makes money comfortably. The real view says the profit left after ad costs is thin, and some campaigns are probably below zero. Without a report that starts from the order system, nobody can tell which.

Why the platforms disagree, and how to reconcile them, is covered in our guide to cross-channel attribution.

What a marketing report should contain

A useful marketing report answers six questions, in this order. If a section does not help answer one of them, it belongs in an appendix.

Two rules make the table work. First, results and return come from your systems, so every agency is measured on the same sales. Second, efficiency is judged on gross profit, not clicks or platform ROAS. A channel with a high return on ad spend can still lose money if it sells low-margin products; our guide to what a good ROAS is shows the arithmetic.

The monthly marketing report: a structure you can copy

The monthly marketing report is the working document for the people who run the marketing: ten minutes to read, with enough detail to act on. A structure for a business with several brands, sites or accounts:

1. One-paragraph summary. Spend, sales, gross profit and cost per sale against last month and plan, in plain words.
2. Group view. One table of every brand or location: spend, sales, revenue, gross profit, cost per sale and gross profit per £1.
3. Channel view. The same columns by channel, with each agency's channels side by side.
4. Sales check. What each platform claimed against what your systems recorded, with the gap stated and explained.
5. What changed. Tests run, budgets moved, campaigns launched or paused, and what each did to the numbers.
6. Tracking health. Any tag, form or feed that broke, with the dates affected, so nobody mistakes a tracking fault for a change in performance.
7. Next month. Planned moves, each with an owner and the gain expected.

What PPC reporting should add, and what to leave out

PPC reporting tends to fill pages with click-through rate, impression share and quality score. Those matter to whoever manages the account, but they are inputs, not results. In the monthly report, keep paid search to spend, sales matched in your own system, cost per sale and gross profit per £1 by campaign group, plus the search terms that cost money without selling. Put the diagnostics in an appendix for anyone who wants them.

The board-level marketing report: one page

The board, or the finance director, needs a different document. Their question is whether the money is working, and whether to spend more or less. As one UK finance chief told Marketing Week, "the P&L is not lying to me" (Liz Kistruck, CFO of Motorway, Marketing Week, 2024).

The gap between marketing's numbers and finance's numbers is common. Gartner found only 52% of senior marketing leaders said they succeed in proving marketing's value and getting credit for it, with CFOs among the executives they saw as most doubtful (Gartner, 2024). Marketing Week's Language of Effectiveness survey of more than 1,000 marketers found 60% do not measure whether their work delivers business outcomes (Marketing Week, 2025).

A board-level marketing report fits on one page:

• Total marketing spend, media and fees, against budget for the month and the year to date.
• Gross profit returned on that spend, and gross profit per £1, with the trend over twelve months.
• The strongest and weakest brand or location, and what is being done about each.
• Payback: how quickly each major channel returns its cost, with quick-return spend kept apart from brand building.
• Risks: tracking faults, agency changes, rising costs.
• Decisions needed from the board, each with a recommendation.

How to create a digital marketing report each month

Built by hand, the report follows the same seven steps every month. They are worth knowing even if you plan to automate, because automated reporting only repeats a process you have already defined.

1. Fix the definitions. Agree what counts as a sale or qualified lead, which system is the record of it, and the gross margin to use for each brand or product range. Write them down.
2. List every source. Each ad account, analytics property, CRM, order or booking system, finance package and agency invoice.
3. Tag the spend. Make sure every campaign name and UTM tag says which brand, location and channel it belongs to, so spend can be grouped without guesswork.
4. Pull spend and results. Spend from the platforms and invoices; sales from your own systems.
5. Match and reconcile. Tie sales back to the campaigns that bought them where you can, and state the gap between what platforms claim and what you recorded.
6. Write the commentary. What changed, why, and what it means. It is the part that gets squeezed when the data takes all week.
7. Agree next moves. Each with an owner, a date and the gain expected.

Steps 2 to 5 are where the time goes. In a 2023 survey of 713 marketers commissioned by Funnel, some respondents said they spend as much as 25 hours a month compiling reports (Funnel, State of Marketing Data 2024). That is an upper figure, not an average.

Agency reporting: one set of numbers from several agencies

Agency reporting works when every agency is held to your numbers rather than its own. In an AAR and ISBA survey of more than 100 UK marketing leaders, carried out in 2024, 41% said their agency roster is "not fit for purpose" (AAR and ISBA). Before changing the roster, fix the measurement, so each agency is judged on the same evidence:

• Own every account. Ad accounts, analytics and tag managers should sit in your business's name, with agencies given access. Then you can pull the data yourself.
• Set one naming convention. Brand, location, channel and objective in every campaign name and UTM tag, used by every agency.
• Agree one definition of a sale. Each agency reports against the sales in your CRM or order system, not its platform's conversions.
• Ask for data, not PDFs. Daily exports or access to the accounts, so the numbers can be joined.
• Review agencies side by side. One report, one meeting, everyone on cost per sale and gross profit per £1.

Automated reporting: your options, compared honestly

Automated marketing reports build themselves from live data instead of monthly exports. Digital marketing reporting tools fall into five broad routes, and each is the right answer for some businesses.

Google renamed Looker Studio back to Data Studio in April 2026; the free edition continues, and a paid Pro edition adds AI features (Google Cloud, 2026). Supermetrics-style connectors pull platform data into it, or into a spreadsheet, well. What none of these does on its own is decide that a Meta lead and a CRM sale are the same customer, or apply each brand's margin. That joining is the real work, and it is why a business with several agencies outgrows the first three routes.

It is the gap Orion's Intelligence build closes: booking or sales, CRM, ad and finance data joined into one live view in your own accounts, with weekly and monthly reporting that runs itself, alerts, and a daily self-check that reconciles the numbers against each other. If you also want the campaigns run on it, Growth adds weekly analysis, budget moves and a monthly board-ready report.

AI can now draft much of the commentary as well, but only from data that is already joined. Our guide to AI reporting tools compares what each kind can and cannot answer, and marketing dashboards for multi-brand businesses shows what the live view should put on screen.

Checklist: is your marketing report good enough?

• Every agency is measured on the same sales, from your own system.
• Spend includes agency and supplier fees, not just media.
• Results are shown by brand or location as well as by channel.
• Efficiency is judged on gross profit per £1, not clicks or platform ROAS alone.
• The gap between sales the platforms claim and sales you recorded is stated, not hidden.
• Tracking faults are logged with dates.
• Every recommended move has an owner and an expected gain.
• The board version fits on one page and ends with a decision.
• Nobody spends days each month rebuilding it.

If more than two of those are missing, start by mapping what you spend and where each number lives. Orion's diagnostic maps your systems and spend across every agency and account and reconciles spend against invoices and results, with each finding costed. You can book a diagnostic call to talk it through.