List Building Deep Dives | Skills Pool
List Building Deep Dives Deep dives into ICP construction, multi-source workflows, Apollo + Clay templates, firmographics, technographics, and contact enrichment. Use when building prospect lists or defining ICPs.
juandaniel190 1 星標 2026年2月25日 List Building — Detailed Reference
Deep dives into each phase, ICP construction, multi-source workflows, and the Apollo + Clay template.
ICP Deep Dive: Building Your Ideal Customer Profile
Step 1: Analyze Your Best Customers
Pull top 20–30 customers by: highest LTV, fastest close, lowest churn, highest NPS, easiest to work with.
Answer:
What industries are they in?
What's their average company size?
What tools do they use?
What triggered them to buy?
What do they have in common?
Tool: Export from CRM → enrich in Clay with firmographics/technographics → look for patterns.
Step 2: Analyze Your Worst Customers (Anti-ICP)
Pull customers who: churned quickly, had long/painful sales cycles, required excessive support, low LTV.
快速安裝
List Building Deep Dives npx skills add juandaniel190/personal-projects
星標 1
更新時間 2026年2月25日
職業
What made them a bad fit?
What should have been a red flag?
What do they have in common?
Step 3: Interview Your Team
Sales: "Who closes fastest? Who's most excited about our product?"
Customer Success: "Who gets the most value? Easiest to onboard?"
Marketing: "What content resonates? What channels work best?"
Product: "Who uses the product most effectively?"
Step 4: Document Your ICP One-page document with must-haves, nice-to-haves, and disqualifiers (see template in SKILL.md).
Step 5: Score Your ICP Build a 0–100 scoring system in Clay as a formula column that auto-scores every company.
List top 10 best customers
Find 3 patterns they share
List top 5 worst customers
Find 2 patterns they share (anti-ICP)
Write ICP hypothesis in one paragraph
Create scoring rubric
ICP Layer Details
Layer 1: Firmographics Criteria Questions Example Industry What industries do best customers operate in? SaaS, E-commerce, Manufacturing Company Size How many employees? 50–500 (mid-market) Revenue Annual revenue range? $10M–$100M ARR Location HQ? Where do they operate? US-based, expanding to EU Company Age Startup vs established? 3–10 years old Business Model B2B, B2C, B2B2C? B2B SaaS companies Funding Stage Bootstrapped to PE-backed? Series A-B
Data sources: Your CRM (best), LinkedIn Sales Nav, Clay enrichments, Clearbit, People Data Labs.
Layer 2: Technographics Category What to Look For Why CRM Salesforce, HubSpot, Pipedrive Sales sophistication, budget Marketing Automation Marketo, Pardot, ActiveCampaign Marketing maturity Sales Tools Outreach, SalesLoft, Apollo Active outbound motion Analytics Segment, Amplitude, Mixpanel Data-driven culture Infrastructure AWS, GCP, Azure Technical sophistication Complementary Tools Tools that integrate with yours Easy adoption path Competitor Tools Using your competitors Ripe for switching
Data sources in Clay: BuiltWith, Clearbit, 6sense, HG Insights.
Layer 3: Behavioral Signals Signal What to Track Where to Find Hiring Roles related to your solution LinkedIn, job boards, Clay job tracking Funding Recent rounds Crunchbase, PitchBook, news Expansion New offices, new markets News, LinkedIn, company websites Leadership Changes New C-level hires LinkedIn, press releases Product Launches New products/features Product Hunt, news, social Tech Stack Changes Adding/removing tools BuiltWith, technographic tracking Content Engagement Downloads, pricing page visits Your analytics, intent data Competitor Activity Competitor mentions, visits 6sense, Bombora, G2
In Clay: Claygent for news monitoring, job change tracking, Crunchbase/PitchBook integrations, 6sense/Bombora for intent.
Layer 4: Psychographics Indicator How to Identify Growth vs optimization mindset Hiring velocity, funding, leadership messaging Innovation vs conservative Tech stack (cutting-edge vs legacy), company age Data-driven culture Analytics tools, data team size Customer-centric NPS scores, CS team size, reviews Compliance-focused Industry (healthcare, finance), certifications (SOC2, GDPR) Remote-first Job postings, office locations, culture
Research: About page, careers page, blog, Glassdoor reviews, leadership LinkedIn posts, customer case studies, Claygent for website summaries.
ICP Examples
Industry: B2B SaaS, Professional Services, Agencies
Size: 50–500 employees, $5M–$50M revenue
Tech: Salesforce or HubSpot CRM
Signals: Hiring SDRs/AEs, raised Series A/B
Psychographics: Growth-focused, outbound sales motion
Industry: Technology, Financial Services, Healthcare
Size: 200–2,000 employees, $20M–$200M revenue
Tech: Workday, BambooHR, or Greenhouse
Signals: Hiring HR Ops, headcount expanding >15% YoY
Psychographics: Employee experience-focused, remote-first
Industry: E-commerce, DTC Brands, B2C SaaS
Size: 20–200 employees, $2M–$20M revenue
Tech: Shopify, Klaviyo, or Attentive
Signals: Launching new products, expanding to new channels
Psychographics: Data-driven, customer acquisition-focused
Multi-Source Company Discovery: Detailed Workflows
Source 1: Clay Find Companies
Create new table in Clay
Add Source → Find Companies
Set filters matching ICP (industry, employees, location, technologies, funding)
Preview results → run source
Use "OR" logic for technologies to maximize coverage
Save filter templates for reuse
Cost: Free to search; credits for enrichment columns.
Source 2: Apollo (CSV → Clay Import)
Apollo.io → Company search
Set same ICP filters
Use keywords to narrow (e.g., "B2B SaaS" in description)
Export as CSV (always include Domain field)
Clay → new table → Import CSV → map columns
Cost: Free tier: 50 exports/month | Basic $49/mo (10K) | Pro $79/mo (unlimited).
Source 3: LinkedIn Sales Navigator
Sales Navigator → Company Search
Advanced filters: headcount, growth %, hiring, posted recently, technologies
Save as Lead List (max 2,500)
Export via Phantombuster ($50–100/mo) or Evaboot
Import to Clay
Unique filters: Headcount Growth, Posted on LinkedIn, Hiring on LinkedIn.
Cost: Core $99/mo | Advanced $149/mo + export tools.
Multi-Source Merge Workflow
Table 1: Clay Companies (from Clay Find Companies)
Table 2: Apollo Companies (from CSV import)
Table 3: Merged — use "Write to Other Table" from both Table 1 and Table 2
In Table 3: dedupe by Domain
(Optional) Table 4: LinkedIn Sales Nav companies → write to Table 3 → dedupe again
Typical result: 40–70% more companies than single source.
Advanced Strategies Waterfall Sourcing: Start with highest-quality source (LinkedIn with intent signals), add next source only if you need more volume.
Source by Segment: Enterprise → ZoomInfo + LinkedIn; Mid-market → Clay + Apollo; Startups → Crunchbase + Clay.
Layered Sourcing: Broad search (10K) → add intent signals (filter to 3K) → enrich and score (final 1K A-tier).
Apollo + Clay Template: 6-Table Workflow
Table 1: Apollo Companies (CSV Import)
Import CSV from Apollo export
Key fields: Company name, domain, industry, employee count, revenue, location
Table 2: Clay Companies (Native Search)
Clay "Find Companies" source
Match Apollo search criteria
Table 3: Merged & Deduped Companies + Enrichment
"Write to Other Table" from Table 1 and Table 2 into Table 3
Dedupe by company domain
Add: company tiering logic (formula/AI), scoring, additional enrichment
Create blank Table 3 ("Merged Companies - Deduped")
In Table 1: Add "Write to Other Table" column → select Table 3 → map fields → run all rows
In Table 2: Add "Write to Other Table" column → select Table 3 → map same fields → run all rows
In Table 3: Select Domain (or Company Name) column → click DeDupe → Value → delete duplicates
Add enrichment columns (tiering, scoring, qualification)
Field mapping must be consistent across both source tables
Use run conditions to only write qualified companies
Re-running Write to Table will auto-update Table 3
Table 4: Apollo People
Import domains from Table 3 (filtered for qualified companies)
Apollo people search: job titles, seniority, departments
Table 5: Clay People
Same domains from Table 3
Clay "Find People" source with matching criteria
Table 6: Merged & Deduped People (Final Output)
Import from Table 4 and Table 5
Dedupe by email (primary) or name + company domain
Final enrichment: email validation, phone waterfalls, personalization data, AI messaging
Output: final list ready for outreach
Local Prospecting For clients selling to local businesses (gyms, clinics, logistics, real estate, etc.) that don't appear in Apollo/LinkedIn.
Option A: Openmart + Clay (US-based)
Use Openmart to find local leads by category/location
Export → clean CSV
Import to Clay → enrich (email, website, LinkedIn, owner/decision-maker)
Option B: Google Maps Scraping via Clay
Clay's Google Maps integration → search by type + location
Pull: name, website, address, phone
Enrich: email, LinkedIn, ownership data
Option C: Directory Scraping
Find niche directory (Clutch.co, local chambers, industry associations)
Use Instant Data Scraper Chrome extension
Export CSV → import to Clay → enrich
If domain missing: use Claygent to find company website from name
TAM Scoping via DiscoLike When to use: When Apollo, Clay, and LinkedIn aren't finding your targets.
What it does: Discovers lookalike websites based on keywords and tech tags — not limited to LinkedIn data.
Finds net-new companies outside typical B2B databases
Search based on one or multiple sites (like Ocean.io)
Filter by country or language
No built-in firmographic data (or very limited)
Higher enrichment cost (~1 credit per row to qualify)
If too many results: tweak similarity variance and company start date
Helps avoid missing high-potential lookalikes due to volume caps
Email Waterfalls Use 3–5 providers sequentially — if provider 1 misses, try provider 2, etc.
LeadMagic, Prospeo, Findymail for personal emails
Catch-all/generic as fallback
Always validate to remove bounces
Phone Waterfalls Same principle for direct dials and mobile numbers — multiple providers for coverage.
Deduplication Strategy
Company level: Dedupe by domain BEFORE finding people (saves credits)
People level: Dedupe by email after merging sources
Alternative: dedupe by full name (saves credits, small risk of false dedupes)
Sequencer safety net: Enable "Skip lead if in Workspace" in Instantly/Smartlead/etc.
Common ICP Mistakes
Too broad: "Any company with 10+ employees" — can't afford to target everyone
Too narrow: "Only fintech in SF with exactly 150 employees" — TAM too small
Based on assumptions, not data: Talk to customers, analyze CRM
Static ICP: Markets change, revisit quarterly
Ignoring anti-ICP: Knowing who NOT to target is equally important
No scoring system: Without scoring, every lead looks the same
Data Sources
Clay Find Companies (built-in)
Apollo (apollo.io, free tier available)
LinkedIn Sales Navigator ($99/mo, 30-day trial)
ZoomInfo (enterprise, $15K–$30K/year)
Crunchbase ($29–$99/mo)
Export/Scraping
Phantombuster (LinkedIn scraping)
Evaboot (LinkedIn Sales Nav export)
Instant Data Scraper (Chrome extension, free)
Apify (web scraping)
Claygent (built-in AI web research)
Enrichment in Clay
Clearbit — firmographics, technographics
BuiltWith — tech stack data
People Data Labs — company data
Crunchbase — funding data
Claygent — custom research (values, news)
Data Quality
Clay deduplication (built-in)
Email validation providers (LeadMagic, Prospeo, Findymail)
Clay formulas — custom scoring logic
AI columns — evaluate fit based on criteria
Built by ColdIQ & Ivan Falco . For questions on implementation or anything not covered here, reach out to Ivan directly on LinkedIn .
02
ICP Deep Dive: Building Your Ideal Customer Profile
銷售同市場推廣
Open a Pull Request Open a pull request with proper PR template, test coverage, and review workflow. Guides agents through creating a PR that follows repo conventions, ensures existing behaviors aren't broken, covers new behaviors with tests, and handles review via bot when local testing isn't possible. TRIGGER when user asks to "open a PR", "create a PR", "make a PR", "submit a PR", "open pull request", "push and create PR", or any variation of opening/submitting a pull request.
Significant-Gravitas 183.5k