A useful service-business marketing dashboard should show what you spent, which enquiries were suitable and what happened to those opportunities. Reach and clicks provide context, but they do not tell you whether marketing is helping the business win work.
Start with a small decision-focused report. This guide describes what to include, how to avoid misleading totals and how to turn the dashboard into a practical discussion between marketing and sales.
Define the decision before choosing the chart
Ask what the report needs to help you decide. You may be deciding which service to promote, whether to repair tracking or whether a campaign can support a larger test. Each decision needs different evidence.
For an owner reviewing lead generation, the first screen can summarise media spend, accepted enquiries, qualified leads and customers. Place channel diagnostics below that summary. Add an explanation of missing or delayed data so an empty field is not mistaken for zero performance.
Use a metric dictionary
| Metric | Working definition |
|---|---|
| Media spend | Platform advertising cost for the stated period and currency. |
| Accepted enquiries | Valid submissions or contacts recorded by the lead system. |
| Qualified leads | Enquiries that meet your documented suitability criteria. |
| Customers acquired | Confirmed new customers under an agreed sales definition. |
| Cost per qualified lead | Relevant media spend divided by qualified leads. |
| Media acquisition cost | Relevant media spend divided by attributed new customers. |
Media acquisition cost excludes other acquisition expenses. If you want a full customer acquisition cost, define which management, creative, tools and sales costs are included. Label the two measures differently.
When a denominator is zero, show the rate as unavailable rather than a misleading zero cost. Missing lead-quality data should also be visible, not silently treated as disqualified leads.
Use the right source for each answer
Advertising platforms explain delivery and media spend. GA4 describes observed website behaviour. Your CRM or controlled lead register records qualification and sales outcomes. Each source serves a different purpose and may use different attribution or reporting rules.
Do not add conversions claimed by different advertising platforms and call the result unique customers. One customer can appear in multiple platform reports. Use a documented business-level method for customer totals and keep platform-attributed results labelled separately.
If the numbers disagree, check definitions before assuming a fault. Our guide to Google Ads and GA4 conversion differences explains common reasons.
Compare equivalent periods and allow for sales delay
Use a consistent reporting timezone, currency and date window. Distinguish a lead-created view from a sale-completed view. Leads generated this week may close next month; dividing this week’s spend by this week’s closed deals can combine unrelated groups.
For a lead cohort, track the eventual outcomes of enquiries first received during the same period. Mark recent cohorts as incomplete while follow-up continues. For a cash-flow view, show sales completed during the reporting period and explain that it answers a different question.
A worked example: cheaper leads can cost more per customer
The figures below are hypothetical teaching data, not Pixel Pulse Media results or market benchmarks. Assume both campaign cohorts have completed their normal follow-up period.
| Sample metric | Campaign A | Campaign B |
|---|---|---|
| Media spend | $1,000 | $1,000 |
| Accepted enquiries | 50 | 25 |
| Qualified leads | 10 | 15 |
| Customers acquired | 2 | 3 |
| Cost per enquiry | $20 | $40 |
| Cost per qualified lead | $100 | $66.67 |
| Media acquisition cost | $500 | $333.33 |
Campaign A produces cheaper enquiries, while Campaign B has the lower media acquisition cost in this example. That does not establish which campaign is more profitable: customer value, delivery cost and other acquisition expenses still matter. With only two or three customers, a small change can also move the rates substantially.
Check the data before automating the report
Reconcile a sample of records from the original sources. Confirm date filters, conversion definitions, duplicate handling and currency conversion. Check joins carefully: combining several campaign rows with several lead rows on an insufficiently specific key can multiply totals.
Include a data refresh timestamp and show disconnected sources clearly. Keep personal contact details out of broad marketing dashboards; use aggregate counts and appropriate access controls. Google also provides guidance on keeping personally identifiable information out of Analytics.
Finish each review with an action
Record the finding, the next action, an owner and a review date. For example: “Many enquiries are outside the service area; review location settings and offer wording.” That is more useful than “Improve performance.”
Review operational problems promptly and commercial trends after enough time for the normal sales cycle. Avoid daily budget changes based on a handful of new leads. Keep a change log so future readers can explain why a trend shifted.
Build a dashboard around your sales process
Pixel Pulse Media provides Looker Studio reporting and dashboards and GA4 and conversion tracking support. Request a reporting project proposal with your platforms, CRM or lead register, reporting markets and the decisions your current report cannot answer.