Lead source diagnosis

The Spreadsheet Column I Look For Before Calling A Lead Source Bad

A first-person operator guide to the spreadsheet column that helps separate a weak lead source from weak follow-up before a contractor buys replacement leads.

Main keyword: lead source

Long-tail keywords: lead source spreadsheet cleanup; contractor lead source follow-up column; bad lead source or bad follow-up.

Source notes for editor review:

• FTC advertising guidance emphasizes truthful, supportable claims and cautions businesses not to overstate what evidence proves: https://www.ftc.gov/business-guidance/resources/advertising-marketing-internet-rules-road
• Google Ads Local Services leads guidance shows that lead review requires looking at lead details and context, not just broad source labels: https://support.google.com/localservices/answer/6224841
• Google Ads call reporting guidance shows why call details and timing can matter when interpreting phone leads: https://support.google.com/google-ads/answer/2454052
• AI Cleanup Doctor service terms set no-guarantee boundaries for rankings, traffic, leads, revenue, booked-job outcomes, AI citations, and source-performance claims: https://cleanup.stoga.com/service-terms
• AI Cleanup Doctor First Scan Readiness explains the current no-password first-scan path: https://cleanup.stoga.com/first-scan-readiness

First-Person Short Answer

When a contractor says a lead source is bad, the first spreadsheet column I look for is not the source name.

It is the next-step column.

Sometimes it is called next step. Sometimes it is last meaningful touch. Sometimes it is follow-up note, owner note, second attempt, or status detail. The name matters less than the answer it gives:

What actually happened after first contact?

If the spreadsheet only says "Google," "LSA," "website," "referral," "Facebook," or "old estimate," the source name does not tell me enough. A lead source label can show where the inquiry started. It does not show whether the office replied, who owned the lead, whether the buyer was a fit, or whether anyone tried again.

Before calling a lead source bad, I want to see whether the sheet can show a real next step.

For a first AI Cleanup Doctor scan, this can usually start from a small redacted spreadsheet sample. No passwords, two-factor codes, full customer lists, private records, or full CRM exports are needed for the first look.

Start here:

https://cleanup.stoga.com/first-scan-readiness

The Column That Changes The Conversation

The column that changes the conversation is usually one of these:

• next step;
• last meaningful touch;
• second follow-up;
• owner note;
• lead outcome;
• current status detail;
• follow-up action;
• reason closed.

The best version is plain:

The better note does not prove the source is good. It simply makes the follow-up visible.

That visibility matters because "bad lead" can mean many different things:

• wrong service;
• outside service area;
• duplicate;
• no answer;
• price mismatch;
• late reply;
• no owner assigned;
• buyer asked a question and nobody answered;
• estimate sent but no second touch;
• office did follow up, but the next step was not recorded.

Those are not the same problem.

Scenario-Style Example, Not A Real Customer Claim

A contractor says a paid lead source is not worth it.

The spreadsheet has columns for date, name, phone, source, and status. Ten rows say "bad lead." The source column names the platform. The status column is too vague to explain what happened.

I would not start by arguing with the owner. I would ask for one more column:

What was the last meaningful touch?

After that column is added, the rows look different:

Now the conversation is no longer "the source is bad."

It becomes:

• Which rows are wrong-fit source problems?
• Which rows are follow-up ownership problems?
• Which rows are timing problems?
• Which rows are missing evidence?
• Which rows need a second action before the source is judged?

This is a scenario-style explanation, not an actual customer outcome record or performance claim.

Source Versus Follow-Up

A contractor can have a source problem and a follow-up problem at the same time.

The spreadsheet should help separate them.

This is why lead source spreadsheet cleanup is useful. It stops the owner from using one vague label for multiple different problems.

Minimum Spreadsheet Columns

Before calling a lead source bad, I want the spreadsheet to show at least:

If those columns are missing, the lead source may still be bad. But the spreadsheet cannot show it clearly yet.

The first cleanup is to make the evidence visible.

What To Do Before Buying More Leads

Before buying more leads from the same source, do this:

• Pull a small sample from the last 30 days.
• Remove names, phone numbers, emails, full addresses, payment details, and private notes.
• Add source, service type, service area, owner, first action, last meaningful touch, fit label, status, and next step.
• Separate wrong-service and outside-area rows from follow-up rows.
• Mark duplicate contacts.
• Mark rows with no owner.
• Mark rows with no second touch.
• Review rows that only say "bad lead" or "no answer."
• Decide what the team needs to clean before buying more volume.
• Hold any strong claim about the source until the notes are clearer.

This is not about defending a lead source.

It is about not making expensive decisions from vague notes.

What AI Cleanup Doctor Can Review First

For a first scan, AI Cleanup Doctor can often review:

• a public page or source path;
• a small redacted spreadsheet sample;
• the columns used today;
• the owner's lead-source question;
• examples of vague statuses;
• examples of next-step notes;
• the current follow-up owner pattern.

A first scan should not need:

• passwords;
• two-factor codes;
• full customer lists;
• complete CRM exports;
• call recordings;
• payment details;
• private customer records;
• platform admin access;
• sensitive legal, medical, insurance, or regulated details.

If a later review needs CRM, phone, ad, or call-tracking access, that request should be scoped after the first question is clear.

The Mistake I Try To Avoid

The mistake I try to avoid is treating "bad source" as a complete explanation.

It is not.

"Bad source" might be true. But it might also be a shortcut for:

• slow callback;
• no owner;
• no second touch;
• weak intake note;
• wrong service-area page;
• unclear form confirmation;
• duplicate lead counting;
• after-hours voicemail mismatch;
• old estimate never followed up;
• estimate sent with no next date.

Those problems need different fixes.

That is why the next-step column matters. It gives the owner a place to see what actually happened.

Lead Source Spreadsheet Cleanup Checklist

Use this before blaming a source or buying more leads:

• Copy a small sample into a separate sheet.
• Remove customer names, phone numbers, emails, full addresses, and private notes.
• Keep the source column.
• Add service type and service area.
• Add owner.
• Add first action.
• Add last meaningful touch.
• Add fit label.
• Add status.
• Add next step.
• Mark unknown fields honestly.
• Review whether the issue is source quality, follow-up ownership, response timing, duplicate counting, or missing evidence.

If the sheet cannot answer those questions, it is too early to make a confident source judgment.

FAQ

What spreadsheet column matters most before judging a lead source?

The next-step or last meaningful touch column. It shows what happened after first contact. Without it, the source name alone cannot explain whether the issue was source fit, response timing, ownership, duplicate counting, or missing follow-up.

Is a bad lead source ever really bad?

Yes, it can be. But a spreadsheet should separate wrong service, outside area, duplicates, no answer, late reply, no owner, and no next step before the source is judged. Otherwise "bad source" may hide a follow-up problem.

What if my sheet only has source and status?

Add owner, first action, last meaningful touch, fit label, and next step. You do not need a full CRM to start. A simple spreadsheet can show a lot once the right columns exist.

Should I send AI Cleanup Doctor the full spreadsheet?

No, not for the first scan. Send a small redacted sample or rewritten example that removes customer names, phone numbers, emails, full addresses, payment details, and private notes.

Can this prove a lead source is profitable?

No. A small spreadsheet sample cannot prove profitability, rankings, traffic, revenue, booked-job outcomes, AI citations, or source performance. It can show whether follow-up evidence is strong enough to inspect.

What if a lead source sends wrong-service calls?

Mark them clearly. Wrong-service rows may point to targeting, page wording, offer clarity, or source fit. They should not be mixed with no-answer or no-owner follow-up rows.

What if the team called once and the buyer did not answer?

Record that, then decide whether a second touch was needed. A single no-answer row is different from a wrong-service row. The next-step column helps separate those cases.

What should be reviewed before buying more leads?

Review source, service type, service area, owner, first action, last meaningful touch, fit label, status, and next step. Then decide whether the next cleanup is source targeting, page clarity, office response, or follow-up ownership.

Safe Next Step

Before calling a lead source bad, ask for the next-step column.

If it does not exist, that is the first cleanup.

Related guide on lead owner notes:

https://cleanup.stoga.com/blog/lead-owner-note-cleanup-before-contractor-blames-lead-source

Related guide on follow-up proof:

https://cleanup.stoga.com/blog/how-to-tell-if-contractor-leads-are-being-followed-up

First Scan Readiness:

https://cleanup.stoga.com/first-scan-readiness

Order path:

https://cleanup.stoga.com/order

Sample scan format:

https://cleanup.stoga.com/sample-audit

Prepared-only note: this Markdown draft is local preparation for AI Cleanup Doctor. It has not been converted to HTML, deployed, posted to Facebook, submitted to IndexNow/Bing/GSC, emailed, or published externally.