Key takeaways
- A marketing dashboard exists to prompt a decision. If a chart does not change what anyone does, remove it.
- Build separate views for the owner, the marketing lead and the practitioner. They ask different questions at different cadences.
- Write down each metric's definition, source and caveat. Search Console, GA4 and the CRM will not agree, and the dashboard should say why.
- Pull revenue from the CRM, search visibility from Search Console and on-site behaviour from GA4, then join them on a shared source field.
01
What is a marketing dashboard for?
A marketing dashboard is a single view of the measures that show whether marketing is producing leads and revenue, built so someone can make a decision from it. The test is simple: for each chart, name the action someone would take if it moved. If you cannot, it is decoration.
Most dashboards fail by showing everything the tools can export. Analytics platforms offer a long list of dimensions and metrics, and a dashboard that mirrors them gives readers nothing to prioritise. Start from the decisions your business makes each month, such as where to spend, which pages to improve and whether sales is following up, and work backwards to the few numbers each decision needs.
02
Which metrics should a marketing dashboard include?
Organise metrics by funnel stage and keep one or two per stage. Visibility: impressions and clicks from search. Engagement: sessions and key events on the site. Capture: form submissions and calls. Pipeline: qualified leads and opportunities from the CRM. Revenue: closed-won value by original source. Reading across the stages shows where volume is lost.
Leave off vanity measures that cannot be tied to a decision, such as raw page views or social follower counts on their own. They can sit in a practitioner view where someone is diagnosing a channel. The executive view should hold the numbers that connect to money.
| Funnel stage | Metric | Typical source | Caveat |
|---|---|---|---|
| Visibility | Search clicks and impressions by page and query | Search Console | Only Google Search; average position is an average |
| Engagement | Sessions and key events by landing page | GA4 | Consent settings and filters change counts |
| Capture | Form submissions, calls, booked meetings | Forms, call tracking, CRM | Count unique people, not repeat submissions |
| Pipeline | Qualified leads, opportunities, stage conversion | CRM | Depends on agreed stage definitions |
| Revenue | Closed-won value by original source | CRM | Long sales cycles lag behind spend |
03
Who should see what? Views by audience
The owner or founder wants to know whether marketing is paying for itself: leads, qualified leads, pipeline and revenue by source, compared with the previous period. One page, read monthly. The marketing lead needs channel-level detail and trends, so a page per channel with spend or effort beside results. The practitioner needs query, page and campaign detail for weekly work.
Resist building one view for everybody. A page dense enough for the practitioner overwhelms the owner, and one simple enough for the owner hides the problem the practitioner has to fix. Link between them so a leader can drill from a falling number to the page that explains it.
- Owner view: leads, qualified leads, pipeline and revenue by source; month on month
- Marketing lead view: each channel's results, cost or effort, and conversion to qualified lead
- Practitioner view: queries, landing pages, campaigns, form errors and speed to first contact
04
Which data sources feed a marketing dashboard?
Three sources cover most small and mid-sized businesses. Google Search Console reports how the site performs in Google Search, with clicks, impressions, click-through rate and average position by query, page, country and device. GA4 reports on-site behaviour, with dimensions such as page or country and metrics such as active users and event counts. The CRM records what happened to each lead afterward. Only the CRM can say which marketing source produced revenue.
Know each source's limits before you chart it. The Search Console API notes that it does not guarantee to return all rows, only the top ones, and that fresh data can be incomplete and later change. GA4's own documentation warns that report API figures may not match the interface. So a dashboard should show a date range that excludes the last couple of days, and it should say which tool each number came from.
05
How do you define each metric so people trust it?
Write a definition for every metric on the page: what it counts, the source, the filters applied, and the known caveat. A lead might be defined as a unique person who submitted a form and passed a spam check, counted once per thirty days. A qualified lead is a lead the sales team accepted. Illustrative example: if Search Console shows more clicks than GA4 shows sessions from Google, that is expected, because they measure different things in different ways, and the definition note should say so.
Agree the source field early. If every lead carries a consistent original source value from first touch, the CRM can join the three data sets. If sources are free text, the revenue-by-channel view will be wrong however good the chart is. Keep the definitions on the dashboard itself, in a small panel or tooltip, not in a document nobody opens.
06
How often should a dashboard refresh, and what mistakes should you avoid?
Match the cadence to the decision. Lead capture and response time deserve daily visibility, since a missed enquiry cannot be recovered later. Search and content results move slowly and are noisy day to day, so weekly is enough for practitioners and monthly for owners. Pipeline and revenue follow the sales cycle, so review them monthly and quarterly. Refreshing everything hourly adds cost and invites overreaction.
The common mistakes are predictable: too many charts, no definitions, comparing a partial month with a full one, mixing data from tools without noting differences, and no owner to maintain connections when a form or field changes. Name an owner, put a last-refreshed timestamp on every page, and review the dashboard each quarter to remove what nobody used.
- Charting incomplete recent days as if final
- Reporting leads without showing how many were qualified
- Changing a definition without marking the break in the trend
- Letting a broken connector go unnoticed
Was this useful? Send it to someone who owns this problem.
Primary sources and further reading
Use the source material to validate details against your own context and current platform configuration.
- Google Search Central: Get started with Search Console
- Google for Developers: Search Console API, Search Analytics query
- Google for Developers: Analytics Data API, dimensions and metrics
This field note follows the XenGrowth editorial policy: primary sources where available, visible limitations, material review dates, and no invented first-hand experience.
Stay with the problem
Related field notes
Revenue OperationsMarketing Audit: A 12-Point Check for Where Your Spend Leaks
GTM StrategySales Enablement for Small and Mid-Size Teams: Build What Sales Will Actually Use, and Measure It Honestly
GTM StrategyBrand Messaging Framework: A One-Page Version That Sales and Marketing Can Both Use, With a Fill-In Table