Difference between revisions of "Listware Online:US & CANADA Contact Data Quality"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← Listware Online {{CustomTOC}} ==Upload== You must first upload the file you want to cleanse and enrich. Then select the data quality service you w...")
 
 
(2 intermediate revisions by the same user not shown)
Line 13: Line 13:
<h3 style="background-color:rgb(240,240,240);">Choose Data Quality Service Options</h3>
<h3 style="background-color:rgb(240,240,240);">Choose Data Quality Service Options</h3>
:;Check
:;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
:;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
:;Move Update
::
::Appends address data of contacts who have moved based off of multisource data.


:;Append Names/Companies
:;Append Names/Companies
::
::Appends missing name or company information if available.


:;Append Addresses
:;Append Addresses
::
::Appends missing address information if available.


:;Append GeoLocations
:;Append GeoLocations
::
::Appends missing geolocation information if available.


:;Append Phones
:;Append Phones
::
::Appends missing phone information if available.


:;Append E-mails
:;Append E-mails
::
::Appends missing e-mail information if available.
 
 


<h3 style="background-color:rgb(240,240,240);">Demographic Appends</h3>
<h3 style="background-color:rgb(240,240,240);">Demographic Appends</h3>
:;Date of Birth
:;Date of Birth
::
::Append the date of birth, if available.


:;Date of Death
:;Date of Death
::
::Append the date of death, if available.


:;Household's Income
:;Household's Income
::
::Append the household's income, if available.


:;Gender
:;Gender
::
::Append the gender, if available.


:;Length of Residency
:;Length of Residency
::
::Append the length of residency, if available.


:;Owner/Renter
:;Owner/Renter
::
::Append the owner/renter status, if available.


:;Presence of Children
:;Presence of Children
::
::Append the presence of children, if available.


:;Occupation
:;Occupation
::
::Append the occupation, if available.


:;Marital Status
:;Marital Status
::
::Append the marital status, if available.
 
 
 


<h3 style="background-color:rgb(240,240,240);">Review and Map the Input Columns</h3>
<h3 style="background-color:rgb(240,240,240);">Review and Map the Input Columns</h3>
Line 78: Line 73:
<h3 style="background-color:rgb(240,240,240);">Name1</h3>
<h3 style="background-color:rgb(240,240,240);">Name1</h3>
:;Full Name
:;Full Name
::
::The full name for the record.


:;Prefix
:;Prefix
::
::The parsed name prefix. E.g., "Dr."


:;First Name
:;First Name
::
::The parsed first name. E.g., "Bill."


:;Middle Name
:;Middle Name
::
::The parsed middle name. E.g., "S."


:;Last Name
:;Last Name
::
::The parsed last name. E.g., "Preston."


:;Suffix
:;Suffix
::
::The parsed name suffix. E.g., "Esquire."


:;Gender
:;Gender
::
::This will output the name's gender.
 
::{|class="alternate01" cellspacing="0"
!Code
!Description
|-
|M||Male
|-
|F||Female
|-
|N||Neutral
|}


<h3 style="background-color:rgb(240,240,240);">Name2</h3>
<h3 style="background-color:rgb(240,240,240);">Name2</h3>
Line 102: Line 108:


:;Full Name
:;Full Name
::
::Only used if 2 names are in the Full Name field. The second parsed full name.


:;Prefix
:;Prefix
::
::Only used if 2 names are in the Full Name field. The parsed prefix for the second name.


:;First Name
:;First Name
::
::Only used if 2 names are in the Full Name field. The parsed first name for the second name.


:;Middle Name
:;Middle Name
::
::Only used if 2 names are in the Full Name field. The parsed middle name for the second name.


:;Last Name
:;Last Name
::
::Only used if 2 names are in the Full Name field. The parsed last name for the second name.


:;Suffix
:;Suffix
::
::Only used if 2 names are in the Full Name field. The parsed suffix for the second name.


:;Gender
:;Gender
::
::Only used if 2 names are in the Full Name field. The gender for the second name.


<h3 style="background-color:rgb(240,240,240);">Salutation</h3>
<h3 style="background-color:rgb(240,240,240);">Salutation</h3>
:;Salutation
:;Salutation
::
::Output a salutation. E.g., "Dear Mr. Preston."


<h3 style="background-color:rgb(240,240,240);">Address</h3>
<h3 style="background-color:rgb(240,240,240);">Address</h3>
:;Company
:;Company
::
::The company or organization.


:;Address
:;Address
::
::The address.


:;Address 2
:;Address 2
::
::The second address. If you specify a second address line, secondary information (apartment, suite, etc.) will be put here. If you choose to not output to Address 2, secondary information will be appended to the first Address.


:;City
:;City
::
::The city.


:;State
:;State
::
::The US State or Canadian Province.


:;Postal Code
:;Postal Code
::
::The 9-digit postal code for U.S. addresses and 6-digit postal code for Canadian addresses.


:;Country
:;Country
::
::The country name.


:;Address Key
:;Address Key
::
::The AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa products.


<h3 style="background-color:rgb(240,240,240);">GeoLocation</h3>
<h3 style="background-color:rgb(240,240,240);">GeoLocation</h3>
:;Latitude & Longitude
:;Latitude & Longitude
::
::The geocoded latitude and longitude for the address.


<h3 style="background-color:rgb(240,240,240);">Phone</h3>
<h3 style="background-color:rgb(240,240,240);">Phone</h3>
:;Phone
:;Phone
::
::The standardized phone number.


<h3 style="background-color:rgb(240,240,240);">Email</h3>
<h3 style="background-color:rgb(240,240,240);">Email</h3>
:;E-mail
:;E-mail
::
::The e-mail address.


<h3 style="background-color:rgb(240,240,240);">Detailed Address Information</h3>
<h3 style="background-color:rgb(240,240,240);">Detailed Address Information</h3>
:;Address Type
:;Address Type
::
::A code for the address type.
 
::{|class="alternate01" cellspacing="0"
!Code
!Description
|-
|S||Standard Address
|-
|G||General Delivery Address
|-
|M||Military Address
|-
|P||PO Box Address
|-
|R||Rural Route Address
|-
|U||Unique/LVR Address
|}


:;Delivery Indicator
:;Delivery Indicator
::
::The Delivery Indicator.
 
::{|class="alternate01" cellspacing="0"
!Code
!Description
|-
|B||Business Address
|-
|R||Residential Address
|-
|U||Unknown Address
|}


:;Extra Address Information
:;Extra Address Information
::
::Extra information that does not fit in any of the output address columns.


:;Urbanization (PR Only)
:;Urbanization (PR Only)
::
::The urbanization name. These are used only in Puerto Rican addresses.


:;City Abbreviation
:;City Abbreviation
::
::The city abbreviation is any is available.


:;State Name
:;State Name
::
::The full state name.


:;ISO Country Code
:;ISO Country Code
::
::The ISO country code.


:;Carrier Route
:;Carrier Route
::
::The Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.


:;Delivery Point
:;Delivery Point
::
::The Delivery Point (DP) and its check digit. This is a 2-digit code defining the address's delivery location. The single-digit check digit follows the delivery point and serves as an error check for the ZIP Code, Plus4 and Delivery Point.


:;Universal Time Code
:;Universal Time Code
::
::The Universal Time Code (UTC.) This indicates the amount of hours:minutes offset from Greenwich Mean Time (GMT.)


<h3 style="background-color:rgb(240,240,240);">Census Information</h3>
<h3 style="background-color:rgb(240,240,240);">Census Information</h3>
:;CBSA Code
:;CBSA Code
::
::The Census Bureau Core-Based Statistical Area (CBSA) code. This is a 5-digit code for the address.


:;CBSA Title
:;CBSA Title
::
::The Title describing the CBSA code.


:;CBSA Level
:;CBSA Level
::
::The Level of the CBSA code. If present, the CBSA Level will be Metropolitan or Micropolitan.


:;CBSA Divisional Code
:;CBSA Divisional Code
::
::The CBSA representing the division associated with the address.


:;CBSA Divisional Title
:;CBSA Divisional Title
::
::The Title describing the Divisional CBSA code.


:;CBSA Divisional Level
:;CBSA Divisional Level
::
::The Level of the Divisional CBSA code. If present, the Divisional CBSA Level will be Metropolitan or Micropolitan.


:;County Name
:;County Name
::
::The County name.


:;County FIPS Code
:;County FIPS Code
::
::The County FIPS code. This is a 5-digit code. The first two digits indicate the state while the last three digits indicate the county within the state.


:;Census Block
:;Census Block
::
::The Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blocks are the smallest geographic area for which the Bureau of the Census collects information.


:;Census Tract
:;Census Tract
::
::The Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Census Tracts are small subdivisions of the county.


:;Place Name
:;Place Name
::
::The Place Name. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Name will refer to that area.


:;Place Code
:;Place Code
::
::The Place Code. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Code will refer to that area.


:;Congressional District
:;Congressional District
::
::The Congressional District. This is a 2-digit code indicating the address's congressional district.


<h3 style="background-color:rgb(240,240,240);">Parsed Address Components</h3>
<h3 style="background-color:rgb(240,240,240);">Parsed Address Components</h3>
:;House Number
:;House Number
::
::The parsed House Number for the output address.


:;Street Pre-Directional
:;Street Pre-Directional
::
::The parsed Street Pre-Directional for the output address.


:;Street Name
:;Street Name
::
::The parsed Street Name for the output address.


:;Street Suffix
:;Street Suffix
::
::The parsed Street Suffix (a.k.a. Street Type) for the output address.


:;Street Post-Directional
:;Street Post-Directional
::
::The parsed Post-Direction for the output address.


:;Suite Name
:;Suite Name
::
::The suite name.


:;Suite Number
:;Suite Number
::
::The suite number.


:;Private Mailbox Name
:;Private Mailbox Name
::
::The parsed Private Mailbox Name for the output address. These mailboxes are used in commercial receiving agencies, such as the UPS store.


:;Private Mailbox Number
:;Private Mailbox Number
::
::The parsed Private Mailbox Number for the output address. These mailboxes are used in commercial receiving agencies, such as the UPS store.


:;Route Service Number (Canada)
:;Route Service Number (Canada)
::
::The parsed Route Service Number for the output address. Canada only.


:;Delivery Installation (Canada)
:;Delivery Installation (Canada)
::
::The parsed Delivery Installation for the output address. Canada only.


:;Lock Box Number (Canada)
:;Lock Box Number (Canada)
::
::The parsed Lock Box Number for the output address. Canada only.





Latest revision as of 22:47, 1 August 2017

← 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
The full name for the record.
Prefix
The parsed name prefix. E.g., "Dr."
First Name
The parsed first name. E.g., "Bill."
Middle Name
The parsed middle name. E.g., "S."
Last Name
The parsed last name. E.g., "Preston."
Suffix
The parsed name suffix. E.g., "Esquire."
Gender
This will output the name's gender.
Code Description
M Male
F Female
N Neutral

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
Only used if 2 names are in the Full Name field. The second parsed full name.
Prefix
Only used if 2 names are in the Full Name field. The parsed prefix for the second name.
First Name
Only used if 2 names are in the Full Name field. The parsed first name for the second name.
Middle Name
Only used if 2 names are in the Full Name field. The parsed middle name for the second name.
Last Name
Only used if 2 names are in the Full Name field. The parsed last name for the second name.
Suffix
Only used if 2 names are in the Full Name field. The parsed suffix for the second name.
Gender
Only used if 2 names are in the Full Name field. The gender for the second name.

Salutation

Salutation
Output a salutation. E.g., "Dear Mr. Preston."

Address

Company
The company or organization.
Address
The address.
Address 2
The second address. If you specify a second address line, secondary information (apartment, suite, etc.) will be put here. If you choose to not output to Address 2, secondary information will be appended to the first Address.
City
The city.
State
The US State or Canadian Province.
Postal Code
The 9-digit postal code for U.S. addresses and 6-digit postal code for Canadian addresses.
Country
The country name.
Address Key
The AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa products.

GeoLocation

Latitude & Longitude
The geocoded latitude and longitude for the address.

Phone

Phone
The standardized phone number.

Email

E-mail
The e-mail address.

Detailed Address Information

Address Type
A code for the address type.
Code Description
S Standard Address
G General Delivery Address
M Military Address
P PO Box Address
R Rural Route Address
U Unique/LVR Address
Delivery Indicator
The Delivery Indicator.
Code Description
B Business Address
R Residential Address
U Unknown Address
Extra Address Information
Extra information that does not fit in any of the output address columns.
Urbanization (PR Only)
The urbanization name. These are used only in Puerto Rican addresses.
City Abbreviation
The city abbreviation is any is available.
State Name
The full state name.
ISO Country Code
The ISO country code.
Carrier Route
The Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.
Delivery Point
The Delivery Point (DP) and its check digit. This is a 2-digit code defining the address's delivery location. The single-digit check digit follows the delivery point and serves as an error check for the ZIP Code, Plus4 and Delivery Point.
Universal Time Code
The Universal Time Code (UTC.) This indicates the amount of hours:minutes offset from Greenwich Mean Time (GMT.)

Census Information

CBSA Code
The Census Bureau Core-Based Statistical Area (CBSA) code. This is a 5-digit code for the address.
CBSA Title
The Title describing the CBSA code.
CBSA Level
The Level of the CBSA code. If present, the CBSA Level will be Metropolitan or Micropolitan.
CBSA Divisional Code
The CBSA representing the division associated with the address.
CBSA Divisional Title
The Title describing the Divisional CBSA code.
CBSA Divisional Level
The Level of the Divisional CBSA code. If present, the Divisional CBSA Level will be Metropolitan or Micropolitan.
County Name
The County name.
County FIPS Code
The County FIPS code. This is a 5-digit code. The first two digits indicate the state while the last three digits indicate the county within the state.
Census Block
The Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blocks are the smallest geographic area for which the Bureau of the Census collects information.
Census Tract
The Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Census Tracts are small subdivisions of the county.
Place Name
The Place Name. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Name will refer to that area.
Place Code
The Place Code. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Code will refer to that area.
Congressional District
The Congressional District. This is a 2-digit code indicating the address's congressional district.

Parsed Address Components

House Number
The parsed House Number for the output address.
Street Pre-Directional
The parsed Street Pre-Directional for the output address.
Street Name
The parsed Street Name for the output address.
Street Suffix
The parsed Street Suffix (a.k.a. Street Type) for the output address.
Street Post-Directional
The parsed Post-Direction for the output address.
Suite Name
The suite name.
Suite Number
The suite number.
Private Mailbox Name
The parsed Private Mailbox Name for the output address. These mailboxes are used in commercial receiving agencies, such as the UPS store.
Private Mailbox Number
The parsed Private Mailbox Number for the output address. These mailboxes are used in commercial receiving agencies, such as the UPS store.
Route Service Number (Canada)
The parsed Route Service Number for the output address. Canada only.
Delivery Installation (Canada)
The parsed Delivery Installation for the output address. Canada only.
Lock Box Number (Canada)
The parsed Lock Box Number for the output address. Canada only.


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.