From a Raw Lead List to One Offer: A Worked Funnel (Example)

Stage 1: Acquire and clean (500 rows become 460)

Our example starts with 500 rows pulled from a county delinquent roll cross-referenced with parcel data — the raw material. Cleaning is unglamorous and decisive: standardize addresses, drop exact duplicates and parcels that are land-only or commercial (outside this investor's criteria), remove government and utility owners, flag the rows already marked sold or redeemed since the file was published. Forty rows die here — dead data that would have eaten postage and, worse, credibility (nothing marks an amateur like pitching a house the owner sold a year ago).

The cleaned 460 get enriched: owner mailing addresses checked against property addresses (absentee flag), phone and mailing data verified through lookup tools where lawful and appropriate, and each row scored by stack depth — how many distress signals it carries. The investor now has something the raw file never was: a prioritized queue, where the top of the list carries delinquency plus absentee ownership plus an aging property in a target zip, and the bottom carries a single weak signal.

Stage 2: Outreach in sequence (460 become conversations)

The campaign runs in the order the stack dictates: highest-scored owners first, a simple letter (who we are, we buy as-is in the area, one phone number), then a postcard, then a second letter referencing the tax situation plainly and respectfully. Phone calls, to verified numbers with consent-compliant practices, go to the top tier. In this example, the three mail touches and the call round produce 31 real responses — owners or family members who engage — of which 19 become genuine conversations about selling (the rest are cures, wrong numbers, not-interested, and two requests to never be contacted, honored immediately and permanently).

Do not grade this stage by its percentages; grade it by its tracking. Every response is logged with the owner's situation in their own words — the daughter handling a father's estate taxes, the landlord done with a distant rental, the owner who cured and wants to be left alone. Those notes are the funnel's memory. Stage 2's real product is not 19 conversations; it is 19 documented situations, of which a handful are ready now and the rest are timed follow-ups rather than dead ends.

Stage 3: Qualify and analyze (19 become 4)

Qualification is a conversation with a checklist: timeline, condition, occupancy, the tax amount and sale date, other liens or complications, and the price conversation — what they need, not what they hope. Most situations resolve out here, honorably: several owners cure with family help, a few are already listed with agents, two want retail prices for houses needing wholesale work, one property turns out to be entangled in a title problem the investor is not equipped to solve and is referred onward with the investor's notes. Four situations survive with real potential.

Those four get the full analytical treatment — drive-by and photo documentation, comp work to a defensible ARV, repair estimates by the tier method, and the offer math (MAO, less fee for the wholesale structure this example uses). Two of the four fail the math: the spread between the owner's floor and the MAO is not bridgeable by any honest structure. The investor tells both owners exactly that, shows them the numbers, and leaves the door open — one of them calls back seven weeks later in the fuller story, though our example ends before that. (In the real business, that call-back is not a footnote; it is a significant share of where deals come from, and it only happens to investors who showed their math on the way out.)

Stage 4: The offer (2 become 1)

Two offers go out, written, with proof of the math attached. One owner chooses a cash-buyer competitor whose higher headline price came with a longer, vaguer contract — a legitimate choice, and the investor's follow-up note schedules a check-in in case it falls through (fall-throughs are common enough that this single habit recovers real deals across a year). The other offer is accepted: an absentee owner, three years delinquent, who wanted the tax problem and the distant house gone in one signature. Contract signed at the analyzed price, earnest money deposited, title opened the same day.

The conversion, read backward: 500 rows → 460 clean → 31 responses → 19 conversations → 4 qualified → 2 offers → 1 signed contract. Read forward, every arrow is a place where process either happened or did not. The mail that was never sent, the call-back never made, the analysis rushed — each is a leak. This example's funnel is not impressive because of its ratios; funnels vary wildly by market and list quality. It is instructive because every stage is visible, countable, and therefore improvable — the investor now knows exactly which stage to work on next cycle (in this case, qualification speed, because two of the four analyses arrived after the owners had already talked to competitors).

What the funnel costs and what it teaches

The example campaign's cash costs are modest — printing, postage, lookup fees, and fuel for drive-bys — and its real cost is the investor's hours, which is why the stages are sequenced to spend expensive time (analysis, conversations) only on leads that survived the cheap stages. That sequencing is the entire economics of list work: cheap filters wide, expensive attention narrow.

Run your own list through the same accounting. Write the stage counts down. The list was never the asset, and now you can prove it to yourself: the asset is a conversion process you can count, cost, and improve — and unlike a list, a process does not expire when the county publishes next year's roll.

Replicating the funnel on a budget

Nothing in this walkthrough required expensive tooling, and the budget version is worth stating plainly. The list itself: county publications, often free or priced at copying cost. Cleaning: a spreadsheet, sorted and de-duplicated with patience. Lookups: the county's own records first, modest lookup tools second. Mail: a simple letter, printed and mailed in small batches matched to your follow-up capacity — because a campaign that generates calls you cannot return within a day burns the trust it just bought. Tracking: the same spreadsheet, with a status column and a next-action date, reviewed weekly without exception.

What cannot be budgeted away is the cadence. The funnel's conversions lived in the second and third touches, the call-backs, and the check-in with the owner who chose a competitor first. Those cost time and organization, not money, which is precisely why they are available to a beginner competing against funded operations: the funded shops buy bigger lists and work them thinner. Work a smaller list completely — every stage, every follow-up, every file note — and your 500-row funnel will outperform their 20,000-row blast in signed contracts more often than the spreadsheet prophets expect. Depth is the beginner's discount. Take it.