Listware Online:US & CANADA Contact Data Quality

← Listware Online

Upload

You must first upload the file you want to cleanse and enrich.

Then select the data quality service you want to use.

Mapping

By default, the File Name, File Size, Header presence, and Record Count are displayed at the top of this page.

Choose Data Quality Service Options

Check

The Check action determines whether the data within a submitted record is valid, e.g. whether or not a given postal code contains the given city. It can also make limited corrections and appends to the data. Check looks at each data point separately, the inputs you put in for email don't affect what Check does with an address. Check returns results codes that describe which inputs were invalid, valid, or corrected. It also returns the input data after it has been corrected and added.

Verify

The Verify action allows you to determine whether the input data points are associated with each other. By default the input Address will be used as the centric, or pivot piece of data. If no address is used as input, phone and email will be used in that order as the centric piece of data.

Move Update

Appends address data of contacts who have moved based off of multisource data.

Append Names/Companies

Appends missing name or company information if available.

Append Addresses

Appends missing address information if available.

Append GeoLocations

Appends missing geolocation information if available.

Append Phones

Appends missing phone information if available.

Append E-mails

Appends missing e-mail information if available.

Demographic Appends

Date of Birth

Append the date of birth, if available.

Date of Death

Append the date of death, if available.

Household's Income

Append the household's income, if available.

Gender

Append the gender, if available.

Length of Residency

Append the length of residency, if available.

Owner/Renter

Append the owner/renter status, if available.

Presence of Children

Append the presence of children, if available.

Occupation

Append the occupation, if available.

Marital Status

Append the marital status, if available.

Review and Map the Input Columns

Match the input columns with the correct data type. The service will try to match the columns automatically, but you may need to do some fine tuning.

Outputs

Check the boxes next to your desired output columns

Name1

Full Name

Prefix

First Name

Middle Name

Last Name

Suffix

Gender

Name2

Note: When two names are found (e.g., "Mr John Smith Jr. and Dr. Mary L. Jones, MD") the second name will appear in these fields.

Full Name

Prefix

First Name

Middle Name

Last Name

Suffix

Gender

Salutation

Salutation

Address

Company

Address

Address 2

City

State

Postal Code

Country

Address Key

GeoLocation

Latitude & Longitude

Phone

Phone

Email

E-mail

Detailed Address Information

Address Type

Delivery Indicator

Extra Address Information

Urbanization (PR Only)

City Abbreviation

State Name

ISO Country Code

Carrier Route

Delivery Point

Universal Time Code

Census Information

CBSA Code

CBSA Title

CBSA Level

CBSA Divisional Code

CBSA Divisional Title

CBSA Divisional Level

County Name

County FIPS Code

Census Block

Census Tract

Place Name

Place Code

Congressional District

Parsed Address Components

House Number

Street Pre-Directional

Street Name

Street Suffix

Street Post-Directional

Suite Name

Suite Number

Private Mailbox Name

Private Mailbox Number

Route Service Number (Canada)

Delivery Installation (Canada)

Lock Box Number (Canada)

Review

This section displays your selected options and columns.

Create Job Name

You must also create a name for the job.

Report

Once we have processed your job, you may access a summary report of the job. This will show you the record counts (e.g. number of verified records, matches, etc.) and credit costs.