Name-Date-Contribution

Hello!

Does anyone have a report they can share with the following three fields?  For a date range, campaign, & list, I need to pull:

1. Name

2. Date of Contribution

3. Contribution Amount

Essentially it's a Fund Activity Report with contribution dates.  I can't use the New Contributions report because it doesn't pull by campaign.  Help!

Thank you!

Jessica

  • We have various custom reports, but to get the kinks worked out in order to specify those, we start with Development  > Current Constituent Giving by List.  I normally go wide with the date parameter and filter any outlier campaigns in the Excel output: this to be sure to pick up contributions that jump the start/end of fiscal years.

     

    John Trimble
    Data and Prospect Manager
    Dallas Symphony Orchestra
    Morton H. Meyerson Symphony Center
    Schlegel Administrative Suites
    2301 Flora Street
    Dallas, Texas 75201-2413

    214-871-4041 - phone
    214-981-2988 - fax

    j.trimble@DalSym.com
    www.MyDSO.com

    http://www.mydso.com/media/292645/clip_image001.gif


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jessica Blaisus
    Sent: Monday, September 08, 2014 2:41 PM
    To: John Trimble
    Subject: [Tessitura Development Forum] Name-Date-Contribution

     

    Hello!

    Does anyone have a report they can share with the following three fields?  For a date range, campaign, & list, I need to pull:

    1. Name

    2. Date of Contribution

    3. Contribution Amount

    Essentially it's a Fund Activity Report with contribution dates.  I can't use the New Contributions report because it doesn't pull by campaign.  Help!

    Thank you!

    Jessica




    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!

  • Hi Jessica,

    We have a Custom Fund Activity Report that will give you this information. The Santa Barbara Centre for the Performing Arts will put it up on the Shared Reports workspace this afternoon, that way you can download the SQL files and so forth.

    Hope it works for you!

    -Jessica

     

    Jessica Simon

    Sponsorships & Special Events

    Lobero Theatre Foundation

    *Please note my new phone number 805-679-6007*

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jessica Blaisus
    Sent: Monday, September 08, 2014 12:37 PM
    To: Jessica Simon
    Subject: [Tessitura Development Forum] Name-Date-Contribution

     

    Hello!

    Does anyone have a report they can share with the following three fields?  For a date range, campaign, & list, I need to pull:

    1. Name

    2. Date of Contribution

    3. Contribution Amount

    Essentially it's a Fund Activity Report with contribution dates.  I can't use the New Contributions report because it doesn't pull by campaign.  Help!

    Thank you!

    Jessica




    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!

  • Thank you!  I look forward to seeing it!

     

    Jessica

  • Jessica,

    Have you tried the Pledge Gift report in the Finance folder?

    Dale

  • Hi Jessica,

    An Output Set could be built to return this information. There are several elements in the Output Set Cookbook where a contribution date range and fund can be specified. There is also general documentation about Output Set Builder available too; if you're not familiar with it already, it's a powerful tool for outputting data without custom reports.

    -Michael, Tessitura Network