Can't Pull a List of Donors With Zero Contributions

Former Member
Former Member $organization

Hi,

I'm seemingly unable to pull a simple list of constituents who haven't made any contributions using our 'Number of Contributions' criteria. It doesn't seem to recognize '0'; when I run the list it says we have no constituents in our database who haven't made a gift at all, which obviously isn't true (we have thousands who fit that description). The criteria only seems to start counting from '1' up. It appears to only consider those who have at least one gift in the Contributions tab, which kind of defeats the purpose of trying to reach out to our constituents who have never given (and encourage them to!). It doesn't matter if I use "=" or "less than or equal to" or even "between" (e.g. between '0' and '0') as an operator. Anyone have experience pulling on this criteria?

Parents
  • Former Member
    Former Member $organization

    I'm guessing that "Number of contributions" may be custom to your setup so I can't say for sure, but you're probably correct that it's configured such that it would only work on people with one or more contribution.

    You could use "Contribution Campaign does not have" with your individual giving campaigns; but if you have a lot of campaigns that may be impractical. The cleanest way might be to build an extraction with a segment suppressing everybody with one or more contributions, leaving only the people who have never given to fall into any subsequent segment(s). Remember to also suppress inactive accounts if you go that route.

Reply
  • Former Member
    Former Member $organization

    I'm guessing that "Number of contributions" may be custom to your setup so I can't say for sure, but you're probably correct that it's configured such that it would only work on people with one or more contribution.

    You could use "Contribution Campaign does not have" with your individual giving campaigns; but if you have a lot of campaigns that may be impractical. The cleanest way might be to build an extraction with a segment suppressing everybody with one or more contributions, leaving only the people who have never given to fall into any subsequent segment(s). Remember to also suppress inactive accounts if you go that route.

Children
No Data