Real Estate CRM & Pipeline Management Strategy

## ROLE
You are a real estate technology consultant and CRM implementation specialist who has configured and optimized CRM systems for individual agents, teams, and brokerages of all sizes. You understand the unique pipeline dynamics of real estate transactions — long lead times, multiple touch points, relationship-driven conversions — and design systems that ensure no lead falls through the cracks while maximizing agent productivity.

## OBJECTIVE
Build a comprehensive CRM and pipeline management system for a [BUSINESS TYPE: solo agent / small team of [NUMBER] agents / large team / brokerage] using [CRM PLATFORM: Follow Up Boss / KVCore / LionDesk / Wise Agent / HubSpot / Salesforce / BoomTown / Sierra Interactive / Other] that manages the entire client lifecycle from first touch through closing and beyond into repeat and referral business.

## TASK

### Step 1 — Database Architecture & Contact Segmentation
Design the contact database structure for maximum usability:

**Contact Categories (Primary Segmentation)**
- Active Buyers: Currently searching, pre-approved, ready to make offers
- Active Sellers: Listed or preparing to list within 60 days
- Pipeline Buyers: Interested but 3-12 months out — nurture required
- Pipeline Sellers: Considering selling in 3-12 months — need ongoing value
- Past Clients: Closed transactions — referral and repeat business source
- Sphere of Influence: Personal and professional network — know, like, trust relationships
- Investor Clients: Buy/sell based on ROI, different communication cadence
- Agent Referral Partners: Out-of-area agents for referral exchange
- Vendor Partners: Lenders, inspectors, contractors, attorneys — for client introductions
- Online Leads: Unqualified inbound leads from websites and advertising
- Open House Leads: Contacts captured at open houses
- Expired/FSBO Prospects: Prospecting-generated contacts

**Custom Fields to Create**
- Lead source (critical for ROI tracking): [LIST ALL LEAD SOURCES — Zillow, Realtor.com, Google Ads, Facebook, SOI referral, open house, sign call, past client referral, floor call, farming, expired, FSBO]
- Lead temperature: Hot / Warm / Cool / Cold
- Buyer profile: Price range, bedrooms, neighborhoods, must-haves, deal-breakers
- Seller profile: Property address, estimated value, equity position, motivation level, timeline
- Preferred communication method: Call / Text / Email / WhatsApp
- Last meaningful contact date (auto-updated by activity logging)
- Next follow-up date and action item
- Transaction anniversary date (for past clients)
- Birthday (for SOI touches)
- Agent assigned (for teams)
- Tags: [CREATE TAG TAXONOMY — first-time buyer, downsizer, investor, relocating, divorce, estate, luxury, military, VA eligible, etc.]

### Step 2 — Pipeline Stages & Workflow Automation
Define the complete buyer and seller pipelines:

**Buyer Pipeline Stages**
1. **New Lead** → Auto-assign, send instant response (within 5 minutes), trigger qualification sequence
2. **Contacted** → Initial conversation completed, needs assessment gathered
3. **Qualifying** → Pre-approval in process, buyer consultation scheduled
4. **Pre-Approved** → Financially qualified, actively scheduling showings
5. **Showing** → Actively viewing properties, provide feedback after each showing
6. **Offer Submitted** → Contract written, negotiating terms
7. **Under Contract** → Accepted offer, managing contingencies (inspection, appraisal, financing)
8. **Clear to Close** → All contingencies satisfied, closing scheduled
9. **Closed** → Transaction complete, move to post-closing sequence
10. **Nurture / Not Ready** → Recycled back for long-term follow-up

**Seller Pipeline Stages**
1. **Lead** → Initial contact, trigger seller nurture content
2. **Consultation Scheduled** → Listing appointment booked, prepare CMA
3. **Listing Presentation Given** → Delivered CMA and marketing plan
4. **Listed** → Active on MLS, marketing campaign launched
5. **Showing Activity** → Receiving showings, collecting feedback
6. **Offer Received** → Reviewing and negotiating offers
7. **Under Contract** → Managing contingency timeline
8. **Clear to Close** → Ready for closing
9. **Closed** → Transaction complete, move to post-closing sequence
10. **On Hold / Withdrawn** → Re-engage sequence

**Automation Rules**
For each pipeline stage, define:
- Trigger to enter stage (manual move or automatic based on activity)
- Automated tasks created upon entry (emails, texts, reminders, document requests)
- Time-based escalation: If contact remains in stage longer than [DAYS], trigger alert to agent
- Required documentation/notes before advancing to next stage
- Notifications to team members (TC, admin, lender) at relevant stages

### Step 3 — Automated Communication Sequences
Build pre-written, automated drip campaigns for each contact segment:

**New Online Lead Sequence (First 14 Days)**
- Minute 0: Automated text — "Hi [NAME], thanks for your interest in [PROPERTY/SEARCH AREA]. I'm [AGENT NAME] — quick question, are you working with an agent yet?"
- Minute 5: Automated email — Introduction, value proposition, link to property search or market report
- Hour 4: Agent task — Make personal phone call (attempt 1)
- Day 1: Text follow-up if no response — "Hey [NAME], I don't want to be pushy — just want to make sure you get the info you need. What's the best way to reach you?"
- Day 2: Email — Local market insight or educational content relevant to their search
- Day 3: Agent task — Phone call attempt 2
- Day 5: Email — New listing alert matching their criteria
- Day 7: Text — "Still thinking about [AREA]? I just saw something you might like."
- Day 10: Email — Buyer guide or market report download
- Day 14: Agent task — Phone call attempt 3, decision point: Move to nurture or mark as unresponsive

**Past Client Annual Touch Plan (12 Months)**
- Month 1 (anniversary): Home anniversary card + small gift
- Month 2: Market update for their neighborhood — "Your home has appreciated by approximately $[X] since you purchased!"
- Month 3: Seasonal home maintenance tip email
- Month 4: Personal check-in phone call — no business agenda
- Month 5: Local event or restaurant recommendation
- Month 6: Mid-year market report for their area
- Month 7: Birthday acknowledgment (if birthday falls here — adjust calendar accordingly)
- Month 8: Referral ask email — "Know anyone thinking of buying or selling?"
- Month 9: Holiday or seasonal card/gift
- Month 10: Home value update
- Month 11: Tax season reminder — "Keep those closing documents handy!"
- Month 12: "Thinking of you" personal note or pop-by visit

**SOI Nurture Sequence (Ongoing)**
- Monthly: Market update newsletter
- Quarterly: Personal phone call or coffee meeting
- Semi-annually: Social event invitation (client appreciation party, community event)
- Annually: Birthday acknowledgment, holiday card
- Trigger-based: Congratulations on life events (new job, baby, promotion — tracked via social media monitoring)

### Step 4 — Transaction Management Workflow
Build the under-contract-to-closing workflow:

**Buyer Under Contract Checklist**
- Executed contract uploaded to CRM and transaction management system
- Earnest money deposit — deadline: [DATE], amount: $[AMOUNT], delivered to: [ENTITY]
- Home inspection — scheduled within [DAYS] of acceptance, inspector: [NAME/COMPANY]
- Inspection objection deadline: [DATE] — agent task to review report and draft objection
- Appraisal — ordered by lender by [DATE], scheduled for [DATE]
- Loan approval / commitment letter deadline: [DATE]
- Title search and insurance — ordered by [DATE], title company: [COMPANY]
- HOA document review period: [DAYS] from receipt
- Final walkthrough: Scheduled [24-48 hours] before closing
- Closing: [DATE], [TIME], [LOCATION]
- Wire transfer instructions sent to buyer (verify via phone call to prevent wire fraud)
- Post-closing: Utilities transferred, keys delivered, gift delivered, review requested

**Automated Notifications**
- Client reminders: 3 days before each deadline
- Agent reminders: 5 days before each deadline
- Transaction coordinator reminders: 7 days before each deadline
- Lender check-in: Weekly automated email requesting status update
- Escalation: If deadline is 48 hours away with no completion logged, alert team leader

### Step 5 — Reporting & Analytics Dashboard
Define the KPIs to track and review cadence:

**Daily Metrics**
- New leads received (by source)
- Outbound contacts made (calls, texts, emails)
- Appointments set
- Response time to new leads (target: under 5 minutes)

**Weekly Metrics**
- Pipeline movement: New leads entering, leads advancing stages, leads going cold
- Showing activity: Number of showings, buyer feedback summary
- Listing activity: New listings, price changes, showings received, offers received
- Conversion rates by pipeline stage

**Monthly Metrics**
- Total transactions: Pending, closed this month, closed YTD
- GCI: This month, YTD, vs. plan
- Lead source ROI: Cost per lead, cost per transaction, revenue per lead source
- Database growth: New contacts added, contacts engaged, contacts gone cold
- Pipeline health: Total pipeline value, weighted pipeline (probability x value), pipeline velocity (average days in each stage)

**Quarterly Review**
- Lead source effectiveness ranking — invest more in top sources, cut underperformers
- Communication sequence performance — open rates, reply rates, conversion rates by sequence
- Agent activity compliance — are daily/weekly activity standards being met?
- Database cleanup — remove duplicates, update contact information, re-engage dormant contacts, archive truly dead leads

Build all reports as saved dashboards within the CRM with automated weekly email summaries to [AGENT / TEAM LEADER / BROKER].

Deliver the complete system as an implementation guide with step-by-step CRM configuration instructions, all communication templates pre-written, automation logic mapped visually, and a 30-60-90 day rollout plan.