In This Article:

    Gifts Report: Loyal Donor

    In This Article:

      Creating a report in DonorPro of donors who donated consistently, in consecutive years:

      1. Go to your Reports menu, then select Gifts, then Donor Detail.

      2. On the top row of the report, set your multi-year date range with the From and To dates in the top right. To select the entire current year, you have to make the To date January 1 of next year.
        2018-04-06_1256.png

      3. To the left of the window, deselect Include Co-donors and Include Soft Credit Donors.

      4. Make sure Consolidate Spouses is checked.

      5. Any other Additional Filters or Excluding Gifts in Kind are optional preferences.

      6. To the right of the Run Report button, change 'Formatted' to 'Advanced Query by Year'.

      7. Run the Report. The results will open in a Query Results format.

      8. Select Convert to Spreadsheet at the bottom left. Data should appear in Excel.

      9. In Excel, click the Sort button from the Data ribbon menu. Then click Filter. This adds filter icons to each column.

      10. Select the yearly column header filter icon.

      11. Deselect the $0.00 checkbox. This will hide all donors who gave $0 in that year.

      12. Do this for all yearly columns, and only the donors who gave consistently in every year will be displayed.

      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Please sign in to leave a comment.