# CT UCC Lead Gen Pipeline — Context Trace

## The Core Insight

Every business that finances equipment (copiers, printers, MFPs, production print) files a **UCC-1 financing statement** with the Secretary of State. These are public records. When a lease matures (typically 36-60 months), the UCC filing goes stale. If the business doesn't refile, their **equipment is free and clear** — meaning they're ripe for a displacement pitch.

Connecticut publishes all UCC filings via Socrata/CT Open Data. We downloaded the full export (~19K rows, 54 columns) and built a pipeline to identify businesses with maturing equipment leases.

## What We Built

### Step 1: Filter to CT
- Source: `EDA_Export_FullFile_20260218.xlsx` (4.9MB, 18,977 rows)
- Filtered to CT: **11,188 rows**, **1,056 unique businesses**

### Step 2: Competitor Displacement View
- Non-Xerox equipment: **6,824 rows**, **638 businesses** — targets where Xerox/canon/toshiba/etc. can be displaced
- Xerox equipment lapsing: **2,949 rows**, **322 businesses** — Xerox accounts up for renewal

### Step 3: Financial Decision-Maker Detection
- Scanned `BUYC1TITLE` / `BUYC2TITLE` for CFO, Treasurer, Controller, VP Finance, etc.
- Found **508 rows**, **50 businesses** with named financial officers
- Direct dial access to budget-holders

### Step 4: Cycle Detection (The Real Gold)
- Grouped filings by business, calculated gap between consecutive UCC dates
- A genuine lease cycle shows a gap of **18-60 months** between filings
- **V2 clean list: 218 businesses** with documented multi-year filing gaps
  - 42 past due (filing expired, equipment possibly unencumbered)
  - 176 upcoming (lease approaching maturity within 12-24mo)

### Step 5: SMB Refinement (Today)
- Zoho CRM analysis showed actual clientele are **small businesses** (therapists, dentists, law firms, print shops, churches, real estate) — not enterprise fleets
- Re-filtered to professional-services SICs with equipment values **$5K-$50K per item, <$100K total**
- **Curated top 24 targets** — actual match to what the business sells

### Step 6: Email Enrichment
- Hunter.io free tier: 50 searches/100 verifications per month
- Brave Search API for domain discovery
- Hit rate: ~40% got usable emails on first pass
- Limitation: domain discovery needs refinement (Brave returns generic sites too often)

## The Data Assets

| Asset | Records | URL |
|-------|---------|-----|
| CT UCC raw (all) | 11,188 rows | local Excel |
| View 1: Non-Xerox | 6,824 rows, 638 businesses | — |
| View 2: Xerox lapsing | 2,949 rows, 322 businesses | — |
| View 3: Financial officers | 508 rows, 50 businesses | — |
| V2 Cycle list | 218 businesses, confirmed gaps | [CSV](https://claw.residentliberal.com/workflow-files/ct_cycle_call_list_v2.csv) / [HTML](https://claw.residentliberal.com/workflow-files/ct_cycle_call_list_v2.html) |
| SMB Top 30 (enriched) | 24 targets with emails | [CSV](https://claw.residentliberal.com/workflow-files/ct_smb_enriched_30.csv) / [HTML](https://claw.residentliberal.com/workflow-files/ct_smb_top30_report.html) |

## The Magnitude

**CT alone (one state):**
- 1,056 businesses with active UCC equipment liens
- 218 with confirmed lease cycles (21% of universe)
- Estimated addressable: 100-150 genuine near-term opportunities
- Average equipment value: ~$20K-$50K per SMB deal

**National projection (50 states):**
- Most states publish UCC data via Socrata or similar open-data portals
- Conservative estimate: **50,000-100,000+ businesses nationally** with maturing copier/print leases
- This is a **repeatable pattern**: every 3-5 years the same businesses re-enter the market

**Unit economics:**
- Cost per lead: ~$0.01 (data is free/public)
- Enrichment cost: ~$0.05/lead at Hunter.io scale ($49/month for 500 searches)
- A single closed deal ($20K-$50K equipment) pays for years of data pipeline

## How It Works (For Replication)

```
1. Pull UCC data from state SOS portal (Socrata API or bulk download)
2. Filter to equipment financing (EQTMAN, SPCLASS = financier)
3. Group by business, analyze filing date gaps
4. Score by: gap length ≥18mo + past-due status + Xerox presence + value range
5. Enrich: find website → Hunter.io domain search → email extraction
6. Prioritize: financial decision-makers first, SMB over enterprise
7. Outreach: email/LinkedIn/cold call with lease-maturity angle
```

## What's Needed Next

1. **Paid Hunter.io key** — $49/month for 500 searches unlocks this at scale
2. **Better domain discovery** — business-name-to-website resolution (could try Clearbit, BuiltWith, or just smarter Brave queries)
3. **Multi-state expansion** — CT was the proof-of-concept; every state is a new gold mine
4. **Call list integration** — pipe enriched contacts into dialer for outbound
5. **Zoho CRM sync** — auto-push qualified leads into existing pipeline
6. **SMS/email sequences** — automated follow-up after initial contact

## Technical Stack (Current)

- Python + pandas for data munging
- Brave Search API (free tier) for domain lookup
- Hunter.io for email finding
- Zoho CRM v8 for pipeline management
- Zoho leads already have custom fields: Digital_Copiers_Type, Printing_Volume, Package_Size, Lease_End_Date, Lease_or_Rental, Page_Band
- Hosted on VPS at claw.residentliberal.com (nginx + Python)

## The Wider Opportunity

This isn't just copiers. The same UCC data set reveals leases for:
- Medical/dental equipment
- Construction/heavy machinery  
- IT/server infrastructure
- Restaurant/kitchen equipment
- Fleet vehicles

Every equipment-financed vertical has the same refiling pattern. The pipeline we built for copiers can be **re-skinned for any equipment vertical** by changing the SIC filter and manufacturer keywords.