Skip to content
VirtualCmo
Marketing analytics dashboard

Marketing analytics dashboard that ends in a decision

A marketing analytics dashboard is a single view of the numbers that show whether marketing is producing the revenue the company needs. For executives it should answer three questions: are we on track to target, which channels pay back, and what should change this week.

Three recommendations free from your own numbers. No card.

Finance chief checking marketing spend limits at a home desk late in the evening

Why most marketing dashboards get ignored

Open the average marketing dashboard and you find forty charts. Sessions, impressions, click-through rate, follower growth, open rate, bounce rate, all of them trending in some direction, none of them connected to the revenue number the CEO promised the board. The marketing team reads it because they built it. The leadership team stops opening it after the second month.

The problem is not missing data. It is that the dashboard reports activity, not outcome, and it stops at the chart. Nobody is told what the chart means for the budget, so every review meeting ends with "let's keep an eye on it". An executive dashboard should be short, tied to a target and finished with a recommendation someone can approve.

A crop of the product with sample data. Your workspace shows your own numbers.

What an executive marketing dashboard should show

Six views cover almost every question a CEO, CFO or board asks about marketing. Everything else belongs in the channel reports your specialists use day to day.

  • Pipeline against target. Marketing-sourced pipeline this month and quarter to date, against the pipeline the revenue target requires, with a plain on track or at risk status.
  • CAC by channel. What a new customer costs in Google Ads, LinkedIn, Meta, SEO, content and the rest, against the band you planned.
  • LTV and LTV to CAC. What a customer is worth in gross margin and how that compares with what you paid for them.
  • ROAS by channel. For ecommerce and anything sold online, revenue returned per dollar of media.
  • Payback by channel and cohort. How many months of gross margin it takes to earn back the acquisition cost, split by the month customers joined.
  • Decisions. What changed last week, what the system recommends now and what needs a human call.

Metric definitions and formulas

Arguments about marketing performance usually turn out to be arguments about definitions. Agree on these once, write them into the dashboard and the debate moves on to what to do.

MetricFormulaWhat it tells you
Pipeline coverageMarketing-sourced pipeline / pipeline required by the targetWhether today's pipeline can produce the revenue you committed to
CACChannel spend plus program cost / new customers from that channelWhat one new customer costs in each channel
LTVAverage monthly revenue per customer x gross margin x expected customer lifetime in monthsWhat a customer is worth in gross profit, not in top-line revenue
LTV to CACLTV / CACWhether acquisition creates value; many SaaS operators treat 3 to 1 as a floor
ROASAttributed revenue / ad spendHow much revenue each media dollar returns, mainly for ecommerce
PaybackCAC / (monthly revenue per customer x gross margin)Months until a new customer has repaid what they cost to win
Win rateClosed-won opportunities / all closed opportunitiesHow much of the pipeline turns into revenue

See the pipeline your revenue target needs and three recommendations for your company.

Get my CMO plan

A worked example from one quarter of data

Take a B2B SaaS company with a first-year contract of 24,000 USD, which is 2,000 USD a month. Assume an 80 percent gross margin, so each customer produces 1,600 USD of gross profit a month, and value customers over a conservative 36 months. LTV is then 1,600 x 36, or 57,600 USD.

In the quarter, Google Ads spent 23,400 USD and won 5 customers, so its CAC is 4,680 USD, LTV to CAC is about 12 to 1 and payback is just under 3 months. LinkedIn Ads spent 16,200 USD and won 2 customers, a CAC of 8,100 USD, LTV to CAC of about 7 to 1 and payback of about 5 months. Meta Ads spent 7,200 USD and won no customers at all.

A traditional dashboard would show LinkedIn with the highest click-through rate and Meta with the cheapest cost per lead, and both would look fine. The executive view shows that Google pays back twice as fast as LinkedIn and that Meta prospecting has produced nothing in a quarter. Those are numbers you can act on. The rules for acting on them live in performance marketing management, and the method behind the channel numbers is broken down in the CAC, LTV and payback by channel guide.

Vanity metrics to drop from the executive view

These numbers are not useless. Your channel specialists need them to tune campaigns. They just do not belong on the page your CEO reads, because they move without telling anyone whether revenue will arrive.

  • Impressions and reach, which grow with spend whether or not anyone buys.
  • Follower counts and likes, which have no stable link to pipeline in most B2B categories.
  • Website sessions on their own, without the conversion to leads and opportunities that gives them meaning.
  • Click-through rate, which rewards clever ads more than qualified buyers.
  • Email open rate, which privacy features in mail clients have made unreliable.
  • Cost per lead without lead quality, which pushes teams towards the cheapest and weakest leads.

How VirtualCmo turns the dashboard into decisions

VirtualCmo connects read-only to GA4, Google Search Console, Google Ads, Meta Ads, LinkedIn Ads, HubSpot, Salesforce, Pipedrive, Klaviyo, Mailchimp and Shopify, or takes a CSV import if you prefer. It calculates CAC, LTV, LTV to CAC, ROAS and payback by channel and cohort, and compares each one with the band in your plan.

The dashboard does not stop at the chart. When a channel drifts out of its band, a recommendation lands in the queue with the rationale, the expected impact, the risk and the effort, plus four buttons: Approve, Auto-execute, Dismiss, Ask why. Every week the CEO report puts the whole picture on one page: on track or at risk, three decisions taken, three decisions needed. On Scale, the same numbers export into a board-ready quarterly review in PDF or PPTX.

The budget the dashboard measures against comes from the revenue target, as described in marketing budget planning, so every number on the screen has a target next to it.

Setting up an executive dashboard in five steps

  1. 1 Run the free demo on the home page with your website, revenue target, monthly budget and business model to see the required pipeline.
  2. 2 Connect your analytics, ad accounts and CRM read-only. Nothing in those accounts changes unless you allow it.
  3. 3 Confirm the definitions: gross margin, customer lifetime, attribution window and which deals count as marketing-sourced.
  4. 4 Set a CAC and payback band for each channel, or accept the bands VirtualCmo proposes from your history.
  5. 5 Read the first weekly CEO report, approve or dismiss the recommendations and let the decision log start building.

What a dashboard cannot tell you

Numbers explain where money works. They do not explain why a message lands, whether your brand feels right to buyers, or what to do in a category with no history to measure. Attribution is also imperfect: a deal touched by a podcast, three ads and a referral gets credited to one channel. VirtualCmo shows the attribution model it uses and flags channels where the data is too thin to judge, so you know when to lean on your own judgment instead.

Frequently asked questions

How is this different from the reports in our ad platforms?

Each ad platform grades its own work and counts conversions its own way. VirtualCmo pulls spend from the platforms and revenue from your CRM or store, then calculates CAC, ROAS and payback the same way for every channel.

Which data sources do we need to connect?

At minimum your ad accounts and your CRM or store. Analytics and Search Console add the organic picture. Growth includes 6 data sources and Scale has no limit on sources.

Can VirtualCmo change our campaigns from the dashboard?

Only with permission. Connections are read-only by default, Approve mode is the default, and auto-execute works only inside guardrails you set.

What if our attribution is messy?

Most is. VirtualCmo shows which model it uses, separates marketing-sourced from influenced pipeline and marks channels where too few deals exist to calculate a reliable CAC.

Can we share the dashboard with our board?

Yes. Add board members as Viewers, or on Scale export the quarterly review deck in PDF or PPTX. See pricing for what each plan includes.

See the plan your revenue target needs

Enter your website, revenue target and monthly budget. The required pipeline and three recommendations are ready in about a minute.

$
$
Business model