Electrician Lead Tracking Spreadsheet: Stop Losing Jobs to a Messy Notepad
How Many Calls Did You Miss This Week?
Be honest. If you're running an electrical contracting business and the answer is "I'm not sure," you're leaving money on the table. A lot of it.
The average independent electrician misses 8 to 15 calls per week because they're on a job site, under a house, or up a ladder when the phone rings. And when they call back, half those leads have already hired someone else.
The fix? It's not expensive software. It's not hiring a receptionist. It starts with one thing: a lead tracking spreadsheet that actually works.
Why Your Notepad Is Costing You €2,000/Month
Here's the math. Say you miss 10 calls a week. At a conservative 20% close rate on callbacks, that's 2 lost jobs per week. Average electrical job in France: €350. That's €700/week — €2,800/month — vanishing because you didn't have a system to track who called and whether you followed up.
And here's the brutal part: most electricians do call back. But they call once, leave a voicemail, and never follow up again. Studies show it takes 3 to 5 follow-ups to convert a warm lead. One call and you're out.
The Spreadsheet That Actually Works
You don't need a CRM. You need 6 columns in Google Sheets (free):
| Column | What to Put |
|--------|-------------|
| Date/Time | When the lead came in (auto-timestamp with Ctrl+;) |
| Name + Phone | Full name, number, best time to call |
| Source | Google, referral, Facebook, repeat customer |
| Job type | Emergency, estimate, maintenance, new install |
| Status | New → Contacted → Quoted → Won / Lost |
| Next follow-up | Date you'll call/email/text again |
That's it. Six columns. Takes 20 seconds to fill in.
The 3-Step System That Recovers 40% of Lost Leads
Step 1: Capture Every Lead (30 seconds)
When you miss a call, enter the name and number immediately. Don't wait until end of day — you'll forget. Keep the sheet open on your phone's Google Sheets app.
Step 2: The Triple Follow-Up
- **Hour 1:** Call back + leave voicemail with your name, company, and callback number
- **Hour 4:** Send SMS: "Hi [Name], this is [You] from [Company]. I got your missed call — available to discuss your electrical project. Call me back at [number]"
- **Day 3:** Final SMS: "Hi [Name], just checking if you still need an electrician. No pressure — just want to make sure you're taken care of."
Step 3: Learn Where You're Losing
At month's end, filter by "Source" and "Status." You'll see patterns:
- Are Facebook leads converting better than Google?
- Are you losing emergency calls because you respond too slowly?
- Which job types are worth pursuing and which are time-wasters?
What This Looks Like in Practice
Marc, an electrician in Toulouse, tracked his leads for one month using this exact spreadsheet. He discovered:
- **73 missed calls** — he thought it was maybe 20
- **28 jobs won** after implementing the triple follow-up (40% recovery rate)
- **€9,800 additional revenue** in 30 days
- **Best source:** Google Maps referrals (62% close rate)
The spreadsheet took him 5 minutes to set up.
When to Upgrade to a System
The spreadsheet works for shops doing 1–3 jobs per day. When you cross 5+ jobs/day and start hiring technicians, you need something automated — lead capture that texts customers back instantly, tracks follow-ups, and gives you a dashboard instead of a spreadsheet.
That's what the [Electrician Lead Recovery Toolkit](https://buy.stripe.com/...) does. It includes:
- Done-for-you follow-up SMS and email templates
- A Google Sheets template with the 6 columns pre-built + formulas
- A call-tracking log to audit missed opportunities weekly
€39. One-time. No subscription.
The Bottom Line
You're already missing calls. The question is whether you'll keep guessing how many — or start tracking them with a system that takes 20 seconds per lead and pays for itself in one recovered job.
Stop guessing. Start tracking.
*RevenuePatch.com — Lead Recovery Systems for Trades Businesses*
*Questions? hello@revenuepatch.com*