Formlyy Journal

Agency client reporting: how to prove revenue impact in 2026

May 22, 2026 · 10 min read · By Arthur Goudard

Agency client reporting dashboard connecting ad campaigns, leads, appointments and revenue

Agency client reporting has long resembled a photo album of Ads platforms.

Prints.

Clicks.

CPC.

CPL.

Clean graphics, reassuring colors, variation from the previous month.

But when the client asks “does this really bring us anything?”, many reports become fragile.

In 2026, good agency client reporting must do something else: connect campaigns to appointments, opportunities and business decisions.

Not to decorate the dashboard. To maintain confidence.

The problem of classic media reporting

Classic media reporting above all answers a question: “what happened on the platforms?”

It's useful, but incomplete.

The client does not pay an agency to contemplate curves. He wants to understand:

  • what really generates useful leads;
  • what blocks between the click and the appointment;
  • what deserves more budget;
  • what needs to be cut;
  • what the agency learns from sales quality.

A low CPL can hide unusable leads. A correct CPA can hide unqualified appointments. Good volume can mask a worrying no-show rate.

This is exactly the subject of Why the cost per appointment is becoming more useful than the cost per lead: media performance is not business performance.

Definition of revenue-oriented client reporting

Revenue-oriented agency client reporting is reporting that connects acquisition indicators to qualification, appointment, pipeline and closing indicators.

It does not replace Ads metrics. He puts them in their place.

Looker Studio allows you, for example, to transform data into shareable and viewable reports. But the tool does not decide on the right metrics. The central question remains: what does the client need to understand to make a better decision?

Truly useful reporting must therefore combine three layers:

1. media figures;
2. post-click numbers;
3. commercial lessons.

Metrics to keep

You should not throw away all the media metrics. They must be prioritized.

LevelMetricRole
Mediaspend, impressions, CPC, CTR, CPLunderstand acquisition efficiency
Post-clickcompletion rate, qualified lead rate, callback timeunderstand the quality of the passage
Appointmentbooking rate, show-up rate, cost per appointmentunderstand the sales impact
PipelineSQL, opportunities, estimated value, close rateunderstand the business contribution
Decisionbudget to strengthen, channel to correct, offer to clarifyact

The last line is the most important.

Reporting without decisions is a passive dashboard.

The 5-block method

Here is a simple structure for monthly agency reporting.

1. Business summary

Start with the conclusion.

Not by 18 charts.

Example:

This month, the volume of leads increased, but the rate of qualified appointments decreased on Meta Ads. Google Ads generates fewer leads, but twice as many business opportunities. The recommendation is to maintain the Google budget, reduce overly broad Meta sets, and modify the qualifying questions.

The client must understand the month in one minute.

2. Acquisition

Here you show expenses, volume, costs and variations.

But you avoid presenting the CPL as an automatic victory.

A falling CPL is only interesting if the quality follows.

3. Qualification

This block is often missing. Yet it’s the one that changes the conversation.

Add:

  • rate of exploitable leads;
  • rate of qualified leads;
  • grounds for disqualification;
  • source of the best leads;
  • questions that filter best.

This block directly links reporting to lead quality.

4. Appointments and pipeline

This is where the agency begins to speak the language of the leader.

Follow:

  • appointment booked;
  • qualified appointments;
  • no-shows;
  • opportunities created;
  • pipeline value;
  • sales if available.

If everything is not yet tracked, indicate this clearly. A lack of visible tracking is better than an invented certainty.

5. Next month’s decisions

Finish with the arbitrations.

Examples:

  • increase the budget on a campaign that generates SQL;
  • modify a form question;
  • exclude an audience that generates a lot of weak leads;
  • add specific routing for hot leads;
  • test a WhatsApp reminder on unreached leads.

Good reporting must make action obvious.

Concrete example

Let's imagine an agency that manages two channels for a client.

ChannelLeadsCPLQualified appointmentsCost per qualified appointment
Meta Ads18018 EUR9360 EUR
Google Ads6242 EUR11€237

If the agency stops at CPL, Meta Ads seems better.

If it looks at the qualified appointment, Google Ads becomes stronger.

The conclusion is not necessarily “cut Meta”. The conclusion can be: Meta needs better qualification, a more direct message or optimization on qualified leads rather than volume.

This is the nuance that is missing in many reports.

How to recover dirty data

Revenue-oriented reporting requires a minimum connection with the CRM.

Google Analytics already encourages looking at lead generation beyond the simple visit. Cote Ads, Meta Conversions API aims precisely to connect marketing, server, CRM or offline data to optimization and measurement systems.

In practice you can start simple:

  • a reliable source field in the CRM;
  • a qualified/unqualified lead status;
  • an appointment status made;
  • a show-up status;
  • an opportunity or sale status.

No need for a perfect data warehouse to do better than reporting limited to CPL.

Common errors

Showing too many numbers

The more metrics a report contains, the less it says something.

Keep the numbers that explain a decision.

Hide bad news

A channel may have produced weak leads. A form may have too few filters. A client may call back too late.

The reporting must show it without drama, with a clear follow-up.

Never include sales feedback

If salespeople say that the leads are bad, the reporting must translate it into facts: source, campaign, response, deadline, reason for disqualification.

Otherwise, the discussion turns to feelings.

Confusing automation and intelligence

Automating bad reporting doesn't make it better.

The value comes from interpretation, not just automatic updating.

The format I recommend

For an ad agency, I would keep a short format:

  • a summary page;
  • an acquisition page;
  • a qualification page;
  • an appointment/pipeline page;
  • a decisions page.

The client does not need a monthly encyclopedia. He needs to understand where their money is going, what is coming back in opportunities, and what the agency does next.

FAQ

Frequently asked questions

Should we abandon CPL in client reporting?

No. The CPL remains useful for monitoring acquisition efficiency. It only becomes dangerous when it is presented as a final indicator of performance.

What to do if the client does not share their CRM?

Start with a simple file with source, lead status, appointment and result. The goal is to obtain a minimal feedback loop, not a perfect architecture in the first month.

What is the best KPI to retain an agency client?

There is no single KPI. But metrics close to revenue, like cost per qualified appointment, cost per SQL and pipeline value, are often more compelling than lead volume alone.

About the author

Arthur Goudard

My name is Arthur Goudard. I share what I see in the field when a marketing strategy needs to turn warm interest into a useful conversation, then into a clear appointment.

View Arthur Goudard on LinkedIn

Sources

Keep reading

Read next

Continue reading

Back to blog