See Which Marketing Channels Book Jobs, in One View

This page is about the view that shows which of your marketing actually books work, why honest attribution changes what you cut, and where Tableau fits (and where it does not).

What Should a Marketing Dashboard Show a Home Services Owner?

One number, per channel, side by side: the cost per booked job. Not clicks, not leads, not impressions. The cost to produce one job you actually sold, for Google Local Services Ads, Google Ads, Meta, Angi, and referrals, in a single view you can read in ten seconds.

Most owners already know the feeling: five browser tabs open, each ad platform swearing its own leads are the good ones, and no single number saying which channel actually put a job on the calendar. A marketing dashboard earns its keep only when it collapses those tabs into one view and ties every channel to jobs on the calendar, not to raised hands. Tableau is one tool that can build that view. The view itself is the point; the tool is a detail.

The gap between cost per lead and cost per booked job is where the money hides, and misspent marketing is one of the three profit leaks every home services business is already paying for. We take that gap apart channel by channel in where your marketing money leaks. This page is about the view that makes it visible.

Why Can't You Tell Which Channel Books Jobs Right Now?

Because the channels live in separate systems that never talk to each other, and none of them knows whether a lead became a sold job. Google counts a click. Angi counts a shared lead. Your CRM counts a job, weeks later, often under a different phone number. Nothing joins the spend to the sold work, so you are guessing.

That guessing gets expensive when your average ticket runs into the thousands. The fix is not a bigger ad budget. It is one honest view that pulls every channel together and matches it to what your CRM says you closed. Getting that match right is its own discipline: source capture at the phone, tracking numbers, and the join into the CRM. The dashboard is what you get to look at once that plumbing is done.

Is Tableau the Right Tool for Home Services Marketing Analytics?

Sometimes. Tableau connects to almost anything, Google Ads, Meta, your CRM, a spreadsheet, and puts it all on one canvas, which is exactly what this one view needs. But it is a build and visualization layer, not a growth lever, and plenty of shops doing a few million do not need it yet.

If your data is already clean and lives in one place, a report inside your CRM, or even a spreadsheet, can show cost per booked job by channel. Reach for Tableau when the numbers live in too many systems to join by hand, or when the view has to refresh on its own every morning so nobody rebuilds it. If a vendor is selling you Tableau before your lead sources are even tagged, they are selling the wrong thing first. The honest version of that argument is you probably don't need the expensive model.

How Does Attribution Decide Which Channel Gets Credit for a Booked Job?

It depends on which touch you count. The common default gives all the credit to the last click before the form fill, which flatters whatever channel closes and starves the channel that started the job weeks earlier. Every touch attribution spreads the credit across the whole path, and it usually tells a truer story.

Here is why it matters for what you cut. A homeowner might see your Meta ad in March, search your name on Google in April, and finally call from your Google Business Profile in May. Last click hands the whole job to that final search and makes Meta look worthless. Cut Meta on that logic and the jobs it quietly started dry up two months later. Every touch credit keeps you from starving the channel that fills the top of the funnel.

Honest attribution is also why your marketing report and your sales report rarely agree: each platform claims the same homeowner on its own terms, so the totals count the same job more than once. That is a separate rabbit hole, taken apart in why your marketing report and your sales report never agree. For the dashboard, the rule is simple: pick one credit method, apply it the same way to every channel, and compare like with like.

How Do You Build a Dashboard That Shows Cost Per Booked Job by Channel?

You do not start in Tableau. You start with the data underneath it. Five steps, in order:

1. Tag every channel so a lead carries its source. A call tracking number for each channel that rings the phone, UTM tags on every link you control. If the source dies at the phone, the whole view is a guess.
2. Get the source into your CRM and keep it on the job record. The channel has to ride along from lead to booked to sold, so a closed job still knows where it came from.
3. Decide your credit rule once. Last click or every touch, written down, applied to every channel the same way. See the attribution section above.
4. Build one table, one row per channel. Four columns: what you spent, how many leads, how many booked jobs, and the spend divided by those booked jobs. That last column is the number the whole view exists to show.
5. Put it where you will see it weekly, and let it refresh on its own. This is where Tableau earns its price. The view updates every morning so nobody rebuilds it by hand. For the deeper build order behind a Tableau dashboard, we laid it out in how to build a profit, CAC, and LTV dashboard in Tableau.

None of steps one through four need Tableau. They need discipline. Tableau makes step five painless.

What Happens When an Owner Acts on One Honest View?

The number on the board changes, or it does not. That is the only test. CDA built All States Home Improvement a Tableau command center that made their most consequential metric a daily view instead of a number they only saw in a quarterly review, and the owner acted on it. The metric was different from cost per booked job, but the mechanism is the same: one honest view, seen daily, that someone acts on.

The lesson repeats on the build side. On one client's HubSpot, a lead scoring model CDA deployed had the top tenth of scored leads closing at more than three times the base rate, so the sales team knew which leads to call first. The platform held the data. The thing CDA built on top of it is what made the data worth money. Whether your view lives in Tableau or in a platform like HubSpot, the rule holds: the dashboard is not the deliverable. Booked revenue is. What a platform gives you before you build on it is covered in what marketing data you can get from HubSpot.

How we measured this: Both figures come from CDA's own engagement records. The All States numbers were measured at the close of that project (see the case study linked above), and the lead scoring result came from a separate client build.

If you want to know which of your channels is bleeding money right now, the free Profit Leak Audit reads your own ad accounts and CRM and shows you the worst channel first. Read only, no obligation, yours to keep.

Frequently Asked Questions