Looker Studio Lead Dashboard: Six Numbers a Service Business Owner Should See Every Month

What a lead dashboard should do for an owner

Most dashboards fail for the same reason: they were built to show what the platforms can report, not what the owner needs to decide. Impressions, clicks and reach are available in every connector, so they end up on the first page, and the question the owner cares about, whether marketing paid for itself, needs a spreadsheet and a calculator. A lead dashboard reverses that order. It starts with the decision (keep, cut, test or fix a channel) and works backward to the minimum data needed.

It also has a second job: it removes arguments. When the agency says Google Ads produced 60 conversions and the sales team says only 20 were real enquiries, a dashboard that shows both numbers side by side, defined in plain words, turns a dispute into a question about lead quality. Our monthly marketing report guide covers the written report; this article covers the live dashboard that sits behind it.

Step 1: Build the lead log before the dashboard

The platforms know how many clicks and forms they recorded. Only you know which enquiries were real, which were quoted and which became jobs. That information belongs in a lead log, ideally a Google Sheet because Looker Studio reads it natively. Keep one row per enquiry with these columns.

Do not put names or phone numbers in this sheet if it will feed a dashboard shared with people who do not need them. Use an enquiry ID instead, and keep contact details in a separate protected sheet or in your CRM. The lead tracking spreadsheet guide gives a layout you can copy, and the WhatsApp lead follow-up system explains how to keep stages consistent so the sheet can be updated from the inbox.

Step 2: Choose your data sources honestly

Looker Studio distinguishes between connectors built by Google and third-party connectors built by outside developers. Google's documentation lists Google Ads, Google Analytics and Search Console among the Google connectors, and Google Sheets in its spreadsheet and file group. Facebook Ads is not among the Google-built ones; Google describes it as the kind of product that community or third-party connectors cover. That difference decides how you plan the Meta page.

Our recommendation for a small business is simple. Connect the lead log, Google Ads and GA4 directly. For Meta, either export a spend table into a Sheet each month or use a third-party connector only after you have read what data the provider collects and how it is priced. A dashboard that depends on a connector you do not understand will eventually break at the worst moment.

Step 3: Define six numbers and write the definitions on the page

Put a short definitions text box on the dashboard itself. When the numbers change, readers can see whether the definition or the performance changed. For deeper guidance on which measures matter, see marketing KPIs for service businesses and the cost per lead calculator.

Step 4: Lay out four pages, not one crowded screen

1. Summary: the six numbers for the chosen month, a comparison with the previous month, and one sentence of commentary typed by a person.
2. Sources and campaigns: a table by source and campaign with spend, enquiries, qualified enquiries, booked jobs and cost per booked job. Sort by cost per booked job, not by clicks.
3. Quality: stage funnel, loss reasons, and enquiries by area and service. This page answers why leads are not turning into jobs.
4. Data health: rows with missing source, rows with no stage after a set number of days, and the last date each source was updated. This page is for you and your agency, not the owner.

Resist adding more. Every extra chart is another definition to defend. If a number does not change a decision, leave it for an appendix. Mobile matters too: owners often open dashboards on a phone, so check the layout at a small width and keep tables narrow.

Step 5: Blend with care

Blending joins data from two sources, for example Google Ads spend and the lead log, on a shared key such as campaign name. It is powerful and fragile. Three rules keep it honest. First, join on a field that is spelled identically in both places, which is why campaign naming conventions come before dashboards. Second, aggregate before you blend if one source has many rows per day and the other has one. Third, always reconcile the blended total against each source on a single test month; if Google Ads says AED 9,800 and the dashboard says AED 10,300, find out why before anyone sees the page.

A worked example with hypothetical numbers

Suppose a cleaning company spent AED 8,000 on ads in a month and the lead log shows 64 enquiries, 38 qualified and 17 booked jobs. These figures are invented to illustrate the arithmetic, not a benchmark. Cost per enquiry is about AED 125, cost per qualified enquiry about AED 211 and cost per booked job about AED 471. Now imagine the sources page shows that one campaign produced 30 of the enquiries but only 3 bookings, while another produced 12 enquiries and 9 bookings. The first looks cheap on the platform and expensive on the log. That is the insight no ad platform report would give you, and it is why the lead log is the spine of the whole dashboard.

Sharing, credentials and privacy

Google explains that a data source can use the owner's credentials or the viewer's credentials. With owner's credentials, viewers can see the report without having access to the underlying data; with viewer's credentials, each person needs their own access. Google also advises making sure you trust the recipients before sharing with owner's credentials, and notes that Workspace administrators can change the defaults. In practice:

• Share the dashboard with named people, not "anyone with the link", unless the data is harmless.
• Keep personal data out of the dashboard. Use enquiry IDs and aggregate counts.
• For clinics, never include diagnoses, treatments or patient names; track only neutral stages such as enquiry, booked and attended.
• Use a company-owned Google account to own the data sources, not an employee's personal account, so the dashboard survives staff changes.
• Document who has edit access and review the list every quarter.

Common failures and quick fixes

How to use the dashboard in a monthly review

Hold the review on the same day each month. Read the summary page, then the sources page, then the quality page. For each channel decide one action: keep, cut, test or fix. Write the decision in the change log next to the dashboard, with the date, so later you can tell which result followed which decision. Compare with the same month last year when you have it, and remember that enquiries and bookings lag; a December enquiry may become a January job. If your account is managed by an agency, ask for access to the Google Ads account itself, not only the dashboard; our agency contract checklist explains why.

How we work at ZED

ZED is a digital marketing agency for service companies and clinics. Our conversion tracking service describes agreeing a short list of conversions, giving each call, WhatsApp and form button its own event with GA4 and Google Tag Manager, sending conversion events to Google Ads, and reporting through one dashboard with four numbers: enquiries, their sources, cost per enquiry and the page that produced the most. The Google Ads service adds conversion uploads from lead outcomes. We have not published a Looker Studio template, and we do not promise results; if you send your current report and lead log structure on WhatsApp, we will say what we would change first. You can also see our work on the case studies page, or reach us through the contact page.

Checklist before you share the dashboard

• Every number has a written definition on the page.
• One test month reconciles with each source.
• No names, phone numbers or clinical details are visible.
• The data health page shows no old gaps.
• Access is limited to named people and owned by a company account.
• A person has written one paragraph of commentary for the month.

Frequently asked questions

Is Looker Studio free?

Check Google's current pricing and terms before planning. Third-party connectors, Google Workspace or Cloud add-ons and your own time can carry costs even when the report builder itself does not.

Can Looker Studio connect to Google Ads and GA4?

Yes. Google's documentation lists Google Ads, Google Analytics and Search Console among its Google connectors, and Google Sheets among its spreadsheet connectors.

How do I bring Meta Ads data into Looker Studio?

Meta Ads is not among Google's own connectors. Options include a third-party connector, after you have read its data and pricing terms, or exporting spend to a Google Sheet. Choose the option you can maintain.

What is the best data source for leads?

Your own lead log, because it records qualified enquiries and booked jobs. Platform conversions count events, not business outcomes.

How often should I check the dashboard?

Weekly for data health, monthly for decisions. Daily checking tends to encourage reacting to noise.

Is it safe to put customer data in a shared dashboard?

Avoid it. Use enquiry IDs and counts, share with named people, and for clinics keep health information out entirely.

Do I need a dashboard if I get a PDF report?

A PDF suits dated commentary and a dashboard suits checking numbers. Many owners use both, with consistent definitions.

Can ZED build this for me?

We can review your lead log and tracking and advise on structure. We do not promise results or publish prices; send your details on WhatsApp for an initial view.