Duplicate data is a common issue in Ticketmaster Archtics® due to the multiple data entry points, both direct and indirect, into the database.
Duplication can cause a number of problems for both the sales and the marketing departments. Salespeople need to spend extra time finding the right customer data. Leads and customers may get redundant phone calls and mailings. These issues result in inefficiencies and can lead to a less favorable perception of the organization. In the worst cases, the result is lost ticket sales.
Database duplicate detection is often limited to a simple comparison of text strings and substrings from among a set of fields. The problem with the text string comparison method is that it only catches a fraction of duplicates.
We’re introducing a solution based on a proven technology for client/server applications.
Archtics Duplicate Records That Aren’t Detected
Duplicate records can be created in Archtics via both user data entry and by external feeds via a variety of channels. The following are some of the cases for which duplicates are not be detected by standard text comparison methods:
- Nicknames (Gabby vs. Gabriella)
- Phonetic Similarities (Catherine vs. Kathryn)
- Subtle Name Variants (Johnson vs. Johnston)
- Misspellings (Duglas vs. Douglas)
- Word Order (Peter Smith vs. Smith, Peter)
- Abbreviations (AVT vs. Advanced Video Technologies)
- Noise Words (Inc., Ltd, LLC, Corp, .com, The, & Company, etc.)
- Word Segmentation (Salesforce vs. Sales Force)
- Spelled out Street Numbers (One Market vs. 1 Market)
- Multiple Email Addresses (<fan>@yahoo.com vs. <fan>@gmail.com)
In order to be an effective duplicate detection tool, the tool must have phonetic, fuzzy matching capability to find matches based on cases such as these.
An Archtics Duplicate Detection and Cleaning Process
With this more advanced method, there are four steps involved in identifying and removing duplicates from Archtics.
Step 1
Define your specific rules and thresholds for Archtics duplicate detection
Step 2
Review suspected matching records
Step 3
Export the record IDs for identified sets of matches
Step 4
Use Archtics-developed merge scripts for your current version to clean the Archtics database
For more information on this method for detecting duplicates in your Archtics database, please call us at 1-800-799-4539, email us at info[at]lexnetcg[dot]com or fill out the following form:
