Does anyone have a good way of pulling donors by their final pledge payment date? I'm looking for a way to know what "monthly" (sometimes it isn't precisely monthly) donors will have completed their pledge soon and are ready to be solicited for renewal. I can't necessarily pull by gift date either, because our pledges last anywhere from 4-12 months from what I've observed so far.
I've jerry-rigged a way to extract the folks I want for now, but if anyone has a fancy bit of SQL I'd be much obliged.
The Yearly Cash Planning report may work for this. Check it out! It is an Out-Of-The-Box report.
Marie
---
Marie Kocher | Development Assistant
Kansas City Ballet | Todd Bolender Center for Dance & Creativity
500 W. Pershing Road, Kansas City, MO 64108
816.216.5582 (D) | 816.931.2232 x1382 (O) | 816.931.1172 (fax)
kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Katie Krueger Sent: Wednesday, June 22, 2016 1:49 PM To: Marie Kocher <mkocher@kcballet.org> Subject: [Tessitura Development Forum] Final Payment Date 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!