Data Scrubbing Solutions

Like just about everything else in life data gets dirty if you don't clean it occasionally. And in our experience, the more you use it, the more it needs to be cleaned. Data Scrubbing, or Data Quality improvement, is a general term that applies to many different solutions. These can include filling in missing data or standardizing data so others can use it more easily. It also includes ensuring your data is current and verifying it is valid. PacificEast can help you with all of these standard data scrubbing needs. Since each component of a contact record has different data scrubbing needs and options we've described them separately below. However, PacificEast can combine all of the scrubbing methods described here to form a holistic data cleansing system specific to your data's particular challenges.

Names
Most systems that search for instances of a particular name only use or need the actual surname or given name. Titles (like Mr, Mrs and Dr), generational suffixes (like Jr, Sr, III) and honoraries (like PhD, DDS, MD) often get in the way of finding a match because many search system require some kind of match on all the elements of the query. Therefore, removing these parts of a name can, at times, provide better results. But what if the name and these parts are glued together through a data entry error? Do you need to manually verify and change each name?

For problems like this PacificEast has developed a series of different name cleaners that work differently depending on where a subsequent search will be directed. The most common name cleaner we use, the NCOA Name Cleaner, is a pre-cleaner for any file undergoing NCOA processing. Another common name cleaner is our name splitter that divides combined names into surname and given name.

Phone Numbers (LIA, DNC)
Even simple 10-digit telephone numbers need to be cleaned once in a while. Data Entry errors can swap digits making them unusable. They can, of course, also be disconnected and re-assigned to another person or business. And even if you have the correct number, you may not legally be able to dial it for particular purposes. Additionally, what kind of number is it? Is it a business, is it a consumer, is it a cell phone or a landline? Have you ever glanced at your phone, seen an out of state number and wondered exactly where the call was coming from? The answer to these phone quality issues is to use products like Line Identification Append (LIA) and Do Not Call (DNC).

Other Data Scrubbing Systems (Merge/Purge)
Other scrubbing systems don't look at just one element but verify the usability or validity of the whole record or help clean up whole records or files.

Merge/Purge compares two files and eliminates duplicates between them based on a configurable combination of fields that defines a unique key

Full Line of Data Scrubbing Products:

Do Not Call checks telephone numbers against a set of national registries of numbers on various do-not-call lists. All remaining numbers can be called for general marketing purposes
LIA checks the validity of a phone number in the US and Canada. Also assigns an indicator of whether the associated phone is a landline or wireless number
Merge/Purge compares two files and eliminates duplicates between them based on a configurable combination of fields that defines a unique key
NCOA Name Cleaner prepares names for processing through a national change of address process
NCOA/CCOA - The nationally certified Change Of Address utilities for the US and Canada, respectively. These detect and return a forwarding address when one was supplied by the addressee
PCOA - A proprietary change of address utility that detects moves not in the relevant official COA system like NCOA or CCOA