Most home service owners know what they spent on marketing last month. Few can say which dollar of it produced a signed job. Blended reporting hides that answer inside one average number.
Foster (not his real name) runs a digital marketing agency that serves home service businesses, and he built a working answer into his own reporting: a dashboard that matches every lead back to the sale it closed, channel by channel.
One dashboard, matched lead by lead to its sale, was all it took to expose a channel earning 16 times its cost and a Google Ads account quietly burning $55,000.
Most home service owners know what they spent on marketing last month. Few can say which dollar of it produced a signed job. Blended reporting hides that answer inside one average number.
Foster (not his real name) runs a digital marketing agency that serves home service businesses, and he built a working answer into his own reporting: a dashboard that matches every lead back to the sale it closed, channel by channel.
Most marketing reports show one number: total spend against total leads. That average hides everything useful. Organic search (SEO) earning a client 16 times its cost can appear right alongside a paid campaign burning 30% of the revenue it generates, and the blended total just looks "high," with no way to tell which channel is dragging it down. Channel-isolated ROAS tracks spend and revenue separately for every source, then matches each closed sale back to where the lead came from. Once the channels are split apart, the wasteful one usually stands out immediately, and it's rarely the channel an owner assumed.
Which dollar worked is the one question a marketing report exists to answer — and for years, Foster's couldn't.
Foster's team had always been able to tell clients how many leads came in each month. What they couldn't do, reliably, was connect those leads to which ones became paying jobs. Working through it with Stuart Trier in January, Foster named the real problem: the data existed, but nobody could hold all of it in their head during a client call, and nothing forced it onto paper where a pattern could show up.
"You have the data, but you can't possibly hold all of it in your mind when you're talking with a client. It needs to be on paper." — Foster.
That one line is what started the build: a working dashboard, something a report could never be.
A spreadsheet wasn't going to fix this. Foster's team needed something that reconciled 2 data sources on its own.
To build it, Foster's team pulled call-tracking data (every phone number that came in through a tracked source) and matched it against CRM records by phone number, so a closed sale could be traced back to the channel that produced it. Where a customer's CRM entry already said "referral" or "returning customer," that overrode the tracked source, so the dashboard never took credit for a lead it didn't generate.
Some leads couldn't be matched to a tracked call at all, usually because a customer called a direct or personal line instead of the tracked number. For those, the system distributed them proportionally across the channels already confirmed, instead of guessing or dropping them.
"Because they have no clarity on that number, they micromanage. They bring you on their emotional journey." — Stuart Trier, Clear Results.
That's the failure state a dashboard like this is built to close. Without it, a client's read on their own marketing comes from whichever line on the report looked worst that week.
By May, the dashboard was live and updating daily, and the first full month it covered told a clean story.
For one of Foster's clients, a foundation repair company, organic search had generated close to $200,000 in a single month against a $12,500 retainer, roughly 6 cents spent for every dollar it brought in. That same client's Google Ads spend, run in parallel, had generated $8,000 against about $2,500 spent, closer to 31 cents spent for every dollar it brought in. Both channels were producing revenue. Blended into a single spend number, a 5-times difference in efficiency had never been visible before.
Over the following quarter, the pattern held: organic search returned roughly 11 times what it cost, while Google Ads spend for that client consumed about 22% of the revenue it produced in the same period.
Not every client waited for Foster's dashboard before touching their own ad account.
Another client, a foundation repair contractor, had let 2 staff set up a separate Google Ads account with no involvement from Foster's agency.
That account had been running since the previous August with no call-tracking on it, no conversion reporting, nothing connecting the spend to a single closed job. By the time Foster found out, it had spent $10,000 to $11,000 in the previous 30 days alone, and $55,000 total since it started.
"That is the most absurd thing I've ever heard. People get paid $300 to $400 an hour to optimize a Google Ads account, and everybody in this industry knows Google will take your money if you let it." — Foster.
The client had told Foster he was too tight on cash for marketing, while quietly running a second campaign that outspent it.
| What a Blended Report Shows | What Channel-Isolated Tracking Shows Instead |
|---|---|
| One combined marketing spend number, read as "high" or "low" | Spend and revenue tracked separately per channel, so each one can be judged on its own |
| Leads counted whether or not they ever became a sale | Every lead matched to whether it closed, by phone number, against the CRM |
| An efficient channel (organic search at roughly 6 cents on the dollar) looks the same as an inefficient one once averaged together | The same channel shows an 11 to 16 times return, clearly separated from a channel returning far less |
| A self-managed account run outside the agency is invisible until someone asks about it directly | $55,000 in untracked spend becomes visible the first time anyone looks for it |
Where a typical home service coaching program hands an owner a template and checks in once a month, Clear Results worked through this build with Foster directly, inside his own weekly numbers, until the dashboard matched reality.
Blended marketing reporting isn't a foundation-repair problem. It shows up anywhere a business runs more than one lead source at once:
The mechanism is the same everywhere: until every lead is traced to its actual source and its actual outcome, an owner is reading an average and calling it a fact.
Ask for spend and results broken out by individual channel. An agency able to separate organic search from paid search from referrals, and able to show which specific leads in each channel became paying jobs, is giving you real information. One that only reports a blended total is handing over an average dressed up as an answer. A useful test: ask what share of last month's paid leads closed into signed jobs. An agency with real channel-level tracking will have that figure ready within a day. One that only tracks a blended number usually won't have it at all.
The core mechanism is simpler than it sounds: match every lead's phone number against your CRM's sales records. Where a call-tracking tool and a CRM already exist, the two can usually be connected without new software, just a consistent process for logging the source on every incoming call. The harder part is the discipline: someone has to check the match weekly, correct the leads that got attributed wrong, and keep the manual entries current. A dashboard built once and never maintained drifts back into guesswork within a couple of months.
Some leads will always come in through an untracked line, a returning customer, or a referral that skips the tracking number. Don't drop them or guess. Log them against whatever source the customer reports, and count that manually entered data as real information in the total. For these cases, Foster's team built a proportional rule: unmatched leads get distributed across the channels already confirmed, in the same ratio those channels are already producing. That beats assigning every unmatched lead to one source, or dropping it from the total.
No. Most home service coaching programs hand an owner a framework and a monthly check-in call, then leave the owner to build the rest alone. Clear Results built this dashboard alongside Foster, inside his actual weekly numbers, testing the matching logic against real client data until it held up. That distinction matters most here: an agency selling channel transparency to its own clients has to trust its own numbers first. A framework handed down from a monthly call wouldn't have caught the untracked $55,000 account. Weekly, hands-on work with the real data did.
Ask directly, on a set schedule, whether anyone on staff is running paid ads outside the agency of record. A self-managed account set up through a platform's own onboarding flow often has no conversion tracking at all, and it won't show up in any report until someone asks the question by name. Build the question into a recurring check, monthly at minimum, instead of waiting for someone to mention it. In Foster's case, the account had been running quietly for months, spending more than the tracked campaign, before anyone found out.
Because it's the easiest line item to point to when cash feels tight, even when it's the channel paying for everything else. An owner staring at one blended spend total sees only one line to cut, and the efficient channel and the wasteful one look identical inside it. Separating spend and return by channel before cutting anything is what prevents an owner from cutting the one thing that's working. In Foster's dashboard, that separation is what let one client finally see which channel was earning its keep.
This article is based on real advisory work with a Clear Results client. Identifying details have been changed to protect the client's privacy; the business challenges, numbers, and outcomes described are accurate to the engagement.
Stuart Trier is the Founder and CEO of Clear Results. Over the past 20 years, Stuart has built, bought, and sold 11 companies across the home service, healthcare, and marketing industries. He built his first company from startup to $8M in revenue in 3 years before a successful exit, then built a chain of 28 healthcare clinics and sold the business to a publicly traded company. Following that acquisition, Stuart spent 3 years working alongside the CEO, helping lead the organization through a take-private transaction before participating in a nine-figure exit to a Fortune 10 company. Today, he's the lead investor behind an electrical services platform operating across 3 U.S. states, and has worked directly with owners through 1,800+ strategic advisory sessions.
A foundation and waterproofing contractor cut PPC ad spend to zero for 2 months to test what his sales team could do without it, and the test uncovered a tracking error that had been hiding his real return on ad spend the whole time.
A foundation repair company cut its Google Ads budget by $20,000 a month, moved the money to Angi, Yelp, and Facebook, and watched its revenue go from $215,000 to $522,000. The agency had been saying to spend more. Someone finally did the math instead.
