Industry guide
Home services marketing dashboard: from ad spend to booked jobs
A home services marketing dashboard shows an HVAC, plumbing, electrical or roofing business, or the agency that markets it, which channels produce booked jobs and revenue, and what each booked job costs. This guide is for marketing agencies with contractor clients and for multi-location home services companies whose ad reports stop at the click. It covers the KPIs, the data sources, how to bring in calls, Local Services Ads leads and field service software data, a page layout and a worked cost-per-booked-job example.

Quick answer
What should a home services marketing dashboard include?
A home services marketing dashboard should show booked jobs and revenue by channel, cost per booked job, inbound calls and answered rate, Local Services Ads leads and charged leads, form submissions, Google Business Profile actions and ad spend. Lead data comes from ad platforms, GA4 and call tracking; booked jobs and revenue come from field service software such as ServiceTitan or Housecall Pro.
- Judge every channel on cost per booked job, not cost per lead or cost per click.
- Phone calls are a core enquiry route for contractors, so call data belongs on page one.
- Booked jobs and revenue live in field service software, not in GA4 or the ad platforms.
- Agencies should build one template with fixed field names and copy it for each contractor.
What is a home services marketing dashboard?
It is one live report that follows a homeowner from an ad, a map listing or a search result to a booked job and an invoice. Ad platforms report clicks and conversions. Call tracking reports calls. Field service software reports jobs and revenue. A home services marketing dashboard joins all three, so an owner can see that last month's furnace replacement campaign produced eleven booked installs, not just two hundred clicks.
The pages that rank for this topic today fall into three groups. Reporting tools such as AgencyAnalytics sell a ready-made product for agencies. Field service platforms such as ServiceTitan show the dashboards inside their own software, with KPIs like booking rate, average ticket and revenue by ZIP code. Contractor marketing blogs list KPIs but stop before explaining how the data is connected. This guide covers the part they leave out: how the sources fit together in Data Studio (formerly Looker Studio), and how to keep the numbers honest.
We build these dashboards in Data Studio because it is free for creators and viewers, it has native connectors for GA4, Google Ads and Search Console, and the finished report belongs to the contractor or the agency rather than to a software subscription.
Which KPIs belong on a home services marketing dashboard?
Group the KPIs by stage: visibility, enquiry, booking, job and value. Each stage has its own source, and a drop between two stages points to a different fix. A fall from calls to bookings is a call handling or dispatch problem. A fall from clicks to calls is an ad, landing page or listing problem. Mixing them in one total hides which team needs to act.
| Stage | KPI | Usual source |
|---|---|---|
| Visibility | Impressions, clicks and spend by campaign and service line | Google Ads native connector, Meta via partner connector |
| Visibility | Map views, calls, website clicks and direction requests | Google Business Profile via partner connector |
| Enquiry | Inbound calls, answered rate, missed calls by hour and day | Call tracking platform export |
| Enquiry | Local Services Ads leads by type (phone, message, booking) and charged leads | Google Ads API local_services_lead resource |
| Enquiry | Form submissions and online booking starts | GA4 key events |
| Booking | Booked jobs by lead source and business unit | ServiceTitan, Housecall Pro or similar, aggregated |
| Job | Completed jobs, average ticket, close rate on estimates | Field service software, aggregated |
| Value | Cost per booked job, revenue per marketing dollar, membership sign-ups | Calculated in Sheets or BigQuery |
Where does the data come from, and how does it reach Data Studio?
A typical contractor has five to seven data sources. Some connect natively, some need a partner connector, and the most valuable ones, booked jobs and revenue, usually need an export or an API job. Data Studio blends are limited to 5 sources and equality joins only, so for anything beyond a small report we combine the data first in Google Sheets or BigQuery and point Data Studio at one clean table.
Field service software is the source that makes the dashboard useful. Housecall Pro's own KPI dashboard, according to its help center, breaks booked jobs down by lead source such as Google, Yelp, repeat customer and referral, and some views like the Tech Leaderboard require its Essentials or MAX plan. ServiceTitan's dashboards report booking rate, call-booking rate, average ticket and revenue by ZIP code. Neither has a native Data Studio connector, so the practical routes are a scheduled report export or an API job that writes weekly counts by source, business unit and location.
Local Services Ads deserve their own feed. Google documents a local_services_lead resource in the Google Ads API that exposes each lead's type (phone, message or booking), status, service category, whether it was charged and whether feedback was submitted. A partner connector or a short script that queries it can land weekly lead counts in Sheets or BigQuery without copying homeowner contact details into the report.
- Native in Data Studio: GA4, Google Ads, Search Console and Google Sheets.
- Partner connectors (Supermetrics, Windsor.ai, Porter Metrics and others): Meta Ads, Google Business Profile, Microsoft Ads. Vendor prices change, so check them directly.
- Exports or API jobs: call tracking, Local Services Ads leads, ServiceTitan or Housecall Pro jobs and revenue.
- Mapping table in Sheets: one row per tracking number, campaign and lead source label, so every system uses the same channel names.
How do you calculate cost per booked job? A worked example
Cost per booked job is marketing spend for a channel divided by the jobs booked from that channel in the same period. It puts Google Ads, Local Services Ads, Meta and direct mail on equal terms, because each one is judged on the outcome the owner pays for.
Take a hypothetical HVAC company in one month. These are illustrative numbers, not benchmarks. It spends $6,000 on Google search ads and $3,000 on Local Services Ads. Search ads produce 150 calls and forms, 45 booked jobs and $27,000 in completed revenue. Local Services Ads produce 60 charged leads, 33 booked jobs and $13,200 in completed revenue.
Cost per lead favors search: $40 a lead against $50 for Local Services Ads. Cost per booked job reverses that, at about $133 for search ($6,000 divided by 45) and about $91 for Local Services Ads ($3,000 divided by 33), because Local Services Ads leads booked far more often. Revenue per marketing dollar adds a third view: $4.50 for search and $4.40 for Local Services Ads, because search brought more replacement work with higher tickets. A report that stopped at cost per lead would have cut the channel that books most efficiently. The dashboard shows that both earn their keep, that Local Services Ads fill the schedule cheaply, and that search is where the larger jobs come from.
In Data Studio these are calculated fields such as SUM(spend) / SUM(booked_jobs) and SUM(revenue) / SUM(spend), built on a table where spend, leads and jobs already share the same week, channel and business unit keys. A CASE statement on the lead source field groups free-text sources like 'google ad', 'GAds' and 'PPC' into one channel before the division.
How should a home services marketing dashboard be laid out?
Five or six pages cover most contractors. Each page answers one question, and the first page answers the question the owner asks on Monday morning: what did we spend, what did we book and what did each booked job cost? Put a date control, a location filter and a business unit filter (install, service, maintenance) on every page.
Split by service line wherever the data allows. An emergency drain call and a full system replacement have very different values, and a single blended cost per job hides which campaigns bring the profitable work.
- Summary: spend, booked jobs, cost per booked job and revenue per marketing dollar by channel, against target.
- Paid search and Local Services Ads: campaigns by service line, charged leads, disputed leads and cost per booked job.
- Phones: inbound calls, answered rate, missed calls by hour and day, and calls to bookings.
- Local presence: Google Business Profile calls, website clicks, direction requests and new reviews by location.
- Website: GA4 sessions by channel, form and booking key events by landing page.
- Jobs and revenue: booked and completed jobs, average ticket and memberships sold by lead source.
How do agencies report on many contractor clients at once?
Build the dashboard once as a master template and copy it for each client, swapping data sources. Data Studio has no built-in client management for agencies, so the process around the template matters more than the template itself: identical field names in every client's Sheet or BigQuery table, a checklist for credentials, and a scheduled delivery per client.
Choose data source credentials deliberately. Owner's credentials let clients view a report without their own access to the underlying data, which is what most contractors expect. Viewer's credentials are stricter and suit groups where each branch manager should only see data they already have rights to.
Watch GA4 quotas as the client list grows. The GA4 Data API allows 14,000 tokens per project per property per hour on standard properties, and a report with many charts opened by many people can hit that limit. Extracts, or moving GA4 data into BigQuery, keep busy client reports loading. Agencies that want each contractor's report under their own brand usually pair this with our white-label service.
What mistakes make home services marketing reports misleading?
Most misleading contractor reports are not wrong. They stop too early or count the wrong thing. These are the issues we check first when we review an existing report.
- Counting every call as a lead, including existing customers chasing an invoice, suppliers and spam.
- Ignoring missed calls, so an understaffed phone line on Saturday looks like a weak ad campaign.
- Reporting Local Services Ads leads without the charged and disputed split, which overstates cost per lead.
- Leaving booked jobs out, so cheap, low-intent leads look like the best channel.
- Mixing service and install work in one average ticket, which hides where the margin is.
- Letting lead source be free text in the field service software, so 'Google' appears under six spellings.
Should you build it yourself or hire a Data Studio agency?
Build it yourself if you run one location, advertise on Google Ads only and are happy to paste a weekly count of booked jobs by source into a Sheet. A single summary page with a calculated cost per booked job already beats most channel reports.
Bring in help when you run several locations or business units, report for many contractors as an agency, need call tracking, Local Services Ads and field service data joined automatically, or have outgrown blends and need BigQuery. Help is also worth it when nobody trusts the current numbers and the first job is reconciling them.
We are not the right fit if you want a packaged app with a login for each contractor and no data work. Tools like AgencyAnalytics do that. We build custom Data Studio dashboards that you own, with the data layer behind them.
How Greenwolf Tech Labs builds home services marketing dashboards
We start with a free review of your channels, your call tracking setup, your field service software exports and the lead source values your team already uses. Then we agree KPI definitions, build a mapping table and the data layer in Sheets or BigQuery, design the pages in Data Studio, and reconcile every total against the ad platforms and the field service software before handover.
Our team has delivered 100+ projects for 200+ clients, and our multi-channel marketing dashboards bring Google Ads, Meta, LinkedIn, GA4 and Search Console into one view. We quote a fixed price after the review, and everything we build sits in accounts you own.
FAQ
Frequently asked questions
What KPIs should an HVAC or plumbing company track for marketing?
Track booked jobs and revenue by channel, cost per booked job, inbound calls and answered rate, Local Services Ads charged leads, and average ticket by service line. Add Google Business Profile calls and reviews for local visibility. Cost per booked job is the number that ties spend to work on the schedule.
Can I connect ServiceTitan or Housecall Pro to Data Studio?
Not with a native connector. The usual routes are a scheduled report export or an API job that writes weekly counts of booked jobs and revenue by lead source and business unit to Google Sheets or BigQuery. Data Studio then reads that table alongside your ad and call data.
How do I report on Local Services Ads in a dashboard?
Google exposes Local Services Ads leads through the local_services_lead resource in the Google Ads API, including lead type, status and whether each lead was charged. A partner connector or script can write weekly counts to Sheets or BigQuery for Data Studio. Report charged and disputed leads separately so cost per lead is accurate.
Is there a free home services marketing dashboard template?
Connector vendors publish generic marketing templates for Data Studio covering ads, GA4 and search. They rarely include calls answered, Local Services Ads or booked jobs from field service software, which are the numbers contractors care about. Most teams start from a template and add those sources.
Why do my ad platform conversions not match booked jobs?
Ad platforms count calls and form fills, many of which are existing customers, quotes that never book, or duplicates. Field service software counts jobs actually booked. A dashboard that shows both, joined by source and week, makes the gap visible and shows which channels produce real work.
How long does it take to build a home services marketing dashboard?
It depends mostly on the data, not the charts. A single-location contractor with clean lead source values and Google Ads only is a small project. Several locations, call tracking, Local Services Ads and messy field service exports add data preparation time, which is why we review the sources before quoting.
Do contractors need a paid licence to view the dashboard?
No. Data Studio is free for creators and viewers. Data Studio Pro costs $9 per user per project per month and applies only to creators, editors and managers in Pro workspaces, so owners and branch managers who view the report never need a licence.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.