How to Track Insurance Lead Sources That Work

Most agents have a gut feeling about which lead sources work. That gut feeling is almost always wrong. The source you think is your best one usually isn't, and the source you've been quietly ignoring is often your highest closer. The only way to know which is which is to track it. Not in your head. In your CRM.

This training walks you through how to set up a lead source tracking system inside whatever CRM you already use. The goal is simple. Every dollar you spend on marketing should be tied to a number that tells you whether it worked. Every hour of free time you spend on referral coffee meetings should be tied to the same number. Without that, you're guessing. With it, you make every renewal cycle smarter than the last.

Here's why this matters. The average producing agent runs 3 to 5 active lead sources at any time. Maybe one is paid. Maybe one is referrals. Maybe one is a community event. Maybe one is your monthly email. The temptation is to keep all of them running because each one feels like it produces something. But producing something isn't the same as producing return. When you track properly, you almost always find that 1 or 2 of those sources are quietly carrying the others. You shut down the dead weight, double down on the winners, and your income goes up without working harder.

The fear most agents carry is that real tracking is going to be complicated. It isn't. A lead source tracking setup that works for a solo agent or a small agency takes about 90 minutes to build, and once it's built it runs in the background of every appointment you take.

Before any of the setup, 3 things you need to be honest about. First, lead source has to be captured at the moment of first contact, not reconstructed from memory 3 weeks later. If you wait, you'll guess, and your data will be useless. Second, every lead gets a source even if the answer is unknown. Unknown is its own category, and watching unknown shrink over time is a sign your intake is improving. Third, source is not the same as channel. A senior who heard about you from a friend who saw your Google Business Profile is a referral, not a search lead. Capture how they actually decided to call, not where they originally saw your name.

Now the setup. There are 4 parts to a working tracking system inside a CRM. The lead source field. The conversion stage stamps. The cost per source input. And the monthly review.

Start with the lead source field. Almost every CRM has a default field called Lead Source. Most agents either leave it blank or fill it in with whatever word comes to mind, and the data turns to mush. Fix this by replacing the free text default with a closed picklist. A picklist is a dropdown of exact, predefined values. Same options for every lead, every time. No typing. No variations.

Build your picklist with 5 to 7 categories that match how leads actually reach you. A workable starter list. Referral from client. Referral from professional. Google search or Google Business Profile. Local event or workshop. Direct mail. Paid online lead. Carrier supplied lead. And one called Other or Unknown for anything that doesn't fit. That's it. Resist the urge to make it longer. The shorter the picklist, the cleaner the data, the easier the monthly review.

If your CRM lets you make Lead Source a required field on the lead record, do that. Required fields force discipline. Optional fields get skipped. 80 percent of bad lead source data comes from leaving the field optional.

Once the source field is set up, add a second required field called Source Detail. This is a free text or short list that captures the specific within the category. If the source is Local event or workshop, source detail is the name of the workshop. If it's Referral from professional, source detail is the name of the partner. If it's Paid online lead, source detail is the specific vendor or campaign. The category tells you what kind of source. The detail tells you which one inside that category. Both numbers are useful in the monthly review.

Once your lead source field and source detail field are in place, the second piece is conversion stage tracking. A lead source by itself only tells you where the lead came from. What you actually need to know is how that source performs all the way through the funnel.

Your CRM should let you stamp every lead with the date it moves into each stage of your pipeline. At minimum, 4 stamps. The date the lead came in. The date the first appointment was set. The date the appointment actually happened. And the date the policy was placed. 4 time stamps on every lead, regardless of source.

Those 4 stamps unlock the only metrics that matter for source comparison. Lead to appointment rate. Appointment show rate. Appointment to close rate. Days from first contact to placed policy. When you can pull those 4 numbers per source, you can finally answer the question every agent has asked at some point. Is this source actually working, or am I just busy.

Set this up so the stamps happen automatically wherever your CRM allows it. Manual data entry is where lead tracking dies. If your CRM can trigger a date stamp when a lead status changes, use that feature. If it can't, build a 30 second checklist you run at the end of every appointment. Either way, stamps happen the day they happen, not at month end from memory.

The third piece is cost per source. This is where most agents quietly avoid the truth. You need to log every dollar spent on every source, and the easiest place to put that data is a single field on the source itself, not on the lead. If your CRM doesn't support that, keep a simple tracker that mirrors your picklist categories, with one row per source per month, and one column for spend.

What counts as cost. Direct mail and postage. Paid online leads. Carrier supplied leads if you paid for them. Workshop costs, including venue, food, and invitations. For referral sources, your time matters too. Assign your hourly opportunity cost to any meeting time. If you spend an hour a quarter with each of 5 referral partners, that's 5 hours a quarter at whatever your hour is worth. That lets you compare a referral relationship honestly to a paid lead source on a cost per acquisition basis.

The fourth piece is the monthly review, and this is what turns the system from a data exercise into a business decision tool. Once a month, on the same day every month, you sit down for 30 minutes with one report. Leads per source. Conversion rate per source. Cost per source. Cost per closed sale per source. 4 columns. One row per source.

The first time you run that report, you will be surprised. The source you thought was carrying you turns out to be average. A source you almost shut down turns out to have the best close rate. The paid lead vendor you've been complaining about is either cheaper per closed sale than you thought, or far more expensive. Either way, now you know.

Here's what running the full system looks like in practice. An agent set this up over a single weekend. She built a closed picklist with 7 categories, added a source detail field, set up 4 conversion stamps tied to her pipeline stages, and started a monthly spend tracker. Total setup time, just under 2 hours.

3 months later, she ran her first real review. Referrals were producing closed sales at about 45 dollars in time cost. Paid online leads were costing 260 dollars per closed sale. Direct mail sat at 110 dollars. And her local workshops, the ones she thought were too time intensive, were producing closed sales at 65 dollars apiece including venue and food.

Armed with that data, she made 3 decisions in one meeting. She doubled her workshop frequency from one a quarter to one a month. She cut her paid online lead spend in half and moved it into direct mail. And she set a target to add one new referral partner every month.

6 months later, her cost per closed sale across the book had dropped 30 percent and her volume was up. None of that came from working harder. It came from finally having the data to make calm, math based decisions.

Common mistakes to avoid. One, treating the system as optional. It collapses the first month somebody types the source field instead of using the picklist. Two, reviewing too often. Weekly is noise. Monthly is signal. Three, killing a source after one bad month. A source should underperform for 2 consecutive cycles before you cut it, because seasonality and small samples can make a strong source look weak in any one month.

Here's your action step today. Open your CRM and look at your Lead Source field. If it's free text, replace it with a closed picklist of 5 to 7 categories before you take another lead. Add a Source Detail field next to it. Make both required. That single change, made today, is the foundation of every report you'll run from here on. Everything else builds on it.

Download

Free text turns the data to mush. One agent types "referral," another types "Referral - John," another types "client referral," and now you cannot run a clean report. A closed picklist forces every lead into the same 5 to 7 categories every time, so the monthly review actually compares apples to apples. 80 percent of bad lead source data comes from leaving the field optional or open.

At minimum: the date the lead came in, the date the first appointment was set, the date the appointment actually happened, and the date the policy was placed. Those 4 dates unlock lead to appointment rate, appointment show rate, appointment to close rate, and days from first contact to placed policy. You cannot compare sources fairly without all 4.

Assign your hourly opportunity cost to any meeting time spent with referral partners. If you spend an hour a quarter with each of 5 referral partners, that is 5 hours a quarter at whatever your hour is worth. That converts referral relationships into a real cost per acquisition number you can compare honestly against paid leads, direct mail, and workshops.

Once a month, on the same day every month, for about 30 minutes. Weekly is noise because the sample is too small and seasonality dominates. Monthly is signal. The report has 4 columns: leads per source, conversion rate per source, cost per source, and cost per closed sale per source.

Let a source underperform for 2 consecutive monthly cycles before you cut it. Seasonality and small sample sizes can make a strong source look weak in any single month, and you do not want to kill a winner because of one slow cycle. 2 cycles in a row is the threshold that filters out noise.