Learn about our newest features and enhancements!
Data Importing: Contacts & Use of Contact Matching
Authored by:
on 1/30/2024 11:24:00 AM

Introduction

Whether you are adding contacts in bulk into your new account or adding additional contacts to an existing account, we know that having good data is essential for reporting and fundraising. CharityEngine's importing feature will assist in managing or identifying duplicate contact records. 



Prerequisites

  1. If you are completing your initial contact importing, CharityEngine recommends disabling matching as there is no data to match within the database. This will also allow the import to run much faster.
  2. If you are completing contact importing into your existing database with existing records, enable matching to leverage CharityEngine's logic to avoid importing duplicate records. 
  3. Once Contact Matching is enabled, two drop downs will appear, Multi-Match Action and Match Update Action.

Instructions - How "Contact Matching" Works

"Contact Matching" Feature - 15 criteria in which the system will match

These criteria are ranked and the system will choose the highest ranked match criteria:
    1. Name And Email And Phone And Address
    2. Name And Email And Address
    3. Name And Phone And Address
    4. Name And Email And Phone
    5. Name And Email
    6. Name And Address
    7. Name And Phone
    8. Email And Phone And Address
    9. Email And Address
    10. Phone And Address
    11. Email And Phone
    12. Email Address
    13. Address - If it is not an office*
    14. Phone Number
    15. Name
* Contacts often share a business address, due to this if the address type if an office, the criteria is suppressed and not used to match contacts.

Example: You already have two existing contacts in CharityEngine and are entering a third. If you are using the Select Closest Match option, the data base will select the contact using the above criteria.

Existing Contact 1:
First Name: Ben
Last Name Bird
Email: bbird@charityengine.net
Address 123 Givens Place, New York, NY 10015
Phone: 212-555-1234
 
Existing Contact 2:
First Name: Mister
Last Name: Bird-Snyder
Email: bbird@charityengine.net
Address: 456 Sesame Place, New York, NY 10015
Phone: 212-555-6789
 
Imported contact information:
First Name: Ben
Last Name Bird
Email: bbird@charityengine.net
Address 123 Givens Place, New York, NY 10015
Phone: 212-555-1212
 
The contact that will be selected as closest match is Existing Contact 1 due to having the most data in common with the imported contact. Note that this is considered a match even though their phone numbers are different.

Contact Matching is located within the Data Jobs wizard within Configure Additional Job Settings:

 


Instructions - How "Multi-Match Action" Works

Multi-Matching Action

Multi-Match Action is the action that will take place when multiple matches are found in CharityEngine but no matches are considered an exact match.

The Multi-Match Action drop down will have three options:

  1. Select Closest Match: This option will import the new data point(s) to the contact that matches closest to the information already input. The system will choose the closest match based on the 15 criteria listed above. These criteria are ranked, which means if there are multiple contacts with similar information, the system will choose the highest ranked match criteria.
  2. Create Duplicate Record: This option will create a new record for the contact and creation of a duplicate contact record.
    1. For example, if three people are in the same household, containing the same mailing address, but emails and other contact information differs. You would not want to import the new contact information to a contact that already exists but create a new or duplicate contact. After the duplicate record has been imported, the duplicate records can be updated by navigating to the De-Dupe Page.
  3. Fail as Bad Record: This option will result in no action to the database and will result in the creation of a Bad Record txt file.
    1. As a best practice, CharityEngine suggests using this option first so you can easily identify the total number of contacts that may be identified as a duplicate record.
    2. From the Bad Record txt file, you can then determine your best approach for managing and attempt a second import of these records. 

Multi-Match Action is located within the Data Jobs wizard within Configure Additional Job Settings:


    Instructions - How "Match Update Action" Works

    "Match Update Action" Feature - Determine the right setting

     

    The second important drop down, is the Match Update Action. This drop down tells CharityEngine what to do when a match is found. The drop down has two options:

    1. None: This option will result in no change to the existing contact and contact data. This action will however add new data if the existing data element is currently null.
    2. Update: This option will result in an update to the matched contact’s data with the data in the import file. New data from the import file will overwrite any information on the contact record. 

    Match Update Action is located within the Data Jobs wizard within Configure Additional Job Settings:

     


    FAQs & Additional Reading

    Q. How do I begin importing People Contacts?
    A. Learn more about people contact importing and best practices here
    Q. I have decided to intentionally import duplicate records. What is the best approach to identify duplicate records?
    A. When importing a contact that has similar contact information as another contact, but is a different person, or you are unsure if you already have a contact in your database, this is the best option to choose.  For example, if three people are in the same household, they will have the same address and possibly the same phone number, but their emails and other contact information is different. You would not want to import the new contact information to a contact that already exists but create a new or duplicate contact. After the duplicate record has been imported, the duplicate records can be updated by navigating to the Automation & Workflow App > Contacts > De-Dupe People feature. 

    There will be active filters already in place, however these can be updated by selecting different filters in the Advance Filter.

     



    Related Articles

    Powered by Powered By CharityEngine