Merge two customer lists and remove duplicates before a CRM import
- Budget
- You set this
- Timeline
- 2 weeks
- Category
- Data & analytics
Scope
After acquiring a smaller company we have two customer lists, one in HubSpot and one in spreadsheets, with overlapping customers written in different ways. We want them merged into one clean list, duplicates removed by rules we agree, and imported into HubSpot.
Deliverables
- Data profile of both sources
- Agreed matching and merge rules
- One deduplicated customer list
- Change log of merged and removed records
- Import into HubSpot with field mapping
Skills
- Data cleaning
- Excel
- HubSpot
- Deduplication