Consecutive Years Giving

To find constituents who have given gifts in consecutive years, create queries with the Consecutive Years Giving field.

Consecutive Years Giving tracks how many calendar years in a row a constituent gave a gift, starting from their most recent gift and counting backward. For example, if a constituent gave a gift every year for five years, and their last gift was two years ago, their total is five consecutive years. If a date filter removes any of the consecutive gifts, only the gifts that match the filters are counted.

Navigation

1. Open Query editor.

2. From Criteria, select Summary for Gift, and Consecutive Years Giving.

For more information see Query.