How Do You Track Which Leads Turn Into Appointments and Sales?

By Bill Stilwell · Last reviewed October 16, 2026

The short answer

Give every lead one record that follows it from first contact to final payment. Record the source, whether an appointment was booked, whether the person showed up or canceled, whether you gave an estimate, whether it closed, how much revenue it brought in, and the margin after job costs. Then review it by source each month to see which marketing actually makes you money.

What this means

Website analytics tells you how many people called or filled out a form. It can’t tell you who paid. That lives in your customer records, your calendar, and your invoices. Appointment and sales tracking joins them up.

A made-up lawn care company, Green Acres Lawn Service, tracks each lead with these fields:

Field	Example
Lead date	March 3
Source and campaign	Google Business Profile (GBP), spring promo
Appointment booked	Yes, March 5
Showed, canceled, or no-show	Showed
Estimate amount	$1,200 for season
Closed	Yes, March 7
Revenue collected	$1,200
Direct job cost	$700
Margin	$500

This page covers two outline lines: 13.7.5 (appointment tracking) and 13.7.6 (sales tracking).

Why it matters

Cheap leads can be expensive. A source that brings in lots of leads but few sales may cost more per job than a source with fewer, better leads (see 20.10 Paid-Job Economics).
No-shows and cancellations cost money. Tracking them shows whether reminders, deposits, or booking rules need to change (see 17.3 Appointment Reminders).
Revenue isn’t profit. A source that brings big jobs with thin margins may not be worth it (see 24.4 Job Margin Review).
Good records support your books. The Internal Revenue Service (IRS) says good records help you track progress, prepare financial statements, and support what you report on your tax return.

Who this applies to

Every business that wants to know what its marketing returns. If you spend any money on ads, directories, or lead services, this is how you tell which ones to keep (see 20.11 Ad Budget and Stop Rule).

A very small business can do this in a spreadsheet. As volume grows, a customer relationship management (CRM) system makes it easier (see 15.1 Choosing a CRM).

How to do it

Pick one place for lead records. A spreadsheet or a CRM. Not three different places.
Set your stages. For example: new lead, contacted, appointment booked, appointment kept, estimate sent, won, lost. Use the stages from your sales pipeline (see 15.7 Sales Pipeline).
Capture source on day one. Every lead gets a source and campaign when it comes in, from the form, the call tracking number, or by asking “How did you hear about us?” (see 15.8 Lead-Source Tracking).
Track appointments. Record booked, kept, canceled, and no-show, with dates. Pull these from your booking tool if it can export or sync (see 13.4.5 Booking or Estimate Page).
Track estimates. Record the amount and date of each estimate.
Track the outcome. Won or lost, with the reason if lost. Common reasons: price, timing, chose a competitor, never responded.
Track revenue when it’s collected. Use invoice and payment records, not the estimate amount (see 10.7.5 Invoices).
Add margin. Subtract direct job costs like materials, labor, and subcontractors (see 7.1.8 Direct Delivery Cost).
Review monthly by source. For each source, total leads, appointments, show rate, close rate, revenue, and margin. Compare against what that source cost.
Send outcomes back to analytics if useful. Some businesses import closed sales into analytics or ad platforms so the tools learn which leads matter. Only do this if you understand the privacy side and have disclosed it.
Keep it clean. Merge duplicate records and fill in missing sources each week (see 15.5 Importing and Cleaning Records).

What proof to keep

The lead tracking sheet or CRM report with all stages
Monthly summaries by source: leads, appointments, shows, estimates, wins, revenue, and margin
Marketing spend by source for the same month
Notes on any changes made because of what the numbers showed

Store monthly summaries in your financial records folder.

Common mistakes

Using estimate amounts as revenue. Count money collected.
“Unknown” as the top source. If many leads have no source, fix how you capture it.
Counting appointments but not shows. A booked appointment that doesn’t happen isn’t a win.
Ignoring margin. A big job with almost no profit can look like a success on a revenue report.
Judging a source after two weeks. Some sources take longer to turn into sales. Look at a few months.
Leaving lost reasons blank. Knowing why you lose jobs is often more useful than knowing why you win them.

When to get help from a pro

A bookkeeper or certified public accountant (CPA): to make sure your revenue and job cost numbers match your books. Ask:

How should I record job costs so margin by job is accurate?
Can my bookkeeping software tag revenue by lead source?

A CRM or analytics specialist: if you need to connect your booking tool, CRM, and analytics. Ask:

Can these tools share lead source and outcome automatically?
What’s the simplest setup that gives me revenue by source?

Bill’s note

[Bill: add a short story or lesson here. For example, a client who learned their cheapest lead source was their least profitable, or how you track SiteSmarty leads from first contact to paid invoice.]

If you’d rather have this done for you, SiteSmarty sets up lead and sales tracking for local businesses.

How I did this for SiteSmarty

[Date I did this:]
[What I actually did, step by step: the tool and stages I use to track SiteSmarty leads, appointments, and sales]
[What it cost and how long it took:]
[What surprised me or what I’d do differently:]
[Screenshot or photo to add, with private info blurred: the lead tracking view with source, appointment, sale, and revenue columns]
[Result so far:]

Questions people ask

How do I track which leads turn into sales? Give every lead one record with its source, and update it as it moves through appointment, estimate, and won or lost, then add the revenue collected.

How do I track no-shows and cancellations? Record every booked appointment as kept, canceled, or no-show, with the date. Review the rates monthly.

Do I need a CRM? Not at first. A spreadsheet works for low volume. A CRM helps as leads and staff grow.

How do I know which marketing makes me money? Compare each source’s revenue and margin to what it cost over the same few months.

Should I count estimates as sales? No. Count a sale when the job is won, and count revenue when it’s collected.

Audit check

Question: Can the business show, for each lead source, how many leads became appointments, shows, estimates, wins, revenue, and margin?
Pass looks like: One lead record system. Source captured for nearly every lead. Appointment status, estimate, outcome, lost reason, revenue collected, and job cost recorded. Monthly summary by source compared with spend.
Fail looks like: Leads spread across inboxes and notebooks. Many unknown sources. Estimates counted as revenue. No show or no-show data. No margin.
Evidence to collect: The tracking sheet or CRM report, monthly source summaries, spend by source, and a sample of records traced to invoices.

Where this fits

Do this first: 13.7.1 Analytics Setup and Measurement Plan, 13.7.3 Form Tracking, 15.7 Sales Pipeline, 15.8 Lead-Source Tracking

Do this next: 13.8 Website Launch Checklist

Sources

Internal Revenue Service, "Recordkeeping" (checked October 16, 2026)
Google Analytics Help, "Mark events as key events" (checked October 16, 2026)

This page explains general rules and Bill's own experience. It is not legal, tax, or insurance advice. Talk to a qualified professional about your situation.