The Monthly Marketing Dashboard a CEO Should Actually Read

Most monthly marketing reports are written for the people who run the campaigns. They list impressions, reach, click-through rates, followers gained and cost per click, often across a dozen slides. A CEO reads the first page, asks “so did it work?”, and rarely gets a straight answer.

A management dashboard has a different job. It should tell the person who signs the budget three things in under five minutes: what marketing cost, what it produced in pipeline and revenue, and what will change next month. This guide sets out what belongs on that page, what to leave off it, and how to combine ad-platform, Google Analytics and CRM data honestly when they disagree, which they usually do.

Start from the decision, not the data

Before choosing a single metric, write down the decisions the dashboard is meant to support. For most owners and CEOs there are only four:

1. Should the marketing budget go up, down or stay the same?
2. Which channels or campaigns should get more of it, and which should be paused?
3. Is the problem in marketing (not enough of the right buyers) or in sales (the right buyers are not closing)?
4. Is the brand getting stronger, or are we buying every lead from scratch?

Every number on the dashboard should help answer one of these. If a metric does not change any of the four decisions, it belongs in the team’s working report, not on the CEO’s page.

The core numbers: from spend to revenue

The centre of the dashboard is a single funnel that runs from money spent to money received. The definitions matter more than the design, so agree them once and keep them fixed.

Two points make this table work. First, use total spend, not just media spend, otherwise the cost per lead flatters the channels with the highest production cost. Second, “qualified” must be written down in one or two sentences that sales and marketing both sign off, for example “a company in our target sectors, with a defined project and a decision-maker in the conversation”. Without a written definition, the number becomes an argument.

Make the CRM the source of truth

The funnel above depends on one thing: every lead, wherever it came from, recorded in a CRM (or at minimum one shared, structured sheet) with its source and its outcome. Ad platforms are excellent at reporting what happened on their platform. They cannot see the WhatsApp conversation, the site visit or the signed purchase order.

Google’s own lead-generation events follow the same stages a CEO needs. Its recommended events include generate_lead (a form submitted online or information submitted offline), qualify_lead, working_lead (the lead contacts or is contacted by a representative), close_convert_lead (the lead became a customer) and their negative counterparts. Mirroring those stages in your CRM makes it far easier to connect the two systems later; our CRM requirements checklist covers which fields to insist on.

In Google Analytics, the actions that matter most are marked as key events, defined by Google as events that measure “an action that’s particularly important to the success of your business”. A Google Ads conversion can be created from a key event. Keep the list short: if everything is a key event, nothing is. Our guide to GA4 key events for lead tracking sets out which ones a B2B site needs.

To close the loop back to advertising, Google Ads supports sending offline outcomes back to the account through offline conversion imports and enhanced conversions for leads, using the Google Click ID (GCLID) stored with each lead. Google’s help page also notes that since 15 June 2026, uploads for offline conversions and enhanced conversions for leads have been migrated to the Data Manager API and blocked in the Google Ads API, so build any new integration on the Data Manager API. On Meta, the Conversions API connects data from a server, website platform or CRM, including offline events.

When the sources disagree

They will. A common first meeting goes like this: Meta reports 140 conversions, Google Ads reports 90, Google Analytics shows 110 and the CRM has 120 leads, of which 35 are qualified. (These figures are a hypothetical illustration.) None of the systems is broken. They are counting different things under different rules.

Google’s article on understanding conversion tracking data lists the main reasons Google Ads and Google Analytics differ: different attribution models, different lookback windows, Google Ads reporting conversions against the date of the click rather than the date of the conversion, and processing delays of up to 24 to 48 hours. Google Analytics also may reattribute conversions for up to seven days under data-driven attribution, so last week’s numbers can still move. Add a second ad platform, which also credits itself, and the totals will exceed reality. Our guide to measuring marketing effectiveness covers attribution beyond the dashboard.

A workable set of rules for the management dashboard:

• Count leads and revenue from the CRM only. Never add platform conversion totals together.
• Use platform data for direction, not totals. Ad-platform reports are useful for comparing campaigns within that platform, and that is how the team should use them.
• Tag every link consistently. Google advises always using utm_source, utm_medium and utm_campaign, and warns that values are case sensitive (Google Analytics Help). Publish a naming sheet and enforce it.
• Close the month a few days late. Pull final figures after processing delays and reattribution have settled, and state the cut-off date on the dashboard.
• Show the gap, do not hide it. One line stating “platforms reported X, CRM recorded Y” builds more trust than a single number that nobody can reconcile.

Leading indicators: brand and content in three lines

A dashboard built only on leads and revenue tells you about the past and pushes every decision toward short-term spend. Add a small set of indicators that show whether demand is building on its own:

• Branded search and direct traffic trend: are more people looking for you by name?
• Share of leads from organic, referral and direct sources: how much of the pipeline is not bought media?
• One content signal that matches your goal: for example, inquiries that mention a specific article or video, or engagement on LinkedIn from decision-makers in your target sectors.

Keep these to three lines and show them as trends over six to twelve months, not as monthly highs and lows.

The one-page layout and the monthly review

The final dashboard fits on one screen or a single page, in four blocks:

1. Headline (top line): total spend, qualified leads, new customers, revenue from marketing-sourced deals, each with last month and the same month last year for comparison. Seasonality matters in the region, so a month with Ramadan, the summer slowdown or a major exhibition should be compared with the same period, not the previous month.
2. Funnel: the conversion rates from qualified lead to quotation to deal, with the cost per qualified lead and cost per customer.
3. Channels: spend, qualified leads and won revenue by source, ranked by revenue rather than by lead volume.
4. Next month: three decisions taken, three tests planned, and any risk the CEO should know about.

Run a 30-minute monthly review with marketing and sales in the same room, using only this page. Spend the first ten minutes on the funnel, because a falling lead-to-quotation rate is a sales conversation (see when leads are not converting into sales), while a falling qualified-lead rate is a targeting conversation. Close the meeting on the “next month” block.

What to leave off

Impressions, reach, follower counts, click-through rates and cost per click all have their place, inside the team’s working reports. On the management page they invite the wrong question (“why are impressions down?”) and push out the right one (“why are quotations not closing?”).

Building it without a large data project

You do not need a data warehouse to start. A sound first version needs three things: a CRM or structured sheet with a source and stage on every lead, consistent link tagging, and one person responsible for pulling the month together on a fixed date. Visual tools such as Looker Studio can be added once the definitions are stable; automation built on unstable definitions only produces wrong numbers faster.

A practical first step: take last month’s new customers, look each one up in the CRM and write down its original source. If more than a few have no source recorded, fix lead capture before designing the page; if they all do, you already have the “revenue by source” line. KPI dashboards and reporting form part of RX Designer’s marketing strategy and research service, with tracking set up through performance marketing.