Lead Follow-Up Tracker
An inquiry can arrive through a form, a call or a referral. This simple tracker gives the team one place to record who is responsible and what happens next. It works as a starting spreadsheet or as a checklist for the fields you need in a CRM.

Use it with your own business.
Step 1
Open the CSV in your spreadsheet app, read the instruction rows and remove the clearly marked fictional example.
Step 2
Add each inquiry once, assign an owner and give every open lead a dated next action.
Step 3
Review the open rows regularly and record the actual outcome when the conversation closes.
Give every open inquiry an owner
A team inbox can show that a message arrived without showing who will answer it. Add one owner and a next action. “Sam will call to confirm the service address” is something the team can follow. “Follow up” is easy to leave untouched.
The downloadable file uses a lead reference rather than asking you to put a customer’s personal details into every row. Keep contact information in the system your business already uses for that purpose. A reference is enough to connect the tracker to the original conversation.
Use stages people understand
Start with a short list: New, Contact attempted, In conversation, Quote sent, Won, Lost and Not a fit. Change those stages if they do not describe your work. The important part is that two people reading the same row reach the same conclusion about what happens next.
Separate the date an inquiry arrived from the date of the next action. An old inquiry can still be active if the buyer has a later project date. A recent inquiry can already be closed. The notes field should explain the situation briefly without collecting unnecessary personal information.
Close the loop with marketing
Record the source as it is known, and use Unknown when it is not. Do not guess that every call came from the campaign that happened to be running. Record a campaign reference only when you have a reasonable way to connect it to the inquiry.
At review time, look for practical patterns. Are certain requests outside your service area? Are quotes waiting on one missing detail? Share those observations with the person managing the website and ads. The tracker is a working record, not a complete attribution system, and it does not replace the conversation with your sales team.
Make it a working document.
Download the template and adapt it for your business. Example rows are illustrations, not targets or benchmarks.
