# Lead PageSpeed Filtering Plan
## Date: 2026-02-18 | Status: Ready to Execute

### OBJECTIVE
Filter 3,886 tradie leads to find the worst-performing websites, especially those paying LocalSearch/Sensis. These are our highest-value poach targets for Website Replacement ($397/mo).

### KEY DISCOVERY
We already have a **complete heatmap audit engine** at `/mnt/e/genesis-system/scripts/heatmap_audit/` with:
- Batch async processor for bulk PageSpeed checks
- 5-category scoring (Speed, Mobile, Online Presence, SEO, AI Readiness)
- Brave Search API integration for directory detection
- Rate limit handling built in

### LEAD DATA
- **Primary dataset**: `/mnt/e/genesis-system/data/LEADS/TRADIE LEADS AUSTRALIA/ZOHO_SIMPLE_IMPORT.csv` (3,887 rows)
- **Estimated with valid websites**: 2,500-2,800 leads
- **Segmented datasets**: `/mnt/e/genesis-system/data/LEADS/SEGMENTED/`

### 3-PHASE PLAN

#### Phase 1: Bulk PageSpeed Scan (2-4 days)
- Run existing heatmap_audit batch processor against all 2,500-2,800 leads with websites
- PageSpeed Insights API is **FREE** (no key needed for basic usage)
- Cache results in PostgreSQL for reuse
- Output: Speed score + mobile score for every lead

#### Phase 2: Filter + Enrich (1-2 days)
- Filter for PageSpeed score < 50 (slow sites)
- Cross-reference with Brave Search for "LocalSearch" or "Sensis" or "Yellow Pages" presence
- Identify leads paying $300-500/mo for a terrible website
- Expected yield: **400-600 low performers**, **150-250 likely paying directory customers**

#### Phase 3: Targeted Outreach (1-2 weeks)
- Generate personalized audit PDFs (existing audit.html mock report as template)
- Load into Instantly.ai for email campaign: "Your website scores 30/100. You're paying $350/mo for this."
- Telnyx voice follow-up 48 hours after email open

### COST
- PageSpeed API: **FREE**
- Brave Search API: ~$5-15
- Compute: Minimal (existing scripts)
- Total: **Under $20**

### EXPECTED ROI
- 150-250 qualified leads identified
- 5% conversion = 8-13 new clients
- At $397/mo = **$3,176-$5,161 MRR** from one batch

### NEXT STEP
Run Phase 1 — execute the bulk PageSpeed scan using existing heatmap_audit engine.
