The Problem
Finding good agency prospects by hand is slow and inconsistent. There is no clean way to compare one agency against another or decide who to call first.
What Was Built
A repeatable lead-list generator and scorer. It reads a list of agencies, applies a 100-point model across eight factors — size fit, proximity, web-presence gap, independence, longevity, line breadth, reputation, and a named decision-maker — and writes a formatted Excel workbook. Scores are live formulas: edit a weight on the Scoring Model sheet and every lead rescores instantly. Rerun any time from the command line.
The Result
A ranked, tiered list of 25 starter agencies across central NJ, eastern PA, Delaware, and NYC — with verified phone numbers for all 25, emails for most, a named decision-maker for nearly every one, and Google ratings checked directly. Work the top tier first, highest score down.