How to track customer referrals (without a spreadsheet mess)
If you cannot tell who sent you a customer, you cannot thank them or know what referrals are worth. Here is how to track them without the mess.
The REFERX team · · 5 min read
Why tracking matters
Most owners know referrals are their best customers. Far fewer can say how many they got last month, or who sent them. That gap costs more than it seems.
First, you cannot thank the right person. A customer sends you a friend, the friend books, and nobody connects the two. The customer never hears a word. They figure you did not care, and they do not send anyone else.
Second, you cannot tell what referrals are worth. Without numbers, it is hard to decide how big a reward to offer, or whether to move money from ads into referrals. You end up guessing.
Tracking does not need to be fancy. It just needs to happen on every new customer.
Option 1: ask “how did you hear about us?”
The simplest method. Whoever answers the phone or the booking form asks every new customer how they found you. If they say a friend, ask for the friend’s name and write it down.
- Pros: free, works today, and catches referrals from people who never had a link or code.
- Cons: depends on someone remembering to ask. Customers forget, say “a friend” without a name, or get names slightly wrong. Two customers named Mike on the same street can cause real confusion.
Keep asking this question even if you use another method. It is a good backup.
Option 2: referral codes
Each customer gets a short code, like MARIA50, to give their friends. The friend mentions the code when they call or types it into a form.
- Pros: clearer than a name, easy to print on a card, and easy to say over the phone.
- Cons: the friend still has to remember the code and actually use it. Codes get lost, typed wrong, or shared on coupon sites by people who never met your customer.
Option 3: unique links
Each customer gets their own link. When a friend opens it and requests service, the referral is recorded on its own. Nobody has to remember a name or a code.
- Pros: the most accurate method. Easy for customers to forward by text. The friend lands on a page about your business, ready to book.
- Cons: you need a tool to create the links and record who used them. And a friend who skips the link and calls your main number will still need the “how did you hear about us?” question.
Option 4: a spreadsheet
A spreadsheet is not really a way to capture referrals. It is where you keep them once you know about them. Most small businesses start here, and that is fine.
- Pros: free, flexible, and you already know how to use it.
- Cons: someone has to type everything in. It is easy to forget to update a job from “quoted” to “won.” Rewards slip through the cracks. Past a handful of referrals a month, it tends to get messy.
What to track for every referral
Whatever method you use, record the same few things for each referral. This is enough to thank people, pay rewards on time, and see what referrals are worth.
- Who referred: name and phone number of the customer who sent them.
- Who was referred: the new customer’s name and contact details.
- Date: when the friend first got in touch.
- Job won or lost: and, if lost, a word on why.
- Job value: what the first job was worth.
- Reward: what you promised, and the date you sent it.
Date | Referred by | Referrer phone | New customer | New customer phone | Job type | Status (new / quoted / won / lost) | Job value | Reward owed | Reward sent (date) | Thanked? (Y/N) | Notes
Oct 3 | Maria Lopez | (555) 010-2233 | Tom Reed | (555) 010-4455 | Water heater install | Won | $2,400 | $75 gift card | Oct 6 | Y | Neighbor two doors down
Sort by status once a week. Anything marked “won” without a date in “Reward sent” needs attention.
How to tell if it’s working
Once you have a few months of data, look at four numbers. You do not need software for this. A calculator and your sheet are enough.
- Referrals per month: is the number going up as you ask more customers?
- Close rate: of the referred leads, how many booked? Many owners find referred leads close better than ad leads.
- Revenue: add up the job value of every won referral.
- Cost per customer: add up rewards and any tool costs, then divide by won referrals. Compare that to what a customer from ads costs you.
Here is an example. Say you got 12 referred leads in a quarter and 7 booked. You paid seven $75 rewards, so $525. Add a tool at $150 a month, and the total is $975, or about $139 per customer. If ads cost you $200 or more per customer, referrals are pulling their weight. These numbers are examples. Plug in your own.
Common mistakes
Most tracking problems come from a few habits. Fix these and the rest gets easier.
- Forgetting to ask. If “how did you hear about us?” is not part of every call, many referrals go unrecorded.
- Paying before the job closes. Pay when the referred job is won and done, not when a name comes in. Say so up front.
- Never thanking. A referral with no thank-you is often the last one you get from that customer.
- Letting the sheet go stale. A list nobody updates is worse than no list, because you trust numbers that are wrong.
- Tracking in three places. A notebook, a sheet, and your inbox means nothing is complete. Pick one home for it.
When to move past the spreadsheet
If you get a few referrals a month, a spreadsheet and a good habit will do. Once it grows, or once rewards start slipping, it is worth letting a tool do the record-keeping.
That is what REFERX is built for. It gives every customer their own link after each job, records who sent who on its own, tracks each job from lead to won, and sends the gift card when the job is won. Whatever you use, the goal is the same: know who sent each customer, and thank them every time.
Written by the REFERX team, run by owners Hayden Bird and Ryan Hales.