The Problem
A fast-growing outbound sales agency — running campaigns for 7 enterprise clients, scaling toward 30–40 within a year — was operating entirely out of drifting spreadsheets. In the baseline client dataset alone: only 4 of 1,259 phone numbers were in a usable format, 359 rows had the country typed into the city field, 64 of 248 companies didn't match any approved target list, and there was no unified opt-out enforcement across clients — a real compliance risk, not just a tidiness problem.
My Role
Lead CRM systems architect on the implementation — data architecture, ingestion pipeline, workflow automation, and training, end to end.
The Approach
Rather than importing the spreadsheet chaos straight into HubSpot, built a proper separation between permanent records (a company, a person) and temporary ones (a specific outreach campaign for a specific client) — so the same person being targeted by two different clients doesn't turn into crossed wires. Built a custom access model instead of relying on HubSpot's native team structure, since the native version penalizes cost as the agency scales past 10 teams. Every incoming client spreadsheet now has to match one locked, validated template before it's allowed into the system, instead of writing custom import logic for each client's own format.
The Outcome
Live and verified:
- Phone formatting fixed from 0.3% usable (4 of 1,259) to 100% across all direct lines, with shared switchboard numbers separated out so they stop causing misattributed calls
- Country data recovered for 364 contacts that had it trapped in the wrong field, taking valid coverage from 629 to 993 contacts
- 265 companies and 1,142 contacts migrated with zero dropped records
- Cross-client opt-out enforcement now latches permanently at the person level, closing the compliance gap
Still in progress:
- Full production rollout across all client workbooks — the baseline client is live, the rest are being standardized and staged
- Historical call log backfill, ready to run once team access is finalized
- Any measure of sales cycle speed or meeting volume — honestly too early; that gets measured 60–90 days after the full team has adopted the system
What I'd Do Differently
Enforce the single locked template from day one. Early on, time went into writing flexible logic to handle whatever format each client's spreadsheet happened to arrive in — that turned out to be the wrong bet. Locking one strict format upfront would have cut the ingestion work down by days.