Advanced Search Recipe: Find Non-Donors

Oftentimes a list is needed of Individuals in your database who have not donated to the campaign. This, for example, could be used for mailing purposes to contact potential donors. You can use the following two-step Advanced Search recipe to locate those individuals.

Step #1:

Area: Entities
Field: Entity Type
Relationship: Is Any Of
Value: Individual

Click the Add Rule button.

Step #2:

Leave that rule in the Search Criteria section and back up in the Add Rule section, select the following:

Area: Contributions
Field: Amount
Relationship: Is More Than
Value: 0

Instead of clicking Add Rule, this time click Add as Exclusion.

At this point you have the option of generating the list on your screen by clicking the Run Search button at the bottom of the screen. You can also generate this list to a spreadsheet by selecting one of the Export options.

If you plan on generating this list on a regular basis, click the Save & Run Search button to save the search criteria for future use. This will prevent having to re-add the criteria every time you need the list. Moving forward you’ll see the list in the Saved Searches menu based on the name you gave it.