A canvasser knocks 41 Birch Street at 3:40. The homeowner is interested in a quote but wants to talk to her husband first. The canvasser logs it as "41 Birch St — Linda — call after 6" with no phone number, because Linda said "you can just come back."
At 6:20 a setter works a purchased list. Row 212 is "L. MacNeil, 41 Birch Street, 902-555-0147." No note, no history. The setter dials, pitches from scratch, and Linda says, "Someone was already here today." Now there are two records for one house, two reps who think they own it, and a homeowner who just learned your company doesn't talk to itself.
Duplicates are not a data-entry nuisance. On a hybrid door and dial floor they cost you books, confuse attribution, and make your best leads feel like they're being spammed. The fix is not a heavier CRM. It's a short set of match rules, one owner per household, and a habit of searching before you create.
If you're still setting up the hybrid model itself, start with the door-to-door plus dial hybrid tracker. This post is narrower: how to keep one household as one record when address and phone arrive from different channels.
Why door and dial create duplicates
Door and dial teams collect different identifiers.
- Canvassers start with an address. They often get a first name, sometimes a phone number, rarely an email. Spelling is whatever was typed on a phone in the wind.
- Setters start with a phone number. Purchased and marketing lists have phone plus an address that may be formatted differently ("41 Birch St." vs "41 Birch Street Unit A").
- Inbound leads start with whatever the homeowner typed. A web form might have a cell number that doesn't match the landline on your list.
So the same household shows up with a different "key" depending on who touched it first. If your tracker only matches on exact phone, door leads slip through. If it only matches on exact address, list leads slip through. Most teams match on neither, and rely on someone remembering.
Storm and promo weeks make it worse. When the floor is flooded with seasonal reps and new lists, the duplicate rate climbs exactly when attribution matters most. We covered that pressure in how to protect attribution during a storm blitz.
The rule: one household, one record, one owner
Before you get into matching logic, agree on the principle every rep can repeat:
One household gets one record. That record has one owner and one next due date.
Everything else follows from this. When a canvasser and a setter both touch a house, they don't each make a lead. One of them updates the existing record and the other one sees the history before they act.
Ownership isn't permanent. It can move from canvasser to setter at a defined handoff point (for example, "anything not booked on the porch goes to the evening dial queue"). But at any given moment, one person owns the next attempt.
Match rules that actually work
You don't need fuzzy-matching software. You need a short, consistent checklist that a rep can do in 30 seconds before creating a new record.
1. Normalize phone numbers on entry
Strip spaces, dashes, brackets, and the leading country code. "(902) 555-0147", "902.555.0147", and "+1 902 555 0147" are the same number. If your tracker or sheet stores digits only, a phone search will find all three.
2. Normalize addresses to a short form
Agree on a house-number-plus-street-name format with standard abbreviations: "41 BIRCH ST". Drop "Street/St./st" variations, and put unit or apartment numbers in a separate field. A search for "41 Birch" should surface every version.
3. Search phone first, then address
Before creating anything:
- Search the phone number (if you have one).
- If no match, search house number plus street name.
- If still no match, search last name plus street name.
If any search hits, you update that record. You don't create a new one.
4. Treat a partial match as a match until proven otherwise
Same street and house number but a different name? It's probably a spouse, a tenant, or a typo. Add the new contact to the existing household and flag it, rather than making a second lead. A manager can split it later if it really is a different household (a duplex, a new owner).
5. Decide what wins when data conflicts
Write down which source wins for each field:
- Phone: the number the homeowner gave in person or inbound beats a list number.
- Name: whatever the homeowner said beats the list.
- Address: the canvasser's on-site address beats a list address.
- Notes: never overwrite; append with date and rep name.
Who owns the household after a collision
Duplicates are only half the problem. The other half is the argument afterward about whose lead it is. Set the ownership rules before it happens:
- First meaningful contact owns it. A real conversation (not a no-answer, not a hanger) sets the owner. A knock where the homeowner said "call me after six" counts. A list row that was never dialed doesn't.
- Dated promises transfer with the record. If the canvasser promised "call after 6," that due date belongs to whoever owns the evening dial queue, and that rep calls with the porch note in front of them.
- Booked-by credit follows the book, not the first touch. Whoever actually books the sit gets booked-by credit. If you want to reward the canvasser for the porch conversation, use a separate "sourced-by" field. See how to attribute books vs closes fairly for a clean split.
- Managers resolve disputes once a day. Not mid-shift in a group chat. Flag the record, keep dialing, review at end of day.
The 30-second pre-entry check
Print this or pin it in your team channel:
- Do I have a phone? Search it (digits only).
- No hit? Search house number and street.
- Still nothing? Search last name and street.
- Hit on any of them? Update, don't create. Add your note with today's date.
- Check the owner and the next due date before you call or knock.
- Nothing found? Create the record with the normalized phone and address, set yourself as owner, and set the next due.
Thirty seconds per record feels slow on a busy porch, so canvassers can log quickly and run the check at the end of a street. Setters should always check before dialing a row that looks fresh.
Weekly cleanup for the duplicates that slip through
Some duplicates will still happen. Catch them with a short weekly pass, ideally folded into your existing hygiene routine like the Friday call log cleanup:
- Sort by normalized phone and look for repeats.
- Sort by short address and look for repeats.
- Merge into the record with the most recent real conversation. Keep all notes, keep the earliest sourced-by, keep the current owner unless there's a reason to change it.
- Kill the stray due date on the losing record so it doesn't fire a duplicate callback on Monday.
- Track the count. If one rep or one list keeps producing duplicates, that's a coaching or list hygiene problem, not bad luck.
A floor that merges ten duplicates a week and coaches the cause will be down to two or three within a month.
What to tell reps (the short version)
If you only share one thing with the team, share this:
- Search before you create. Phone, then address, then name.
- One house, one record, one owner, one due date.
- Never overwrite notes. Add a dated line.
- If you're not sure who owns it, flag it and keep working. The manager settles it at end of day.
That's it. No new software required for the rules themselves.
Where a call tracker helps
Spreadsheets can run these rules, but they don't make them easy. You end up with tabs per rep, color-coding nobody agrees on, and a "master list" that's out of date by lunch.
A shared call tracker built for high-activity teams makes the search-before-create habit natural: one list of households, outcomes logged per attempt, an owner on every record, and due dates that show up in the right rep's queue. Dialed Sales is built for exactly that kind of floor (roofing, solar, HVAC, and other home-services teams running door and dial together), and Sara AI can summarize who touched which household this week so duplicates stand out.
If you want to start lighter, grab the free call log template. It already has outcome and next-due fields, so you can add a normalized phone column and a short-address column and run the match rules today.
When you're ready to stop merging spreadsheets, start a free trial of Dialed Sales and put every household, owner, and due date in one place.