You must first upload the file you want to cleanse and enrich.
Then select the data quality service you want to use.
By default, the File Name, File Size, Header presence, and Record Count are displayed at the top of this page.
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.
Check the boxes next to your desired output columns
- Full Name
- Full name. E.g. "Dr. Bill S. Preston, Esquire."
- Any part of the name that precedes the given name, such as "Mr.," "Ms." or "Dr.," for each full name detected.
- First Name
- Parsed first name. E.g. "Bill."
- Middle Name
- Parsed middle name. E.g. "S."
- Last Name
- Parsed last name. E.g. "Preston."
- Any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), for each full name processed.
- Company Name
- The company or organization name.
- Address 1
- The updated address or standardized street address that was used for verification.
- Address 2
- 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.
- The city name. The information returned may be different than the contents of the City input field, if the preferred city name has been substituted for a vanity city name or if the address was coded to a different ZIP Code instead.
- Two-character state abbreviation.
- Postal Code
- Five-digit U.S. ZIP Code.
- Country name.
- Address Key
- AddressKey for the returned record. The Address Key was created by Melissa Data to uniquely identify an address and used as input to our other individual services like Geocoding.
- Move Type
- Move type description.
- Move Status
- Move status description.
- Move Date
- Move effective date.
- Extra Address Information
- Extra information that does not fit in any of the output address columns.
- Suite. If requested, the suite will be populated in this column instead of the output address columns.
- Private Mailbox
- Private Mailbox. These mailboxes are used in commercial receiving agencies, such as the UPS store. If requested, the Private Mailbox will be populated in this column instead of the output address columns.
- Urbanization (PR Only)
- Urbanization name. These are used only in Puerto Rican addresses.
- City Abbreviation
- City abbreviation is any is available.
- ISO Country Code
- ISO country code.
- Carrier Route
- Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.
- Delivery Point
- 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.
- House Number
- Parsed House Number for the output address.
- Street Pre-Directional
- Any directional indicators that precede the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
- Street Name
- The street name, minus the suffixes or directionals. For "SW Main Street," this would return "Main."
- Street Suffix/Type
- The standard abbreviations for the street types: "RD," "ST," "AVE," "BLVD," etc.
- Street Post-Directional
- Any directional indicators that follow the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."
- Suite Name
- The descriptive portion of the secondary address: "SUITE," "APT," "UNIT," etc.
- Suite Number
- Parsed Suite Number for the output address.
- Private Mailbox Name
- Parsed Private Mailbox Name for the output address. A private mailbox, or PMB, is a secondary address associated with a Commercial Mail Receiving Agency (CMRA). Because the CMRA may itself be located in a suite, such an address may have both a suite number and a PMB number.
- Private Mailbox Number
- Parsed Private Mailbox Number for the output address.
- Route Service Number (Canada)
- Parsed Route Service Number for the output address. Canada Only.
- Delivery Installation (Canada)
- Parsed Delivery Installation for the output address. Canada Only.
- Lock Box Number (Canada)
- Parsed Lock Box Number for the output address. Canada Only.
This section displays your selected options and columns.
Create Job Name
- You must also create a name for the job.
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.