Lead Tracking Spreadsheet for a Service Business

Why a spreadsheet beats memory and chat history

Most service businesses in the UAE and Saudi Arabia receive enquiries in three places at once: phone calls, WhatsApp chats and website forms. When someone asks "how many leads did Google bring last month?", the honest answer is often a guess. Chats scroll away, calls are forgotten and the sales person who remembers the details goes on leave.

A simple spreadsheet fixes that without buying software. It gives you one list where every enquiry has a source, a status and an outcome. It is also the missing half of ad reporting: the ad platform tells you what was clicked and counted, while your sheet tells you who was qualified, who received a quote and who became a customer. If you rely on the platform alone, read our notes on tracking calls and WhatsApp conversions as well.

The core columns, one row per enquiry

Create a tab named Leads and add these columns in this order. Keep the names short and use drop-down lists wherever the answer is a choice, because free text ruins later counts.

Column	What goes in it	Input type
Lead ID	Running number, e.g. L-0001	Auto or manual
Date received	Day the enquiry arrived	Date
Source	Google Ads, Google Maps profile, SEO, Meta ads, referral, direct	Drop-down
Campaign or page	Campaign name or landing page address	Drop-down or text
Channel	Call, WhatsApp, form, walk-in	Drop-down
Service	The service they asked for	Drop-down
Area	Emirate, city or district	Drop-down
Name and phone	Contact details (see privacy below)	Text
Status	Where the lead is now	Drop-down
Qualified	Yes, No or Unsure	Drop-down
Quote value	Amount quoted, if any	Number
Outcome	Won, Lost, Open	Drop-down
Lost reason	Price, timing, no reply, outside area, other	Drop-down
Owner	Who is handling it	Drop-down
Next action and date	What happens next and when	Text and date

Source deserves special care. Ask every caller or chatter "how did you find us?" if the tracking cannot tell. Cross-check with the numbers recorded by your ad account and your website analytics, because customers frequently mention the wrong source.

Statuses that mean something

A status list works only if every person on the team uses the same words for the same stage. Keep it short, define each entry, and do not invent new ones on the fly.

Status	Meaning	Typical time limit
New	Arrived, nobody has replied	Reply as soon as the team can; aim for the same working day
Contacted	First reply or call completed	Next step agreed within a few days
Qualified	Right service, area, need and ability to buy	Quote or visit scheduled
Quoted	Price or proposal sent	Follow up within a few days
Won	Customer confirmed the job	Record the value and date
Lost	Customer declined or went silent	Record the reason
Not a lead	Job seeker, vendor, wrong number, spam	Keep for source quality review

The time limits are suggestions for you to adapt to your business, not rules. What matters is that you set targets and look at them. See lead qualification questions for ways to decide what counts as qualified.

What counts as a qualified lead

Write your definition on the sheet, so everyone applies it equally. A practical test has four parts: the person asks for a service you offer, in an area you serve, with a need that matches your minimum job, and with a way to proceed (decision maker, budget range, or timing). A pure price-shopper who never shares details may be Unsure until you speak. A person asking for work is Not a lead.

Record qualification separately from outcome. A qualified lead may still be lost; that is normal. What you want to measure is how many qualified leads each channel produces and what they cost.

Cost per qualified lead: hypothetical numbers

The figures below are invented to show the calculation. They are not benchmarks and do not describe any client.

Source	Spend (AED)	Enquiries	Qualified	Won	Cost per enquiry	Cost per qualified lead
Google Search ads	6,000	60	24	8	100	250
Meta ads	3,000	45	9	2	67	333
Google Maps profile	0	20	12	5	0	0 (time not counted)
Referrals	0	10	8	6	0	0 (time not counted)

Look at what the table reveals. Meta looks cheaper per enquiry (about AED 67 against 100), but more of its enquiries are unqualified, so cost per qualified lead is higher (about 333 against 250). The raw click or message count would have pointed the wrong way. Cost per won job tells the next layer: 6,000 / 8 = AED 750 for Google, 3,000 / 2 = AED 1,500 for Meta, in this invented example. Remember that with few jobs, one extra win moves the number a lot; avoid big decisions on tiny samples. Our cost per lead calculator goes deeper on the formulas.

Summary tab and weekly review

Add a second tab called Summary and use counts by source and by week. Four formulas cover most needs: a count of leads per source and week, a count of qualified leads, a count of Won, and the sum of Quote value for Won. Pull ad spend from the ad account into a small table beside it and divide.

The 20-minute weekly review

1. Count last week's enquiries by source and channel.
2. Check how many are still New. Any older than your target means a process problem, not a marketing problem.
3. Count qualified leads and compute cost per qualified lead per source.
4. List the Lost reasons. "No reply" and "price" patterns tell you whether to change follow-up or the offer.
5. Pick one change for next week, and write it in the log with the date.

Share the monthly numbers in a format your owner or manager can read; our monthly marketing report outline shows one, and marketing KPIs for UAE service businesses explains which to watch.

Mistakes that spoil the data

• Free-text statuses. "Called", "called back", "will call" cannot be counted. Use drop-downs.
• Missing source. If half the rows say "unknown", your marketing review is blind.
• Counting duplicates. One person who calls twice and messages once is one lead. Search the phone number first.
• Deleting lost leads. They show which source wastes time.
• Updating monthly. By then nobody remembers. Update daily.
• Only the sales person sees it. The marketer needs read access to learn which campaigns bring customers. Slow replies are also a leak, so use the routine in our WhatsApp lead follow-up system.

Privacy and access

A lead sheet holds phone numbers and sometimes addresses and health or legal details. Treat it as sensitive: restrict editing to people who need it, avoid sharing the sheet by open link, remove people who leave the team, and keep sensitive notes out of it. For clinics, record only what is needed to schedule care, and follow your professional and local data rules. This is general guidance, not legal advice.

How we work at ZED

Our conversion tracking service page explains that we agree which actions count as conversions, give every call, WhatsApp and form button its own event, send those events to Google Ads and build a simple report with four numbers: enquiries, their sources, cost per enquiry and the page producing the most enquiries. Our landing page design page also lists optional offline outcomes such as qualified, quoted and won, and campaign comparison by cost per qualified enquiry. That is exactly what this sheet captures by hand. For the advertising side see our Google Ads service. We do not publish a price list; send your business details on WhatsApp and we reply with an initial plan.

Frequently asked questions

What columns should a lead tracking spreadsheet have?

At minimum: lead ID, date received, source, channel, service, area, contact, status, qualified yes or no, quote value, outcome, lost reason, owner, next action and its date. Use drop-down lists for source, channel, status and outcome so the data can be counted. Add columns only when you will actually review them.

Is a spreadsheet enough or do I need a CRM?

For a small service business a well-kept spreadsheet is usually enough at the beginning. The key is that someone updates it daily and that every row has a source and an outcome. Consider a CRM when several people share leads, volume grows, or you need automated reminders.

How do I calculate cost per qualified lead?

Divide the money you spent on a channel in a period by the number of qualified leads from that channel in the same period. For example, if you spent AED 6,000 and got 24 qualified leads, the cost is AED 250 each. These numbers are only an illustration. Use your own spend and your own definition of qualified.

How do I record a lead that calls and then messages on WhatsApp?

Search the phone number first, and add a note to the existing row instead of creating a new one. Keep the original source and date, and record the new contact in the notes. Counting one person several times inflates lead numbers and makes cost per lead look better than it is.

How often should I review the lead sheet?

Update it daily, review it weekly and summarise it monthly. The weekly review takes about 20 minutes: count leads by source, check unanswered leads, calculate cost per qualified lead, read lost reasons and choose one change. Monthly summaries help owners and managers see trends.

How do I know the source if the customer does not remember?

Combine methods: tracked phone numbers, WhatsApp click tracking, form fields that capture the page, and a simple question such as how did you find us. When methods disagree, trust tracked data first, and mark the row Unsure. Over time you will see which sources are consistently under-reported.

Is it safe to keep customer phone numbers in a shared sheet?

It can be, with care. Limit access to people who need it, do not share the sheet by open link, remove former staff, and keep sensitive details out of notes. If you handle health or legal enquiries, apply the stricter rules of your profession and local regulations. This is general guidance and not legal advice.