Simple Lead Tracking for a New Remodeler: What to Record From Day One
New remodeling company? Here's the simple lead log I'd start on day one: the fields to record, how to ask the source question, and what to review monthly.
Start with one spreadsheet row per prospective project, fifteen short columns, and one honest question on every first call. You can buy software later.
Tracking leads in your head right now? If you just started a remodeling company, anywhere in the U.S., that’s normal. The phone rings while you’re on a ladder, a referral texts you on a Saturday, and by Tuesday you can’t remember whether you called the basement lady back. No dashboard fixes that. A simple lead log does.
Here’s the log I’d start on day one: the fields worth recording, how to ask where a homeowner heard about you, how to move a lead from first call to signed contract, and the short monthly review that turns the log into decisions. At the end there’s a blank template you can copy.
Why log the first inquiry instead of waiting for a CRM?
Because the habit matters more than the tool, and you’re building the habit right now whether you mean to or not.
New owners tend to put tracking off until they “get a real system.” Meanwhile the early inquiries, the ones that tell you most about who’s calling and why, go unrecorded. Those first months are when you learn which towns call, which project types you get asked about, and which leads go nowhere. Lose that and you’ll pick software, and maybe spend marketing money, based on guesses.
There’s also a simpler reason. A lead you forget to call back is a job you didn’t lose to a competitor. You lost it to your own memory. A spreadsheet you open once a day stops that.
And it doesn’t have to be fancy. A Google Sheet, an Excel file, or a notebook you type up at night all work, as long as every inquiry gets a row and the row gets updated. Google doesn’t require any particular tool, and the fields below are my recommendation, not an official standard.
Which fields belong in the day-one lead spreadsheet?
Fifteen columns sounds like a lot until you see them. Most take a few words, and several you fill in only when the lead moves. I group them into three jobs.
Who and what
Date, a lead ID, private contact details, town or ZIP, project type, and rough scope. Enough to call them back and know what they want.
How they found you
Where they first heard about you, what they used to reach out, and any other influence they mention. This is the part most new outfits skip.
Where it stands
Qualified or not, current stage, next action, follow-up date, signed or not, and notes. This is what keeps leads from slipping.
Here’s what each one is for, and what to write in it.
Date
The day the inquiry came in. You’ll use it to spot slow follow-ups and to sort your monthly review.
Lead ID
A simple running number. It lets you talk about a lead without repeating a homeowner’s name, and it keeps rows straight if two clients share a last name.
Contact (private)
Name, phone, email. Keep this column private. If you ever share the log with a bookkeeper or a marketing helper, hide or remove it first.
Town or ZIP
Where the project is. This is how you’ll see whether leads come from the area your crew can realistically run, or from an hour past it.
Project and scope
Two columns: the type (kitchen, bath, basement, addition) and a few words of scope (“full gut,” “vanity and tile,” “permits needed”). It tells you what work you’re actually being asked for.
First heard, inquiry channel, other influence
Three columns, covered in the next section. In plain terms: the first place they heard your name, the way they got in touch, and any extra nudge along the way.
Qualified?
Yes, no, or unknown. Does the project fit your work, your area, and roughly your budget range? You’ll learn more about your pipeline from this one column than any other.
Stage, next action, follow-up date
Where the lead is now, what happens next, and when. “Bid sent / call to check questions / Thursday.” If a row has no next action and isn’t closed, it’s a lead you’re about to lose.
Signed? and notes
Yes or no, kept separate from stage so you can count signed work at a glance. Notes hold everything else: who referred them, why they passed, what to remember next time.
How should you ask “How did you hear about me?”
Ask on the first call, before you get into the project. People remember best right then, and once you’re talking about cabinets nobody wants to circle back.
Keep it plain. Something like: “Quick question before I ask about the job: how’d you hear about me?” Then let them answer. Don’t offer a menu, because people pick from menus. Write down what they say in their own words, then put it in a category later.
After the first answer, one follow-up catches what they didn’t think to mention: “Anything else that pointed you my way?” That’s when you hear about the yard sign on their street or the website they checked before calling.
- First heard: the first way they learned your name. “Neighbor used you for a bathroom.”
- Inquiry channel: what they used to reach you. “Called from Google,” “texted the number on the yard sign,” “filled out the website form.”
- Other influence: anything else they mention. “Saw the truck a few times.”
- If they don’t remember, write “unknown.” A real unknown is more useful than a guess.
For the categories themselves, a short list is enough: referral, yard sign, truck sighting, Google, social, paid ad, repeat client, and other or unknown. These aren’t an official Google list. They’re a practical set you can rename to match how your business gets work. Just don’t change them every month, or your monthly review stops comparing like with like.
Why two source columns and not one? Because homeowners rarely find a remodeler one way. A referral leads to a Google search, which leads to a call. If you keep only one column, you’ll credit whichever one you happened to write down, and you’ll draw the wrong conclusion about what’s working.
One row per project, not one row per call
This sounds minor and it’s the mistake that wrecks most early logs.
Say a homeowner calls about a kitchen, emails photos two days later, and calls again after you visit. If each contact gets its own row, your log shows three leads when you have one. Your monthly count looks busier than it is, and your source columns triple-count whatever channel they used.
So the rule is one row per prospective project. Update that row as things happen. Add the dates of later calls in notes if you want them.
The exception: if that same client comes back a year later for a bathroom, that’s a new project and a new row. Their source is “repeat client,” which is worth knowing on its own. Repeat work is a sign your past jobs are doing some of your marketing for you.
How do you track a lead from first call to signed contract?
Use a short set of stage labels and stick to them. These are the ones I’d start with. Each describes something that actually happened, not how hopeful you feel.
- New inquiryThey called, texted, or filled out a form. You have their details and the source answers.
- ContactedYou talked to them and understand the basic project.
- Consultation setYou’ve booked a time to see the project in person.
- Bid sentThey have your proposal. Not a sale yet.
- SignedA contract is signed. Mark the “Signed?” column yes.
- Lost or passedThey went another way, stopped responding, or you decided not to bid. Write a few words on why.
The “Qualified?” column sits alongside the stage. A homeowner can be “contacted” and “not qualified” at once, for example someone two counties outside your service area, or someone who only wanted a rough price over the phone.
What about that rough-price caller? I’d log them as contacted, mark qualified as “unknown” or “no” depending on the conversation, and give them a next action if you want one. Don’t skip the row. Price-only calls are part of your real pipeline, and if they pile up from one source, you’ll want to know.
Google’s own analytics tools draw a similar line. Google Analytics documents separate recommended events for generating a lead and for later converting a lead. You don’t need Google Analytics to run this log, but it’s a useful reminder: an inquiry and a signed project are different things, and they deserve different columns.
The five-minute habit that keeps the log alive
Most calls come in while you’re on a job site. You can’t stop to fill in fifteen columns with a crew waiting. So don’t try.
On the call, jot down three things anywhere: name, number, and how they heard about you. A notes app, the back of a material list, a text to yourself. Then once a day, at a set time, move those into the spreadsheet and fill in what you know.
End-of-day works for a lot of owner-operators. So does first thing in the morning, before the truck is loaded. Pick one and keep it. While you’re there, scan the follow-up column for anything due today. That’s the whole habit: capture fast, enter once a day, check follow-ups.
If someone else answers your phone, give them the same three-item rule and the same source question. The log only works if everyone records leads the same way.
What Google’s tools will and won’t record for you
New owners sometimes assume Google is already tracking their leads. It’s tracking some activity, but not the things your log needs.
Your Google Business Profile Performance report counts call-button clicks and website clicks. Search Console shows how your site shows up and gets clicked in Google Search. Google Analytics can label campaign traffic using utm_source, utm_medium, and utm_campaign tags, and record lead events if you set them up.
Whether the call was answered and what the homeowner wanted. Referrals, yard signs, and truck sightings. Whether the project fits your area and your work. Who’s following up and when. Which bids turned into signed contracts.
The key one for a new remodeler: a call in your Business Profile report is a click on the call button, not an answered conversation. If your report shows more calls than your log does, some of those clicks never turned into a real talk. Your log is the record of what actually happened.
Campaign tags are an optional next step. If you later send people to your site from an email, an ad, or a partner’s page, adding those tags to the link lets Google Analytics label where the visit came from. They only work on links people click. A truck wrap or a yard sign has no link, which is exactly why the source question still matters.
What this is based on: Google’s Business Profile Performance help page for what call and website metrics count; Google Analytics help on campaign URL builders; Google’s GA4 recommended events reference for lead events; and Google’s Search Console product page, each reviewed in October 2026. The lead-log fields, stage labels, and source categories in this article are my recommendations, not a Google standard.
What people get wrong about lead tracking for a new remodeler
These are the beliefs that keep new owners from tracking leads at all, or from tracking them in a way that’s useful.
“I need a CRM before I can track leads.”
You don’t. A spreadsheet with consistent columns, updated daily, does the job for a new outfit. A CRM is a tool for a habit you already have.
“Google is already tracking my leads.”
Not the way you need. Business Profile counts call-button clicks, and Search Console shows search clicks. Neither records an answered call, a referral, or a signed job.
“The spreadsheet will tell me the true source.”
It tells you what the homeowner said. That’s valuable, but it’s their memory, and many have more than one source. That’s why there are two source columns.
“A bid sent is basically a sale.”
It isn’t. Keep bid sent and signed as separate stages, or you’ll never see how many proposals stall.
“Only good leads belong in the log.”
Log every inquiry, including price shoppers and out-of-area calls. If one source keeps sending poor-fit leads, the log is how you find out.
“I’ll remember the details.”
Not after a month of job sites. Write it down the same day, even if it’s just three things.
When is a spreadsheet enough, and when is it becoming too hard to maintain?
I can’t give you a lead count where you should switch. It depends on how many people touch the log and how much follow-up your sales process needs. What I can give you is the signs to watch for.
One or two people enter leads. Follow-ups rarely slip. You can do the monthly review without fighting the file. Everyone uses the same columns and stage labels.
Several people edit it and rows conflict. Follow-ups get missed even though they’re in the sheet. You want reminders, call logging, or emails attached to a lead. Finding a lead takes longer than updating it.
When you do move to software, bring your columns with you. The fields that worked in the spreadsheet should exist in the CRM. And the source question doesn’t go away: a CRM records what you type into it, not how the homeowner found you.
What should you review at the end of each month?
Block half an hour on the last Friday of the month, or whatever day fits your schedule. Open the log and answer these, using only your own rows.
- How many new inquiries came in, and how many were qualified?
- Which first-heard sources started the qualified ones?
- Which towns or ZIP codes did the qualified leads come from? Any outside your service area?
- Which project types were people asking for, and are they the work you want?
- Which rows have no next action, or a follow-up date that passed? Deal with those first.
- How many bids went out, and how many signed? For the ones that didn’t, what do the notes say?
- Do your Business Profile call clicks roughly line up with the calls in your log? If not, why?
Then make one decision for next month. Maybe it’s calling every bid within three days. Maybe it’s asking past clients for referrals because that’s where your best leads started. Write the decision in a note at the top of the sheet so next month you can check whether you followed through.
Don’t expect patterns in month one or two. A new outfit doesn’t have many rows yet. The point early on is the habit. The patterns come as the rows pile up.
What blank lead-log template can you copy today?
Open a new spreadsheet and put these column names in the first row, one per column:
Date, Lead ID, Contact (private), Town/ZIP, Project, Scope, First Heard, Inquiry Channel, Other Influence, Qualified?, Stage, Next Action, Follow-up, Signed?, Notes
Then set up three quick lists so entries stay consistent:
- Source listFor First Heard and Inquiry Channel: referral, yard sign, truck sighting, Google, social, paid ad, repeat client, other/unknown. Rename to fit your business.
- Stage listNew inquiry, contacted, consultation set, bid sent, signed, lost or passed.
- Yes/no/unknownFor Qualified? and Signed?.
Freeze the top row, sort by Follow-up date when you open it each day, and keep the Contact column private. That’s the whole setup. There are no sample rows here on purpose: your first real lead is the first row.
Frequently asked questions
Should I make a separate row for every phone call or every prospective project?
Every prospective project. Multiple calls about the same kitchen stay one row, updated as it moves. A new project from the same client gets a new row.
What if the homeowner says they found me through two sources?
Record both. Put the first way they heard about you in First Heard, how they reached out in Inquiry Channel, and anything else in Other Influence.
Do I need Google Analytics before I can track my first leads?
No. Google Analytics measures website activity. Your lead log records what homeowners tell you and what happens next. You can add analytics and campaign tags later if you start sending traffic from links.
Which lead status should I use for someone who only asks for a rough price?
Log them as contacted, mark Qualified? as unknown or no based on the conversation, and add a next action if you plan to follow up. Don’t leave them out.
How can I tell whether the leads fit my service area?
Record the town or ZIP for every lead, then check it during your monthly review against the area your crew can realistically work. Mark out-of-area leads as not qualified.
At what point should I consider a CRM?
When the spreadsheet gets hard to keep current: several people editing, follow-ups slipping, or you need reminders and call logging. There’s no fixed lead count; it depends on how you sell.
About the Author
Tracking leads in your head right now?
Want help deciding what to track before you buy software? Tell me what kind of work you do, where you work, and how leads reach you today. I’ll tell you what I’d record first and what can wait until you’re busier. Prefer to talk first? Call me.