• Replies 3 replies
  • Subscribers 412 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Development Report with Ticket History

Brad Watkins
$organization

I am wondering if anyone out there has a report or suggestions that would show ticket history for fundraising call purposes.  

In the Full Bio report, it only shows subscriptions, in the Patron Appeal Call Sheet, it shows total number of tickets purchased and dollar amount, but neither show specific shows that were purchased (i.e. if they were a single ticket buyer).

I would like my callers to be able to say, "I see you had tickets to 'The Big Opera Show'  wasn't it great, blah, blah, blah" and can't figure out a way to come up with that info. 

Help,
Brad Watkins, Opera Omaha

  • $organization

    I belive there is a shared report on TASK written by the Boston Symphony Orchestra exactly for this purpose. I used it al my last place of employment and it worked well.

  • $organization
    Telefundraising Call Sheet Report (Shared Reports)

    Entered on 08/16/2007 at 16:58:07

    This user defined report has been provided courtesy of the Boston Symphony Orchestra.
    While the Network does not endorse the accuracy of the report, you are encouraged to
    test it and determine if it will work well at your site.

    This download consists of a PBL file and SQL Script for a custom Telefundraising Call
    Sheet. Some of the copy on the form feeds into the BSO's Telemarketing/Telefunding
    custom screen, but the text can be easily changed.

    The lead sheet is made up of a master report and several embedded reports. The main
    report uses a SQL procedure that pulls all consitituents with an input promoted
    source code. Each sub-report uses SQL data statements in the datawindow.

    ORIGINALLY UPLOADED 3/6/2004

     

    This is the report I was reffering to.

    Cheers,

     

    Christian

  • $organization in reply to Christian Mauri

    Thank you!  I’ll look at it!

     

    Brad A. Watkins

    Operations Manager

     

    Opera Omaha

    1625 Farnam St. Suite 100

    Omaha, NE  68102

    Phone:  402-346-4398 x204

    NOTE:  NEW CELL #  402-238-1306

    Fax:  402-346-7323

    bwatkins@operaomaha.org 

     

    Subscribe Today!

    2009-2010 Season

    Take advantage of all the season has to offer

    PLUS receive all your subscriber benefits 

    Click operaomaha.org or Call 346-7372

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Wednesday, May 13, 2009 11:42 AM
    To: Brad Watkins
    Subject: Re: [Tessitura Development Forum] Development Report with Ticket History

     

    Telefundraising Call Sheet Report (Shared Reports)

     

    Entered on 08/16/2007 at 16:58:07

    This user defined report has been provided courtesy of the Boston Symphony Orchestra.
    While the Network does not endorse the accuracy of the report, you are encouraged to
    test it and determine if it will work well at your site.

    This download consists of a PBL file and SQL Script for a custom Telefundraising Call
    Sheet. Some of the copy on the form feeds into the BSO's Telemarketing/Telefunding
    custom screen, but the text can be easily changed.

    The lead sheet is made up of a master report and several embedded reports. The main
    report uses a SQL procedure that pulls all consitituents with an input promoted
    source code. Each sub-report uses SQL data statements in the datawindow.

    ORIGINALLY UPLOADED 3/6/2004

     

    This is the report I was reffering to.

    Cheers,

     

    Christian

    From: Brad Watkins <bounce-bradwatkins4671@tessituranetwork.com>
    Sent: 5/13/2009 11:16:38 AM

    I am wondering if anyone out there has a report or suggestions that would show ticket history for fundraising call purposes.  

    In the Full Bio report, it only shows subscriptions, in the Patron Appeal Call Sheet, it shows total number of tickets purchased and dollar amount, but neither show specific shows that were purchased (i.e. if they were a single ticket buyer).

    I would like my callers to be able to say, "I see you had tickets to 'The Big Opera Show'  wasn't it great, blah, blah, blah" and can't figure out a way to come up with that info. 

    Help,
    Brad Watkins, Opera Omaha




    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!