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.
Melissa MatchUp is the most powerful and accurate matching and deduping solution on the market to combat the problem of duplicate records. What sets it apart from the rest is its intelligent parsing capability to understand and parse the various components of international addresses. By combining deep domain knowledge of international address formats and advanced fuzzy matching techniques, MatchUp gives you the ability to identify and merge/purge even the most difficult-to-spot duplicate records.
Try to find the duplicate records using some of MatchUps matchcodes.
MatchUp employs a Matchcode or set of rules 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:
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:
The World Edition of MatchUp can match international records with support for 12 countries, including Canada, Germany, U.K., and Australia and upcoming quarterly additions. 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).
Survivorship/Golden Record (SQL Server® and Pentaho® only)
MatchUp’s most unique method for determining the most accurate view of the customer – the Golden Record – is called Survivorship. The Golden Record process identifies the best record of a matched group based on criteria including most complete, best overall data quality (derived from the validity of address, name, phone, and email data), most frequent specified value or a custom criterion you create. Duplicate entries can be collapsed into a single customer record while retaining any additional information that may be accurate and applicable through unlimited Survivorship configuration options.
MatchUp has some unique attributes which can be employed to help identify duplicates geographically or by household.
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.
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.
MatchUp offers three methods of operation (or ways to match records):
"Melissa's technology works seamlessly with SQL Server Integration Services, and provides another way for my clients to achieve highest data quality information. Customer service was excellent, and their technical team provides top support for people wanting to use the technology."
"Melissa easily integrates into both our system and our vendor's systems. They offer a variety of cleansing solutions. Setting up our contract has been easy. We are cleansing our data so that we do not mail invalid records. We've saved hundreds of thousands of dollars a year and decreased cost per acquisition."
"The advanced features of the Address Object API allows us to greatly reduce our "undeliverable" loses and improve our next-day delivery customer experience. In my experience Melissa has done a fantastic job in advancing their products and services. We have been move then pleased by their performance and pricing for their products."
"The API was easy for my developers to integrate into the applications we use. The documentation was excellent and the customer support equivalent. Data integrity is also another key component and makes verifying addresses simple and accurate."
Request a free trial by filling out the form.