lead-enrichment

# Lead Enrichment — Multi-Source Data Completion

Enrich CRM contact records by filling missing fields from multiple sources. Works with DuckDB workspace entries or standalone JSON data.

## Sources (Priority Order)

1. **LinkedIn** (via linkedin-scraper skill) — name, title, company, education, connections
2. **Web Search** (via web_search tool) — email patterns, company info, social profiles
3. **Company Website** (via web_fetch) — team pages, about pages, contact info
4. **Email Pattern Discovery** — derive email from name + company domain

## Enrichment Pipeline

### Step 1: Assess What's Missing
```sql
-- Query the target object to find gaps
SELECT "Name", "Email", "LinkedIn URL", "Company", "Title", "Location"
FROM v_leads
WHERE "Email" IS NULL OR "LinkedIn URL" IS NULL OR "Title" IS NULL;
```

### Step 2: Prioritize by Value
- **High priority**: Missing email (needed for outreach)
- **Medium priority**: Missing title/company (needed for personalization)
- **Low priority**: Missing education, connections count, about text

### Step 3: Enrich Per Record

For each record with gaps:

#### If LinkedIn URL is known but other fields missing:
1. Use linkedin-scraper to visit profile
2. Extract: title, company, location, education, about
3. Update DuckDB record

#### If LinkedIn URL is missing:
1. Search LinkedIn: `{name} {company}` or `{name} {title}`
2. Verify match (name + company alignment)
3. Store LinkedIn URL, then scrape full profile

#### If Email is missing:
1. Find company domain (web search or LinkedIn company page)
2. Try common patterns:
   - `first@domain.com`
   - `first.last@domain.com`
   - `flast@domain.com`
   - `firstl@domain.com`
3. Optionally verify with web search: `"email" "{name}" site:{domain}`
4. Check company team/about page for email format clues

#### If Company info is missing:
1. Web search: `"{name}" "{title}"` or check LinkedIn
2. Fetch company website for: industry, size, description, funding

### Step 4: Update Records
```sql
-- Up...