Advanced: Dedupe and Merging


Managing duplicates is a critical part of maintaining a useful database. Powerbase offers a number of complex methods to properly avoid duplicates and merge ones that are created.


All participants should finish this lesson understanding what a de-dupe rule is, how to create one and the workflow for finding and merging duplicates.


Good math skills.


The lesson should take about 45 minutes. All students should be using the training database for this lesson.


Q: How do you know if two records in your database are the same person?
A: First name, last name and email is our recommended answer, but...
Q: What if you are importing records without an email address (sign in sheet or from another source).
A: First name, last name and email OR phone. Different situations call for different.

Balancing act between allowing duplicate records and avoiding improper merges.

FUN FACT: When you allow people to register for an event or make a contribution, you are inviting complete strangers to edit your database.

Explain steps:

  1. Define rules
  2. Configure Powerbase touse rules
  3. Find duplicates
  4. Merge duplicates


First Step: define rules

  1. Display Find and Merge screen
  2. Difference between individual and organization
  3. Difference between supervised and unsupervised
  4. Add new rule and explain weights and thresholds
  5. Don't use length unless absolutely necessary!

Second Step: configure Powerbase to use rules

Show event page where you can specify which rule to use.

Third step: Find duplicates

Back to Contacts → Find and Merge duplicates

Explain batch process

Fourth Step: Merge

Also show merge contacts option in search results.

Training Category: