Contact Zone delivers powerful extraction, transformation, and loading (ETL) capabilities combined with seamless data cleansing and enrichment functionality. Built on the Pentaho Data Integration (PDI) platform, Contact Zone empowers users to visually design transformations and jobs that cleanse and prep data stores and make them available for easy reporting, analysis, and migration to the data warehouse.
With an intuitive, graphical, drag and drop design environment and a proven, scalable, standards-based architecture, Contact Zone is ideal for organizations that want to make trusted data available across the enterprise in one set of tools.
Contact Zone Provides
Data Integration (?)
Prepare and blend data to create a complete picture of your business that’s analytics ready.
Identify data errors at their source and monitor rules and standards over time to improve quality.
Generalized Cleansing (?)
Build data cleansing scripts from six operations to clean a wide range of errors and inconsistencies.
Personator (ID Verification) (?)
Correct, verify and enrich U.S. and Candian contact data. Also provides name-to-address matching for ID verification.
Global Contact Verify (?)
Verify, standardize and format international contact data – name, address, phone and email - for 240+ countries plus geocoding.
SmartMover (NCOA) (?)
Change-of-address processing for U.S. and Canadian customers that have moved.
Contact Verify (?)
Verify, standardize and format U.S. and Canadian contact data – name, address, phone and email plus geocoding.
Identify and merge/purge duplicate records utilizing advanced fuzzy matching and deep-domain knowledge.
Add valuable property and mortgage data from over 140 million U.S. records.
Access detailed consumer demographics from over 2 billion U.S. individuals and household records.
Add company information including contact name, title, address, sales volume and more for 25 million businesses.
IP Location (?)
Find a geolocation of an IP address including latitude, longitude, city, region, country and more.
Contact Zone provides ease of use with the power to integrate all of your data. It offers a rich library of pre-built components and Melissa Data components to access, prepare, and blend data from relational sources, big data sources, enterprise applications, and more.
Contact Zone’s intuitive drag-and-drop data integration is coupled with data agnostic connectivity spanning from flat files and RDBMS to Hadoop and more. Go beyond standard ETL to scalable and flexible management of end-to-end data flow with:
Poor data quality equals poor business. The first step in improving data quality is to profile your data to gain valuable insight into the accessiblilty and usability of your data. The Data Profiling component does just that – it generates simple to advanced profiling information – including basic data statistics (mean, median, frequency, variation, etc.) and details (structure, content, classifications, etc.). Armed with this information you can identify weak points in your data collection processes and work to optimize data quality over time with the Profiling Component’s monitoring capabilities.
Generalized Cleansing Component
The Generalized Cleansing Component empowers you to build data cleansing scripts for data suffering from a wide range of errors and inconsistencies. The component combines six operations that allow you to cleanse data and save operations (simple or complex) for future projects. The component is highly customizable so you can use programmatic expressions and regular expressions to trigger operations – giving you the ability to self-validate non-contact data to your own specifications.
Cleansing Operations Available:
The Personator component taps a multisourced dataset containing billions of records to validate each provided element of a U.S. or Canadian contact record: name; address; phone; and/or email, and match name-to-address for a simple and quick identity verification.
The Personator Component also offers a wealth of append functionality to enrich your contact records, including:
Global Contact Verify Component
Use the Global Contact Verify Component to clean, verify, standardize and format all your global people data – name, address, email and phone. The component will verify addresses from 240+ countries, standardize addresses to local country format, and add missing postal codes, regions, etc. The component supports many different language sets and can transform non-Latin writing systems into Latin characters so addresses in foreign languages like Russian, Greek, Chinese, Japanese and others can easily be validated.
The component also geocodes international addresses for 40+ countries, providing a precise (rooftop) latitude/longitude coordinate for an address to power market segmentation, sales clustering, logistics, risk exposure, and more.
In addition, the component performs verification on your phone, email, and name data. Phone verification includes real-time lookup technology to distinguish between global landlines and mobile numbers, and validates the number is accurate, live and callable. Caller ID will return the name and address associated with the billing contact. Email verification capabilities include: real-time email mailbox verification to ensure an inbox is live; email syntax and domain correction; and FCC Mobile Domain Detection to ensure CAN-SPAM compliance.
Contact Verify Component
For your U.S. and Canadian contacts, the Contact Verify Component is ideal for standardizing, verifying and enriching name, address, email and phone info. The component utilizes a USPS CASS-Certified™ engine to return a complete and standardized U.S. address and even adds missing ZIP+4® data, missing suite and apartment numbers, identifies the address as residential or business, and corrects spelling and formatting errors.
The component also verifies U.S. and Canadian phone, email, and name data. Phone verification includes real-time lookup technology to distinguish between U.S. and Canadian landlines and mobile numbers, detect if it is residential, business or SOHO (small office/home office), and validates the number is accurate, live and callable. Caller ID will return the name and address associated with the billing contact.
Similar to the Global Verify Component, the Contact Verify Component’s email verification capabilities include: real-time email mailbox verification to ensure an inbox is live; email syntax and domain correction; and FCC Mobile Domain Detection to ensure CAN-SPAM compliance.
On average, a database contains 8-10% duplicate records. These duplicates result in waste and inefficiencies and cloud your ability to get a single, accurate view of the customer. The MatchUp Component uses advanced fuzzy matching algorithms and deep domain knowledge of contact data to find even the hardest-to-detect U.S. and international (Canada, Europe, South America, Australasia and more) duplicate records.
MatchUp employs over 16 different fuzzy matching algorithms to identify “non-exact matching” duplicate records that are difficult to uncover, including:
The SmartMover Component provides change-of-address processing for U.S. and Canadian addresses. This helps you stay in touch with consumers and businesses that have moved, eliminate the costs associated with undeliverable-as-addressed mail, and qualify for applicable postal discounts.
For U.S. addresses, the SmartMover component matches your customer records against the USPS® full NCOALink® data file of 160 million moves going back 48-months. Processing your records utilizing the SmartMover component will satisfy the USPS Move Update requirement for a period of 95 days from the date of processing to qualify for First-Class, and USPS Marketing Mail™ (Standard Mail).
Melissa Data is an NCOALink Full Service Provider licensee of the USPS. NCOALink processing requires a Processing Acknowledgement Form (PAF). Download a copy of our NCOALink PAF
For Canadian addresses, the SmartMover component will match your address file against the Canada Post NCOA® database containing over 11 million records over the last 72 months. Melissa Data is one of only a handful of Canada Post licensees. Canada NCOA processing requires a signed copy of the Canadian NCOA Acknowledgement Form. Download a copy of our Canadian NCOA form.
The Demographic Component provides detailed consumer demographics from over 2 billion records containing 250 million individuals and 170 million households in the U.S. This valuable information offers you deeper insight into your customers, their behavior, and trends. The following variables can be added:
The BusinessCoder Component adds detailed firmographic data to your business records including company and contact information (name, address, phone number, and email address), SIC/NAICs codes, employee size, sales estimate and more. Adding firmographic elements to your prospect and account records helps improve lead scoring, analytics and sales and marketing efforts. Simply pass an address, StockTicker, website, phone number, or Melissa Address Key (MAK), and BusinessCoder will return the following elements for over 25 million businesses:
The Property Component provides valuable property and mortgage data from over 140 million records for the U.S. Access variables from over 165 fields in categories such as: parcel; property address; owner; owner mail address; property values; current sale; current trust deed; prior sale; lot/land; square footage; building. For a complete list of data available click here.
The IP Location Component provides the geographic location of an Internet Protocol (IP) address, including latitude, longitude, city, state, ZIP Code™/Postal Code, region, hosting Internet Service Provider (ISP), connection speed and type, and domain name. This information helps you identify where your web visitors are coming from. This is useful for ecommerce sites where you might want to prepopulate country code on forms, display a different language, filter access from countries you don’t do business with, and/or reduce credit card fraud based on geographic location. IP Location can also help fight illegal spamming and hacking by identifying the location of the problem.
Postal Presort Component
The Presort Component can help you take advantage of the postage discounts offered by the USPS for presorting your mail to the finest level. The component is Presort Accuracy and Validation Evaluation (PAVE) Gold-Certified by the USPS to presort letters, cards, and flats for – First Class, Periodicals, and USPS Marketing Mail (Standard Mail) classes. The component presorts mail to all the allowable levels (walk sequence and high-density saturation, carrier route, enhanced line-of-travel, 3-digits and 5-digit presort). Use the Presort Component combined with the Contact Verify (address correction), SmartMover (move-update processing) and MatchUp (duplicate elimination) components to get your mailing lists in the best shape for efficient delivery and maximum postal discounts.