Building Your Business

You may be getting information from multiple sources and it is possible that you may have more than one record in your database for the same contact. Relevant automatically takes care of dedupping when doing a mailing so you don't have to worry about sending the same email address more than one message in a mailing. But you should periodically dedup you database to reduce your record storage costs and keep your database lean and fit.

Click on Databases and make sure the correct database is selected. The duplicates report is located on the right side of the main database screen in the special searches section.



Often the simple dedup report will work for you. Select the field that you want to dedup on, usually email address. Select display first only.



There are some cases where you need to dedup on more than one field. If that is the case try the advanced duplicates search. Click on the option 'show all but one' to delete all but one record.



Next you will see a display of all the duplicate records. Click on 'delete this list'. You can safely do this as assuming you clicked on display first only or display all but one you know that you are only deleting the duplicate record. And just to make you feel more comfortable about deleting data be reassured that we back up all data every night so we can always restore for you just in case. You also must always confirm before any deletions:



After you have deleted your duplicates the clean database will be displayed.



Let us know if you have any questions or need help.

Labels: databases, duplicates, tutorial