Marketing dashboard: which numbers to track to decide your budget

Short answer: a marketing dashboard that helps you decide shows, by channel, how much was spent, how many leads came in, how many became sales, how much each sale cost and how much came back in revenue. Everything else, such as reach, likes and click-through rate, is second level: it helps the media buyer adjust campaigns, not the owner decide the budget.

In this article

  • What a dashboard is for and who it is for
  • The five first-line metrics
  • Second-level metrics and when to look at them
  • Where the data comes from and how to bring it together
  • How to organize the dashboard into screens
  • Reading frequency and common mistakes
  • Frequently asked questions

What a dashboard is for

A dashboard is not a report to file away. It is a screen for making decisions: increase or reduce budget, switch a channel, fix a customer service problem. If you look at the dashboard and do not know what to do next, it is showing the wrong things.

Remember also that different people need different views. The owner wants to know whether the investment is paying off. The media buyer needs to know which creative wore out. Sales wants to see how many leads are stuck. A good dashboard has a simple first screen for decision makers and detail screens for operators.

The five first-line metrics

MetricWhat it answersSource
Spend by channelHow much was spent on each platformMeta Ads, Google Ads and others
Leads by channelHow many contacts each channel broughtCRM, with the source tagged
Lead-to-sale conversion rateHow many leads became customersCRM
Cost per saleHow much each new customer costSpend divided by sales
Revenue and returnHow much came back for every dollar spentCRM or sales platform

With these five lines, split by channel and compared with the previous month, you can answer almost every budget question. Notice that three of the five depend on the CRM. That is why a dashboard built only on ad platform data never shows the full picture. Understand the difference in the article on cost per lead vs cost per sale.

Second-level metrics

These metrics explain why the first-line numbers went up or down. They belong on a detail screen.

Media

  • Cost per thousand impressions (CPM): shows whether the auction got more expensive.
  • Click-through rate (CTR): tells you whether the ad is grabbing attention.
  • Cost per click (CPC): combines the two above.
  • Frequency: how many times the same person saw the ad; when it climbs too high, the creative wears out.

Website and page

  • Page conversion rate: visitors who submitted the form or clicked WhatsApp.
  • Mobile load speed: a slow page loses people before it loads.

Sales

  • First response time: how long the lead waits to be answered.
  • Booking and show-up rates: for sales that involve a meeting or a visit.
  • Loss reasons: price, timing, no response, wrong profile.

A reading example

Imagine Google's cost per sale went from US$ 180 to US$ 260 in the month. The dashboard shows that cost per lead stayed stable, but the lead-to-sale rate dropped. Going to the sales screen, you see that first response time doubled because a salesperson was on vacation. The problem is not the campaign, it is customer service. Without a dashboard that brings media and CRM together, the natural reaction would be to change the campaign, which was working.

Where the data comes from

  1. Ad platforms: spend, impressions, clicks and recorded conversions.
  2. Google Analytics 4: on-site behavior, session sources and conversion events.
  3. CRM: leads with source, stages, sales, values and loss reasons.
  4. Sales or finance system: when actual revenue lives outside the CRM.

What ties these sources together is the lead source. If UTMs are standardized and the CRM saves each contact's campaign, you can put spend and sales on the same line. If not, the dashboard becomes a collection of numbers that do not talk to each other. The technical base for this is tracking, which we explain in the article on server-side GTM and GA4.

Tools

For visualization, Google's Looker Studio is free and connects natively to GA4 and Google Ads. For Meta and the CRM, you usually need a connector or an intermediate spreadsheet updated automatically. What matters is not the tool, it is the standardization rules for the data going into it.

How to organize the dashboard

ScreenFor whomContent
1. OverviewOwner and leadershipThe five metrics by channel, current month vs previous, monthly goal
2. MediaMedia buyerCampaigns, creatives, CPM, CTR, frequency
3. Sales pipelineSales managerLeads by stage, response time, loss reasons
4. WebsiteWhoever manages the pagesConversion by page, traffic sources, devices

How often to look

  • Daily: spend and delivery, to catch technical problems early. It takes two minutes.
  • Weekly: leads, quality and response time.
  • Monthly: cost per sale, return by channel and budget decisions.

Budget decisions made with two or three days of data are usually bad. Campaigns fluctuate and the sales cycle takes time.

Common mistakes

  • A dashboard with 40 charts. Decision makers get lost and stop looking.
  • Adding up platform conversions. Meta and Google may count the same sale, because each attributes the result to itself. The truth about sales lives in the CRM.
  • No comparison. A number on its own does not say whether it is good. Compare it with the previous period and with the goal.
  • Messy UTMs. "Facebook", "facebook" and "fb" become three different channels.
  • Manual updates. If someone has to build the report every week, one day it will be late.

How to build yours in five steps

  1. Write the questions before the charts. "Which channel brings the cheapest sales?", "is customer service answering fast?", "are we on pace for this month's goal?". Every chart should answer a question from this list.
  2. Standardize sources. Define a UTM standard for all campaigns and for the links on your Google profile, Instagram and emails. Document it and allow no exceptions.
  3. Make sure the CRM saves source and value. Without that, half of the first line stays empty.
  4. Connect the sources. GA4 and Google Ads connect directly to Looker Studio. Meta Ads and the CRM come in through a connector or an automatically updated spreadsheet.
  5. Validate with known numbers. Before trusting the dashboard, compare total leads and sales for a closed month with what the sales team knows happened. Big differences point to a tracking or data entry problem.

The monthly numbers meeting

A dashboard gains value when it becomes a routine. A monthly 30 to 45 minute meeting, with whoever handles marketing and sales, is enough for most small and mid-sized businesses. The agenda can always be the same: the month's result against the goal, what changed in each channel and why, what will be tested next month and how the budget will be redistributed. Leave the meeting with at most three decisions, each with an owner. A dashboard nobody discusses becomes wallpaper.

How EMB-S delivers the dashboard

In EMB-S projects, the dashboard is the last piece of a pipeline that starts with the ad. First we make sure tracking works and the source is saved in the CRM; then we build the dashboard with an overview for the owner and detail screens for operators. The data updates on its own and the reading happens in a monthly meeting with clear decisions. That way, the question "is marketing working?" stops depending on opinion and gets a number per channel, compared with the goal and with your business's margin.

Frequently asked questions

Is the ads manager report not enough?

It shows what the platform sees, which is usually the lead or the click. Sales that happen on WhatsApp, by phone or in store are left out. To decide budget, you need the CRM in the same dashboard.

Do I need a data analyst?

Not to get started. With correct tracking and an organized CRM, a simple dashboard does the job. An analyst starts to make sense when the number of channels and products grows a lot.

What is the most important metric?

For most lead generation businesses, cost per sale compared with margin. For online stores, return on ad spend, taking product margins into account.

Summary

  • First line: spend, leads, conversion to sale, cost per sale and return, by channel.
  • CPM, CTR and frequency explain the numbers, but do not decide the budget.
  • Three of the five main metrics come from the CRM.
  • Standardize UTMs so the data from each source can be connected.
  • Check spend daily, quality weekly and sales monthly.