• Replies 4 replies
  • Subscribers 413 subscribers
  • Views 13 views
  • Users 0 members are here
Related

Looking for 25K Donors in FY2012

Marcus Myers
$organization
How would you pull a list of constituents who have in the fiscal year 2012 thought gifts, pledges or soft credits totaling $25,000 or more?
 
At this time I'm able to pull a list of constituents that have given $25,000 or more through gifts or pledges, though my output is not the most optimal for me to use.
 
I just need this list so I can provide Devo with a name, address, phone number, email address and total FY12 giving total.
 
I tried to pull this list using an output set because when you create an output set (Total giving 2011-2012) it will allow you to add a field named Contribution_total_giving (that then will allow you to set a specific time period for total giving).  I found this does not work because when you go to create the output set it will produce an error.  I can also see under the list of available fields under the contribution folder (Contribution_last_year_giving) but there is not a field for this year's giving that would help me with this list
 
Thanks
Marc
Parents
  • $organization

    Mendy,

     

    That report sounds really great.  Does it by any chance include Campaign?  Would you be willing to send it my way? 

     

    Thanks,

    Nancy

     

    Nancy Clarkin
    Individual Giving Manager

    First Stage
    325 West Walnut Street

    Milwaukee, WI 53212
    (414) 267-2938 direct

    (414) 267-2930 fax

     

    Website: www.FirstStage.org | Facebook: www.facebook.com/firststage | Twitter: twitter.com/firststage
    YouTube:  www.youtube.com/user/firststage | Blog: firststagechildrenstheater.blogspot.com

     

    For tickets and information visit www.firststage.org!

     

    Registration now available for Spring, Spring Break, AND Summer 2012!

    Milwaukee Youth Arts Center | Oconomowoc Arts Center | Sharon Lynne Wilson Center for the Arts

    ...plus, our Overnight Academy at Carthage College returns this August!

    Visit www.firststage.org for information or to register!

     

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mendy Sudranski
    Sent: Tuesday, February 28, 2012 8:23 AM
    To: Nancy Clarkin
    Subject: Re: [Tessitura Development Forum] Looking for 25K Donors in FY2012

     

    Hi Marc,

    I have a quick report that i created for my finance department that lets you put in a cont start and end date and a minimum total giving for the date range. how much they gave to what with a total giving. let me know if this will help. i can give you the proc or the whole report.

    Mendy Sudranski
    IT Manager
    Manhattan Theatre Club
    msudranski@mtc-nyc.org

    From: Marcus Myers <bounce-marcusmyers9566@tessituranetwork.com>
    Sent: 2/24/2012 3:08:11 PM

    How would you pull a list of constituents who have in the fiscal year 2012 thought gifts, pledges or soft credits totaling $25,000 or more?

     

    At this time I'm able to pull a list of constituents that have given $25,000 or more through gifts or pledges, though my output is not the most optimal for me to use.

     

    I just need this list so I can provide Devo with a name, address, phone number, email address and total FY12 giving total.

     

    I tried to pull this list using an output set because when you create an output set (Total giving 2011-2012) it will allow you to add a field named Contribution_total_giving (that then will allow you to set a specific time period for total giving).  I found this does not work because when you go to create the output set it will produce an error.  I can also see under the list of available fields under the contribution folder (Contribution_last_year_giving) but there is not a field for this year's giving that would help me with this list

     

    Thanks

    Marc




    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!

  • $organization in reply to Nancy Clarkin

    Hi, send me your email and i'll forward the files.

     

    ===========================

    Mendy Sudranski

    IT Manager

    Manhattan Theatre Club

    311 West 43rd Street - 8th Fl

    New York, NY 10036

    Phone: (212) 399-3000 ext. 4105

    msudranski@mtc-nyc.org

     

Reply Children