🧬 ClinicalTrials.gov Recruiting Trials + NIH Grant & CRO Bottleneck Intelligence (clinical-trials-leads-scraper)

100/100 Buyer-Ready Scale Certified · Entity-Level Relational LEFT JOIN: ClinicalTrials.gov v2 Interventional Studies ⟕ Sponsor Total Pipeline Depth API ⟕ NIH RePORTER v2 Grant Funding

---

1. Who Buys This Data & How They Use It

Paying Buyer Persona	Target Product / Offer	Exact CRM / Outreach Workflow
Patient Recruitment Agencies (AutoCruitment, StudyKIK, Clariness)	Digital patient pre-screening & enrollment ($1,500–$5,000 per randomized patient)	Filter patients_per_site_burden_num >= 30 and import contact_email, contact_salutation (Dr. Gabel), sponsor_clean_name, and outreach_icebreaker directly into Instantly.ai / Smartlead.
Boutique Clinical CROs & eClinical SaaS (EDC, eTMF, CTMS, ePRO vendors)	Full-service trial monitoring & software ($50k–$500k per study)	Filter sponsor_commercial_tier == "COMMERCIAL_BIOTECH_PHARMA" + sponsor_total_trials_count_num <= 10 (Emerging Biotech sponsors without large internal clinical ops teams).
Central Labs & Cold-Chain Bio-Couriers (Marken, World Courier)	Specimen logistics & biomarker assays	Filter multi-center trials (clinical_sites_count_num >= 3) and reach out to contact_email + secondary_site_emails.

---

2. Relational LEFT JOIN Architecture

1. Primary Entity (1 Row = 1 Active Interventional Clinical Trial, nct_id):
   • Prioritizes active Interventional Drug, Biologic, and Device trials (AREA[StudyType]INTERVENTIONAL), harvesting both the Central Study Contact and all individual Clinical Site contacts.
2. Relational LEFT JOIN #1 (Sponsor Pipeline Depth via query.spons countTotal=true):
   • Queries ClinicalTrials.gov for the exact total number of trials sponsored by lead_sponsor_legal_name (sponsor_total_trials_count_num), distinguishing Emerging Single-Asset Biotech Startups from mega-pharma/university hospitals.
3. Relational LEFT JOIN #2 (ClinicalTrials.gov ⟕ NIH RePORTER v2 API):
   • Queries NIH RePORTER across FY2024–2026 by (contact_first_name, contact_last_name) and lead_sponsor_legal_name to extract active federal grant funding (nih_funding_usd_num).

---

3. 7-Gate Buyer-Ready Output Format (33 Plug-and-Play Columns)

• Gate 1 (Entity Purity): nct_id (NCT..., 1 Row = 1 Recruiting Interventional Trial).
• Gate 2 (Clean Split Decision-Maker Name): contact_first_name ("Kelsey"), contact_last_name ("Gabel"), contact_credential ("PhD"), contact_salutation ("Dr. Gabel").
• Gate 3 (Clean Sponsor Name): sponsor_clean_name stripped of INC/LLC/CORP and converted from ALL-CAPS when needed.
• Gate 4 (Atomic Contact Channels): Single primary contact_email, contact_phone_e164, contact_phone_formatted, plus separate secondary_site_emails.
• Gate 5 (Sortable Numeric Columns): enrollment_target_num, clinical_sites_count_num, patients_per_site_burden_num, sponsor_total_trials_count_num, nih_funding_usd_num.
• Gate 6 (Atomic Geography & ISO Dates): primary_site_facility, primary_site_city, primary_site_state, primary_site_country, plus strict ISO YYYY-MM-DD start_date and primary_completion_date.
• Gate 7 (Plug-and-Play Outreach Hook): outreach_icebreaker referencing the exact NCT ID, phase, condition, enrollment target, and per-site patient burden.