Trail Blazer Knowledge Base:


Home : Record Management : How to Find Duplicate Contact Records by Identical *Primary* Email Address, and Automatically Merge them Together

Knowledge Base







User:

Password:



Article ID: KB282
Keyword Name: Merge, Email Duplicates, Automatically, Record Management, Cleanup, Database Maintenance, Dupe, Email,dedupe
Created: February 15, 2017
Viewed: 2628

How to Find Duplicate Contact Records by Identical *Primary* Email Address, and Automatically Merge them Together






Click Here to view this article as a PDF.






Author: Joel Kristenson

Last Updated: 2015-06-15








Overview


This article walks through the steps to find duplicate contact records in your database by Primary E-Mail Address - which is a new feature that was released in 2015.  It also shows how to quickly merge those duplicates where First Name and Primary E-Mail Address are *Identical*.



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: If you’ve never cleaned up the duplicates in your database take a look at these few articles to keep your database as tidy as possible:

- (Video) Households – What To Do B4 Householding!!

- (Video) How to Manage Duplicates

- (Article) Address Management

- (Article) Automatically Conform Addresses

- (Article) Auto-Merging Duplicate Address Records






Steps


Navigate to your Contacts (Donors/Voters) list.



Navigate to the General > E-Mail tabs, plug-in the tab, uncheck the Alternate box, uncheck all of the email flag check boxes, and click [Search] > (Load All)


The image below shows my query which produced 5,851 contacts.



Select File > Utilities > Find Possible Duplicates



Check the box for Email ONLY, Primary Email only, and click [OK].



This will run the process on all contacts that are in the list and provide you with the final count.  My example results are below where the system found 154.



Click [OK] to finish.


At this point you have a couple of options.  You could set an attribute for everyone in the list labeling them as a possible duplicate to cleanup at a later time, or you could go through the automated merge process.


I opted to auto-merge any contact that had an identical First Name and Primary E-Mail address.


Follow File > Utilities > Merge.



Select Merge contacts where email address and name match, and click [OK].



This system will update you with the results once it’s complete.  For any records that didn’t merge you’ll need to either fix their name/address data so that it’s exactly the same and run the process again, or drag-and-drop merge the duplicates.



















Related Resources

Article: Manually Merging Contact Records

Article: Auto-Merge Duplicate Contact Records

Video: How to Manage Duplicates





Trail Blazer Live Support

http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.


Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.




Find our more information about Trail Blazer Campaign Services Inc. [click here]


Powered by: ClickCarts KnowledgeBase