Melissa Data Quality Platforms
Melissa's Full Spectrum DQ Approach. Learn More
ETL/MDM PlatformsMelissa offers a host of solutions for full spectrum data quality to ensure the success of your data.
Melissa Identity Verification
Increase compliance, reduce fraud and improve onboarding. Visit the Melissa Identity Suite
Melissa E-Commerce / CRM
Apps and APIs for higher conversions, better data and more reliable shipping. See All Melissa IntegrationsMelissa Enrich
Gain insight into who and where your customers are.Popular Products
Melissa Mailing
Qualify for postal discounts with USPS CASS & PAVE Certified solutions.Integrations
Melissa makes it easy for you to cleanse and standardize your data. See All Melissa IntegrationsMelissa Industries
See how Melissa's solutions work across industries.Data Hygiene
Keep your mailing list up-to-date, qualify for postal discounts & reduce UAA mail.Data Enhancement
Enrich your consumer or business records for greater insight & omni-channel marketing success.SaaS
Clean and update your data in the cloud, no software to maintain.
Our Data
Verify & enrich your records with multi-sourced, authoritative reference datasets.
How MatchUp Works
MatchUp employs a matchcode to determine if two records should be considered duplicates. MatchUp uses a predefined matchcode, or one that you have created using the Matchcode Editor.
The following matchcode components (data types) are available for use in identifying duplicates:
Fuzzy Matching
MatchUp combines Melissa’s deep domain knowledge of contact data with over 20 fuzzy matching algorithms to match similar records and quickly dedupe your database.
MatchUp employs the following fuzzy matching algorithms to identify “non-exact matching” duplicate records.
Global Merge / Purge & Deduping
The World Edition of MatchUp supports 46 countries, including Canada, Germany, U.K., and Australia. MatchUp’s advanced deduping can see through diacritic equivalents to Latin characters and interpret keywords that are the same but spelled differently (i.e. Germany and DEU).
Unique Matching Scenarios
MatchUp has some unique attributes which can be employed to help identify duplicates in some interesting ways.
- Survivorship for Golden Record Creation
Matchup can select the best elements from multiple records to survive consolidation, ideal for the creation of golden records for a single customer view. Available in Microsoft SQL Server Integration Services (SSIS) and Pentaho PDI. - Proximity Matching
MatchUp’s patented distance algorithm uses latitude-longitude coordinates and proximity thresholds to identify duplicate records that are geographically close together. For instance, using location attributes, MatchUp can detect matching records at different addresses (for example, a company with two different entrances) but within a specified distance to each other. - Householding
MatchUp can identify and consolidate records that are members of the same household to better understand customer relationships, lifecycle, and needs. You can also use MatchUp to bring together multiple business accounts into “corporate families” to build insight and better evaluate the total sales relationship. Householding can also be used to eliminate unnecessary multiple mailings to the same household to cut down on wasted print, production, and postage costs.
Three Ways to Dedupe Your Data
MatchUp offers three methods of operation (or ways to match records):
- Read / Write Deduping Compares records in one or more databases at once. Each unique group will have one record that receives an “output” status; the other matching records receive a “duplicate” status. Ideal for matching entire databases at one time.
- Incremental Deduping Enables real-time matching by comparing each record as it comes in (like from a web form or call center) against the existing master database. If the incoming record is not a duplicate, it can be added.
- Hybrid Deduping Provides a combination of the first two methods with the flexibility to customize the process to match an incoming record against a small cluster of potential matches. With hybrid deduping you can store the match keys in a proprietary manner. Ideal for real-time data entry or batch processing of entire lists.
