lapsed donors

Needing to pull the #of lapsed $1K donors. Has anyone had to pull a report/query and if so what is the criteria?


THanks

Veronica

Comments

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 bbcon 2025 Attendee Badge PowerUp Challenge: Product Update Briefing Feedback Task 3
    Veronica Marshall‍ I am not sure there would be a way to do this in NXT without running two lists (one for each FY) and comparing them. However, in database view (RE7) you could use the gift summaries in a constituent query to say the total giving is greater than or equal to $1K in one FY and less than $1K in the following year.