Basic Lead Scoring Model: Spreadsheet-Ready
An agent with 200 leads in a spreadsheet wants a simple scoring model they can apply manually. No CRM integration needed — just a weighted scoring system that helps them prioritize follow-up calls each morning.
You are a real estate lead management specialist who builds simple, spreadsheet-ready lead scoring models.
Build a lead scoring model I can apply in a spreadsheet to prioritize my 200 leads.
Data available for each lead: source (Zillow, open house, referral, website, social media), first contact date, last response date, stated timeline, pre-approval status, property searches (if any), email engagement.
Create a 0-100 weighted model with clear scoring criteria. Include spreadsheet column formulas if possible. Show how to categorize leads into action tiers.
You are a real estate lead management specialist who builds spreadsheet-ready lead scoring models. Build a 0-100 scoring model I can apply manually to my 200 leads. Data I track for each lead: - Lead source (Zillow, open house, referral, website, social) - First contact date - Last response date - Stated timeline (now, 1-3 months, 3-6 months, 6-12 months, just looking) - Pre-approval status (yes, no, in process) - Number of property links clicked in my emails - Number of replies to my messages Create weighted scoring criteria and action tier categories.
LEAD SCORING MODEL — Spreadsheet Implementation FACTOR 1: LEAD SOURCE (Max 20 points) Referral: 20 pts (highest conversion rate in real estate, ~30%) Open house visitor: 15 pts (showed up in person = real interest) Website form: 12 pts (proactive inquiry) Social media DM: 10 pts (engaged but often earlier stage) Zillow/portal lead: 8 pts (high volume, lower intent) Cold/purchased list: 3 pts FACTOR 2: STATED TIMELINE (Max 25 points) Ready now / within 30 days: 25 pts 1-3 months: 20 pts 3-6 months: 12 pts 6-12 months: 6 pts Just looking / no timeline: 3 pts FACTOR 3: PRE-APPROVAL STATUS (Max 20 points) Pre-approved (letter in hand): 20 pts In process with lender: 12 pts No pre-approval, says they'll get one: 5 pts No pre-approval, hasn't mentioned it: 0 pts FACTOR 4: ENGAGEMENT RECENCY (Max 20 points) Last responded within 48 hours: 20 pts Last responded within 1 week: 15 pts Last responded within 2 weeks: 10 pts Last responded within 30 days: 5 pts No response in 30+ days: 0 pts FACTOR 5: BEHAVIORAL SIGNALS (Max 15 points) Clicked 5+ property links: 10 pts Clicked 2-4 property links: 6 pts Clicked 1 property link: 3 pts Replied to 3+ messages: 5 pts (add to click score, cap at 15) Replied to 1-2 messages: 3 pts SPREADSHEET SETUP: Column A: Lead name Column B-F: Raw scores for each factor Column G: =SUM(B:F) [Total score] Column H: =IF(G>=70,"HOT",IF(G>=40,"WARM","COLD")) [Tier] ACTION TIERS: HOT (70-100): Call today. These leads have high intent, recent engagement, and financial readiness. Personal phone call within 4 hours. If no answer, text + voicemail + email within 24 hours. WARM (40-69): Structured follow-up. These leads are interested but not urgent. Weekly personalized email or text. Monthly phone call attempt. Targeted property alerts. COLD (0-39): Automated nurture. Monthly market update email. Quarterly check-in text. Re-score monthly — cold leads warm up when timelines shorten or engagement increases. RE-SCORING CADENCE: Update scores every Monday morning. Change engagement recency based on last week's activity. Adjust timeline scores as stated timelines progress. A lead who said "6 months" three months ago should now score as "3 months."
Why It Works
The model uses five factors weighted by their actual predictive power in real estate lead conversion. Referrals score highest because they convert at 30%. Pre-approval scores high because it's a commitment signal. The spreadsheet implementation means any agent can use this without buying software.