Lead source tracking spreadsheet local service teams can copy into a CRM or sheet

The sheet

Copy/paste lead source tracking columns

Create one row per inquiry. Keep customer notes short and avoid sensitive details; the goal is to see which sources create qualified conversations and booked work.

Date received | Lead source | Channel | Customer first name | City/area | Service requested | Urgency | First response time | First responder | Qualified? | Quote/estimate sent? | Follow-up stage | Booked? | Estimated value | Actual revenue | Lost reason | Next action | Owner | Notes

• Lead source: Google Business Profile, referral, website form, phone call, Yelp/Angi/Thumbtack, Facebook, repeat customer, paid ad, or other.
• Channel: call, voicemail, SMS, form, email, DM, marketplace message, or walk-in.
• First response time: under 5 minutes, under 1 hour, same day, next business day, or later.
• Follow-up stage: new, first reply sent, qualified, estimate sent, waiting, booked, closed-lost, or stop.

Weekly review questions

1. Which source produced the most qualified leads, not just the most inquiries?
2. Which source had the slowest first response time?
3. Which service type most often stalled after the estimate?
4. Which lost reasons point to a script, pricing, scheduling, or qualification issue?
5. Which one follow-up template should be improved before adding more ads?

Pair this with the free lead response ROI mini-calculator to estimate what faster response and cleaner follow-up could be worth.

AI prompt for a weekly source summary

Use AI only on non-sensitive summary rows. Remove customer names, addresses, phone numbers, payment details, health details, and private job notes before pasting.

You are helping a local service business review a weekly lead source tracking sheet. Use only the non-sensitive summary table below. Identify: (1) top qualified lead sources, (2) slow-response bottlenecks, (3) follow-up stages with the most stuck leads, (4) one script/process improvement to test next week, and (5) data fields that look inconsistent. Do not invent results. Ask for missing data when needed. Summary table: {paste anonymized rows or pivot summary}

Then turn the next test into a small workflow using the AI Lead Response Quickstart.

Stop rules and privacy notes

• Do not upload raw customer contact details to an AI tool unless your policy and customer agreements allow it.
• Do not let AI decide which leads are worth serving; use it to summarize records for human review.
• Do not overwrite the CRM with unverified AI classifications.
• Do not treat source volume as success if qualified rate, booked rate, or revenue is weak.
• Stop follow-up when the prospect says no, asks not to be contacted, or the job is no longer relevant.