How to Clean Your Real Estate Contact Database

A real estate database grows in layers: open house sign-ins, website inquiries, past clients, referral partners, an export from an old CRM and a spreadsheet from a team you joined years ago. Over time it fills up with duplicates, dead addresses and people you can’t remember. Here’s a step-by-step clean-up, and the habits that keep your list healthy afterwards.

Why a clean list matters

• More of your email reaches the inbox. Mailbox providers such as Gmail and Outlook watch how often your email bounces and how often people mark it as spam. Sending to dead addresses and uninterested people makes it more likely that everyone’s copy lands in spam.
• The right email reaches the right person. A buyer who closed two years ago doesn’t need your first-time buyer guide. Accurate contact types and stages make segments trustworthy.
• You respect people’s choices. Someone who unsubscribed must never be emailed again, and a messy list is how that goes wrong.
• You may pay less. Many email tools charge for every stored contact. OneHive Mail charges only for active contacts, but a smaller, engaged list is cheaper and more effective anywhere.

Start with a backup

Before changing anything, export your whole database to a CSV file and keep it somewhere safe. If you merge the wrong two records or delete someone by mistake, you can look up what was there. In OneHive Mail you can export any filtered view of your contacts to CSV, so you can also save smaller lists, such as everyone tagged “Past client”, before you work on them.

Merge duplicates

Duplicates usually come from importing the same people from several places, people who use two email addresses, couples who share one address, and typos. Deal with them in this order:

1. Exact duplicates (the same email address twice). OneHive Mail keeps one contact per email address, and an import updates the existing contact instead of adding a second one. Blank cells in the file never wipe out details you already have.
2. The same person with two addresses. Decide which address they actually read; if you’re not sure, ask them. Move any notes, tags and preferences to the record you keep, then delete or archive the other one.
3. Couples and households. If both partners want your emails and have their own addresses, keep two contacts and link them as relationships, so their history stays together.
4. Typos such as “gmial.com”. Only correct an address if you can confirm it with the person; a guessed address belongs to someone else.

Deal with bounced addresses

A hard bounce means the address doesn’t exist or permanently refuses mail. A soft bounce is temporary, such as a full mailbox. Repeatedly sending to hard-bouncing addresses is one of the fastest ways to damage your sender reputation.

OneHive Mail takes addresses that hard-bounce out of every future send automatically, and they stop counting toward your plan. If you’re cleaning up a list from another tool, leave out addresses it marked as bounced or “cleaned”. If a client gives you a new address, use that one rather than retrying the old one.

Respect unsubscribes

This is the step that matters most. In Canada, CASL requires unsubscribe requests to take effect within 10 business days; in the US, CAN-SPAM sets the same 10-business-day limit. And once someone has opted out, a new import or a fresh copy of an old spreadsheet is not new permission.

• When you move from another tool, leave unsubscribed people out of the import file. Importing contacts into OneHive Mail means confirming that everyone in the file agreed to hear from you, so an unsubscribed person shouldn’t be in it.
• Don’t delete an opt-out to tidy up. In OneHive Mail, an unsubscribe, bounce or spam report stays on record even if the contact is deleted and added again later, so they’re never emailed by accident.
• Never re-subscribe someone yourself. If a person wants your emails again, they should sign up again, for example through your sign-up form.

Organise who’s left

With duplicates, bounces and opt-outs dealt with, make the rest of your database easy to use:

• Contact type: Buyer, Seller, Landlord, Tenant, Investor, Referral partner, Lawyer, Mortgage broker and so on. This is what lets you send a listing to buyers and a market update to homeowners.
• Pipeline stage: where each person is, from new lead to past client. Move closed clients to “Past client” so client-care emails reach them.
• Owner: on a team, assign every contact to the agent responsible for them.
• Tags and lists: decide a short, consistent set of tag names before you start (“Open house: 123 Main” or “Neighbourhood: Kitsilano”, not five spellings of the same thing). Tags can be renamed later.
• Consent: record how each person agreed to hear from you. If you rely on implied consent in Canada, note the date, because it runs out.
• Location: city and province or state make neighbourhood emails possible.

Once the details are in place, segments do the rest. A segment such as “contact type is Buyer AND city is Surrey” updates itself as contacts change, so your list stays organised without a spreadsheet. Our guide to lists, tags and segments explains when to use each.

Decide what to do with inactive contacts

Some people haven’t opened or clicked anything in a long time. Before you decide what to do with them, remember that open tracking isn’t precise: some mail apps load images automatically, which can record an “open” the person never made. Clicks and replies are stronger signals. OneHive Mail’s engagement score sums up the last 90 days of opens, clicks and activity as hot, warm or cold, which is a good place to start.

1. Ask first. Send the cold group a short, honest email: “Would you still like to hear from me?” with a clear button. Some will reply or click.
2. Archive the rest. In OneHive Mail, archived contacts keep their history, aren’t emailed and don’t count toward your plan. That’s often better than deleting someone you might need to look up later.
3. Keep CRM-only contacts where they belong. A lawyer or inspector you work with can stay in the CRM without receiving your marketing email; contacts kept only in the CRM don’t count toward your plan either.

Keep it clean

• Collect consent at the source. A sign-up form on your website, at your open houses and on your landing pages records the wording each person agreed to, so you never have to guess later.
• Import carefully. Map every column, including contact type, pipeline stage and tags, and leave out anyone who didn’t agree to hear from you. Never use a bought or scraped list.
• Check each report. After a campaign, look at bounces and unsubscribes. A sudden jump usually means a bad import or an email that went to the wrong people.
• Review once a quarter. Twenty minutes every few months, merging new duplicates, updating stages and archiving the cold, saves a weekend-long clean-up later.

A clean database makes every other email better, from your next Just Listed announcement to your monthly newsletter. See how contacts, stages and tags work together in OneHive Mail’s real estate CRM.