• Replies 8 replies
  • Subscribers 414 subscribers
  • Views 107 views
  • Users 0 members are here
Related

Managing sponsors' complementary tickets

Martin Havn
$organization

Hi all,

as pretty recent alumens of the Tessitura Network, we're currently working on moving our sponsor-handling from an external, separate CRM-system into Tessitura, specifically the Plans module.

One issue that's come up is how to best handle the pool of complementary tickets we promise sponsors as part of their deal with us.

The way it works is, we promise the sponsor 100 tickets (for instance) that they can use at their leisure throughout the season. Typically, the coordinator in charge at the sponsor calls a few days in advance and asks for 4 tickets to a specific performance.

Would appreciate any suggestions as to how we can record this pool of 100 tickets to start with, and then write them down as they're spent throughout the season. 

They aren't held or allocated in any specific performance in advance.

I've been thinking about using a ranking and value or attribute and value, or maybe there's a smart way to use CSI's or Plans?

Thanks in advance, and all the best from Denmark :-)

Martin

Parents
  • $organization
    Hi Martin,

    My department isn't the one that really uses what that custom table does...but it must be worth the trouble to the departments that use it, or they would have removed it by now. :) It is very helpful for the ticketing staff to administer member benefits without having to guess about whether someone has already used their tickets. And of course the online redemption option is a big deal. I can't swear to this, but I suspect some of the challenges with this may be due to staff turnover and loss of institutional knowledge. Just think it through carefully and document how the process needs to be managed so that staff departures don't leave you in the lurch, and you'll probably be fine.

    Beth




    Elizabeth Varro
    Director of Membership
    (651) 265-9829

    They made a remarkable comeback from the brink of extinction and sang their way into our hearts. See Humpback Whales on the William L. McKnight-3M Omnitheater's giant screen—the best place in the world to witness their story. Watch a trailer and buy tickets today: www.smm.org/whales.


    From: "Martin Havn" <bounce-martinhavn4532@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Wednesday, February 24, 2016 3:31:47 AM
    Subject: Re: [Tessitura Development Forum] Managing sponsors' complementary tickets

    Wow, some great suggestions, thank you all for chiming in. As often with Tessitura, there really are a lot of different ways to a useful solution. I'll do some more experimentation, as we need to find a way that's convenient enough to use, and also allows for some aggregate reporting.

    Eventually, we'll want to develop a self-service solutions that'll allow sponsors to get their tickets online, so there's something to keep in mind too. 

    Beth, even though the custom table solution has not been flawless, do you find it's been worth you trouble?

    Thanks

    Martin

    From: Beth Varro <bounce-elizabethvarro6946@tessituranetwork.com>
    Sent: 2/23/2016 3:39:03 PM

    We have a couple ways that we manage complimentary tickets at the Science Museum of Minnesota.

    We manage staff comps through attributes; at the beginning of the fiscal year, we use the Update Attributes utility to load 20 comps in each staff record. When a staff member uses a comp, the cashier sells the ticket and then manually decrements the value on the attribute. Simple and effective - we've done this for the entire 8 years that we've been on the system.

    For some of our higher-level members, we wanted them to be able to redeem their comps online. For this purpose we made a local table to house the data. When a ticket is sold with the applicable price type, etc, it decrements from the table. The number of tickets available on each account shows in the header, so staff can easily keep track of that. These benefits are more complicated - things like "X number of free films per day" and "X number of free special exhibits per exhibit." I think the complicated list of benefits plus the desire to redeem online is why we did this one with a custom table. It's not without its dangers, however; we've had a lot of issues with it over the years, mainly when there is a change in special exhibit or when there's a software upgrade. So, as with all customizations, really think it through before you go this route.

    Beth Varro
    Membership Director
    Science Museum of Minnesota





    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!
Reply
  • $organization
    Hi Martin,

    My department isn't the one that really uses what that custom table does...but it must be worth the trouble to the departments that use it, or they would have removed it by now. :) It is very helpful for the ticketing staff to administer member benefits without having to guess about whether someone has already used their tickets. And of course the online redemption option is a big deal. I can't swear to this, but I suspect some of the challenges with this may be due to staff turnover and loss of institutional knowledge. Just think it through carefully and document how the process needs to be managed so that staff departures don't leave you in the lurch, and you'll probably be fine.

    Beth




    Elizabeth Varro
    Director of Membership
    (651) 265-9829

    They made a remarkable comeback from the brink of extinction and sang their way into our hearts. See Humpback Whales on the William L. McKnight-3M Omnitheater's giant screen—the best place in the world to witness their story. Watch a trailer and buy tickets today: www.smm.org/whales.


    From: "Martin Havn" <bounce-martinhavn4532@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Wednesday, February 24, 2016 3:31:47 AM
    Subject: Re: [Tessitura Development Forum] Managing sponsors' complementary tickets

    Wow, some great suggestions, thank you all for chiming in. As often with Tessitura, there really are a lot of different ways to a useful solution. I'll do some more experimentation, as we need to find a way that's convenient enough to use, and also allows for some aggregate reporting.

    Eventually, we'll want to develop a self-service solutions that'll allow sponsors to get their tickets online, so there's something to keep in mind too. 

    Beth, even though the custom table solution has not been flawless, do you find it's been worth you trouble?

    Thanks

    Martin

    From: Beth Varro <bounce-elizabethvarro6946@tessituranetwork.com>
    Sent: 2/23/2016 3:39:03 PM

    We have a couple ways that we manage complimentary tickets at the Science Museum of Minnesota.

    We manage staff comps through attributes; at the beginning of the fiscal year, we use the Update Attributes utility to load 20 comps in each staff record. When a staff member uses a comp, the cashier sells the ticket and then manually decrements the value on the attribute. Simple and effective - we've done this for the entire 8 years that we've been on the system.

    For some of our higher-level members, we wanted them to be able to redeem their comps online. For this purpose we made a local table to house the data. When a ticket is sold with the applicable price type, etc, it decrements from the table. The number of tickets available on each account shows in the header, so staff can easily keep track of that. These benefits are more complicated - things like "X number of free films per day" and "X number of free special exhibits per exhibit." I think the complicated list of benefits plus the desire to redeem online is why we did this one with a custom table. It's not without its dangers, however; we've had a lot of issues with it over the years, mainly when there is a change in special exhibit or when there's a software upgrade. So, as with all customizations, really think it through before you go this route.

    Beth Varro
    Membership Director
    Science Museum of Minnesota





    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!
Children
No Data