# From Website Inquiry to Follow-Up: Design a Simple Lead Tracking Workflow

https://ragipdiler.com/en/blog/digital-tools/inquiry-tracking-workflow/

By [Ragip Diler](https://ragipdiler.com/en/author/ragip-diler/) · 2026-11-17

**A simple lead tracking workflow turns every website inquiry into one record with one owner, one of 5 statuses, and a dated next action, starting the minute the form is submitted.** Aim for a first reply within 1 business hour and never later than the same business day, follow up at most twice on a quote with no answer, and review open records twice a day. A shared spreadsheet handles this well for up to about 20 new inquiries a week and 1 to 3 people. Inquiry volume, the number of people answering, and how many channels requests arrive through move those numbers.

Inquiries rarely vanish in one dramatic moment. They sit in an inbox under newer email, or wait for a callback that each person assumes someone else made. A tracking workflow makes the waiting visible.

## Capture the source and the customer request

Create the record when the inquiry arrives, not when someone gets around to replying, and capture where it came from and what the customer asked for in their own words. Those two facts decide who should answer and how fast.

| Field | Fictional example | Why it matters |
|---|---|---|
| Received | Nov. 17, 9:12 a.m. | Shows how long the inquiry has waited |
| Source | Website quote form, water heater page | Shows which pages and channels bring requests |
| Customer and contact | Sample Customer, phone and email | Links a later call or email to the same record |
| Request and location | Water heater not heating, ZIP 78704 | Tells you whether the job fits your services and area |
| Owner | Dana | Says who moves it forward |
| Status | Contacted | Shows the stage at a glance |
| Next action and due time | Send estimate range, today 3 p.m. | Explains why the record is still open |
| Outcome and reason | Won, or lost: price, no reply, out of area | Shows why inquiries are lost, from records instead of memory |

The cleaner the form, the cleaner the record. If your form asks for a ZIP code, a service, and one reply method, those fields arrive ready to file; if it is one free-text box, someone has to read and re-type every request. That is why it pays to [improve the inquiry form](/en/blog/customer-experience/quote-request-form/) before you design the tracking around it.

If you use Google Forms, you can send every response straight into [a Google Sheets spreadsheet](https://support.google.com/docs/answer/2917686?hl=en) and turn on [email notifications for new responses](https://support.google.com/docs/answer/139706?hl=en). The spreadsheet becomes the list of records and the notification tells the owner a new one arrived, with no re-typing in between.

## Assign ownership and a next action

Every open inquiry needs exactly one owner and exactly one next action with a due time; “the office is on it” means nobody is. The owner does not have to do every step, but they are answerable for the inquiry reaching the next one.

| Vague | Clear |
|---|---|
| “Dana’s handling it.” | “Dana sends the estimate range by 3 p.m. today.” |
| “Waiting on the customer.” | “If no reply by Friday, Dana calls once at 10 a.m.” |
| “Quote going out soon.” | “Luis emails the written quote by noon tomorrow.” |

The middle row matters most. Inquiries waiting on the customer are the easiest to lose, because nobody feels responsible for them. Even when the customer owes you an answer, the record should hold an action and a date on your side.

Decide the assignment rule before requests arrive: by service, by area, or by time of day. When you [map owners and handoffs](/en/blog/digital-tools/workflow-mapping-small-business/), write down who takes over when the owner is out, so a sick day does not freeze a week of inquiries.

## Define a small set of statuses

Five statuses cover most service businesses: New, Contacted, Quote sent, Scheduled, and Closed. Give each one an entry rule, so two people looking at the same inquiry always pick the same status.

| Status | Enters this status when | Next action belongs to |
|---|---|---|
| New | The inquiry arrives | Owner, first reply |
| Contacted | The first reply is sent or the first call happens | Owner, collects missing details |
| Quote sent | A price or price range is sent in writing | Owner, asks for a decision on a set date |
| Scheduled | A date is agreed with the customer | The person doing the work |
| Closed | The job is done or the inquiry is lost | Nobody; record the outcome and reason |

In a spreadsheet, make the status column a dropdown. Google Sheets dropdowns [reject entries that don’t match the list by default](https://support.google.com/docs/answer/186103?hl=en), so “quote sent,” “quoted,” and “sent Q” never pile up as three different statuses.

In a CRM, the same five statuses become pipeline stages. HubSpot, for example, lets you [add, rename, and reorder stages](https://knowledge.hubspot.com/object-settings/set-up-and-customize-pipelines) in a pipeline, while extra custom pipelines require a paid Starter, Professional, or Enterprise subscription. Start with the five stages either way; more stages mostly create more arguments about which one applies.

### Annotated lead record

When one inquiry is opened on a phone, it should read in this order: where it came from, who and what it is, who owns it, what stage it is in, and what happens next.

Fictional concept: Not a real business, customer, or shipped interface. The items on screen are not working buttons in this article.

| No | Mobile order, top to bottom | Content on screen | Design reason |
|---|---|---|---|
| 1 | Source | Website quote form · Nov. 17, 9:12 a.m.: Sent from the water heater page | Where and when the inquiry arrived comes first. A later call from the same person updates this record instead of opening a new one. |
| 2 | Customer and request | Sample Customer, ZIP 78704: Water heater not heating | Only what is needed to assess the job. The full address is asked for once a visit is booked. |
| 3 | Owner | Dana: Backup: Luis | One name. The backup is written down, so a day off does not leave the inquiry without an owner. |
| 4 | Status | Contacted: One of 5 statuses, picked from a list | Status is never free text, so everyone uses the same word for the same stage. |
| 5 | Next action | Send an estimate range: Today by 3 p.m. | One action and one time. Records past their time rise to the top of the daily review. |
| 6 | History | 9:40 a.m. Called, left voicemail, Dana: Every update with a time and a name | Whoever takes over sees where things stand without reading the whole email thread. |
| 7 | Fixed bar | Update status | Updating the record is one tap, so it happens right after the call rather than at the end of the day. |

### Fictional lead board

The board below shows one morning at a fictional three-person plumbing company. Each row is a job someone asked about, not an email thread.

| Received | Request and ZIP | Owner | Status | Next action |
|---|---|---|---|---|
| Nov. 17, 9:12 a.m. | Water heater not heating, 78704 | Dana | Contacted | Send estimate range, today 3 p.m. |
| Nov. 17, 8:05 a.m. | Bathroom repipe, 78745 | Luis | New | First reply, today 9:05 a.m. |
| Nov. 16, 4:40 p.m. | Garbage disposal replacement, 78702 | Dana | Quote sent | Ask for decision, Nov. 18, 10 a.m. |
| Nov. 15, 2:15 p.m. | Slow kitchen drain, 78704 | Luis | Scheduled | Service visit, Nov. 18, 8 a.m. |
| Nov. 14, 11:30 a.m. | Sprinkler repair, 78610 | Dana | Closed | Outside service area |

Sort the board by the next action’s due time, not by when the inquiry arrived. The second row is overdue, so it belongs at the top, even though it is newer than the first.

## Handle duplicates and unanswered inquiries

Match every new inquiry against existing records by phone number and email before creating one, and treat any record past its due time as unanswered. Those two rules catch the two most common ways inquiries get lost: split across records, or quietly overdue.

**Duplicates:** A customer who fills in the form and then calls ten minutes later is one inquiry. Add the call to the existing record’s history. A customer who asks about a second, different job gets a second record, because the two jobs can end differently.

**Unanswered inquiries:** Review open records at two fixed times a day, for example 9 a.m. and 3 p.m. Look first at records past their due time, then at anything still New.

**After hours:** An automatic reply is fine if it tells the truth: “We got your request. We reply between 8 a.m. and 5 p.m., Monday to Friday, and will contact you by 9 a.m. tomorrow.” It does not count as the first reply in your tracking.

**No answer from the customer:** Follow up at most twice after a quote, for example 2 and 7 days later, then close the record as “Lost: no reply.” Open records that will never move hide the ones that still can.

**Old records:** Do not keep personal details from lost inquiries indefinitely. The FTC’s guide for businesses advises keeping sensitive data [only as long as you have a business reason](https://www.ftc.gov/business-guidance/resources/protecting-personal-information-guide-business). Set a cleanup date, such as every quarter, and keep only the outcome and reason.

## Choose the simplest system that supports the process

Run the workflow in a shared spreadsheet first; move to a CRM when the process works but the spreadsheet starts to strain. Signs of strain: more than about 20 new inquiries a week, 4 or more people answering, inquiries spread across several inboxes, or reminders that have to send themselves.

| Situation | Shared spreadsheet | CRM or lead tracking tool |
|---|---|---|
| New inquiries per week | Up to about 20 | Regularly more than 20 |
| People answering | 1 to 3 | 4 or more |
| Channels | Form and one phone line | Several inboxes, chat, and calls |
| Reminders | The twice-daily review is enough | Reminders must send automatically |
| History | A short note per update | Every email and call attached to the record |

A tool does not fix an unclear process; it speeds up a clear one. Run the spreadsheet version for 4 weeks. If statuses and owners hold up for that long, you will know exactly what to ask a CRM for, and you can [choose the simplest suitable tool](/en/blog/digital-tools/custom-software-vs-existing-tools/) instead of the one with the longest feature list.

### Lead tracking setup

Copy this setup into your spreadsheet’s first tab and fill it in with everyone who answers inquiries.

```text
LEAD TRACKING SETUP

Columns: Received / Source / Customer and contact / Request and location /
Owner / Status / Next action and due time / Outcome and reason

Statuses (dropdown): New / Contacted / Quote sent / Scheduled / Closed
First reply target (business hours):
Assignment rule (by service, area, or time of day):
Backup owner when someone is out:
Daily review times:
Follow-ups after a quote (at most two, days after sending):
Duplicate check: match phone and email before creating a record
After-hours reply text:
Cleanup date for lost inquiries:
```

For a two-person team, the assignment rule can be as simple as “mornings to Dana, afternoons to Luis.” A rule that simple is never debated when an inquiry arrives.

**Discuss how your business handles incoming inquiries.** Share where requests arrive and who answers them today.

### Sources and basis

Sources checked on November 17, 2026. The reply targets, status count, follow-up count and timing, review times, weekly inquiry and team size thresholds, cleanup interval, and 4-week trial are my editorial recommendations, not measured benchmarks. No sales or conversion results are claimed. The plumbing company, customers, staff names, board, and mobile screen are fictional examples, not a client project, real customer data, or a test result. Product features and plans change; confirm them on the vendor’s site.


[Discuss how your business handles incoming inquiries](mailto:dilerragip@gmail.com?subject=Inquiry%20tracking)
