Track Lead Source and Lead Value in Your CRM So Reports Show What Pays
Your CRM can only tell you which lead sources pay if every lead carries a clean source and every won deal carries a dollar value. Add two source fields and one value field, make them required, and use one spelling for every source. Then a single report shows which sources bring in revenue, not just names.
Many owners know how many leads came in last month. Fewer can say which source produced the jobs that actually paid. This post shows a simple setup that closes that gap without new software.
Why a lead count is not enough
A lead count treats every inquiry the same. A form fill that never answers the phone counts the same as a referral that signs a large contract. When you spend time or money on the first kind, you lose ground without seeing it.
The fix is not a complex model. You need to record where each lead came from at the moment it arrives. You also need to record what the lead was worth once the deal closes. Everything else in the report follows from those two facts.
The three fields to add
Keep the setup small so your team will actually use it. Three fields cover most service businesses.
- Lead source. A dropdown with a short, fixed list. Examples: website form, phone call, referral, past client, walk-in, event, paid ad, social post.
- Lead source detail. A text or second dropdown field for the specifics. Examples: the campaign name, the event name or the name of the person who referred the lead.
- Deal value. The amount you expect at the quote stage, replaced by the amount you actually invoiced when the deal closes.
Make lead source required before a contact can be saved. If the field is optional, it will be empty on a large share of records within a month.
Use a dropdown, not free text
Free text invites variety. One person types "Website," another types "web form," and a third types "site." Your report then splits one source into three rows and hides its true size.
A dropdown gives each source one name. Review the list every quarter. Add a new choice only when you start a new kind of marketing, and retire choices you no longer use.
Capture the source automatically where you can
For web leads, the source can travel with the visitor. Google's analytics documentation describes campaign parameters you add to a link. The documentation says you should always use utm_source, utm_medium and utm_campaign when you add parameters to a URL. It also lists utm_term and utm_content as optional extras.
Your web form can store those values in hidden fields and pass them into the CRM with the new contact. The lead then arrives with its source already filled in. Your team does not have to ask or guess.
The same documentation makes a point that matters for your CRM. Parameter values are case sensitive, so utm_source=google is different from utm_source=Google. Google recommends a strict naming convention and lowercase as standard practice. Use the same rule in your CRM so values from links and values typed by staff match.
Write a one-page naming guide
Put your source names on a single page that anyone can read in a minute. List each approved source, its spelling and when to use it. Share it with whoever builds links, runs ads or enters leads by hand.
- Use lowercase only.
- Use hyphens, not spaces.
- Use one name per source, forever.
- Never reuse a campaign name for a different campaign.
Capture the source by hand when you must
Phone calls, walk-ins and referrals do not carry hidden fields. For these, build the question into your intake script. Ask, "How did you hear about us?" and enter the answer before the call ends.
Record the customer's own words in the detail field. A phrase such as "my neighbor told me" may sound vague, but it points to a referral. Over time, these notes show which past clients send you new work, which feeds your plan for keeping in touch with them.
Handle unknown sources honestly
Some leads will have no clear source. Add "unknown" as a real choice and use it. Do not assign these leads to your biggest source to make the report look tidy.
Watch the unknown share each month. If it climbs, something in your intake is broken. A form may have lost its hidden fields, or a busy team may be skipping the question.
Record value at two points
Deal value should change as the deal moves. At the quote stage, enter your best estimate. When the work is done and paid, replace it with the invoiced amount.
Keep the two numbers in separate fields if your CRM allows it. Then you can see how well your estimates match real results. A source with large quotes but small final invoices is worth a closer look.
Build the one report that matters
Once the fields are in place, build a single table. Each row is one lead source. The columns are below.
- Number of new leads in the period.
- Number of won deals.
- Win rate, which is won deals divided by leads.
- Total revenue from won deals.
- Average revenue per won deal.
- Average days from first contact to close.
Sort the table by total revenue. The top rows are the sources to protect. A source with many leads but a low win rate may need a better follow-up rule or a clearer offer. A source with few leads and a high average deal may deserve more effort.
Compare sources by revenue, not by volume
Volume is easy to see and often misleading. A source that sends fifty leads and two sales may cost more time than one that sends five leads and four sales. Read the revenue and win rate columns before you decide where to spend next month.
Give each source at least a quarter of data before you judge it. Small samples swing wildly. Two good weeks do not make a trend.
Keep source data clean over time
Source data decays if no one owns it. Assign one person to check it every month. The check takes about fifteen minutes.
- Filter for contacts created this month with an empty or unknown source.
- Fix any you can trace from emails, call notes or form records.
- Look for duplicate spellings in the source list and merge them.
- Confirm that the website form still sends its hidden fields by submitting a test lead.
Never overwrite the original source when a lead returns later. A past client who comes back through a new ad should keep the first source and gain a new entry for the latest touch. If your CRM has only one field, add a note so you do not lose the history.
A note on messaging past clients
Source data often leads you to past clients, and you may want to email them. The Federal Trade Commission's CAN-SPAM guide for business says the law covers all commercial email, with no exception for business-to-business messages. Its example includes a message to former customers announcing a new product line. Check your consent and opt-out records before you send, and keep the source field separate from the consent field so one never stands in for the other.
What to do this week
Add the three fields, make lead source required and write your one-page naming guide. Then set a date, thirty days from now, to run the source table for the first time. Even a first rough report will show you which sources deserve your attention and which ones only look busy.
Frequently asked questions
How many lead source fields does a small business CRM need?
Two is enough. One field holds the broad source, such as website form, referral or phone call. A second field holds the detail, such as the campaign name or the person who referred the lead. Add a third field for deal value so you can compare sources by revenue and not only by count.
Why do my lead source reports show the same source under several names?
People type the same source in different ways. Google's documentation notes that campaign parameter values are case sensitive, so Google and google count as different values. Use lowercase, a fixed list of choices and a dropdown field so each source has exactly one spelling.
What should I do with leads that have no known source?
Label them as unknown and count them. Do not guess. A growing unknown group tells you that your capture forms, phone intake or staff habits need work. Ask new leads how they found you, and record the answer in their own words.
Sources
Want to see your own follow-up gaps? See what AppWT CRM does or book a walkthrough.