!Skip navigation


Remove duplicate records from your database

Duplicate records. Every company's database has them and every database marketer hates them. Duplicate records cost time and money and, no matter how consistent you attempt to be with your data-entry rules, duplicated records will inevitably make their way into your database.

Experian QAS has partnered with helpIT systems, to launch a premium deduplication tool, matchIT, to suit every business need.

matchIT is a powerful and intuitive de-duplication tool, that is highly flexible and customisable. matchIT is ideally suited to all companies and organisations dealing with a wide variety of business and consumer data. matchIT is ideal for:

  • Increasing the effectiveness of marketing campaigns
  • Improving customer intelligence
  • Data migration projects - merging multiple databases and achieving project objectives

Download your free trial of matchIT software.

The problem with duplicates

Duplicate records can cause a lot of headaches for your business and for you.

Common issues:

  • Organisations are unable to obtain a true and complete view of customers and customer data.
  • Data migration projects are unsuccessful due to inability to accurately identify and remove duplicate records
  • Duplicate messages and communications sent to customers damage credibility and customer perception
  • Duplicates reduce the effectiveness of marketing campaigns producing a low ROI
  • Data analysis reports are skewed due to the presence of duplicate records

Benefits of accurate de-duplication

The advantages of using matchIT deduplication solutions will be felt throughout any organisation.

Using matchIT Complete will:

  • Improve the reliability of your data and decisions by validating, cleaning and de-duping your contact database
  • Reduce the time it takes to manually identify duplicate records
  • Save you money ensuring you are mailing to contacts once
  • Enhance brand perception by ensuring your communication is sent once - to the right person at the right address

De-Duplication Range of Solutions

1) matchIT

Is a standalone product ideal for small projects.

The matching functionality enables you to dedupe your current database based on mailing addresses, email addresses and company details, and much more.

2) matchIT Complete

Is an integrated solution that cleans, validates and standardises your address records and dedupes your contact data in one seamless process.

matchIT Complete's core engines are the two leading engines in their respective fields:

  • QAS Batch verifies and cleans your customer/prospect addresses against the records at Australia Post. Clean and accurate address data will result in higher matching rates by the matchIT matching engine
  • MatchIT is considered one of the most sophisticated and effective products available for the detection of matching records within poorly structured data. matchIT's proprietary phonetic algorithm is unrivalled and allied to other matching techniques and customisable tables

Based on match scores, records can be merged automatically or reviewed manually, depending on your preference. matchIT Complete will identify which records are best and should be preserved, and which records should be combined with data from duplicate records so that no data is lost.

3) matchIT + QAS Batch

Is the premium solution for any organisation planning a data migration project. QAS Batch will clean and validate your contact data, enabling interactive cleaning to ensure no record is missed. matchIT will then sort and identify duplicates.

This bundled solution ensures greater control over sensitive contact information and is essential for any major data migration project with more than two databases being combined.

All of the deduplication solutions feature the highly sophisticated matching engine:

  • Maximises true and accurate
  • matches
  • Minimises the manual effort required to review duplicates
  • Provides fully customisable reporting

Features

Phonetic and Fuzzy Matching - matchIT's advanced technology utilises several algorithms to detect phonetic, mis-keyed and abbreviated variations even within poorly structured data. It overcomes human errors to highlight potential matches such as:

  • Bill Dayton Jr. at EPS and Deighton, William Robert at EPS Australia Pty Ltd
  • Sounds like names, such as Bill Deighton and Mr. W. Dayton
  • Acronym and initial matching to match inconsistencies, like Bill and Mr. W.
  • Keying errors, such as transpositions like Wilson and Wislon
  • Element matching to match reversed or incomplete names, such as Mr. W. E. Dayton, Dayton William Jr and Dayton Bill.

To request further information click here.