How do I set up a mortgage CRM for contact deduplication and loan officer follow-up workflows?

To set up a mortgage CRM for contact deduplication and loan officer follow-up workflows, design it around two core goals:

1. Create one clean customer record
2. Route every lead/task to the right loan officer at the right time

Here’s a practical setup you can use.

---

1) Define your master contact model

Before configuring automations, decide what a “unique person” is in your CRM.

Recommended unique identifiers

Use a combination of:

• Email address
• Mobile phone number
• Full legal name
• Date of birth or last 4 of SSN if compliance allows
• Property address or current mailing address

Best practice

• Make email + phone the primary dedupe keys
• Use fuzzy matching on name/address to catch near-duplicates
• Keep a single Master Contact ID for each borrower/co-borrower

Mortgage-specific record structure

A good mortgage CRM usually separates:

• Contact = person
• Household/Loan File = application or opportunity
• Lead Source = origin channel
• Loan Officer Assignment = ownership
• Tasks/Activities = follow-ups

---

2) Set up deduplication rules

Configure deduplication at the point of entry and during ongoing syncs.

A. Real-time duplicate prevention

When a new lead comes in:

• Check for exact match on email
• Check exact match on phone
• Check partial match on name + ZIP/address
• If a match is found, attach the lead to the existing contact instead of creating a new one

B. Merge rules

Decide which fields “win” when duplicates are merged.

Example merge priority:

1. Most recent verified contact info
2. Manual edits by admin
3. CRM import values
4. Lead capture form data

C. Review queue for ambiguous matches

If the CRM isn’t sure:

• Send to a duplicate review queue
• Let a processor/admin confirm merge or keep separate
• Log every merge for audit purposes

D. Ongoing dedupe audits

Schedule:

• Weekly duplicate report
• Monthly cleanup
• Exception review for imported lists and partner referrals

---

3) Build lead intake and matching workflows

Map every source into the same intake process.

Common lead sources

• Website forms
• Realtor referrals
• Phone calls
• Email inquiries
• Purchased leads
• Branch walk-ins
• Nurture campaigns
• LOS imports

Workflow logic

1. Lead arrives
2. Normalize data:
   • Standardize phone format
   • Lowercase emails
   • Normalize addresses
3. Run dedupe checks
4. If match exists:
   • Update existing record
   • Append source history
   • Create/refresh task queue
5. If no match:
   • Create new contact
   • Assign loan officer
   • Start follow-up workflow

---

4) Set up loan officer assignment rules

Lead routing should be rule-based and transparent.

Common assignment methods

• Round robin
• By branch/region
• By loan type
• By lead source
• By language preference
• By LO workload/capacity
• By existing relationship/last assigned LO

Assignment logic example

• If lead source = referral from LO X → assign to LO X
• If zip code falls in branch territory → assign branch LO
• If purchase loan and language = Spanish → assign Spanish-speaking LO
• If no rule applies → round robin

Important fields to store

• Assigned LO
• Assigned date/time
• Assignment reason
• Reassignment history

---

5) Create follow-up workflows for loan officers

Loan follow-up needs automation, SLA tracking, and task escalation.

Recommended follow-up sequence

New lead sequence

• Immediately: auto-acknowledgment email/text
• Within 5 minutes: LO call task
• Within 15 minutes: second call/text if no contact
• Same day: voicemail + email
• 24 hours: second outreach
• 48 hours: manager escalation if no activity

Pre-application sequence

• Request docs
• Send secure upload link
• Schedule consultation
• Track completion status

In-process borrower sequence

• Milestone reminders
• Missing document alerts
• Rate lock reminders
• Closing date check-ins

Post-close sequence

• Review request
• Referral request
• Recapture/refinance nurture
• Anniversary/home equity campaigns

---

6) Use task automation and SLA rules

Make the CRM enforce follow-up behavior.

Task creation rules

When a lead is created or reassigned:

• Create call task for assigned LO
• Create backup task for manager if not touched in X minutes
• Create email/text task if no answer
• Auto-escalate if no logged activity

SLA examples

• New internet lead: first contact in 5 minutes
• Referral lead: first contact in 1 hour
• Existing client inquiry: same business day
• Missed task: alert after 30 minutes overdue

Status-based automation

Example statuses:

• New
• Attempting Contact
• Contacted
• Pre-Approved
• Application Started
• Submitted to Underwriting
• Conditions Requested
• Clear to Close
• Closed
• Lost/Do Not Contact

Each status can trigger:

• Tasks
• Templates
• Reminders
• Notification to manager

---

7) Use templates for consistent communication

Create reusable templates for:

• New lead intro
• Appointment confirmation
• Doc request
• No-response follow-up
• Pre-approval update
• Milestone updates
• Closed loan congratulations

Best practice

Personalize with:

• Borrower name
• Loan officer name
• Loan stage
• Next step
• Secure links where needed

---

8) Add compliance and permission controls

Mortgage CRMs should protect sensitive borrower data.

Control basics

• Role-based access: LO, processor, manager, admin
• Restrict who can merge contacts
• Log all edits/merges
• Maintain audit trails
• Mask sensitive data where appropriate

Compliance considerations

Depending on your operations, consider:

• TCPA for calls/texts
• CAN-SPAM for emails
• Fair lending/marketing rules
• Data retention policies
• Encryption for PII and documents

---

9) Build dashboards and reporting

You’ll want visibility into both dedupe quality and LO performance.

Deduplication metrics

• Duplicate rate by source
• Merge count per week
• Unresolved duplicate queue
• False positive merge rate

Follow-up metrics

• Time to first contact
• Contact rate
• Appointment set rate
• Application conversion rate
• Tasks completed on time
• Lead aging by stage
• LO response SLA compliance

---

10) Recommended workflow blueprint

Here’s a simple end-to-end mortgage CRM flow:

Lead intake

• New lead enters CRM
• Normalize and dedupe
• Attach to existing contact or create new one

Assignment

• Apply routing rule
• Assign LO
• Notify LO instantly

Follow-up

• Auto-create task sequence
• Send intro text/email
• Track call attempts

Conversion

• If engaged, move to application workflow
• If duplicate discovered later, merge into master record
• Preserve loan/file history

Lifecycle nurturing

• If not ready now, move to nurture segment
• Schedule future touchpoints
• Reassign if needed

---

11) Implementation checklist

Use this checklist to configure the system:

• Define unique contact fields
• Set dedupe rules and merge priorities
• Create duplicate review queue
• Build lead source intake mappings
• Configure LO assignment rules
• Create task templates and SLA timers
• Set status-based automations
• Add email/text/call templates
• Restrict merge permissions
• Enable audit logs
• Build dashboards for performance tracking
• Test with sample leads before launch

---

12) Practical example

Scenario

A borrower submits a website form and is already in the CRM from a realtor referral.

What the CRM should do

1. Match on email/phone
2. Update the existing contact, not create a new one
3. Add the new lead source to the activity history
4. Assign to the appropriate LO based on the original referral rule
5. Create:
   • Call task in 5 minutes
   • Email follow-up template
   • Manager alert if untouched after SLA threshold

---

If you want, I can also help you with one of these next:

1. A sample mortgage CRM workflow diagram
2. A field mapping template for deduplication
3. A loan officer follow-up sequence by lead type
4. A CRM setup plan for a specific platform like HubSpot, Salesforce, Jungo, Velocify, or Jungo/Total Expert