Written premium, not quote requests
The ranking is on premium actually written, not on quotes counted, so a channel that brings fewer and larger policies rises.
Marketing attribution for personal lines agencies
Match bound policies and the commission they earn, renewal after renewal, to the campaigns that produced the policyholder.
$295,000 59% of $500,000 paid
The blind spot
A bound policy pays commission for as long as it renews. Judging a channel on the first year's commission understates it by most of its value.
What you get
The ranking is on premium actually written, not on quotes counted, so a channel that brings fewer and larger policies rises.
A quote in one quarter and a policy bound in the next are one match, and the earlier campaign is credited with the premium.
Nothing is inferred. A policy either matches a source exactly or it is reported as unattributed, and the unattributed share is printed rather than absorbed.
A worked example
Not impressions, not leads, not cost per click. Closed revenue, by the channel that produced it, for a period you choose — with the portion we could not trace shown rather than quietly shared out across your paid channels.
| Channel | Sales | Revenue | Share | % |
|---|---|---|---|---|
| Google Ads | 187 | $155,000 | 31% | |
| Meta Ads | 74 | $60,000 | 12% | |
| Referral partners | 96 | $80,000 | 16% | |
| Direct / Unknown | 249 | $205,000 | 41% |
Two channels can bind policies at the same cost while one produces households that renew for eight years and the other produces price-shoppers who leave at the first increase.
Because the match is on the policyholder, every renewal credits the original channel. That single change usually reorders which channel an agency considers its best acquisition source.
An auto policy that becomes auto plus home plus umbrella is worth several times the original, and the campaign that produced the household is never credited for the second and third policy.
Matching on the household means those cross-sales attribute correctly, and it usually reveals which channels produce households worth cross-selling to at all.
An agency quotes far more business than it writes. A household shopping a motor renewal collects four prices, the agency spends staff time on every one of them, and one in several actually binds. The advertising report counts the quote request. The commission statement counts the bind. Nobody routinely puts the two side by side channel by channel, which is exactly where the agency's real acquisition cost has been hiding all along. A cost per quote that looks excellent can sit on top of a bind rate that makes the channel unprofitable.
Uploading the quote log as the lead file and bound policies as the revenue file produces precisely that comparison. Each channel's bind rate becomes visible, and the quotes that never bound sit in the lead file as unmatched leads costing nothing against your allowance. A channel with a cheap quote and a poor bind rate can quite easily be the most expensive source in the agency once the staff time behind those quotes is taken into account. The staff time is the hidden cost in this business, and quote volume is the closest available proxy for it.
It is also the clearest way to see what price-comparison traffic is really doing. Those inquiries quote readily, bind at low premiums and tend to leave at the first increase, and the effect on a cost-per-quote report is flattering throughout. Measured on commission earned against quotes produced, the same source frequently sits at the bottom of the table, which is a reason to bid differently rather than an automatic reason to stop. Knowing which part of the book it is worth quoting is more useful than knowing what a quote costs.
An agency's ability to bind depends on which carriers it is appointed with and what those carriers currently want on the books. An appetite that tightens on coastal property, a carrier pausing new business in one state, a change to the underwriting questions on a submission: all of these move bind rates without a single thing changing in the advertising, and all of them hit some channels considerably harder than others. The advertising did not change, the appetite did, and only one of those shows up in an advertising report.
Because of that, a channel that stops performing is not automatically a channel that stopped working. Comparing a period with the same period a year earlier, and reading the bind rate rather than the bind count, separates a market change from a media change. A channel whose quote volume held steady while its bind rate collapsed is describing an underwriting problem, and cutting its budget would address something that was never the cause. The distinction takes one extra column to see and saves a budget decision that would have been wrong.
A carrier column, where the export carries one, sharpens this considerably. Mapped as Product / service, it shows commission by carrier with how much of each traces to a channel, and therefore how much of the agency's revenue is exposed to a single appetite decision taken somewhere else entirely. Agencies rarely have that view of themselves, and when they get it they tend to read it as a business risk question rather than a marketing one, which is a perfectly fair reading of it. Concentration in a single carrier is a risk an agency can manage once it can see the size of it.
Personal lines demand is driven by things happening inside a household: a house purchase, a new driver added to the policy, a move between states, a marriage, a claim that somebody else handled badly. None of them happen on a media schedule, and the inquiry arrives whenever the event does, which may be many months after whatever first put your agency's name in front of that household. That gap is why a campaign can look dead for a quarter and then produce steadily for the following year.
That makes the sources worth measuring rather unusual ones. A mortgage broker, a real estate agent, a car dealership, a removals firm: each of them meets households at the precise moment an event happens, and each of them can produce a list of names and contact details. Added to the lead file, each household tagged with its referrer, they rank on commission earned beside paid search, which prices the referral relationship properly. These sources cost lunches and reciprocity rather than media spend, so nobody has ever put a figure against them.
The gap between the introduction and the bind is exactly why these relationships are so hard to measure conventionally. There is no click to follow, the conversation may have happened weeks before, and the household arrives by telephone or walks through the door. Matching on the person rather than on a session makes that gap irrelevant, and it lets an agency decide which relationships deserve real investment and which have been running on habit. Habit is an expensive way to run a referral network, and it is the default in most agencies.
Why it matters
"We generated 400 leads" invites an argument. "This channel closed $186,400 last quarter, here is the reconciliation" ends one. The teams that can show closed revenue by channel are the teams that get the next increase approved, because they are asking with evidence rather than with conviction.
Killing spend is politically harder than adding it, because someone always owns the channel being cut. A number that reconciles to the sales export takes the argument out of the room — you are not overruling a colleague's judgment, you are reading the same ledger they are.
Platform-reported conversions do not reconcile to revenue, and eventually someone in finance notices. Reporting built from your own closed-sales export starts from the number finance already trusts, which is why it holds up when it is checked.
Because this reconciles exports rather than tracking visitors, it works on months that have already closed. You are not instrumenting now to learn something in ninety days — you can answer for last quarter today, which is usually when the question is being asked.
Honest answers
Which is why renewals and cross-sales must credit the original channel — that is where the value actually is.
Your agency management system is what matters, and a CSV of bound policies or commission is enough.
Only a contact detail, an amount and a date are needed. No policy numbers, no coverage detail, no claims data.
Pricing
The price here is the price on the invoice, plus any sales tax that applies — no per-call, per-minute or per-form fees. Growth usually fits personal lines agencies and brokerages — thirteen months of history to compare a month to the same month last year, and a PDF you can put in front of whoever holds the budget.
A business scaling ad spend
$49/mo
billed monthly
Questions
Anything else? Talk to us — a person answers, usually the same day.
Bound policies or commission: a policyholder email or phone, the amount, and a date.
Yes — a renewal credits the channel that produced the policyholder.
Yes, when the policy carries the same contact detail; it credits the channel that produced the household.
Yes, with a product column — and it is worth adding, because a blended average across them describes none of them.
Yes. A list of names and contact details is enough, and it lets you price the referral relationship against the ad budget.
Yes — client records are encrypted both in transit and at rest, kept inside your own workspace, and removable on request. A DPA is available.
Yes. Most personal lines agencies and brokerages begin with last year, because it is the cheapest way to find out whether the exercise tells them anything.
Policy or commission rows analyzed in a calendar month. Quote rows do not count.
Yes. Upload the quote log as the lead file and bound policies as the revenue file. Unbound quotes remain as unmatched leads and cost nothing against your allowance, so each channel's bind rate is visible.
Read the bind rate rather than the bind count, and compare against the same period a year earlier. Steady quote volume with a collapsing bind rate points at underwriting rather than at targeting.
Yes, if they can supply a list of names and contact details. Each referrer then ranks on commission earned beside the paid channels, which prices the relationship instead of assuming its value.
Commission, since it is what the agency earns. Each row carries one amount, so the report cannot hold premium beside it; ranking on premium makes a channel look better simply because rates moved during the period.
It is optional and worth including. It shows which channels feed which carriers, and therefore how much of the agency's revenue depends on a single appetite decision made somewhere else.
It matches on the same contact, so the returning commission credits the original channel again — even where a different source captured the return, because the earliest lead carrying that contact wins. The overlap is not reported separately.
Nearby
Match bound policies and the commission they earned to the inquiries and campaigns that produced them, across renewal cycles measured in years.
See how it worksMatch funded loans and commission to the inquiries and ads that produced them, across a cycle that runs weeks to months.
See how it worksMatch funded relationships and the fees they generate to the inquiries that produced them, across a decision measured in months and built on trust.
See how it worksWhere your sales already are
Export paid invoices and contacts, upload your ad and call sources beside them, and rank marketing on revenue rather than on opens.
What to exportExport prospects from Redtail, match them against new households and fees, and rank sources on the assets and revenue they actually produced.
What to exportFrom the blog
Before you can argue about attribution you have to agree what a sale is, when it happened, and how much it was worth. Most businesses have never had that conversation, which is why the marketing number and the finance number never match and everyone assumes somebody is wrong.
Read the articleCall tracking answers one question well: which campaign produced the ring. It has no view of what happened after the call ended, which is where the money is decided. This is what the gap costs, and how to close it without replacing the call tracker you already have.
Read the articleAdd up what your agencies and platforms claim and you have sold the same thing several times over. Nobody is lying. Here is why double counting is structural, how to run the reconciliation meeting, and what to change in the contracts so it stops recurring.
Read the articleStart today
Upload two exports and see your real revenue by channel in minutes. 14 days free, no card.