What I Built
14-Step Automated Pipeline
This isn't a slide deck. It's a production-ready system with working code, real data, and live automation.
Phase 1
Strategy & Research
01
Market Research & Gap Analysis
Analyzed K-12 security landscape, identified Alyssa's Law as regulatory driver,
researched Antioch incident impact, mapped competitor gaps (Verkada/Rhombus = visible weapons only).
02
Define Ideal Customer Profile
Defined sweet spot: 10K-50K enrollment Texas districts. Below = low ACV. Above = 12+ month RFP cycles.
Result:
98 target districts identified.
03
Select Target Personas
Primary: Superintendent (budget authority). Secondary: Safety Director (champion).
Strategy: Dual-thread outreach when both exist.
Phase 2
Data Collection & Enrichment
04
Scrape Texas Districts
Python scraper extracts all 254 Texas school districts with website domains.
Sources: Texas Tribune API + Wikipedia backup. Output:
texas_districts_for_clay.csv
05
Clay API Enrichment PAID
Find target personas at each district via Clay API. Get verified emails, phones, LinkedIn profiles.
05b
Free Data Alternative FREE
Zero-cost alternative to Clay enrichment:
- Texas AskTED Directory — Official TEA database with all school district contacts
- Webhound.ai — Web scraping tool to extract contact data at scale
Result: Scraped 9,738 contacts using this method (before filtering for our 98 target districts)
06
Score & Prioritize Leads
Signal-based scoring: +15 for Safety Director, +12 for recent incident, +10 for new superintendent,
+8 for passed bond.
07
PostgreSQL Data Warehouse
Store all districts, leads, scores, and campaign data. Tables: districts, leads, campaigns,
email_sequences, interactions, slack_alerts.
Phase 3
Automated Outreach
08
Push to Instantly.ai
Add scored leads to campaigns via API. Route by persona: Superintendents → one campaign,
Safety Directors → another.
09
Spintax Email Variations
Generate 40+ unique email variations for deliverability and A/B testing.
5 subject variations × 8 body variations.
10
Email Sequences
3-touch cadence: Day 0 (initial), Day 3 (follow-up), Day 8 (breakup).
Send window: 8am-5pm Central.
Phase 4
Automation & Optimization
11
n8n Webhooks + Slack Alerts
Real-time notifications when leads reply. Parse sentiment, log to database, alert team via Slack.
12
Metabase Dashboard
Real-time campaign performance. Open rates, reply rates, meetings by tier and persona.
13
Data-Driven Iteration
A/B test analysis. "After Antioch" subject → 45% open, 12% reply (winner).
"Quick question" → 18% open, 3% reply. Action: Double down on urgency messaging.
14
WIN — Meeting Booked
Dual-thread success: Safety Director replied → introduced Superintendent → meeting booked.
This is not a pitch. It's a running system.