Track insurance leads from first reply to written policy

Keep one opportunity record for each conversation

Use an agency-approved CRM, management system, or controlled worksheet. Give each opportunity a unique identifier and retain the original source. A second email in the same conversation should update the existing record rather than appear as another new lead. Who answers first, and who covers when that person is out, belongs in your reply ownership workflow.

Homefield provides the email thread and property context with qualified replies. The dashboard helps manage conversations and campaign analytics, while the agent is CC’d on every email. Your agency’s quoting and policy records remain important for confirming downstream outcomes.

Choose fields that answer operational questions

• Source and campaign: where the opportunity began and which message was used.
• Arrival date and first response: when it reached the agency and when the team acted.
• Assigned owner: the person accountable for the next step.
• Current stage: a defined state, used consistently by the team.
• Next action and due date: what should happen next and when.
• Quoted and written outcomes: dates and counts supported by agency records.
• Disposition: a useful reason when the opportunity stops progressing.

Collect only the information needed for your process. Keep sensitive application details and documents in approved systems; a shared marketing worksheet does not need to become a second application database. Compare these fields with everything a Homefield lead record includes.

Give each stage an entry rule

“Interested” and “quoted” mean different things. Define a stage by an observable event so two producers classify the same conversation the same way. A reply belongs in New reply only if it meets your written rule for what makes an insurance lead qualified; the follow-up workflow for insurance email leads covers what to say at each later stage.

Separate households from policies

One homeowner conversation may lead to a home policy and an auto policy. That is one acquired household and potentially two written policies. Report both counts rather than allowing a bundle to inflate the number of leads or new customers. Homefield bills home and auto leads per qualified reply, so a bundle is never counted as two leads.

For example, if ten homeowner conversations produce two new households and three policies, the household conversion is 20%. Policies per lead is 30%. Neither should be labeled simply “close rate” without defining its denominator. The home and auto lead workflow covers how to open and record that second conversation.

Review exceptions every week

Look first for unassigned replies, overdue next actions, and quotes with no follow-up plan. Then review why conversations were closed: wrong territory, outside carrier appetite, uncompetitive quote, homeowner postponed, or another documented reason.

Do not treat a valid lead that chose another option as the same thing as an invalid contact. Use the provider’s written qualification and dispute rules when evaluating credits.

Compare cohorts after equivalent time

Group opportunities by arrival period and source. A lead received yesterday has had less time to produce a policy than one received six weeks ago. Compare groups at the same age and show open opportunities separately.

The result is a practical source review: what arrived, what your team did, what it cost, and what became business. The cost-per-policy guide explains how to turn those records into consistent acquisition-cost calculations.

Copy a starter insurance lead tracking spreadsheet

A starter insurance lead tracking spreadsheet needs one row per homeowner conversation and about fifteen columns: where the lead came from, when it arrived and was answered, who owns it, its stage and next action, and the quoted and written outcomes your agency has confirmed.

Create the row once, when the reply arrives, and update it as the conversation moves. A second email from the same homeowner changes the existing row; it never adds a new one. Use dropdown lists for Source, Stage, and Disposition so every producer picks from the same values.

Illustrative layout and example values. Dana is a fictional homeowner, and this is not a customer record. Adapt the columns to your agency’s approved systems. Keep Timing signal and Confirmed renewal date as two separate columns: the first records what the lead arrived with, and the second records only what the homeowner actually told you.

See which columns a Homefield lead record fills in

When Homefield is the source, each qualified reply arrives with the homeowner’s name, replying email address, property address, estimated home value, timing signal, and the verbatim email thread, so the identity and source columns of your tracking sheet can be filled from the record instead of retyped.

A phone number may be included where available. Phone numbers, when present, are supplemental and are not represented as DNC-screened. An email reply is not blanket permission to call or text.

Homefield qualifies each reply and delivers the record within minutes to your Homefield dashboard. Qualified replies and lead records are also delivered to your inbox, Slack, and CRM, with CRM delivery through a webhook. The agent is CC’d on every email, so the thread in your records and the thread in the dashboard are the same conversation. See the reply dashboard.

Treat the timing signal as a starting point, not a fact about the policy. We use the home’s public-record closing anniversary to model a potential renewal window, then aim to email 30–45 days before it. This is an estimate, not a confirmed policy expiration date or access to carrier records. A mid-term rewrite or carrier change can move the actual renewal. Record it in the Timing signal column as delivered, and fill Confirmed renewal date only when the homeowner states one.

Your team still owns Owner, Stage, Next action, Quoted, Written, and Disposition. A qualified reply shows interest, not completed underwriting, an appointment, or a sale; the rest of the row is agency work that only your records can confirm.

Set the same pipeline stages up in your CRM

Any CRM or agency management system your agency has approved can run the same insurance lead pipeline as the spreadsheet: one pipeline per product line, the six stages from section 3 mapped one to one, and two fields required on every stage change, the owner and the next-action due date.

1. Create one pipeline per line. Name it for what you are tracking, such as “Home insurance, new households”.
2. Add the six stages exactly. New reply, Information requested, Ready to quote, Quote presented, Written, Closed or deferred. Do not add “Interested” as a stage; it describes the reply, not a step your team has completed.
3. Require Owner and Next action due. A record should not move to a new stage without both.
4. Add a Source picklist. Give each outside vendor its own value, separate from referrals, walk-ins, and your own marketing. Avoid a catch-all such as “Internet”.
5. Add four custom fields. Timing signal, Confirmed renewal date, Policies written, and New household.
6. Save two views. Unassigned (no owner) and Overdue (next action due before today).

If you connect Homefield’s CRM delivery through a webhook, the lead record reaches your CRM without retyping. How it maps into fields depends on your CRM’s setup, so check that Source, Arrived, and the thread land where the pipeline expects them before the first campaign sends.

Captive offices often confirm quotes and written policies in carrier-provided systems. Keep this pipeline as the source-level layer, and copy the quoted and written dates in once your carrier system confirms them. Homefield delivers lead records to your dashboard, inbox, Slack, or a CRM through a webhook; it does not connect to carrier quoting or policy systems.

Report monthly metrics with the denominator beside each

A monthly insurance lead report should show a short list of metrics, each printed with its numerator and denominator and calculated from the same sheet or CRM for every source, so a bundle, an open quote, or a young cohort cannot quietly change what a percentage means.

Run every metric per source and per arrival month. In the ten-conversation example in section 4, household conversion is 2 ÷ 10 = 20% and policies per lead is 3 ÷ 10 = 30%; both belong on the report, each with its label. For how to calculate and compare these rates without mixing definitions, use the insurance lead conversion rate calculation guide.

Lead cost per written policy uses lead spend only; agency labor and other operating costs are separate. Take lead spend from your invoices, check it against Homefield’s current per-lead pricing, and use the cost-per-policy guide from section 6 for the calculation.

Run a 15-minute weekly lead review

A weekly insurance lead review is a short, fixed meeting, such as 15 minutes every Monday, where the owner or office manager works through the same exception list in the same order, so stalled conversations are fixed while the homeowner is still waiting rather than discovered at month end.

1. Unassigned replies. Give each one an owner before the meeting ends.
2. Overdue next actions. Reschedule with a new date, or close the row with a reason.
3. Quotes with no follow-up date. Set one for every quote presented.
4. Rows with no first response. Find out why the reply has not been answered and who will answer it today.
5. Rows closed this week. Tally the dispositions: wrong territory, outside carrier appetite, uncompetitive quote, homeowner postponed, or another documented reason.
6. Possible invalid leads. Check the delivery date before the window closes. For Homefield leads, report a disputed lead within 7 days of delivery. Verified invalid leads are credited or removed.
7. Cohort snapshot. Compare this month’s leads with last month’s at the same age, with open rows shown separately.

The review is a process check, not a forecast. It shows where work is stuck and which source is producing which kind of conversation; it does not predict how many policies will follow. Keep the tally sheet from each week so the month-end report can show when a pattern started.

Avoid tracking mistakes that distort a source review

Most distorted lead source reviews come from a few recording habits rather than bad arithmetic, and each one can make a source look better or worse than it is before anyone reads the numbers. Check the sheet for these before the monthly report goes out.

• Counting a bundle twice. A home and auto sale from one homeowner is one lead, one acquired household, and two written policies.
• Comparing cohorts of different ages. A three-day-old group of leads has had less time than a six-week-old one.
• One column for “quoted or written”. Keep separate dates, or quotes will be reported as business.
• Treating a lost sale as an invalid lead. A valid homeowner who chose another option is a sales outcome, not a dispute.
• Writing a modeled window into the confirmed column. The Confirmed renewal date column holds only what the homeowner said.
• Storing application documents in the marketing sheet. Keep them in your agency’s approved systems.
• Ignoring a pattern of “wrong territory”. If that disposition keeps appearing, revisit your ZIP list with the insurance lead territory planning guide.

Questions about insurance lead tracking

More answers about territory, billing, and qualification are in Homefield’s frequently asked questions.