Contacts with $0 or no donations made

James Riley

• April 17, 2023 21:23

Is there any way to filter for Contacts that have no transaction history recorded in Keela? If I filter for Total Donation = $0 or Is Empty, it returns no results. In Contacts, I can Add Columns > Total Donations and sort by the column, but I was hoping to use Donation = $0 as one of the filter conditions of a filter/segment that I need to build.

0

• 

  Claudia Hundloe

  • April 18, 2023 05:37

  Hi James, try Frequency = Is empty. If you use a $ amount it looks at all donations that HAVE been made for $0. I hope this helps.

  0
• 

  James Riley

  • April 18, 2023 20:41

  Thanks Claudia Hundloe! That works wonderfully.
  Filtering for [ Fundraising > Frequency = Is Empty ] returns all contacts with 0-zero donations and 0-zero revenue transactions. 

  0

Please sign in to leave a comment.