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
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.
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.
You could pull a list of everyone with a contribution amount >=1 to find all those who have given. Then use that list of donors as a suppression in either another list or an extraction.
T.C. Brown
Database Administrator
412.392.4834
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tiffany FitzGerald Sent: Wednesday, April 06, 2016 11:30 AM To: TC Brown <TBrown@pittsburghsymphony.org> Subject: [Tessitura Development Forum] Can't Pull a List of Donors With Zero Contributions
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!