Past Client Database Cleanup for Real Estate: The 6 Fields to Audit

If your past-client list lives in an old CRM export, a brokerage spreadsheet and three agents' phones, past client database cleanup for real estate is the first job of this holiday season. A South Jersey team needs six fields it can trust before any message goes out: closing date, email, assigned agent, property and side, contact permission, and last real conversation. Every later automation reads those fields. Bad data does not just slow a system down. It sends the wrong message to the wrong person. This audit is step one of our real estate past client follow-up automation plan for spring 2027, and you have until November 23, 2026 to finish it. Here is what to check.

Why the audit comes before every other automation

Past clients are worth the effort. In a summary of the National Association of REALTORS survey of transactions from July 2024 to June 2025, Virginia REALTORS (2025) reports that 66% of sellers found their agent through a referral or used an agent they had worked with before. The same summary says 18% of buyers chose an agent they had worked with in the past.

Those are national numbers. They do not tell you your team's repeat rate, and we do not have it. They do say the people already in your list are a real source of next year's business, so it is worth being able to reach them correctly.

Here is what bad data does once a follow-up system is running:

• A closing date stored as text, or entered with the wrong year, sends a "happy anniversary" email in the wrong month.
• A missing agent means a client replies to a message and no one on your team owns the answer.
• A duplicate record means one person gets two copies of every email.
• A missing opt-out flag means someone who asked to stop hears from you again.

Each of these is cheaper to fix in a spreadsheet in October than after a send. That is why the audit opens this series. Nothing in the later steps works until these fields are right.

The date matters too. November 23, 2026 is the start of the season window we plan around. From October 8, 2026 that is about six and a half weeks, which is enough for an audit but not enough for a second attempt.

The six fields, and what clean looks like

These six fields are our recommendation, not an industry standard. We chose them because every follow-up we describe in this series, from anniversaries to a pre-spring check-in, needs each one. Your CRM may have dozens more columns. Ignore them for now.

The six fields a past-client follow-up system needs

Field	What clean looks like	Quick check
1. Closing date	A true date field, one per transaction, with a four-digit year	Sort oldest to newest and look for blanks, text entries and future dates
2. Primary email	One working address per person, lower-case, no typos	Filter for missing "@", spaces, and addresses shared by unrelated people
3. Assigned agent	One current agent, picked from a fixed list	Filter for blank, "TBD", or agents who have left
4. Property and side	Street address as closed, plus bought, sold or both	Check blanks, then confirm "both" is used only when it is true
5. Contact permission	A status: OK to email, unsubscribed, or do not contact, with a date	Compare against every unsubscribe list you have ever used
6. Last real conversation	A date and a note, from a call or reply, not an automated send	Sample 20 records and ask the agent if the date is right

Closing date and assigned agent: the two that break most often

Closing dates break because people type them. A column mixing "6/14/21", "June 2021" and "summer 2021" cannot drive a schedule. Convert everything to one date format, and when a day is unknown, mark the record for review rather than guessing the first of the month.

Agent assignment breaks because agents leave. If an agent has left your brokerage, the client still needs an owner. Decide as a team whether those clients go to the original agent's team lead, a rotation, or a shared inbox. Write that rule down, because the system will need it to route replies. If your team is also weighing how the CRM should route this, our custom real estate brokerage CRM work covers lead routing and agent follow-up in one place.

Email and permission: the two that protect your sender reputation

Mailbox providers watch how people react to your messages. Gmail Help (Google, retrieved October 2026) says to keep your user-reported spam rate below 0.1% and to prevent it from reaching 0.3% or higher. You cannot control every complaint. You can avoid mailing people who have already said no, and addresses you know are dead.

That is why permission gets its own field. The Federal Trade Commission's CAN-SPAM compliance guide (retrieved October 2026) says you must honor an opt-out request within 10 business days. Your email tool handles unsubscribes it sent, but not the ones that arrived as a reply or a phone call to an agent. Collect those into the field. For what the law requires of your team specifically, ask your attorney or broker of record.

Property, side and last conversation

The property address and side (bought, sold or both) let a message say something true. A seller and a buyer need different notes a year later. A client who did both should not get a "thinking of selling?" message the week after a closing.

The last-conversation date separates a client who talked to an agent in August from one nobody has spoken to in three years. Those two should not receive the same message. We ask for a human-entered date here on purpose. An automated email send is not a conversation.

A six-week audit plan to November 23, 2026

Run it in this order. Each step feeds the next, and the work that needs other people comes early.

1. Export everything, once (by about October 16). Pull past clients from your CRM, your transaction software, your email tool's list and any agent spreadsheets. Save the originals untouched in a folder and work on copies.
2. Merge and remove duplicates (by about October 23). Match on email first, then normalized phone, then address plus last name. Review matches by hand. Spouses often share an email and are two separate people.
3. Get agent assignments confirmed (by about October 30). Send each active agent their list and ask them to confirm, correct or release each client. This step takes the longest because it needs answers from people with listings to run.
4. Fix dates and addresses (by about November 6). Convert closing dates to real dates, then check addresses against your transaction files for the records that look wrong.
5. Check emails and permissions (by about November 13). Remove obvious bad addresses, merge every unsubscribe and do-not-contact source, and set the permission status for each record.
6. Freeze and sample (by about November 20). Stop editing. Pull 20 random records and verify all six fields against the actual file. If more than a couple fail, go back a step.

These dates are a suggested pace, not a promise about your list. A 300-record list and a 3,000-record list will not move at the same speed. Once the data is frozen, the follow-up logic we describe later, such as workflow automation with human approval steps, has something stable to read.

What to do with records that fail

You will not fix every record by November 23. Sort failures into three groups so the list is still usable.

• Ready: all six fields pass. These go into the first sends.
• Fixable: one or two fields are missing, usually the agent or the last-conversation date. Keep them out of automated sends until an agent confirms.
• Parked: no working email, no reachable contact, or a permission problem. Leave them in the system with a clear status so they are not re-imported later as new contacts.

Never delete a do-not-contact record. Keep it, flagged. If it disappears, the next list import can quietly bring that person back.

It is better to message a smaller, correct list than a larger, uncertain one. A parked record costs you nothing. A wrong message to a client who trusted you with a home purchase costs a relationship.

What this audit will not tell you

We have not found a reliable, citable figure for how fast real estate contact data goes stale, so we are not quoting one. Your own sample in step six is a better guide than any average.

The audit also does not tell you whether past clients want to hear from you. It tells you whether you can reach the right person, from the right agent, with a true statement. Message content, timing and cadence come later in the series.

Texting is a separate question. Rules on text messages differ from email rules, and we do not give legal advice. Ask your attorney before any automated texting plan goes into the system.

Frequently Asked Questions

What fields should a real estate past client database have?

At minimum: a real closing date, a working primary email, one assigned agent, the property address and which side the client was on, a contact-permission status, and the date of the last real conversation. These six let a follow-up system decide who to message, when, from whom, and about what.

How long does a past client database cleanup take for a real estate team?

It depends on list size and how many agents have left. Exporting and merging records is quick. The slow part is agent assignments, because a person has to decide who owns each relationship. We suggest six weeks so nothing is rushed before the November 23, 2026 start of the holiday window.

Can I email past clients without asking them again?

That is a question for your attorney or broker of record, not us. As general information, the FTC's CAN-SPAM guide (retrieved October 2026) says you must honor an opt-out request within 10 business days. Whatever the rule, record each person's permission status in its own field.

How do I find duplicate past clients in a spreadsheet?

Match on email first, since it is the most unique field. Then match on phone number after stripping dashes and spaces, then on property address plus last name. Review matches by hand before merging, because spouses and family members often share an email or an address and are separate people.

Next step: turn a clean list into scheduled follow-up

If you finish the audit and want the list to drive scheduled, agent-owned messages from your own CRM, that is the work we do under CRM-connected email marketing automation. We build it around how your team already runs, and you own it under the project agreement. Start by exporting your list this week and counting how many records pass all six checks. That count is your real starting point for spring 2027.