Internal DemoSample DeliveryPublic-Data Workflow
CRM Cleanup — 15k Contacts
Not a client project — internal demo to show process
Task
De-duplicate 15k contacts, normalize fields (stage, owner, industry), fill blanks and enrich missing firmographics.
Input
HubSpot export (CSV, 15,240 rows), field map: email → primary key, domain → company, plus rules for stage normalization. No live CRM access — CSV only.
Workflow
- Score duplicates on email + domain + phone + fuzzy name (threshold 0.85)
- Normalize stages, owners, industries per mapping table
- Fill blanks where public data found, flag low-confidence
- Generate change log: merged, updated, flagged
- Export clean CSV + summary
Output
Clean CSV (15k → 13,840 unique contacts), change log (1,400 merged, 820 enriched, 210 flagged), ready for import.
Time
5h 10m
Cost
$51
Deliverable
CSV + change log · $10/hour · tracked to the second
Clearly labeled INTERNAL DEMO — do not represent as customer result.
Hire for your CRM →Related: Data Cleaning · CRM Service