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?
Tiffany,
You will want to create three lists. The first of all the constituents you are looking at to see if they made a contribution. The second would be a list of everyone who has contributed. Then in the third you will take both of those lists and using two lines as follows should give you a list of constituents who have not contributed:
List <in> select your list two here of everyone who has contributedList <does not have> select your list one here of you constituents
Terry's approach should work, but I believe she mistakenly flipped the operator assignments — you'd want to "does not have" your list of previous contributors.
Alternatively, if you have view access to your T_KEYWORD system table you could paste in the configuration for your custom criteria element and we could help you debug it.
Both of these suggestions seem work a shot. Thanks! I'll ask our database admin about the system tables.