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 are based on over 200,000+ business records which are maintained through a triple verification process by us. Since 2005 we have developed a special process in place to continuously monitor and improve the quality of data and keep adding thousands of businesses located in commercial premises every year. From 1% change per month to over 1% change per week – that’s the actual rate of change of business information we witness on 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 or call 04 977 7877 to speak to one of our data experts.

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

We have developed our own methodology when it comes to data cleaning and enrichment which 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 the quote is approved 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.