Data Cleaning

Data Cleaning & Enrichment is an important exercise for any business who has a database of customers and prospects.

Over time the data quality drops and your hit rate spirals downward. Customers move, phone numbers change and contacts leave.

Additionally when you’ve grown a list organically you could be missing a large portion of your target market. From our experience we add an average of 30% to existing lists.

Three reasons why your existing database needs to be cleaned

  1. To ensure your sales and marketing efforts aren’t duplicated
  2. Clean data encourages your salespeople to prospect
  3. Having a tidy list of both customers and prospects puts you in the drivers seat and allows you to understand what part of the market you service

Data cleaning and enrichment projects use over 200,000+ of our business records. We maintain our list through a triple verification process. Since 2005 we have developed a special process to continuously monitor and improve the quality of data. In addition, we keep adding thousands of businesses located in commercial premises every year. Since 2005 it’s gone from a 1% change per month to over 1% change per week. This is the actual rate of change in business information we see on the NZ market at different times of the year.

Explore the process below – it’s very simple and straightforward. And once you’re ready to move ahead, simply fill in the enquiry form at the bottom of the page. Alternatively, call call Assia on +64 27 231 8631 to speak to our data expert.

Data cleansing is a multi-dimensional project. Its primitive form involves re-formatting of data to a certain standard, typically NZ Post’s standard. Formatting data is extremely important, but we believe that formatting alone does not solve the problem of data accuracy. In some respect, formatting contributes to the problem by misleading the vendor.

We have developed our own methodology when it comes to data cleaning and enrichment. It blends automatic matching with a human eye to improve the % we can match. This does mean it’s a more manual process and it takes a bit longer for us to process your data, however, the results gained from a higher quality match are significant.

To help you achieve your desired outcome, we employ the following process based on proven methodology:

Matching of your list of contacts to 200,000+ business records in the whoiswhere™ B2B database.

Based on past projects, our typical results will look like the following:

  • 50-75% match depending on how much information you will be able to provide
  • 5-20% may be recommended for deletion being duplicates, closed or merged business entities
  • 10-30% may be not found

Once we have matched your data to ours, removed duplicates, removed closed businesses and identified what the % of change is, we come back with an additional quote to enrich data (add more information you don’t have) in case you want to go beyond just cleaning.

At this stage we’ll also identify which businesses you don’t have that match your criteria and suggest investing in these records as well.

Once you approve the quote, we append all available data from whoiswhere™ to your records so you have the most accurate information available. If required we’ll also add in fresh records which will be new to your database.

We deliver in an Excel file so it’s easy for you to upload to whichever system you are using.