← Back to Case Studies
Attribution
Case Study
$273K in Revenue Attributed to "Phone Number." Sound Familiar?
A 15-minute data audit of one plumbing contractor's CRM reporting. Five attribution problems found before logging into Google Ads.

A plumbing contractor in California asked SearchLight to take a look at their reporting. They wanted to know what would change if they switched from CRM-native attribution to SearchLight's model. Their exact request: "We are interested in your team taking a look at our reporting and data, somewhat of a data audit to see the types of changes we can expect."

As part of our standard onboarding process, our team logged into their CRM and reviewed the performance reporting. Within 15 minutes, we identified five attribution problems that were hiding where their revenue actually came from.

Here is what their CRM was showing for the most recent 30-day period:

CRM CategoryLeadsBookedSold JobsRevenue
Phone Number20525968$273,090
Google10411537$97,629
Website949323$66,296
Search889229$73,260
Direct Web Traffic38367$62,094
Organic25265$25,849

The single largest source was "Phone Number" at $273K. That tells them nothing about what drove those leads, bookings, or sold jobs. The second largest was "Google," which isn't specific to paid, organic, GBP, or LSA. If you don't know which Google properties are driving your business, you can't make informed marketing decisions. The third was "Website," which is a conversion tool, not a source.

None of this tells the contractor which marketing channels are producing revenue and which are wasting budget. And this scenario is common.

Book a Demo

What We Found in 15 Minutes
Finding 01
$273K in Revenue Was Unattributable
The contractor's Google Business Profile was using their legacy phone number: the same number as their main business line. Every call that came through the GBP landed in the CRM as "Phone Number" with no source attribution. 205 leads and $273K in revenue had no marketing attribution at all. SearchLight recommends a dedicated tracking number on GBP so these leads are properly segmented. Google no longer penalizes Name/Address/Phone mismatches the way it did years ago. Tracking numbers on GBP are standard practice across the industry.
Finding 02
"Website" Is Not a Source
94 leads and $66K in revenue were attributed to "Website." But "Website" is a conversion tool, it's where the customer filled out a form. It doesn't tell you what drove them to the website in the first place. Was it Google Ads? Organic search? ChatGPT? A direct mail piece? SearchLight treats website forms as a conversion tool and attributes the lead to the upstream marketing source that generated the visit.
Finding 03
"Google" Was Four Channels in One
The CRM showed 104 leads and $97K from "Google." But "Google" blends paid search campaigns, organic results, Google Maps, and Local Service Ads into a single line. Without breaking these apart, there's no way to know if the Google Ads spend is producing revenue or if the organic listing is doing the heavy lifting. SearchLight connects directly to the Google Ads and LSA APIs and attributes each lead to the specific campaign and channel that generated it.
Finding 04
Campaign Names Were Wrong
The Google Ads campaign was showing in the CRM as a third-party agency label rather than the actual Google Ads campaign name. This means the contractor couldn't see which specific campaigns were producing booked jobs and revenue. SearchLight pulls campaign names directly from the Google Ads API, so reporting always reflects the actual campaign structure.
Finding 05
Last-Touch Was Hiding the Real Source
Most home services CRMs use last-touch attribution, meaning they credit the most recent interaction before the booking. If a customer first calls from a Google Ad, doesn't book, then calls back through the GBP listing a few days later, the CRM credits the job to GBP. The Google Ads campaign that drove the initial interest gets no credit. SearchLight uses a closest-sale attribution model: because we connect directly to all conversion tools and channels, we have every event in chronological order and can attribute the lead to the channel that drove the initial conversion in that sales cycle.
Why This Is So Common

This isn't a problem with any one CRM. Home services CRMs are built for dispatch, scheduling, and invoicing. They're not built to be marketing attribution engines. We've seen these same issues show up across every major platform in the industry.

But when a contractor makes marketing decisions based on CRM data, they're working with a distorted picture. Channels that generate first-touch interest (like Google Ads) without defined sales cycles get undercredited. Channels that happen to be the last touchpoint (like GBP or direct calls) get overcredited. And $273K in revenue sits in a bucket called "Phone Number" where nobody can act on it.

The Core Problem

This contractor was spending real money on Google Ads and couldn't see how much revenue it was producing. They had an online scheduling tool that wasn't connected to their attribution. Their GBP leads were completely invisible. And their CRM was using last-touch attribution, which systematically undercredits the channels that drive initial awareness. All of this was visible in 15 minutes and SearchLight's platform fixes this.

How SearchLight Solves This

Every lead attributed to a source. SearchLight connects to call tracking providers, web forms, chat tools, and online scheduling platforms. Every conversion event is captured with its upstream marketing source, not just the tool the customer used to make contact.

Channels separated, not blended. Google Ads, Google LSA, Google Business Profile, and Google Organic are tracked as separate channels with separate revenue attribution. You see which ones are producing and which ones aren't.

Campaign-level accuracy. SearchLight pulls campaign and keyword data directly from the Google Ads and LSA APIs. Revenue flows back to the specific campaign that generated the lead, not a generic label from a third-party tool.

Closest-sale attribution model. When a customer contacts a business multiple times during their sales cycle, SearchLight credits the channel that drove the initial conversion in that cycle. This gives you an accurate picture of which channels are generating demand, not just which ones happen to be the last touchpoint.

All in one dashboard with a dedicated and meticulous onboarding process. Every channel, every conversion tool, every campaign, with revenue mapped from lead through closed invoice. Month-over-month trends, channel comparisons, and more at your fingertips.

Book a Demo

Data Source
Independent plumbing contractor · Northern California · 30-day CRM performance snapshot · Findings from initial SearchLight data audit · Account details anonymized

Close Menu