What should a marketing dashboard show?

Marketing dashboard illustration: leads, cost per lead and revenue scorecards, weekly leads trend and cost per lead by channel

A marketing dashboard should show the handful of numbers that tell you whether marketing is bringing in customers at a price you can afford: leads, cost per lead, revenue by channel, conversion rate, customer acquisition cost and returning customers. Everything else is detail for the channel owner. Below are the six numbers, five example layouts by business type, a comparison of the main tools and a free Looker Studio template you can copy in two minutes.

Key takeaways

  • A marketing dashboard is one page you open every Monday to decide what to fix this week, not a monthly report.
  • Six numbers run most small businesses: leads, cost per lead, revenue by channel, conversion rate, CAC and returning customers.
  • Keep the top row the same for every business; change only the second row by business type.
  • Google’s free Data Studio (formerly Looker Studio) is enough for most small businesses on Google Ads and GA4.
  • Most dashboards fail because nobody owns them. Put a 20-minute monthly review in the calendar.

What is a marketing dashboard?

A marketing dashboard is a single page that pulls your marketing data from ads, analytics, email and sales into one view that updates on its own. Its job is to answer one question quickly: is marketing working, and if not, where is it breaking?

A dashboard is not the same as a report. A report explains what happened last month; a dashboard is what you open on Monday morning to decide what to fix this week. If you are still choosing what to measure, start with our marketing KPI examples, then put the winners on the dashboard.

The 6 numbers every small business marketing dashboard needs

Most small businesses can run marketing from six numbers. Put them at the top of the page, each with last month and the same month last year beside it.

NumberFormulaWhy it is on the dashboard
LeadsCalls + forms + bookings + chats in the periodThe first sign that marketing is or is not producing demand
Cost per leadAd spend ÷ leads from adsShows which channel buys demand cheaply and which wastes budget
Revenue by channelSales value grouped by the source of the first or last touchTells you where the money comes from, not just the clicks
Conversion rateLeads ÷ website sessions × 100Falls first when a page, form or offer breaks
Customer acquisition cost (CAC)Total marketing and sales cost ÷ new customersThe real price of a customer, to compare with what a customer is worth
Returning customersRepeat customers ÷ all customers × 100Cheap growth that ad dashboards miss
The six numbers for the top row of a small business marketing dashboard, with formulas.

For one Bay Area HVAC client, the cost per lead line is what showed the change: a rebuilt water heater campaign has averaged $34 per lead against a typical $200–250 for HVAC leads in that market (HVAC case study). Without the number on one page, that win would have been buried in an ads report.

Add a seventh line only when a decision depends on it. AI search is the most common candidate in 2026: AI citations and referral sessions from AI assistants, explained in our KPI guide.

Marketing dashboard examples: 5 layouts by business type

The six numbers stay the same; what changes by business type is the second row, the detail you need to act on them. Use the layout closest to your business and delete what you will not look at.

Business typeTop row (the decision numbers)Second row (where to act)Typical data sources
Local service business (HVAC, legal, clinics)Calls and bookings, cost per lead, booked jobsLeads by service and by day of week, missed calls, Google Business Profile actionsGoogle Ads, GA4, call tracking, Google Business Profile
EcommerceRevenue, orders, return on ad spend, conversion rateRevenue by channel and by product, average order value, returning customersGA4, Shopify or WooCommerce, Google Ads, Meta Ads
B2B lead generationQualified leads, cost per qualified lead, pipeline valueLeads by source, lead-to-meeting rate, deals wonCRM (HubSpot, Pipedrive), Google Ads, LinkedIn Ads, GA4
Agency client reportThe client’s goal KPI, spend vs budget, cost per resultChannel breakdown, what changed this month, next stepsAll ad platforms, GA4, the client’s CRM
SEO and AI searchOrganic leads, non-brand clicks, AI citationsTop landing pages, queries gaining and losing, pages cited by AISearch Console, GA4, Bing Webmaster Tools, Microsoft Clarity
Marketing dashboard examples: what to put on the top and second row for each business type.
Marketing dashboard example for a local service business: monthly leads and cost per lead by channel in Looker Studio
A real lead report we built in Looker Studio for an HVAC and plumbing company, one month (May 2026): leads, cost per lead and cost per visit for Yelp, Google Ads, Google Local Ads and SEO. Company name and budgets hidden.

This is the simplest version of the local service layout: the same four numbers for every channel, so the owner can compare Yelp, Google Ads, Local Ads and SEO for the month without opening four platforms. Leads by service, missed calls and booked jobs are the next row to add.

For an agency, the client report layout is the one that keeps the relationship: the first line should be the number the client cares about, not the number the agency is proud of.

Which marketing dashboard tool should you use?

For most small businesses the answer is Google’s free Data Studio, the tool most people still know as Looker Studio: it connects to Google Ads, GA4 and Search Console at no cost and can be shared with a link. Pay for a tool only when you need what the free one lacks, such as many non-Google sources, alerts or a CRM in the same place.

ToolPrice (US list, checked 9 Nov 2026)Data sourcesBest forLearning curve
Data Studio (formerly Looker Studio)Free; Pro $9 per user per project per month (Google)Google sources built in; others through partner connectors, often paidSmall businesses on Google Ads and GA4; client reportsLow to medium
GA4 explorationsFree (the paid GA4 360 is for large companies)Website and app data onlyDigging into one question about site behaviourMedium
HubSpot Marketing HubFree and Starter ($9 per seat per month, annual); custom dashboards from Professional, $800 per month with 3 seats (HubSpot)HubSpot CRM, email, forms, adsTeams that already run sales in HubSpotLow
DataboxFree for 3 sources; Pro $159 per month, unlimited users (Databox)Ready connectors for common ad, analytics and CRM toolsAgencies and owners who want ready-made dashboards fastLow
Power BIFree to build; sharing needs Pro, $14 per user per month, annual (Microsoft)Almost anything, including Excel and databasesCompanies already on Microsoft 365 with someone who knows itHigh
Marketing dashboard tools compared: price, data sources and who each one suits.

Prices change often; the table shows the vendor’s own published price on the date above, before tax. Google’s documentation now says Looker Studio is called Data Studio, so you will see both names in menus and help pages.

How to build a marketing dashboard in an afternoon

You can build a working dashboard in three to four hours if the tracking underneath already works. Most of the time goes into steps 1 and 2, not into charts.

  1. Write down the decisions. List the three or four decisions you make each month, such as moving budget between channels or pausing a campaign. Every chart must help one of them.
  2. Check the tracking. Make sure calls, forms and bookings are recorded as conversions in GA4 and Google Ads, and that the numbers roughly match your CRM or inbox. A dashboard on broken tracking is worse than none. Our guide to what to measure in web analytics covers the setup.
  3. Copy the template. Open our free template, choose Make a copy from the three-dot menu and point it at your own data: the sample sheet with your numbers, or your GA4 property.
  4. Put the six numbers at the top. One scorecard each, compared with the previous period and the same month last year.
  5. Add the second row for your business type. Use the layout from the examples above; stop at about ten charts.
  6. Set the date range and share it. Default to last month, share with view access, and book 20 minutes on the first Monday of each month to read it.

Free marketing dashboard template (Looker Studio / Data Studio)

The template has a top row of six scorecards (sessions, leads, conversion rate, ad spend, cost per lead and revenue), a weekly trend of leads and sessions, a table by channel and filters for date and channel. It runs on a Google Sheet with 90 days of sample data for a small service business, so it opens without any logins. Open the template or see the PDF preview first.

Free marketing dashboard template in Looker Studio with leads, cost per lead, revenue by channel and a weekly trend
The free template with sample data: six scorecards, a weekly trend of leads and sessions and a channel table.

To use it with your own numbers, open the template, choose Make a copy from the three-dot menu, then copy the sample data sheet and replace the rows with yours (one row per day per channel). The second page of the report explains how to switch the data source to GA4 instead. CAC and returning customers need data from your CRM or shop, so add them once that data is in the sheet.

If you would rather not build it yourself, our marketing dashboard setup checks your tracking and delivers a finished dashboard at a fixed price.

Mistakes that make marketing dashboards useless

Most dashboards fail because nobody acts on them, not because the charts are wrong. These are the six mistakes we see most often:

  • Too many charts. Thirty charts on one page means nobody knows which number to fix first. Keep the top row to six.
  • Vanity metrics on top. Impressions, followers and sessions belong lower down; leads, cost per lead and revenue go first.
  • No comparison. A number without last month or last year beside it cannot tell you whether things got better.
  • Broken or double-counted conversions. If GA4 and Google Ads both count the same lead, or a thank-you page fires twice, every number below is wrong.
  • Each platform judging itself. Google Ads, Meta and email each claim the same sale. Use one source of truth for revenue, and read our guide to attribution models before you move budget.
  • Nobody owns it. A dashboard without a fixed monthly review becomes a link nobody opens. Put the review in the calendar.

Frequently asked questions

For most small businesses it is Google’s free Data Studio, formerly Looker Studio, because it connects to Google Ads, GA4 and Search Console at no cost. HubSpot suits teams already selling through HubSpot, Databox suits people who want ready-made dashboards, and Power BI suits companies already on Microsoft 365.

Yes. In Data Studio you share a report by link or email with view-only access, so clients see live numbers but cannot change anything. In Power BI, sharing reports needs a paid Pro or Premium licence.

Once a month for decisions about budget and channels, and once a week for a two-minute look at leads and spend. Daily checking mostly shows noise, especially on small budgets.

An SEO dashboard tracks organic search on its own: non-brand clicks, leads from organic visits, top landing pages and queries that are gaining or losing. In 2026 it should also show AI citations from Bing Webmaster Tools, because AI answers now take clicks that used to go to search results.

Not sure your tracking is right, or no time to build it? Our marketing dashboard setup fixes the tracking and hands you a finished dashboard, at a fixed price and a fixed date.

Sources and method

Written by Mariia Yevhlevska, content and PPC specialist at Well Web Marketing. She sets up tracking and reporting for service businesses and builds the dashboards their owners read every month. More about how we work.

Well Web Marketing

Ready to see what changes for your business?

Still intuition. Still experience. Now with AI doing the heavy lifting.