# CRM Cleanup Report - February 17, 2026

## Issues Identified

### 1. Scoring System Bug
**Problem:** Manual scores not saving properly in CRM
- BKH Group: Should be 95/100, showing 0
- Southwest Construction: Should be 90/100, showing 0  
- Creative Concrete: Should be 75/100, showing 0

**Action:** Added notes documenting correct scores, flagged for technical review

### 2. Incomplete Contact Information (6 leads)
**Unusable leads missing phone AND email:**

1. **JM Structures** (a50b198e-9922-4947-b865-48ce5a004980)
   - Source: Gumtree, Status: new
   - Seeking: Formwork Carpenters, Labourers, Steel fixers
   - **Action needed:** Apollo enrichment or archive

2. **Kenny Constructions** (84f4d44b-d4a7-4f46-bfd3-a7b48dc2d330)  
   - Source: Indeed, Status: new, Location: Sydney NSW
   - Size: 300+ professionals
   - **Action needed:** High priority enrichment (large operation)

3. **Mascot Engineering** (7294e660-e674-46fc-920d-04a4634b1fca)
   - Source: Indeed, Status: new, Location: Newcastle NSW
   - **Action needed:** Enrichment or archive (outside Sydney focus)

4. **Agia Projects** (3750bb4e-19e8-4993-8c65-325edfbd4247)
   - Source: Indeed, Status: new, Location: Sydney NSW
   - **Action needed:** Apollo enrichment

5. **AWCON** (096a7bb6-19d2-4ae9-a5aa-a7f8a6f2a066)
   - Source: Indeed, Status: new, Location: NSW
   - **Action needed:** Apollo enrichment (expressions of interest model)

6. **D4C** (0740f134-768b-4162-8c8c-1968ca37cb7d)
   - Source: Indeed, Status: new, Location: Sydney NSW  
   - **Action needed:** Apollo enrichment

### 3. Data Quality Issues
- Multiple leads with "score":0 despite manual scoring
- Some leads marked as workers in lead_type but should be contractors
- Missing company names in several entries

## Recommendations

**Immediate Actions:**
1. Fix scoring system bug (technical issue)
2. Apollo enrichment for Kenny Constructions (300+ employees = high value)
3. Archive Newcastle-based leads outside Sydney focus
4. Research contact details for remaining Sydney leads

**Process Improvements:**
1. Validate scoring system saves manual scores correctly
2. Mandatory contact enrichment before lead creation
3. Lead type validation during import process

## Priority Cleanup Queue
1. **Kenny Constructions** - 300+ employees, Sydney location
2. **Agia Projects** - Sydney location, active hiring
3. **AWCON** - NSW-wide, expressions of interest
4. **D4C** - Sydney, specialized (water/wastewater)
5. **JM Structures** - Basic formwork contractor

**Status:** Ready for systematic enrichment once scoring bug is resolved.