Duplicate records can be introduced into lists in a number of ways with the most common being poor data capture software, agent error during capture process or when data is merged from a number of different sources
The impacts of having duplicate records include:
adverse effect on reputation and brand. increased costs for the printing of the mail piece.
increased costs for the fulfilment of the mailing campaign. increase postage costs.
increased administration costs due to handling returns.
Our bespoke software utilises complex pattern matching algorithms to compare fields within address records identifying possible duplicates.
Our software uses a combination of exact and fuzzy matching search techniques to ensure that as many possible duplicates are identified and removed.
Our de-duplication process is customisable to match the requirements of your contact strategy to ensure that where duplicates exist, that the correct records are removed. This can involve identifying duplicates against the following criteria.
exact contacts details and exact address details
similar looking contacts at exact same address
exact contact at similar looking address
different contacts at exact same address
similar looking contacts at similar looking addresses
Once duplicates have been removed, we can use the cleansed list as part of your mailing, or return for your own use.
Either way, once your data has been de-duped, it is important to consider what you intend to do with your cleansed list. Unless you also update your source database, then you will be in the same position the next time you need to use your data.
Your IT provider should be able assist with this, but if not our IT department will be able to advise and assist with both the export and the import from and back to your database.
It is impossible to be certain that duplicates exist where the same contact resides at different locations e.g. Andrew Smith listed at 2 addresses. Is this the same person or 2 different people? One way to help determine this is to check whether Andrew Smith is listed in the NCOA database as moving from 1 address to the other.Tags: services, process, data, capture, sources, software, number, agent, merged, poor, error, ways, duplicate, records, introduced
Chat with us
Inspiring better business
The Direct Marketing Association have been leading the way in direct marketing and helping the industry do better business since 1992. There are 800 members in the the UK, including agencies, list brokers and mailing houses, as well as blue-chip corporations such as BT, M&S, Lloyds TSB and the AA.
Policy and practice are driven by 12 Councils, which specialise in areas such as training and development, lobbying and business services.
Advanced Mailing Solutions have been proud members of the DMA since September 2007.
The ISO 9001 standard relates to quality management systems and is designed to help organisations ensure they meet the needs of customers and other stakeholders.
Advanced Mailing Solutions gained 9001 accreditation in October 2011
The ISO 14000 environmental management standards exist to help organizations (a) minimize how their operations negatively affect the environment; (b) comply with applicable laws, regulations, and other environmentally oriented requirements, and (c) continually improve in the these areas
Advanced Mailing Solutions gained 14001 accreditation in October 2011.