Dashboard guide
CMO dashboard: the metrics, pages and build behind a view the board trusts
A CMO dashboard is a one-screen view that shows a chief marketing officer how marketing spend turns into pipeline, customers and revenue, and whether that return is improving. This guide is for CMOs, VPs of marketing and the agencies that report to them. It covers the ten metrics worth showing, how to lay out the pages, where the data comes from, a worked example with numbers, and what it takes to build one in Data Studio.

Quick answer
What should a CMO dashboard include?
A CMO dashboard should include total marketing spend, marketing-sourced pipeline and revenue, blended customer acquisition cost, marketing efficiency ratio, CAC payback, channel mix and conversion through the funnel, compared against target and last year. It joins ad platforms, GA4 and the CRM, and leaves clicks and impressions to channel pages.
- A CMO dashboard answers one question: what did marketing spend return, and is it improving?
- Agree metric definitions with finance and sales before building a single chart.
- The CRM join, not the ad data, decides whether the numbers are believed.
- Data Studio can host the whole view free, with Sheets or BigQuery doing the joins.
What is a CMO dashboard and who is it for?
A CMO dashboard is the marketing equivalent of the finance pack a CFO takes to the board. It sits above channel reports. A paid search manager needs bids, search terms and quality scores. A CMO needs to know whether the money the business gave marketing this quarter produced the pipeline and revenue it was supposed to, and which bets to increase or cut.
That pressure has grown. Gartner's 2026 CMO Spend Survey of 401 marketing leaders found budgets at 7.8% of company revenue, paid media at a five-year high of 31.4% of the budget, and 56% of CMOs saying they lacked the budget to deliver their 2026 strategy. In the same survey, 62% said missing growth targets would lead to budget cuts. When budgets are tight and scrutinised, a CMO who can show spend against revenue in one trusted view is in a far stronger position than one who arrives with eight platform screenshots.
The audience is narrow on purpose: the CMO, the CEO and CFO, and sometimes the board. Everyone else should click through to supporting pages rather than crowd the first screen.
Which CMO dashboard metrics matter most?
Ten metrics cover almost every CMO's needs. They move from money in, through the funnel, to money out, so a weak number points to where the problem sits. Most vendor lists stop at the names. What matters more is the definition, because a CMO dashboard that finance disputes is worse than none.
Notice what is missing: impressions, clicks, followers and sessions. They are useful diagnostics, and they belong one level down. If the top screen shows them, the conversation drifts to activity instead of return.
| Metric | Definition to agree in writing | Question it answers |
|---|---|---|
| Total marketing spend | Media plus agency fees, tools and, if finance agrees, marketing headcount | Are we on budget? |
| Marketing-sourced pipeline | Opportunity value where marketing created the first qualifying touch | Is marketing filling the funnel? |
| Marketing-sourced revenue | Closed-won value from those opportunities, by close date | Did that pipeline turn into money? |
| Marketing efficiency ratio (MER) | Total revenue divided by total marketing spend | Is overall return rising or falling? |
| Blended CAC | Total acquisition spend divided by new customers | What does a customer cost us? |
| CAC payback | Months of gross margin needed to recover CAC | How long is our cash tied up? |
| LTV to CAC | Customer lifetime gross margin divided by CAC | Are we buying customers worth having? |
| Channel mix | Spend and sourced revenue share by channel | Where should the next dollar go? |
| Funnel conversion | Lead to qualified, qualified to opportunity, opportunity to won | Where are we losing people? |
| Target attainment | Each metric against plan and last year | Are we ahead or behind? |
How should a CMO dashboard be laid out?
Use one summary page and four supporting pages. The summary should be readable in under a minute: five or six scorecards with comparison to target and last year, one trend line of spend against sourced revenue, and a short channel table. Everything else lives behind it.
In Data Studio, a date range control and a single business unit or region filter at the top of every page keep views consistent. Page-level filters are better than many chart-level ones, because they stop two charts on the same page from quietly showing different periods.
| Page | What it shows | Main reader |
|---|---|---|
| Executive summary | Spend, sourced pipeline, sourced revenue, MER, CAC and payback against target | CMO, CEO, CFO |
| Channel return | Spend, customers, CAC and sourced revenue for search, social, events, partners and organic | CMO, channel leads |
| Funnel | Volume and conversion at each stage, by segment, with time between stages | CMO, sales leadership |
| Budget pacing | Spend to date against plan, by channel and month, with forecast to period end | CMO, finance |
| Brand and demand | Branded search volume from Search Console, direct traffic and share of new versus returning customers | CMO, brand team |
Where does the data for a CMO dashboard come from?
From four groups of systems, and the hard part is joining them. Data Studio connects natively to GA4, Google Ads, Search Console, YouTube, Google Sheets and BigQuery. Meta, LinkedIn, Microsoft Ads and most CRMs need a partner connector from vendors such as Supermetrics, Windsor.ai, Porter Metrics, Funnel, Power My Analytics or Catchr, or a scheduled export into Sheets or BigQuery.
For a CMO view, the CRM matters more than any ad platform. Ad platforms each claim credit for the same conversion, so adding their reported revenue together overstates return. The CRM knows which opportunities closed, for how much and when. A trustworthy CMO dashboard takes spend from the platforms, revenue from the CRM or finance system, and joins them on campaign, channel and date.
- Spend: Google Ads, Meta, LinkedIn and other ad platforms, plus a Sheet for agency fees, events and sponsorships.
- Behaviour: GA4 for sessions, conversions and landing pages, and Search Console for organic and branded queries.
- Pipeline and revenue: the CRM, with lead source, opportunity value, stage and close date.
- Targets and margins: a finance-owned Sheet with monthly plan figures and gross margin assumptions.
- Mapping: a Sheet that translates campaign names and UTM values into a fixed list of channels.
CMO dashboard example: a worked quarter with real arithmetic
The figures below are illustrative, not benchmarks. They show how the summary metrics are calculated and why channel CAC changes the conversation.
A company books $4.2M of revenue in a quarter and spends $420,000 on marketing, including media, agency fees and tools. MER is $4.2M divided by $420,000, or 10. It wins 600 new customers, so blended CAC is $700. Each customer produces about $100 of gross margin a month, so CAC payback is seven months. If the average customer stays 24 months, lifetime gross margin is $2,400 and LTV to CAC is about 3.4.
The summary looks healthy. The channel page tells a sharper story. Paid search spends $120,000 and produces 260 customers, a CAC of about $462. Paid social spends $90,000 for 120 customers, a CAC of $750. Events spend $110,000 for 50 customers, a CAC of $2,200. Shifting even part of the events budget toward search would lower blended CAC, unless event customers turn out to be larger or stay longer. That is exactly the follow-up the dashboard should make possible, by letting the CMO filter CAC and lifetime value by channel side by side.
| Channel | Spend | New customers | CAC |
|---|---|---|---|
| Paid search | $120,000 | 260 | $462 |
| Paid social | $90,000 | 120 | $750 |
| Events | $110,000 | 50 | $2,200 |
| Organic, referral and other | $100,000 (content, SEO, tools) | 170 | $588 |
| Total | $420,000 | 600 | $700 |
How do you build a CMO dashboard in Data Studio?
Build it in six steps, and spend most of the time on the first three. The charts are the quickest part. The definitions and joins decide whether the CFO accepts the numbers.
Two Data Studio limits shape the design. Blends allow at most five data sources and only equality joins, so a CMO view that combines several ad platforms, GA4, the CRM and targets usually needs the joining done in Sheets or BigQuery first. And GA4's Data API allows 14,000 tokens per project per property per hour on standard properties, so a dashboard opened by many executives on live GA4 connections can hit quota errors. Extracts or a BigQuery copy of the GA4 data avoid that.
- Agree definitions: sourced versus influenced, what counts as spend, which close date applies, in a one-page document signed off by marketing, sales and finance.
- Fix the inputs: consistent UTM rules, a channel mapping table and a required lead source field in the CRM.
- Model the data: land spend, CRM and target data in BigQuery or Sheets and build one tidy table by date, channel and segment.
- Build the pages: summary first, then channel, funnel, pacing and brand, using calculated fields and CASE statements for metrics such as MER and CAC.
- Reconcile: check spend against platform invoices and revenue against the finance system before anyone senior sees it.
- Hand over: document every calculated field, transfer ownership to company accounts and set scheduled email delivery for the monthly pack.
Data Studio, a marketing BI platform or the CRM's own reports?
Most CMOs choose between three routes. The right one depends on how many sources you have, who maintains the dashboard and how much the CFO needs to trust it.
| Option | Strength | Limitation | Best fit |
|---|---|---|---|
| CRM reporting (for example HubSpot or Salesforce reports) | Accurate on pipeline and revenue | Weak on ad spend from many platforms and on finance targets | Teams whose spend is small or mostly in one platform |
| Paid marketing data platform | Prebuilt connectors and models for many channels | Subscription cost that grows with sources and accounts | Large teams with many brands, regions and channels |
| Custom Data Studio dashboard | Free to build and share, flexible, joins spend with CRM and finance data | Needs someone to design the model and maintain connectors | Mid-size companies that want one trusted view without a new platform |
What mistakes make a CMO dashboard fail?
Most failed CMO dashboards fail for the same handful of reasons, and none of them are about chart design. Each one either makes the numbers disputable or buries the answer the CMO needed.
- Adding up platform-reported conversions, which counts the same customer two or three times.
- Showing sourced and influenced pipeline as one number, which finance will challenge.
- Leaving out agency fees and tools, so MER and CAC look better than reality.
- Putting twenty scorecards on the first page, so nothing stands out.
- Comparing months with a different number of working days or campaign launches without a note.
- Running every chart on live GA4 and ad connections, so the board meeting starts with errors and slow loads.
- No owner after launch, so the first broken connector goes unnoticed for weeks.
When should a CMO not commission a dashboard yet?
If the CRM does not record lead source reliably, a CMO dashboard will mostly show gaps. Fix the source field and UTM rules first, run them for a quarter, then build. The same applies if the company has not agreed what marketing-sourced means, or if almost all spend sits in one platform whose own reporting already answers the question.
Very early companies with one or two channels and a founder who reads the ad accounts weekly usually do not need a CMO dashboard either. A simple monthly Sheet will do until spend, channels and stakeholders multiply.
How Greenwolf Tech Labs builds CMO dashboards
We build CMO dashboards in Data Studio for marketing leaders and for the agencies that report to them. Our team starts with a free review of your ad accounts, GA4, CRM and finance targets, then runs a definitions workshop with marketing, sales and finance before designing anything. We build the joins in Sheets or BigQuery, reconcile spend and revenue against your source systems, and hand over a dashboard your company owns, with every calculated field documented.
Our multi-channel marketing dashboards already bring Google Ads, Meta, LinkedIn, GA4 and Search Console into one view, and we build CFO dashboards that put cash, revenue, spend and margin side by side. A CMO dashboard sits between the two. We have delivered 100+ projects for 200+ clients over 8+ years, and we quote a fixed price after the review. If your CRM data is not ready to support sourced revenue yet, we will tell you and suggest what to capture first.
FAQ
Frequently asked questions
What KPIs should be on a CMO dashboard?
Show total marketing spend, marketing-sourced pipeline and revenue, marketing efficiency ratio, blended CAC, CAC payback, LTV to CAC, channel mix, funnel conversion and attainment against target. Keep clicks, impressions and engagement on supporting pages. Every metric needs a written definition agreed with finance.
What is the difference between a CMO dashboard and a marketing dashboard?
A marketing dashboard usually serves the people running campaigns and shows channel detail such as clicks, costs and conversions. A CMO dashboard rolls that up into spend, pipeline, revenue and efficiency for leadership, and joins ad data with CRM and finance data. Most companies need both, linked so the CMO can drill from summary to channel.
Can I build a CMO dashboard in Google Data Studio?
Yes. Data Studio is free and connects natively to GA4, Google Ads, Search Console, Sheets and BigQuery. Meta, LinkedIn and most CRMs need a partner connector or a scheduled export. Because blends are limited to five sources, most CMO dashboards do their joins in Sheets or BigQuery first.
How often should a CMO dashboard refresh?
Daily refresh is enough for almost every CMO view, because leadership decisions run on weekly and monthly cycles. Budget pacing benefits from daily data, while revenue and CAC are best read monthly or quarterly. Faster refresh on live connections mostly adds quota errors and cost.
What is a good LTV to CAC ratio for a CMO dashboard?
There is no single right number, because it depends on margins, cash position and growth goals. What matters on the dashboard is that the ratio uses gross margin rather than revenue, is calculated the same way every period, and can be split by channel. Agree the target with your CFO rather than borrowing a rule of thumb.
Should marketing-sourced or marketing-influenced revenue go on a CMO dashboard?
Show sourced revenue as the headline and influenced revenue separately, clearly labelled. Sourced revenue is easier for finance to audit. Influenced revenue shows marketing's wider contribution but double counts with sales, so it should never be added to sourced figures.
How long does it take to build a CMO dashboard?
Timing depends mostly on data readiness, not chart count. If UTM rules, CRM lead source and targets are already clean, the build is mainly modelling and design. If definitions still need agreement or CRM data needs repair, that work comes first, which is why we scope it in a free review before quoting.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.