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 ease of use with the power to integrate all of your data. It offers a rich library of pre-built components and Melissa 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.
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:
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.
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:
Proximity Matching
MatchUp’s patented distance algorithm uses lat/long coordinates and proximity thresholds to identify duplicate data.
Householding
MatchUp can identify and consolidate records that are members of the same household. This is useful in being able to evaluate the total sales relationship and by eliminating unnecessary multiple mailings for cost savings.
List Intersection / Suppression
MatchUp finds all the common data elements between multiple lists and/or use suppression to find just the data unique to each individual list.
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 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 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 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.
Request a free trial by filling out the form.