Formlyy Journal
Acquisition-to-revenue dashboard: method to manage your revenue in 2026
May 17, 2026 · 9 min read · By Arthur Goudard
A marketing dashboard can be very pretty and yet not very useful.
It can display budget spent, clicks, CPL, conversion rate, leads generated, impressions, rising curves, falling curves. Everyone can nod their heads during the meeting.
Then a question arises: “How much revenue did these campaigns really create?”
And there, silence becomes an indicator.
An acquisition-to-revenue dashboard connects acquisition to sales pipeline and revenue, step by step. It does not replace media dashboards. It makes them more useful.
Definition of an acquisition-to-revenue dashboard
An acquisition-to-revenue dashboard is a dashboard that tracks performance from marketing spend to earned or predictable revenue.
It generally connects:
- advertising expenses;
- sources and campaigns;
- the leads generated;
- exploitable leads;
- qualified leads;
- appointments booked;
- appointments held;
- the opportunities created;
- the pipeline;
- revenue gained or lost.
The logic is close to the Ads-to-sales pipeline, but the dashboard adds a management view: it allows you to read the losses, costs and value by stage.
Why classic reporting is no longer enough
Traditional reporting often answers one entry question: “How much traffic or leads did we buy?”
The acquisition-to-revenue dashboard answers a question closer to the manager: "What part of this acquisition becomes profitable sales progress?"
This difference changes the quality of decisions.
A campaign at 25 euros per lead may seem better than a campaign at 80 euros per lead. But if the first produces few appointments kept and the second opens up solid opportunities, the CPL tells an incomplete story.
Google Ads explains that qualified or converted lead conversions measure the steps that arrive after the initial lead. This is exactly the spirit of the acquisition-to-revenue dashboard: no longer stop at the first easy-to-count event.
Metrics to display
A good dashboard should not display everything. It must display what helps to decide.
| Step | Useful KPIs | Business questions |
|---|---|---|
| Acquisition | cost, clicks, CPC, source | where does the demand come from? |
| Conversion | leads, conversion rate | how many intentions captured? |
| Qualification | qualified lead rate, cost per qualified lead | what part is exploitable? |
| Appointment | appointment booking rate, cost per appointment, show-up | how many real exchanges? |
| Pipeline | opportunities, pipeline value, cost per opportunity | how much sales potential? |
| revenue | Earned Revenue, CAC, Real ROAS | how much value created? |
The strength of the dashboard comes from the transitions.
If the lead volume is good but the qualification rate is low, the problem may be with the promise or targeting.
If the qualification is good but the show-up is bad, you have to look at the deadline, the confirmation, the follow-up channel or the preparation of the meeting.
If the appointments are good but the pipeline is weak, the definition of qualification probably needs tightening.
Method to build it
1. Choose the funnel stages
Start by writing the actual route, not the dream route.
For a meeting activity, a simple structure may be sufficient:
1. expense;
2. lead;
3. actionable lead;
4. qualified lead;
5. appointment booked;
6. appointment kept;
7. opportunity;
8. client.
Each step must have a clear definition. Otherwise, the dashboard will become a permanent debate.
2. Link sources to CRM
The weak point is often between the form and the CRM.
You must keep:
- the source;
- the countryside;
- the keyword or ad when possible;
- the entry page;
- qualifying responses;
- timestamp;
- the lead identifier;
- commercial status.
The article on full lead tracking returns to this data chain. Without it, the dashboard risks comparing leads without knowing what happens to them.
Meta also documents sending server and CRM events via the Conversions API. HubSpot talks about closed-loop reporting to link marketing actions to sales results. The tools change, but the principle remains the same: the data must come back to management.
3. Calculate costs by step
The dashboard becomes interesting when it shows the cost of progress.
Not only:
- cost per click;
- cost per lead.
But also:
- cost per qualified lead;
- cost per appointment held;
- cost per opportunity;
- cost per client.
Cost per opportunity is often a great bridge between marketing and revenue, because it connects the spend to a truly actionable business step.
Also add the cost per SQL and the cost per qualified appointment if your funnel depends on sales calls. Without these two readings, the dashboard risks jumping too quickly from lead to revenue, as if everything that happened in between was an administrative formality. This is rarely the case.
4. Segment by source
Don't mix everything.
A global dashboard is useful for management, but decisions are often made by segment:
- Google Ads;
- Meta Ads;
- SEO;
- referral;
- WhatsApp;
- campaign ;
- offer ;
- area ;
- hearing;
- commercial.
A source may generate less volume but better appointments. Another may generate a lot of input and a lot of noise. The dashboard must make this difference visible.
5. Add a decision view
The last layer is not a metric. It's a reading.
Add a simple zone:
- what works;
- what blocks;
- what we test;
- what we stop;
- what we increase.
A dashboard that doesn't trigger any decisions is just decoration with numbers.
Concrete example
Let's imagine two campaigns.
| Campaign | CPL | Meetings held | Opportunities | Cost per opportunity |
|---|---|---|---|---|
| Meta Ads - free audit | €28 | 14 | 3 | €933 |
| Google Search - strong intent | €76 | 18 | 9 | €506 |
Media reporting might prefer the first campaign.
The acquisition-to-revenue dashboard tells something else: the Google campaign costs more upfront, but it creates more opportunities for each euro invested.
This is not an opinion. This is a better reading of the funnel.
Common errors
Wanting to measure everything from the start
Start with few but clean steps. A simple and reliable dashboard beats a complete dashboard full of holes.
Use fuzzy definitions
“Qualified lead” must mean the same thing for marketing, sales and the manager. Otherwise, the KPI becomes political.
Forget the deadline
The time between lead received, first contact and appointment often changes conversion. A useful dashboard must keep this dimension.
Do not distinguish between earned revenue and pipeline
The pipeline gives a projection. The revenue earned gives the result. Both are useful, but they don't tell the same thing.
FAQ
Frequently asked questions
Which tool should I use to create this dashboard?
Looker Studio, HubSpot, Salesforce, a well-configured CRM or BI tool may be suitable. The main subject is not the tool, but the quality of the link between acquisition, CRM and revenue.
Should you track revenue from day one?
Yes if it's possible, but at least start with the opportunities. revenue can take time to arrive, while the intermediate stages already allow you to manage.
Which metric to prioritize?
For an appointment-based activity, first look at the cost per qualified appointment held, then the cost per opportunity. These two metrics prevent a lot of bad decisions based on CPL 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.
Sources
Keep reading
Read next