How to Find Donor Information in Your Fundraising CRM

Which fields should I search within?

After you’ve determined the type of search you need to perform, it helps to get creative with the fields to search within. Once again, the purpose of your search will help to determine what fields will yield the best results. Let’s review some useful examples to get you started. 

Purpose: I want to avoid creating duplicate records during data entry

Something as simple as searching for existing donor records to prevent duplication can present a challenge if data entry is inconsistent or inaccurate. Consider a donor named Robert who commonly goes by Bob. If you search for his record using his full first name and last name his record may not return in the results. In scenarios such as this, try using several search criteria:

• Search by Last Name only
• Search by Address (this is a good option for finding spouse/partner records too)
• Search by Email Address only

Purpose: I need to prepare for an upcoming mailing by finding records with incomplete donor profiles.

How do you find donor data that isn’t there? This is definitely a scenario where you will need to build a filter, and it’s really quite simple. When you’re building a filter to find records with missing data choose the field you want to focus on and use a filter function that looks for blank (or null) fields. This is a great practice to get in to regularly to maintain your database. Search for donors with missing or incomplete addresses/phone numbers/emails etc. Do your best to obtain the missing information and for those records that you cannot update, identify them as a do not mail record to save costs on mailings.

Purpose: I need to delete old donor information.

It’s hard to let go of donor data. Just like that box of old computer wires, what if it comes in handy one day? If it’s just a record or two, you can use the search screen, but for searches that involve the removal of data, it’s best to handle this with a lot of care. A filter and report are the ideal option because a report can allow you to export and save the data first before you delete it. As far as searching for records to delete, consider searching on fields like their most recent gift date, most recent volunteer date, or most recent interaction with your organization. 

(CRMs, like DonorPerfect, make it easy to create your own fields that will track information like a donor’s most recent contact with your organization.)

Nonprofit CRMs are a great resource to meet your fundraising goals and by asking the right questions, you can easily search for and find the donor information you need. 

Your nonprofit data is meant to help your organization make more informed decisions that will ultimately lead to more revenue for your mission, not make your job harder than it needs to be. The Clean Data Checklist, available for free download below, is a customizable guide for your nonprofit data procedures, complete with best practices and examples. Here’s to healthier data that leads to better results!