Report Roundup: Iron Man Donors

On September 6, 1995, the Iron Man (but not that Iron Man) passed the Iron Horse to set the Major League Baseball record for most consecutive games played. You may never have a donor who gives a gift 2,632 days in a row, but you probably have donors who give every year. You can capture these donors by running the Consecutive Years report.

The Consecutive Years Report is located in Analytical Reports. When you enter the date range for the report, select the latest year in which constituents must have given. For example, if you want to find everyone who gave in 2004, 2005, 2006, and 2007, use the date range 1/1/2007 to 12/31/2007. On the Format tab, highlight Detail, and enter a value in the Minimum number of consecutive years field. For the example above, you would enter 5.

A couple tips:

If you need this group of constituents for a mailing, create an output query of the records included in the report: mark the Create output query checkbox on the General tab. If you want to list constituents by the number of years they have given consecutively, go to Format, Sort/Break, and select to Sort by Consecutive years.

This information can also be found in Knowledgebase solution BB56739.

In the Brain Buster from this month's edition of The User's Edge, Noel would be able to acquire 19 bottles using her strategy. From the original 77 empty bottles, she receives 15 full bottles with 2 left over. From the 17 empties, she receives 3 more full bottles with 2 left over. From the 5 empties she receives 1 final full bottle. 15+3+1=19