How to Find Your Best Lead Sources With Your CRM

Last month I sat with a builder who was spending 400 pounds a month on a directory listing and almost nothing on the referral process that brought in two of his three biggest jobs last year. He had no idea that was the split. The directory felt productive because it produced a steady trickle of enquiries. Most of them went nowhere.

This is the trap. The lead source that feels busiest is rarely the one that pays best, and the only way to tell them apart is to look at what your CRM already knows.

Why the noisy source is usually the wrong one

Volume is loud. Quality is quiet. A channel that sends you 20 enquiries a month feels like it is working, even when 18 of those enquiries are tyre-kickers who never had the budget. Meanwhile the channel that sends you two serious buyers a month feels almost invisible.

Your gut weights leads by how recently and how often they arrive, not by whether they turned into money. That is exactly the bias your CRM data is there to correct.

If your leads currently arrive without a recorded source at all, fix that first. A required lead source field captured at the point of entry is the foundation everything else sits on.

The four numbers that rank a lead source

You do not need a data analyst. You need four numbers per source, all of which your CRM can give you.

MetricWhat it tells youHow to get it
Conversion rateWhat share of leads from this source become clientsWon deals divided by total leads from that source
Average deal valueHow big the jobs from this source tend to beTotal won revenue divided by number of won deals
Revenue per leadThe single best ranking numberConversion rate multiplied by average deal value
Time to closeHow fast and cheap a source is to workMedian days from enquiry to won

Revenue per lead is the one to rank by. It folds conversion rate and deal value into a single figure, which stops a high-volume, low-value channel from flattering itself on enquiry count alone.

Here is what that looks like for a small service business comparing three sources over a quarter:

Revenue Per Lead by Source (one quarter) 0 100 200 300 400 Revenue per lead (£) £370 Referrals 12 leads £190 Website form 28 leads £70 Directory 41 leads

The directory produced the most enquiries and the least money per lead. The referral channel produced a third as many leads and earned more than five times as much from each one. Enquiry count alone would have pointed the budget at exactly the wrong place.

How to pull this from your CRM in an afternoon

You can do the whole analysis with fields you probably already have, plus one or two you may need to add.

Step 1: Make sure every lead has a source

Add a single dropdown field called “Lead Source” to your contact or deal record and make it required. Keep the options short and mutually exclusive: referral, website form, directory, social, networking event, repeat client, and so on. A messy free-text field with 40 spellings of “word of mouth” is worse than no field at all.

Step 2: Tag the outcome and the value

You need to know which leads won, which lost, and what the won ones were worth. Most CRMs handle this through deal stage and a deal value field. If yours does not, a simple “won/lost” field and a “value” field on the contact will do. Clean records here matter, so if your data is patchy it is worth cleaning up your CRM data before you trust the numbers.

Step 3: Group by source and read off the four numbers

Filter or group your closed deals by lead source for a fixed window, ideally a full quarter. For each source, count total leads, count won deals, sum the won revenue, and note the median days to close. Drop those into the four-column table above. Most CRMs can build this as a saved report so you never have to do it by hand twice. It is one of the CRM reports worth running every month.

Step 4: Rank by revenue per lead, not by gut feel

Sort the table by revenue per lead, highest first. The order will often surprise you, and that surprise is the point. The source at the top deserves more budget, faster follow-up, and your best sales attention. The source at the bottom deserves a hard question about whether it earns its keep.

What to do once you know

Data on its own changes nothing. The value is in the three decisions it lets you make with confidence.

Shift spend toward what converts. If referrals earn five times more per lead than your directory listing, the directory budget is a candidate for cutting, and the referral process is a candidate for investing in. A structured client referral programme turns your best source from an accident into a system.

Follow up fastest where it matters most. Speed compounds with quality. The much-cited study by Oldroyd, McElheran and Elkington in Harvard Business Review ↗, which analysed thousands of inbound web leads, found that firms contacting a lead within an hour were nearly seven times likelier to have a meaningful conversation than those who waited even one more hour, and sixty times likelier than those who waited a day. Point your fastest response at your highest revenue-per-lead source.

Score new leads using what you have learned. If website-form leads from a particular service page convert at twice the rate of the rest, that is a scoring signal. Feed source quality into your lead scoring model so the pipeline ranks itself.

Common mistakes that break the analysis

Judging a source on too few leads

A source needs roughly 30 to 50 leads before its conversion rate stops swinging on a single deal. Below that, group small sources together or wait another quarter. Do not axe a channel on the back of five enquiries.

Forgetting the cost side

Revenue per lead ranks sources by what they earn, not by what they cost to acquire. A channel earning 190 pounds per lead at no cost beats one earning 370 pounds per lead that costs you 300 to acquire. Where you can attach a cost, do; where you cannot, at least note which channels eat your time.

Letting attribution rot

People forget to fill in the source field, and within a month a third of your leads say “unknown.” Make the field required, review it in your weekly CRM routine, and the data stays usable. Skip that, and you are back to guessing.

Treating the ranking as permanent

Lead sources drift. A referral spike after one big project fades; a new ad campaign matures over two quarters. Re-run the analysis every quarter rather than deciding once and never looking again.

Start this quarter

Add the lead source field today, make it required, and backfill the last three months from your inbox where you can. In three months you will have a clean quarter of data, a ranked list of sources, and a defensible answer to the most expensive question in your business: where do my best clients actually come from?

Stop funding the channel that feels busy. Fund the one your data proves is paying.

Frequently asked questions

What lead source data should I track in my CRM?

At a minimum, record where each lead came from (the source), the date they arrived, whether they converted, the value of the deal if they did, and how long it took. With those five fields you can calculate conversion rate, average deal value, and time to close for every source. Everything else is a refinement on top of those basics.

How many leads do I need before the data is meaningful?

Conversion rates start to settle once a source has produced around 30 to 50 leads. Below that, one or two unusual deals can swing the percentage wildly. If a source is too small to judge, group it with similar sources or wait another quarter before drawing conclusions. Do not kill a channel on the strength of five leads.

Should I judge lead sources on conversion rate or deal value?

Both, because they tell different stories. A source with a low conversion rate but high average deal value can easily out-earn a high-volume source full of small jobs. The metric that matters most is revenue per lead, which combines conversion rate and deal value into a single number you can rank sources by.

What is the fastest way to start without rebuilding my CRM?

Add a single 'Lead Source' dropdown field to your contact or deal record and make it required. Populate it for new leads from today, and backfill the last three months from memory or your inbox where you can. Within a quarter you will have enough clean data to see which sources are worth your time.

Enjoyed this article? Get more CRM tips straight to your inbox.

Comments

Join the conversation. Share your experience or ask a question below.

0/1000

No comments yet. Be the first to share your thoughts.