BatchDeduplicator

Marketing is one of the most important process in an organization and it significantly affects the sales and revenues. In order to ensure the effectiveness of this process, it is essential that all the data related to potential customers is maintained and managed efficiently because this data can be very heavy in some of the large scale companies. Typically, there are different types of lists in such a database and it is essential to manage all the duplications among different lists and databases in an effective manner. BatchDeduplicator v.4.02 is a powerful utility which allows you to avoid these duplications and provides comprehensive search features on the basis of customized criterion by the end user.

BatchDeduplicator lets you sort out all the duplications in the address tables which can be scheduled in order to ensure periodic searches and quality of data in the longer term. This way, you can easily save the expenses on the duplication of your marketing efforts which is a futile and a wasteful exercise. The doublet search among the two tables that this program provides lets you make a list of customers who do not want to be contacted or receive marketing transmissions; such customers can be easily excluded from future transmission lists. The program supports a number of possible data sources which are popularly used such as Excel, MySQL, MS SQL server, Oracle, Access, Postgre SQL, CSV, dBase, VIsta DB, and other text files. The application can work over various criterion and functions like phone number, postal address, email address, tax number, customer number etc. along with an option to deduplicate data between two tables.

BatchDeduplicator v.4.02 is overall, a powerful tool for avoiding any duplication in between the two datasets, leading it to score three and a half rating points on the scale of five.

The BatchDeduplicator is a program for regular doublet searches performed in address tables on a fixed schedule, in order to ensure the long-term quality of this data. Particularly repetitive advertising in the case of direct marketing and the unnecessary repeated maintenance of client and other address data can thus be avoided. Of course, this leads to a direct savings of costs. Furthermore, a doublet search between two tables can also take a list of customers who do not wish to receive marketing transmissions into consideration, which can save a lot of trouble.
Here is a brief overview of the features of the BatchDeduplicator:
- Fast, largely automated and thus easy to use comparison of address databases for double addresses. The postal address (error-tolerant matching), telephone number, email address, address or customer number and tax number can all serve as matching criteria.
- Option to compare with blacklists and the enhancement of an address database using the comparison results with data from a second address database.
- Option to combine multiple tables into a single matching operation.
- User-defined universal matching, that can be used for any form of data.
- Numerous options for the further processing of the matching results: beside the direct deletion in the source file, it is also possible to flag the results in the source file, or to process further using a stored procedure, a duplicate-, results- or archive-file
- A deletion and results log that includes comments and your own logo, that can be saved as a PDF file, among others.
- The possibility of planning projects. For example, the program could be instructed to execute a certain project every Monday at 8 pm.
- The possibility of executing one or several projects by starting the program with command line parameters. An example of this would be: 'BatchDeduplicator -exec 1+5+7'
- Of course, all projects can also be started manually.
And much more ...