Four Things You Must Track in Your CRM and a Free CRM Replacement Google Sheet [Repost]

Most mortgage and real estate professionals live in the moment — skilled at handling what's directly in front of them and taking care of current clients. But even those with a robust CRM often aren't using it to its full potential, and some systems are so complex they barely get touched at all. One mortgage executive put enterprise CRM usage rates at under 10%. Practicing "no lead left behind" isn't complicated — it just requires discipline.

The real endgame of proper lead management is winning the long tail. In one recent month, half of closed purchase transactions came from leads more than a year old. Once a pipeline of 200 potential buyers is being worked consistently, the shift happens from salesperson to business owner. Four fields make up the core of that system.

Stage

Where is the client in the sales cycle? There are countless ways to track a funnel — keeping it simple and aligned with the loan process works best:

• Prospect — someone from a list who hasn't raised their hand yet

• Lead (New) — a hand-raiser not yet attempted

• Lead (Attempted) — contact attempted, no connection made

• Lead (Contacted) — connected, but still needs work

• Consult Set — a consultation is scheduled

• Prequal — financial information secured and reviewed

• Processing — application taken, loan in progress

• Client / Friends & Family — a past client or personal referral

• Long-Term Follow-Up — timing, capital, credit, or other reasons for a longer runway (generally 90+ days out)

• Disqualified — no longer a fit, for any reason

Focus

This is how priority gets set — a simple A through D scale works well as a marketing priority filter. "A" leads are the top priority and most likely to close; these calls are non-negotiable and worth tracking daily. "B" leads can slide a day if things get busy, but no further. "C" leads represent a real but longer-shot opportunity. "D" is reserved for leads that don't warrant active focus — still tracked, just not chased.

Target Close Date

When does the client want to be under contract? Factoring in the work still ahead and where they are in the buying cycle keeps the pipeline honest and prevents missing a seasonal window, like a "we're buying in the spring" comment made months earlier.

Next Step

The most important field of all: every active lead needs a defined next follow-up. It doesn't need to be elaborate — a text or a handwritten note works fine. This is what actually drives the week's activity and prevents opportunities from quietly slipping through.

Consistent tracking of these four fields is the practical foundation of a no-lead-left-behind discipline — and it doesn't require an expensive system, just a reliable one.