Our data services

Data

CRST Data Service

More important than your mailing, is your data for the mailing. Great data = good results. Good data = mediocre results. Uncertain data = gambling. At CRST, we don’t believe in gambling. We do believe in knowing something about the data we're using. Cornerstone has created custom Board of Elections and Real Property Data filters so you can choose the perfect criteria for your data list. Here are some examples of data type we most often use:

-> Political Registrants

People who have voted within a certain time period, specific election, affiliated party, school or fire district.

-> Real Property Owners

People who own property within a specified county.

-> Secondary Residential Homeowners

People who own property within a specified county but do not live within that county.

-> Occupant-Resident

All address information within a specified area (ZIP™ code).

-> Cultural Enthusiast with Wealth Indicators

People who are designated as having lifestyle interests such as arts, hiking, dance, music and their sub-cultures. Indicators for wealth would include project household income, boats, real property.

-> Dog Owners

People who own dogs

-> Pool Owners

Addresses with pools, their sizes and type (indoor/outdoor, above ground / below ground).

-> Homes with Children

The number of children that live in at a specific address.

When we receive a file from a client we put it through a series of data cleansing steps such as:

Step 1 - Manual File Inspection

we check to make sure all data is in the correct columns, there is no stray characters or symbols, names are in correct formats, character length is set for each row based on artwork size and any foreign addresses are correctly formatted with postal codes and country names (in all caps).

Step 2 - Address Corrections

after importing into our mailing software we run the data file against a USPS® address list to ensure each record is ZIP+4 verified by postal standards. If not, we then research the name or address to find the intended information. Our goal is to make your list less than 2% errors since the more verified addresses you have in your list, the higher chance of delivery. All undeliverable addresses (records with little to no address information) will be removed and marked in the Data Quality Report(DQR).

Step 3 - Move Update

next is to run the list through the NCOA (National Change of Address) software and check to see if any records have moved within the last 48 months (4 years). If there are any matches our software will then update the current address with the new one given to the USPS®. Some records will return back NCOA Errors which are people that have moved recently but have not sent the USPS® a new mailing address. These records are usually removed, but are sometimes kept upon client request or saturation mailing reasons.

Step 4 - Duplication Review

your list is now being checked for duplicates by comparing records with similar address information. There are four (4) levels of de-duplication we run through and they are:

a) Exact

these are records with exact mailing address information and last names. The goal is to have unique mailing addresses so we choose only one to mail to unless otherwise noted by the client.

b) Loose

these are records with loose mailing information and last names, similar information such as primary addresses numbers and fairly close last names.

c) Basic

these are records with basic mailing information. This tends to pick out records where the address is similar but the names are different. This is a manual process of checking the marked duplicates and determining which one is a duplicate to be deleted. Most examples are misspelled names and missing secondary (apartment/suite) designations.

d) House-holding

(upon client request) depending on the type of data and result you are looking for with your mailing, we can also house-hold your data file to combine multiple records of the same last name and address to be “The [Last Name] Family”. This is helpful if you wanted to send only one mail piece per house.

Step 5 - Manual Post Cleanse Check

your data is cleaned and now checked to make sure no errors were missed and all names / address information is correctly formatted.

Step 6 - Mail Sort

after being checked for final fixes your mailing list is ready to be mail sorted for the USPS® and provided with IM Barcodes, Sort Position, proper paperwork, files and postage amount. This is the final step in processing a data file for mailing.

These steps are necessary to provide our clients with discounted postage due to the number of ZIP+4 verified addresses, saturation and automation rates. To put it simply, the cleaner the data, the better the result.

After your data is completely cleaned and mail sorted we provide you back a Data Quality Report showing all of the changes we’ve made to your list. This is an Excel document that is color coded to easily display what the change was and the action applied (such as being deleted, fixed, or automatically changed by our software). Using this information can help keep your list cleaned and organized. Below is an example of a DQR.

CRST Data Quality Report

0
Data Hours
0
Files Processed
0
Addresses Corrected
0
DQR's Created

Like what you see?

Contact Us