┌─────────────────────────────────────────────────────────────┐
│ CLAY TABLE: Outbound Leads │
├─────────────┬───────────────┬──────────────────────────────┤
│ Input Cols │ Enrichment │ AI + Formula + Output │
├─────────────┼───────────────┼──────────────────────────────┤
│ domain │ Company Name │ ICP Score (formula) │
│ first_name │ Employee Count│ Lead Tier (formula: A/B/C) │
│ last_name │ Industry │ Personalized Opener (AI) │
│ source │ Tech Stack │ Recent News (Claygent) │
│ linkedin_url│ Work Email │ CRM Push (HTTP API) │
│ │ Job Title │ Outreach Push (HTTP API) │
│ │ Phone Number │ │
│ │ LinkedIn URL │ │
└─────────────┴───────────────┴──────────────────────────────┘
Column execution order (left to right):
1. Company enrichment (Clearbit) ─ fast, provides context for later columns
2. Person enrichment (Apollo/PDL) ─ medium speed
3. Email waterfall (Apollo > Hunter) ─ conditional: requires domain + name
4. Phone lookup (if needed) ─ conditional: ICP Score >= 80
5. ICP Score formula ─ instant, computes from enriched data
6. Claygent research ─ slow, conditional: ICP Score >= 60
7. AI personalization ─ conditional: ICP Score >= 70
8. CRM push (HTTP API) ─ conditional: ICP Score >= 70 + has email
# Clay Formula Column: ICP Score (0-100)
LET(
# Company size scoring (0-30)
size, IF(Employee Count > 1000, 30,
IF(Employee Count > 200, 25,
IF(Employee Count > 50, 15,
IF(Employee Count > 10, 5, 0)))),
# Industry match (0-30)
industry, IF(OR(
Industry = "Software",
Industry = "Technology",
Industry = "SaaS",
Industry = "Information Technology"
), 30, IF(OR(
Industry = "Financial Services",
Industry = "Healthcare"
), 20, 10)),
# Title seniority (0-25)
title, IF(OR(
CONTAINS(Job Title, "CEO"), CONTAINS(Job Title, "CTO"),
CONTAINS(Job Title, "VP"), CONTAINS(Job Title, "C-Suite")
), 25, IF(OR(
CONTAINS(Job Title, "Director"), CONTAINS(Job Title, "Head of")
), 20, IF(
CONTAINS(Job Title, "Manager"), 10, 5
))),
# Data completeness (0-15)
data, IF(ISNOTEMPTY(Work Email), 10, 0) +
IF(ISNOTEMPTY(Phone Number), 5, 0),
size + industry + title + data
)
# Lead Tier Column
IF(ICP Score >= 80, "A",
IF(ICP Score >= 60, "B",
IF(ICP Score >= 40, "C", "D")))