Basic searching and filtering

In this article:


In addition to name searches, you probably will also want to search for constituents by gift history, location, and/or category. Or perhaps you want to drill down into a set of results, looking at individual categories as filters.

Searching with multiple criteria

LGL gives you many options for searching your constituent data. To get a look at them all, you can click on the dropdown menu in the Advanced Search form on the Constituents tab:

mscreenshot96.png

Simply select the option you want to search by, and then define the parameters for that search field:

mscreenshot97.png

mscreenshot98.png

You can search constituents by more than one criterion as well, by clicking Add more criteria:

add_more_criteria.png

Note that you can also remove criteria by clicking the "x" to the left of the criteria statement.

Now let's take a look at a few common searches.

The classic LYBUNT search

LYBUNTs are donors who gave last year but not this year, accessible in LGL via a simple query by Last gift dates and Gift types:

lybunt_search.png

First-time donors this year

Finding first-time donors in LGL for a given date range is also quite simple—just like LYBUNTs—but using First gift dates instead of Last gift dates:

first_time_donors.png

Donors to a particular campaign

You may want to see who donated to a particular campaign, fund, event, or appeal. The process is the same for all, but we'll show you a campaign search here. We are going to use Gift dates (we don't care if the gift was their first or last), and Campaigns (giving) to find constituents who gave to particular campaign. We could also add Gift types if we wanted to restrict it to specific types of gifts (Pledge, In Kind, Gift, etc.).

campaign_donors.png

Constituents who gave or pledged more than $500 total last year

In this case, we are not concerned with the campaign or anything, just with the Gift dates and the Total giving amt., as well as the Gift types:

500_plus_last_year.png

A mailing list

Mailing lists are the bread and butter of any donor management system, and you can use the constituent search in LGL to easily create those—either in the form of reports/exports, lists, or both. Either way, you'll want to start with a query by Can send mail?, which automatically excludes constituents who:

  • Don't have at least one valid or active mailing address
  • Have been flagged as "Do not mail"
  • Are marked "Deceased"

can_send_mail.png

This is a good starting point for any mailing list, and you can then combine it with other criteria to hone in on the exact constituents you need for any particular mailing. Note: See the Mailings Overview article for details on how to create a mailing.

Filtering search results

Filters provide a great way to visualize the results for any query. They also help to quickly narrow your search results.

Filters appear to the left of the search results:

2012-11-11_1622.png

Clicking on a filter will narrow the results accordingly:

mscreenshot100.png

Searching by category

If you want to query by multiple filters, use the main Advanced Search feature, search for any value under Category (for example, "Groups"), and click the Select button to choose the ones you want to search by:

2014-09-19_1455.png

2014-09-19_1441.png

Still need help? Contact Us Contact Us