The data gap between advertising and sales

A stranger clicks a Google ad for an auto repair shop.

They call the shop.

The service advisor books them in for an inspection.

The inspection becomes a repair order.

Two days later the customer pays a $1,200 invoice.

It's simple, the ad brought in a new customer worth $1,200.

But if the owner asks their software how much revenue the ad produced something strange happens:

• Google Ads says: “We recorded a click.”
• The phone system says: “We recorded a call.”
• The shop management system says: “We created a repair order.”
• The accounting system says: “We issued an invoice.”

None of these systems know that they're talking about the same person.

So the business can’t answer a basic question: Did this ad actually make us money?

Why is something so obvious invisible inside the software that runs the business?

If you run advertising, there are always two sets of data.

Advertising systems know what happens before the lead. They see things like:

• impressions
• clicks
• form submissions
• phone call leads

Business systems know what happens after the lead. They see things like:

• enquiries
• qualified leads
• quotes
• jobs or appointments
• invoices and revenue

Both sides contain important information. But the systems usually don’t talk to each other.

So you can see how many leads came in. But you can’t see which ads produced real customers.

That’s the data gap.

Why the link disappears

On paper, connecting these systems sounds easy.

1. A person clicks an ad.
2. They become a lead.
3. They become a customer.

But in practice the chain breaks almost immediately.

Most businesses run their operations using several different tools:

• Fluent Forms or Typeform for website enquiries
• CallRail or WhatConverts for phone calls
• Jobber, Tekmetric, ServiceTitan or Monday for operations
• Xero or Quickbooks to manage the money

Each system does its job well. But none of them were designed to answer a question like: “Which advertising lead to this invoice?” And if you're trying to run profitable ads, it's a pretty important thing to know.

You might wonder why business software doesn’t solve this already. The reason is simple:

• Advertising systems are designed to measure marketing activity.
• Business systems are designed to manage operations and finances.

Neither system was designed to understand the full journey from ad click to revenue. Both sides have made some efforts in bridging the gap but it's not a high priority.

The most difficult part is matching the same person across systems

Imagine John Smith fills in a contact form.

Later a customer record for Mr. J. Smith appears in Jobber.

Then an invoice appears in QuickBooks for Smith Inc.

Are those three records about the same person?

Maybe.

The most reliable way to match records is through each system’s internal ID.

For example:

• Google assigns every ad click a unique GCLID
• Jobber assigns every client a unique internal ID
• Tekmetric assigns every customer a unique customer number

These IDs are generated automatically and users can’t change them, which makes them reliable for reporting.

Here’s what that looks like in practice.

1. Someone clicks a Google ad.
2. Google generates a click ID and sends it to the landing page.
3. The visitor fills in a Fluent Form on a WordPress landing page.
4. The form captures the click ID and sends it to Litiro.
5. Litiro stores that ID and creates a client record in Jobber using the lead’s contact details.
6. Jobber returns its internal client ID.

Now Litiro has Google's ID and Jobber's ID connected to the same person. When a quote or job is created in Jobber, Jobber sends Litiro the client ID.

Litiro matches it with the one already stored. We can send that to Google so Google optimises for leads who are more likely to contract, and we can track the actual value of sales from our ads.

Suddenly you can ask questions that were impossible before.

Instead of asking:

“How many leads did we get?”

You can ask:

• Which Google searches produce the most revenue?
• Which campaigns attract the best customers?
• Which ads generate enquiries that never turn into jobs?

And instead of guessing you can say things like

Our Google Ads for gutter installation generated 55 leads this month. 21 of them turned into jobs worth $84,576.

But this is impossible without the connection.

Unfortunately, the chain often breaks

Sometimes the internal ID never makes it from one system to another.

Phone calls are a good example.

Call tracking software might capture the advertising data and report something like:

The call from +16055551234 came from Google Ads.

But the service advisor answering the phone has to type the caller’s number into the shop management system. And that’s where things get messy.

They might type:

• 605-555-1234
• (605) 555-1234
• 605-555-1234 (work)

Now we’re trying to match numbers that look completely different. So before we even try to link the systems, we have to clean up the phone numbers and standardise them.

But what happens if the service advisor types in 555-555-5555 (cell)?

The link is broken.

But that's not a total disaster. You don't need perfect tracking for it to be useful.

If you can connect even half of your leads to real outcomes, you start to see patterns:

• You can see which campaigns produce real customers more often.
• You can see which searches rarely turn into jobs.

The goal isn’t perfect attribution. It’s enough signal to make better decisions.

Most businesses are making advertising decisions with almost no connection between marketing activity and real revenue.

They pause campaigns that produce good customers because the cost per click looks high.
They increase budgets on campaigns that generate lots of leads but very little revenue.

Eventually the advertising starts to feel like it isn’t working anymore.

But the real problem isn’t always the ads. Often it’s the missing data between the click and the sale.

Until the click is connected to the invoice, advertising only looks measurable. The number that actually matters stays hidden. Even getting the answer directionally right leads to better advertising decisions.

Related articles

106 quotes. 17 sales.

Why many RCICs don’t know if their Google Ads are profitable

The invisible Google Ads problem: zero-second calls

Why the phone rings but the workshop stays empty

Computer code rusts

The Lead Response Problem I’ve Been Trying to Solve Since 2007

Topics you'll find on this site