SSIS:Contact Verify: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISContactVerifyNav}}
 
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Contact Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Contact Verify|Overview]]
|-
|[[SSIS:Contact Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Contact Verify:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Contact Verify:Advanced Configuration#Community|Community]]
|-
|[[SSIS:Contact Verify:Advanced Configuration#On-Premise|On-Premise]]
|-
|[[SSIS:Contact Verify:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|-
|[[SSIS:Contact Verify:Advanced Configuration#Dedicated Cloud|Dedicated Cloud]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Contact Verify Tabs
|-
|[[SSIS:Contact Verify:Name|Name]]
|-
|[[SSIS:Contact Verify:Address|Address]]
|-
|[[SSIS:Contact Verify:GeoCode|GeoCode]]
|-
|[[SSIS:Contact Verify:Phone-Email|Phone/Email]]
|-
|[[SSIS:Contact Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[SSIS:Contact Verify:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Contact Verify:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}





Latest revision as of 00:01, 10 November 2015

← SSIS:Data Quality Components

Contact Verify Navigation
Overview
Tutorial
Advanced Configuration
Community
On-Premise
Melissa Data Cloud
Dedicated Cloud
Contact Verify Tabs
Name
Address
GeoCode
Phone/Email
Pass-Through Columns
Output Filter
Result Codes
Result Codes



Contact Verify Overview

Contact Verify provides the ability to verify, correct, parse and standardize addresses, phone numbers, email addresses; parse full names and detect vulgarities; and append census and geographic information like latitude and longitude coordinates.

Address Verification

  • Validate and Correct US and Canadian addresses
  • Append missing suites with SuiteLink® and exclusive AddressPlus technology
  • Determine delivery type (business vs. residential)
  • Validate and Correct non-USPS addresses

Geocoding (Spatial Processing)

  • Assign Latitude and Longitude to the Rooftop
  • Census Tract and Block
  • CBSA Information
  • County Names and FIPS
  • Place Names and Place Code

Name Processing

  • Parse and genderize names and multiple names
  • Detect vulgarities and suspicious words in name fields
  • Detect and standardize companies in the name field

Phone Processing

  • Verify telephone numbers to 7 - 10 digit level
  • Determine Telco Switch location
  • Detect landlines vs. cellular or VOIP
  • Detect Residential, business, small office/home office phones

Email Processing

  • Validate and correct email domains
  • Detect mobile domains (restricted from email by FCC)
  • Detect bad mailbox names (spam, noreply…)
  • Correct common misspellings and syntax errors