1. Run the Top Donors Report and create an output query.

  1. General tab:
    • Date range, Specific Range: <last 5 years>
    • Create an output query
  2. Filters tab: enter as necessary
  3. Gift Types tab: enter as necessary
  4. Format tab: Detail > Top 100 count


2. Create a constituent export.

  1. On the General tab, click Include and select the output query created from the Top Donors Report.
  2. On the Output tab, select:
    • Gifts, Gift Date, Gift Amount
    • Number of gifts to export: <highest number of gifts a constituent will have>
    • Date range: exact same as in report parameters
    • Filters: exact same as in report parameters
    • Gift types: exact same as in report parameters
  3. Click Export Now