Most agents treat their database like a digital junk drawer—contacts pile up, tags go stale, and by December nobody knows who's actually ready to transact. A proper year-end audit turns that mess into a pipeline. Done right, you'll enter January with 15–20 qualified conversations already teed up, not scrambling to resurrect cold leads from 2023.

This isn't about cleaning for the sake of tidiness. It's about identifying who moved, who refinanced, who's coming off a fixed rate in Q1, and who you've ignored for eight months despite them being in your A-tier. The process takes four to six hours spread over a week. The return is measurable: agents who run structured audits in December report 22–30% more January closings compared to those who don't, according to OREA's 2024 productivity benchmarks.

Segment Before You Scrub

Start by pulling your entire database into segments that reflect actual transaction likelihood. Most CRMs default to garbage categories like "Hot Lead" or "Past Client." Rebuild around timelines and triggers instead. Create segments for: clients whose mortgage terms renew in Q1 2026 (check your notes or pull from provincial land registry if you have access), past clients who closed 4–7 years ago (statistically due for a move), referral sources who sent you business in the last 18 months, and active listings in your farm area where the owner isn't your client but should be.

In Ontario, you can cross-reference Teranet data if you subscribe. In BC, use BC Assessment roll data to identify properties that changed hands in 2019–2021—those owners are entering the typical move window. Alberta agents can pull similar intel from Spin2 or your board's MLS tools. The goal is to move beyond "I think they might buy" into "Here's why they're statistically likely to transact in the next 90 days."

Purge the Dead Weight

Delete or archive anyone who hasn't responded to three consecutive touchpoints over 12 months and has no documented transaction intent. This includes leads from portals who never replied, open house sign-ins from 2022, and that guy who asked about condos in 2020 then ghosted. Keeping them inflates your numbers and dilutes your focus.

Exception: Don't delete past clients even if they're unresponsive. Move them to a "Past Client - Inactive" segment and set a single annual touchpoint. RECO's guidelines on record retention require you to keep transaction-related records for six years anyway, so there's no compliance risk in maintaining a minimal contact schedule.

For leads who are marginal—responded once or twice but never progressed—tag them "Nurture - Low Priority" and drop them into a quarterly email sequence. Don't waste manual outreach on them during your Q1 push. Your time in January needs to go to the top 20% of your database, which is typically 80–120 people if you're doing decent volume.

Update Contact Details and Transaction Data

Run through your A and B segments and verify phone numbers, emails, and property details. Use TrueCaller or a similar reverse lookup tool for numbers that bounce. For emails, send a quick "checking in" message and watch for bouncebacks. If you get a hard bounce, search LinkedIn or Facebook to find updated contact info—people change emails but rarely delete social profiles.

Update transaction histories: who bought what, when, at what price, and what their mortgage situation likely looks like now. If they bought in early 2021 with a five-year fixed at 1.79%, they're renewing in Q1 2026 into rates around 4.5–5.2%. That's a payment shock worth a conversation. If they bought in 2020 in a starter condo and now have two kids, they're a move-up candidate. Document this in your CRM's notes field with specific triggers: "Renewal Feb 2026 - payment +$780/mo" or "2 kids under 3 - likely outgrown 2bd condo."

For BC agents, remember that properties purchased before the speculation tax came into force in 2018 may now be subject to it if ownership changed. That's a conversation starter for out-of-province investors in your database. Ontario agents should note clients who bought pre-construction in 2020–2021 and are approaching occupancy in 2025—many will need bridge financing or will list their current place.

Assign Outreach Priority and Method

Rank your segments by likelihood to transact and assign outreach methods. Top tier gets a phone call in the first week of January. Second tier gets a personalized video message via BombBomb or Loom. Third tier gets a handwritten note or personalized email. Don't batch-and-blast your entire database with a generic "Happy New Year" email—it's noise.

Mortgage renewals in Q1: Phone call with a specific rate comparison and lender intro if they're not locked in yet
Past clients 5–7 years out: Video message asking if they've thought about their next move, mentioning specific market changes in their neighborhood
Referral sources: Handwritten note thanking them for 2025 business with a small gift card, plus a specific ask for Q1 introductions
Farm area non-clients: Personalized email with a recent sale comp in their building or street, offering a free valuation

Script these out in advance. Write five phone scripts, three video outlines, and two email templates. Test them on a few contacts in late December to see what lands. Adjust based on response rate before you scale in January.

Set Up Automated Follow-Up Sequences

For anyone who doesn't respond to your initial outreach, build a 90-day follow-up sequence in your CRM. This should include a mix of market updates relevant to their property type, neighborhood-specific news, and soft check-ins. Use your CRM's automation tools—Follow Up Boss, LionDesk, and kvCORE all handle this well if you take the time to set up the workflows.

Include at least one piece of value per touchpoint: a sold comp on their street, a new mortgage product that fits their profile, or a zoning change that affects their property. Avoid generic market reports. If you're sending something about interest rates, tie it to their specific renewal date or purchase timeline. If you're sending a sold comp, explain what it means for their equity position or sale strategy.

Run your audit now, finish by December 20th, and spend the last week of the year prepping your outreach materials. By January 6th you should have made contact with your top 50 people and have at least a dozen conversations scheduled. That's how you start the year with momentum instead of hoping the phone rings.