In LGL it is pretty easy to keep tabs on your LYBUNTs. The first step of course is to identify the constituents that fall into this group, and then from there you can build a list to use in other areas of LGL. This tutorial will walk you through the following:
Search for LYBUNTs in Constituents and add them to a dynamic, auto-updating list
Use the list in Fundraising and pull reports for LYBUNTs
These concepts can be applied to many other kinds of list building and reporting in LGL.
1. Navigate to the constituents tab and clear the list history so you don’t include anyone you might have already selected today if you were working on something else
2. Search for constituents who gave a hard credit (Gift) last year and add them all to the working list by clicking the “Select 723″ button
3. Now search for constituents who have given anything this year. We are including soft credits, matching gifts, and pledges in this one to ensure we don’t flag anyone as a LYBUNT who has given in another way. Then we can “Deselect 521 results” to bring the total # of selected constituents down to 444. Note that this number is not the straight difference between the 723 donors who gave last year and the 521 who have given this year, because some of this year’s donors did not give last year.
4. Save the list and set it to auto-update as new gifts come in, removing anyone from the list who is no longer a LYBUNT.
5. Now that we have this list we can do a lot with it, including taking a look at the detailed giving history for these donors. To do that, we will navigate over to the fundraising tab and run and advanced search:
6. Then we can set the search criteria to search by the list that we just built
We will also want to add some dates (say for the last 5 years):
Now we can see the full list of gifts for our 2010-11 LYBUNTS, going back 5 years. From here, it is possible to view the data in several different ways and then export it for review and analysis in Excel or another program:
Like any good donor database should, LGL makes it easy to keep tabs on your LYBUNTs. The first step, of course, is to identify the constituents that fall into this group. From there you can build a list to use in other areas of LGL.
This tutorial walks you through the following:
- Search for LYBUNTs in Constituents and add them to a dynamic, auto-updating list
- Use the list in Fundraising and pull reports for LYBUNTs
These concepts can be applied to many other kinds of list building and reporting in LGL.
1. Navigate to the Constituents tab and clear the list history (so you don’t include anyone you might have already selected today if you were working on something else).

2. Search for constituents who gave a hard credit (Gift) last year, and add them all to the working list by clicking the “Select 723″ button.

3. Now search for constituents who have given anything this year. We are including soft credits, matching gifts, and pledges in this one to ensure we don’t flag anyone as a LYBUNT who has given in another way. Then we can “Deselect 521 results” to bring the total number of selected constituents down to 444. Note that this number is not simply the difference between the 723 donors who gave last year and the 521 who have given this year, because some of this year’s donors did not give last year.

4. Save the list and set it to auto-update as new gifts come in, removing anyone from the list who is no longer a LYBUNT.

5. Now that we have this list we can do a lot with it, including taking a look at the detailed giving history for these donors. To do that, we will navigate over to the Fundraising tab and run an advanced search:

6. Then we can set the search criteria to search by the list that we just built.

We will also want to add some dates (say for the last 5 years):

Now we can see the full list of gifts for our 2010-2011 LYBUNTS, going back 5 years. From here, it is possible to view the data in several different ways and then export it for review and analysis in Excel or another program:
