Our client is a global provider of magnetic interchange sunglass collection created for runners, skiers, bikers, hikers, climbers, kayakers, golfers, and tennis players as well as active weekend warriors.
With the rise of undelivered emails, duplicate mail deliveries, and failure to reach customers by phone, the client decided to clean and update company and customer records. The contact details of more than 85,000 users also had to be cleansed, verified, and validated.
“Data is a precious thing and will last longer than the systems themselves.” – Tim Berners-Lee
Located in the USA and Canada, the company deals with frames, lenses, switch kits, prescription suns, sun readers, and accessories.
This included rectifying spelling errors, de-duplicating the data, and conducting intense Google searches to verify and validate the details of each user. Furthermore, the entries had to be normalized and standardized to ensure consistency across the enterprise.
The major challenge was to perform an intense Google search on finding the given contact details of each user, verifying and updating them to help the client boost marketing efforts and target the right set of customers.
The project involved:
- Checking all mailing addresses
- Rectifying incorrect residential and official addresses
- Verifying customers’ email addresses and phone numbers
- Identifying and removing duplicate entries in the customer database
- Eliminating outdated entries
- Correctly formatting and updating customers’ contact details
Considering the restricted time-frame and the client’s budget, we tailored our solutions to exactly match the client’s requirements, pace up the data cleansing process, and deliver optimum accuracy in the final outcome. So, we appointed a team of 10 skilled professionals who hold experience in manually cleansing and enriching customer records to assist them to improve efficiency and control measures while lowering costs. Our experts analyzed the client’s requirements and identified the areas for improvement.
As part of our Data Cleansing Services, we:
- Filtered and scrubbed mailing lists
- Rectified spelling errors, typographical mistakes, grammatical and punctuation errors
- Removed duplicate entries
- Identified and completed incomplete records
- Normalized, standardized, and re-formatted the records
- Verified and Validated the data against reliable sources