!Skip to content

Identify and merge duplicate contact records

Identify and merge duplicate contacts in volume

In-depth demo Snapshot demo

Highlight duplicate records in your contact lists and databases

  • Identify and merge duplicate contact records
  • Avoid the costs associated with duplicated contact information
  • Find duplicates according to your own business rules
  • Keep the control of your contact data in-house
  • First step towards a single view of your customers
  • Find out more about QAS Unify call 0800 197 7920 or email us

Ensuring that your database is free from duplicate contact records is an essential part of effective contact data management. To provide you with a single view of your customers, your organisation must aim to regularly remove duplicates in your existing database(s), and ensure that duplicate records are unable to enter your database from the outset.

The challenge of duplicate contacts

  • Businesses lose competitive advantage as business decisions are based on unreliable and inaccurate contact data
  • Businesses operate inefficiently by wasting revenue due to poor allocation of resources and lost productivity

"Over half of all organisations said that more than 5% of the data they regularly mail could be duplicates."

'Making sense of a crowded nation'. An Experian QAS whitepaper, November 2008

1/3

  • Businesses have difficulty maintaining a single customer view
  • Not be compliant with industry regulations

"Research indicates that 89% estimate that they have 5-20% duplicates in their database."

Data Matching Survey produced by Hotwire - September 2008

2/3

  • Customers complain about receiving multiple mailings and ask to be removed from your database
  • Customers develop a negative perception of your organisation and consider switching to a competitor.

"Beyond the obvious costs associated with the lack of a 'single view' of data, businesses waste opportunities to increase revenue and profits, reduce time to market, become more efficient, improve customer service, and reduce business and IT complexity."

Predicts 2008: Master Data Management, Gartner February 2008, Andrew White & John Radcliffe

3/3













QAS Unify is a de-duplication software tool that allows you to prevent duplicates at the point of data collection (real-time mode) and allows ongoing maintenance to identify and merge duplicate contact records in your current database (bulk mode).

The benefits of detecting multiple contact records and preventing future duplication are:

Financial

  • Save marketing costs by not sending out duplicate mailings
  • Make profitable business decisions based on reliable and accurate data
  • Removing duplicates means fewer records to enhance, analyse and suppress later on
  • Save money on maintaining your contact data

Brand perception

  • Avoid complaints and negative PR from customers about duplicate communications
  • Ensure your business is environmentally friendly by not sending duplicate mailings
  • Avoid contacting the same person twice in a campaign

Improved data quality

  • Maintain an accurate, single customer view
  • Make informed business decisions based on accurate data and reporting
  • Prioritise matching components and tailor solution to your business process needs
  • Compare two contact lists for overlapping records
  • Create a complete, merged set of details for each contact

Business processes

  • Save time by not entering duplicate contact records
  • Accurate record keeping and data organisation
  • Reduce information security risks - as an in-house solution, QAS Unify allows you to retain control of your data and removes the need for you to send it off-site for duplicate checking.
  • Find out more, contact us on 0800 197 7920, or email us

QAS Unify has two modes of operation:

Real-time de-duplication: duplication prevention at the point a person's contact details are entered into your database. This works by searching for a specified contact against your database. If an exact or similar record is found, the solution will return these records. This offers the option of selecting an existing contact record from within your database for editing, rather than risking a duplicate record being added.

Bulk de-duplication: allows you to identify and merge duplicate contact records in bulk from your database on a regular basis. This can be done by de-duping a single file or database, or by comparing two files or databases for similar or identical records.

Features of QAS Unify include:

  • Support for large data volumes
  • Identify and merge duplicates at a rate of 2 million records per hour for data sources of up to 40 million records in size.
  • Pre-set and custom matching scenarios - make it easy to group records associated with individuals, families, households and businesses.
  • Intuitive rule builders - give you complete control over how duplicates are identified, how the surviving records are selected and how duplicates are merged together.
  • Multiple matching techniques - to ensure matching is successful and accurate. Phonetic, fuzzy and alias matching are among the techniques employed automatically.
  • Exclusion lists of common words - define lists of frequently-occurring words such as "society" or "Ltd." to disregard when matching organisation names.
  • Matches any type of information - find matches across names, businesses and addresses, as well as other types of information such as dates of birth and national insurance numbers. The full range of elements that can be matched means more accurate de-duplication.
  • Import and export - from and to a variety of common file types and databases via ODBC or direct connection to MS SQL Server 2005 and 2008.

QAS Professional Services

With the assistance of QAS Professional Services, the de-duplication capabilities offered by QAS Unify can be integrated, automated and scheduled periodically to fit or be performed as a one-off bulk de-duplication run to fit in with your business workflow. Our training consultants are also on hand to share their expertise on QAS Unify with you.

  • Find out more, contact us on 0800 197 7920, or email us

Calculate ROI

"Beyond the obvious costs associated with the lack of a 'single view' of data, businesses waste opportunities to increase revenue and profits, reduce time to market, become more efficient, improve customer service, and reduce business and IT complexity."

Predicts 2008: Master Data Management, Gartner February 2008

"Organisations estimate they waste 19% of revenue or funding due to bad data, compared to just 6% back in 2005."

Experian QAS Global Data Management Report Jan 2008

Preventing the entry, identification and removal of duplicates in databases is essential to making the most effective use of a contact data and maintaining data quality.

Use our online tool to calculate how much your duplicates could be costing you. Calculate ROI by highlighting how much you could save with QAS Unify.

  • Find out more, contact us on 0800 197 7920 or email us

Additional information

Product Brochure


Do you want to know more?

Fill out the following form and click on the submit button below. We will contact you shortly.


Stopwatch  Generating address fields...


Your privacy is important to us.
 

* denotes a required field.

Thank you for your interest. An account manager will contact you shortly.




Software, data and services from Experian QAS