Skip to main content

Find Constituents Who Donated Within a Time Frame and How Many Times They’ve Donated

Identify people who donated within a specific date range.

Cristina Gruita avatar
Written by Cristina Gruita
Updated over a month ago

Create a Transaction Payment List

  1. Click Add at the top of Donorfy

  2. Select Transaction Payment List

  3. Give the list a clear name (e.g. Donations – Jan to Mar 2025)

  4. Add the filter: Date Paid is between [start date] and [end date].

This list will return all transactions within the date range.
A constituent may appear more than once if they donated multiple times.


Add Giving Statistics Columns

  1. Go to the Columns section of the list.

  2. Add Giving Stats Lifetime - Lifetime Gifts Number

This column shows how many times the constituent has donated in total, across their entire giving history.


Identify First-Time Donors

To find constituents who donated for the first time within your selected time frame:

  1. Add an additional filter:Lifetime Gifts Number equals 1

This ensures:

  • The constituent has only ever made one donation.

  • That donation occurred within your selected date range.

This will show first-time donors in that period.


Handling Duplicate Rows (Optional)

Because this is a Transaction Payment List, constituents may still appear multiple times if they made more than one payment in the period.

You have two options:

Use Excel

  1. Download the list

  2. Open it in Excel

  3. Use Remove Duplicates on Constituent Number or Email

  4. Keep a single row per constituent

Tag the Constituents (Recommended)

  1. From the list, use Bulk Actions-Add Tag

  2. Apply a tag such as: First-time donor – Jan–Mar 2025

  3. Save the tag.

Did this answer your question?