The One Screen That Ends Owner Overload: Profit, Cost Per Booked Job, and Lifetime Value
The fix for running your shop off ten spreadsheets is one screen showing three numbers: profit, cost per booked job, and customer lifetime value. Build it right and the morning reconciliation ends. CDA builds these in Tableau, but the tool is the how, not the point. Dashboards aren't the deliverable. Booked revenue is.
Why Do You End Up Reassembling Your Numbers Every Morning?
Because you are the only person who can see all the systems, so you become the one who reconciles them, by hand, before any decision gets made. Your CRM knows the leads and bookings, your ad accounts know the spend, your job software knows what got installed and what it cost, and accounting knows what got paid. None of them agree on a definition, a date, or a total, so you stitch them together every morning and call the result "the numbers."
That daily stitch is owner overload, and it has two halves this page deliberately leaves to other pages. The reason two systems never agree is its own subject, covered in why your marketing report and sales report never match. And a screen that nobody keeps wired quietly becomes the dashboard nobody opens. This page is about the other half: what the one screen should actually show so the stitch stops being your job.
What Are the Three Numbers That Actually Run a Home Services Shop?
Profit, cost per booked job, and customer lifetime value. Everything else on a good owner screen exists to explain one of those three or gets cut. Profit sits at the top because you are not running a nonprofit; it is what funds payroll, trucks, and next year. The other two tell you whether that profit is healthy and whether it lasts.
Cost per booked job, your CAC made honest, is total acquisition cost, ad spend plus agency fees, divided by the jobs you actually booked, not the raw leads that came in. It answers "am I buying work efficiently, and from which channels." Customer lifetime value (LTV) is the back half: what a booked customer is worth across repeat work, added service lines, and referrals, not just the first ticket. Read together, they tell you how much you can afford to pay for a job and still come out ahead.
The discipline that keeps the screen honest is a test CDA applies to every report it builds: every number on the page must trace to an action, and that action must trace to profit. If a metric ties to no decision and no path to profit, it does not belong on the screen, however interesting it looks. The full list of what a home services owner should track is its own subject; we lay out the whole metrics hierarchy for a home services business. Here we stay on the three at the top.
How Do You Build a Profit, CAC and LTV Dashboard Owners Actually Open?
You lock the definitions before you draw a single chart, model the data once underneath, and only then put three numbers on one canvas. The order is the whole job. Here is the sequence CDA uses, and you can start it Monday:
- Write the definitions on one page. What counts as profit and which costs are in it. What counts in cost per booked job, agency fees, sales commissions, or just media. How you count a customer's lifetime value. Get the owner to sign it. Every future argument about whose number is right is settled here, once, in writing.
- Cut every metric that fails the trace test. List the five or six decisions the screen must answer, then drop anything that serves none of them.
- Build one data table underneath everything, at a declared grain, one row per lead and job, with profit, acquisition cost, and the key dates already resolved in the pipeline rather than in a Tableau formula. When profit is computed once, upstream, every view agrees by construction.
- Reconcile the new numbers against the reports the team already trusts, line by line, before anyone sees a chart. A screen that disagrees with the owner's known numbers, with no explanation, is a screen that dies.
- Put the three numbers on one canvas against targets, with pacing, so a raw month to date figure does not look behind on the 10th when you are actually on track.
- Set the refresh to run when the data pipeline finishes, not on a fixed clock, so nobody ever has to ask whether the number is current.
Notice that only steps 5 and 6 touch Tableau. The first four are why the screen holds, and they are the same in any tool.
What Does the One Screen Look Like When It Works?
It looks like the owner glancing at three numbers, seeing the one that is off, and clicking straight to the reason, instead of opening ten tabs. All States Home Improvement, a home services contractor, ran the business on a stack of manually compiled weekly Excel reports until the person who compiled them left. CDA rebuilt it as command centers organized by role in Tableau, one for the owner, fed by a single automated data foundation.
The design rule was forest before trees. The owner's landing screen shows company trajectory, channel mix, and funnel flow; every individual rep, channel, or day is one click down but never the default view. That is what makes an owner screen a daily habit instead of a quarterly curiosity.
The honest first move is a diagnosis, not a build. A free Profit Leak Audit reads your own numbers, shows you your real cost per booked job and where booked revenue is leaking, and tells you whether a screen like this is even your next move. If it is, you will know exactly which questions it should answer.
Who Should See the Screen, and Who Just Needs the Numbers?
Not everyone needs a Tableau login, and handing out interactive access rarely survives contact with a busy shop. The pattern that works: the owner and any partners get the pulse view against targets. Managers get the tactical cuts by channel, market, crew, or service line. Whoever maintains the analytics gets the workbook. Everyone else gets a scheduled PDF or a CSV of the same numbers in their inbox, which is cheaper than licenses and removes the login as a barrier entirely.
The export page earns its keep here. If people keep screenshotting your screen into decks, give them the export. If they export everything constantly, the screen is answering the wrong questions, which is worth knowing on its own.
The most valuable screen in the whole build was barely a chart. It just answered one question the owner could act on.
When Should You Not Build This Yet?
When the data underneath it cannot be trusted, or when nothing is actually waiting on it. If your lead data and your job data cannot be reconciled, a screen will faithfully display numbers nobody believes; fix the foundation first. If the shop runs fine on a weekly spreadsheet and no decision is stuck waiting on data, a Tableau build is a cost, not an asset, and you probably do not need the expensive build yet. If a previous dashboard already died on you, find out why before commissioning another; usually nobody opened it because it displayed data instead of answering decisions.
And if the real question is not this screen but how to buy analytics help at all, start with the buying guide for a home services business, or the pillar on the three profit leaks you are already paying for. The right screen is worth building only once the three numbers on it are numbers you can bet a decision on. A free Profit Leak Audit will tell you honestly whether you are there yet.
How we measured this
The All States Home Improvement figures come from that engagement's after action review. Median lead callback was measured across 9,135 leads before launch and 3,574 after, comparing roughly the five months before the speed to lead view went live to the seven weeks after. The $650K is the review's estimate of potential sales from the improved response time distribution over that window, reviewed with the client. One shop, one vertical; your numbers will differ.
Frequently Asked Questions
What three numbers should a home services owner watch daily?
Profit, cost per booked job, and customer lifetime value. Profit is the outcome; cost per booked job tells you whether you are buying work efficiently; lifetime value tells you whether that work pays off over repeat jobs and referrals. Everything else on the screen should explain one of those three or get cut. The full metric list is a separate subject.
Is Tableau overkill for a shop my size?
The tool matters far less than the definitions and the data foundation underneath it. Tableau and Power BI can both render an owner screen; choose based on what your team already knows and what your data connects to easily. Then spend the saved deliberation getting the metric definitions right, because that is what actually makes the screen trustworthy.
How is cost per booked job different from cost per lead?
Cost per lead divides spend by every raw lead that came in. Cost per booked job divides your full acquisition cost by the jobs you actually booked, which ties spend to real work won rather than to inquiries. It is the number that tells you which channels are worth more money and which are quietly expensive once you account for how few of their leads close.
How often should the screen update?
When the data pipeline finishes, rather than on a fixed schedule, so the refresh is automatic and visible and nobody wonders whether the number is current. Daily is the right cadence for most owner screens. Faster than that only matters for views someone acts on within the hour, like which fresh leads are still uncontacted right now.
What if my lead data and job data don't line up?
Then fix that before you build the screen, not after. A dashboard cannot reconcile data that does not reconcile; it will just display the disagreement in color. Getting the lead system and the job system to agree on definitions and dates is the actual first project, and it is often where the leaking booked revenue turns out to be hiding.
Find out if the one screen is even your next move
A free Profit Leak Audit reads your own numbers, shows you your real cost per booked job and where booked revenue is leaking, and tells you whether a screen like this is your next move. If it is, you will know exactly which questions it should answer.
Book a Profit Leak Audit