Can't Pull a List of Donors With Zero Contributions

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

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?

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!

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

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?

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!