Listware Online:US & CANADA Contact Data Quality
Jump to navigation
Jump to search
Email
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
- Date of Death
- Household's Income
- Gender
- Length of Residency
- Owner/Renter
- Presence of Children
- Occupation
- Marital Status
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
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.