Report on donors who donated to last years event but not this years event

An organization would like to know which donor's from last year's event have not donated to this year's event. This list can be used to target potential donors for the new event. 
  1. Navigate to Contacts > Individuals. 
  2. Click Advanced Search.
  3. Expand Communities > Special Events > Friends Asking Friends.
  4. Next to Kintera Thon, click Choose Event. 
  5. In the pop-up window, find and mark last year's event. 
  6. Click Ok.
  7. Select Donors. 
  8. Click Add. 
  9. In the pop-up window, click Ok.
  10. Next to Kintera Thon, click Choose Event. 
  11. In the pop-up window, unmark last year's event. Find and mark this year's event. 
  12. Click Ok.
  13. Select Donors. 
  14. Click Add. 
  15. In the pop-up window, click Ok.
  16. On the bottom left of the query filters, click Not
    • Note: This should change the statement from 'AND' to 'AND Not'
  17. Click Run Query

Environment

 Blackbaud Sphere

Was this article helpful?