A cleaning business receives six inquiries on Monday. Two arrive through the website, three by phone, and one by a referral. By Friday, the owner remembers booking a job and sending a few estimates—but cannot confidently say which inquiries are still open or which marketing source produced the booking.

The missing piece is not necessarily new software. It is a consistent record of what happened to each real inquiry after the first contact. For an owner-operated service business, even a modest tracking system can make unanswered requests, unreturned estimates, and uncertain marketing results easier to investigate.

The goal is not to collect every possible metric. It is to answer three questions: Who needs a response? Which opportunities are moving toward scheduled work? And which sources are producing actual jobs rather than just activity?

Start with one record for each genuine inquiry

A website visit is not an inquiry. Neither is every click on a phone button. A usable lead record begins when someone actually contacts the business—or when a submitted request contains enough information to start a conversation.

Give each inquiry a unique reference number and record only the information you need to respond and decide whether the work fits. A practical starting set is:

  • Date received: When the call, message, or form request arrived.
  • Contact and response method: The name and contact details needed for the requested follow-up.
  • Requested service: For example, recurring house cleaning, drain repair, or lawn maintenance.
  • Service area: Enough location detail to determine whether the job falls within your coverage; a full address can wait if it is not yet needed.
  • Lead source: Website form, Google Business Profile, direct call, referral, paid ad, or unknown.
  • Current stage and owner: What happens next, and who is responsible for it.
  • Next action and due date: Call back, arrange an inspection, send a quote, or confirm a time.

Record one ongoing inquiry per job opportunity—not a new lead each time the same customer calls again. If the customer requests a genuinely separate job later, that may deserve a separate opportunity linked to the same customer.

This is also a privacy decision. The Federal Trade Commission's guidance on protecting personal information advises businesses to collect only information they need, restrict access, and avoid keeping sensitive data longer than necessary. A shared lead sheet should not become an unrestricted archive of customer documents or personal details.

Use stages that match how your business actually sells

A useful pipeline needs enough detail to show where work stalls, but not so many stages that nobody updates it. For many small service businesses, these six statuses are enough:

  1. New: An inquiry arrived, but no meaningful response has been completed.
  2. Contacted: Someone has exchanged information with the prospect and explained the next step.
  3. Qualified: The requested work appears to match the service, location, and capacity of the business.
  4. Estimate pending or sent: A visit or quote is being prepared, or the customer is reviewing a quote.
  5. Booked: The customer has accepted and a job or appointment is scheduled.
  6. Closed: The opportunity was declined, lost, canceled, or completed; record the specific outcome.

Keep Booked separate from Completed. A scheduled visit can be rescheduled or canceled. Likewise, an approved estimate is not necessarily revenue received. If you need operational and financial reporting, add explicit outcomes such as Completed, Invoiced, and Paid rather than treating a booking as the final sale.

Google Analytics uses a related distinction in its recommended lead-generation events: it separates generating a lead, qualifying or disqualifying it, working it, and converting or losing it. Those are optional analytics implementation events, not a requirement to install a CRM or create exactly the same stages in a spreadsheet. The underlying principle is useful: initial interest and a won customer are different outcomes.

Track the next action, not just the status

A lead marked Quote Sent can sit untouched for weeks. The record becomes much more useful when it says what someone must do next and when.

Consider a landscaping inquiry:

  • Monday: Request received for a retaining-wall estimate; initial reply sent.
  • Tuesday: Confirmed the project falls inside the service area; site visit scheduled.
  • Thursday: Walkthrough completed; quote preparation assigned to the owner.
  • Friday: Estimate sent; follow-up date recorded.
  • Following week: Customer accepts; work scheduled for a later date.

That sequence is illustrative, not a recommended universal follow-up timetable. What matters is that the next action is visible and the business can distinguish an active conversation from a forgotten request.

For a two-person operation, one person should be responsible for updating the status. If several employees can edit the record, agree on who changes it and when. An elaborate dashboard cannot make up for inconsistent entries.

Record lead sources without pretending you know more than you do

Lead source information is often messier than a marketing report suggests. A homeowner might discover a cleaning company on Google Maps, visit its website another day, and eventually call a saved phone number. Asking “How did you hear about us?” can help, but the answer may reflect only one step in the journey.

Use a small source list consistently. Separate Google Business Profile, organic website search, paid advertising, referral, and unknown only when you have a reasonable basis for the distinction. Never force a guess into a precise category.

The Google Business Profile performance documentation defines Calls as clicks on the profile's call button—not verified phone conversations or booked jobs. Likewise, a website form-submit event does not tell you whether the prospect was qualified. Keep platform activity figures separate from the records of actual conversations and jobs.

If the source is ambiguous, mark it Unknown or Multiple touchpoints reported. That is more useful than false attribution. Keep a short note explaining how you assigned each category so that the definitions stay stable from month to month.

A spreadsheet is enough until the workflow outgrows it

A basic lead sheet can be built with columns in this order:

  • Lead ID; received date; customer reference; requested service; general location.
  • Source; current status; assigned person; last contact date; next action; follow-up date.
  • Estimate amount, if a quote was issued; estimated job date; booked date; closed outcome.

Store detailed contact information securely and limit who can access the file. Avoid placing medical information, financial credentials, or unnecessary sensitive descriptions in open notes. Use a consistent customer reference when you need to connect a lead sheet with a separate scheduling or invoicing system.

You do not need to enter information twice simply to produce a prettier report. If your scheduling software already records inquiry sources, estimates, booking dates, and outcomes reliably, inspect those reports first. A CRM becomes more attractive when multiple people need handoffs, reminders are repeatedly missed, or the same information has to be retyped across different tools. The reason to switch should be an observable workflow problem—not a generic claim that every small business needs automation.

Review a few business outcomes each week

Start with counts that you can audit against actual records:

  • New inquiries: How many genuine opportunities arrived?
  • Qualified inquiries: How many matched the work the business could take?
  • Estimates sent: How many qualified opportunities reached a price or proposal stage?
  • Jobs booked: How many opportunities became scheduled work?
  • Jobs completed: How many booked jobs were actually performed?
  • Open actions overdue: How many promises to reply, quote, or confirm still need attention?

Use consistent denominators. For example, booked jobs divided by qualified inquiries describes something different from booked jobs divided by all incoming contacts. Neither should be labeled a universal conversion rate without explaining what was counted and when.

Imagine 20 incoming inquiries in one month. Five are outside the service area, three are duplicates or spam, and 12 are genuine, suitable opportunities. Of those 12, eight receive estimates and four book jobs. In this hypothetical example, the booked share is four out of 12 qualified inquiries, or about 33%. It would be misleading to say the business converted 20% of qualified leads, or that every missing booking reflects a website failure. The counts represent different stages.

Do not compare a newly received lead with a booking that might happen several weeks later as though the time windows match perfectly. For a clearer picture, review groups of inquiries received in the same period and check their outcomes later.

Know what the numbers cannot explain

A small lead sheet may reveal that many plumbing inquiries arrive after closing time, but it cannot by itself prove that changing website copy would fix missed calls. A low quote acceptance rate might reflect pricing, job fit, customer timing, competition, or incomplete follow-up. Treat the record as a way to find the next question, not as a machine that supplies a single cause.

The same restraint applies to marketing attribution. Better records can show which inquiries you identified as coming from a source. They cannot perfectly reconstruct every influence on a customer's decision, and they should not be described as proof that one marketing channel caused every booking.

Before buying a CRM, running more ads, or changing the website, spend two weeks making sure each new inquiry has an owner, a stage, and a next action. Then review which information was genuinely useful. Remove fields nobody needs, fix stages that people interpret differently, and investigate overdue opportunities.

A modest system that your team updates will usually be more informative than a sophisticated one with missing outcomes. The useful result is not a bigger lead count. It is knowing which customers still need help, which quotes need attention, and which inquiries became real work.

Sources and Further Reading