Hey all,
Could use some help thinking this one out. What's the best way to go about grabbing a list of donors who have donated every year for the last ten years to a specific campaign?
My favorite (inelegant) method to get this is to make a list/segment like "Contribution Campaign IN Individual FY17, Contribution Campaign HAS Individual FY16, Contribution Campaign HAS Individual FY15..." and so on. It falls apart if you want specific amounts, this fund but not that fund, etc., but if you just want to know they supported the same campaign every year it works.
-- Mike
You can write a query, but this is most likely a job for t-stats using the contribution cubes. If you want a query let me know.
Travis
My favorite report for this is the Fund Activity Report. I download it to Excel and run it through a Pivot Table to get the detail that I need. It’s simple and fast.
mark frey
Senior Manager Database & Analytics
The Woodruff Arts Center
404.733.4277
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michael Magnes Sent: Tuesday, April 11, 2017 5:00 PM To: Mark Frey Subject: [Tessitura Development Forum] Donor List
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!
DISCLAIMER NOTICE: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited
We do this every year. I create a separate list for each year’s donors. Then I create list with 10 entries – each one is “has” for one of the 10 lists – this gives me the individuals that are on all 10 lists. Each year I can just remove the oldest year, and add the new year.
Jane Voytek
Donor Database Coordinator
Berkeley Repertory Theatre
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michael Magnes Sent: Tuesday, April 11, 2017 2:00 PM To: Jane Voytek Subject: [Tessitura Development Forum] Donor List