Promo codes/offers and tracking buyer segments

Hi!

I'm in a pickle.  We have several local community groups  who we have created separate promo codes assigned to them all with the same source number.  We are now trying to track who bought what and finding it difficult.  Basically, we want to know the promo they entered, not the source code.

We had each unique promo code trigger the same mode of sale switch and activate the same price type, all of which are called the same thing and again do not tell us  the unique promo code that was entered and our only way of tracking the group that made the purchase.

Aside from creating multiple sources, one for each group and having the box office go crazy  trying to find the right code to match the right group in case someone calls to buy tickets on the phone, is there another way of doing this?

We have a cool custom report that shows us the comp codes connected to price types and use this frequently, but it doesn't help us track online sales at all since none of them have comp codes. 

Thanks in advance.  I will personally hug you at the conference if you can help me get this figured out!

 

  • I am trying to get us to use different sources with different promo codes so that it is easy to see who did what. We name our outside sources starting with the promo code, so if I had an American Express promo, the name of the outside source would start with “amex” (in quotes). The source names sort on top because of the quotation marks. Of course, it helps if someone occasionally does source code maintenance, inactivating sources once they are no longer valid, so that the ticket office doesn’t need to wade through more than necessary.

     

    For offers involving anything that needs to be reported to a third party, we also use distinct price types.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager
    FGO_logo_one_line_2color_web.jpg

  • Hi Tiffany,

    I'm sorry to say I don't have a solution for your current dilemma. As far as i know, only the source number is stored and not the specific promo code they entered. I hope that I'm wrong and someone is able to provide some assistance!

    What I can say is that having multiple sources doesn't need to be a huge hassle. We do it very often here. As long as the promo code is entered in TR_WEB_SOURCE_NO (which it sounds like you're doing if you offer them online) then your box office staff can search for that specific promo code and choose that specific source. When you open the source window in the order screen there is a Promo Phrase Like box at the bottom. If you enter the promo code there it will remove all sources that are not attached to that promo code. No digging through trying to find the right one!

    It does take a bit of extra setup from the source code side of things but it's not too terrible and we haven't had any problems with this method so far.

    Hope that helps and good luck!

  • Former Member
    Former Member $organization in reply to Beth Hawryluk

    Hi Tiffany

    Unfortunately for what you're trying to do, I think Beth is absolutely correct here. The promo code is really just a sort of alias for the source code, as far as the system is concerned. When a web user logs on with a promo code, the website will just use it to look up the matching source code, and then throw the promo code away and use the source code from then on. It doesn't bother remembering what the promo code was. Unless you wrote code into your website to record the promo code itself into the order notes, or one of the custom order fields, it will no longer exist anywhere.

    But really, that's what source codes are supposed to be for - to identify the source of the transaction - so even though they might blow up a bit, using them to report is deeply built into Tess, so it makes sense to use them in the way they're intended to be used, and thereby get the full benefit from them.

    Ken

  • Former Member
    Former Member $organization
    Here's another thought...if you wanted to do some kind of hybrid of the two methods it is possible. You could have your current methodology for phone and window sales and just use separate sources for the web. It would take some math to get to your final results, but if you really want to avoid separate sources over the phone it may be worth it to you.

    Good luck!
    Nicole

    Sent using OWA for iPhone
    From: Tessitura Ticketing Forum <forums-ticketing@tessituranetwork.com> on behalf of Ken McSwain <bounce-kenmcswain5454@tessituranetwork.com>
    Sent: Wednesday, August 06, 2014 7:54:38 PM
    To: Nicole Keating
    Subject: Re: [Tessitura Ticketing Forum] Promo codes/offers and tracking buyer segments
     

    Hi Tiffany

    Unfortunately for what you're trying to do, I think Beth is absolutely correct here. The promo code is really just a sort of alias for the source code, as far as the system is concerned. When a web user logs on with a promo code, the website will just use it to look up the matching source code, and then throw the promo code away and use the source code from then on. It doesn't bother remembering what the promo code was. Unless you wrote code into your website to record the promo code itself into the order notes, or one of the custom order fields, it will no longer exist anywhere.

    But really, that's what source codes are supposed to be for - to identify the source of the transaction - so even though they might blow up a bit, using them to report is deeply built into Tess, so it makes sense to use them in the way they're intended to be used, and thereby get the full benefit from them.

    Ken

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 8/6/2014 5:33:35 PM

    Hi Tiffany,

    I'm sorry to say I don't have a solution for your current dilemma. As far as i know, only the source number is stored and not the specific promo code they entered. I hope that I'm wrong and someone is able to provide some assistance!

    What I can say is that having multiple sources doesn't need to be a huge hassle. We do it very often here. As long as the promo code is entered in TR_WEB_SOURCE_NO (which it sounds like you're doing if you offer them online) then your box office staff can search for that specific promo code and choose that specific source. When you open the source window in the order screen there is a Promo Phrase Like box at the bottom. If you enter the promo code there it will remove all sources that are not attached to that promo code. No digging through trying to find the right one!

    It does take a bit of extra setup from the source code side of things but it's not too terrible and we haven't had any problems with this method so far.

    Hope that helps and good luck!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
  • I love all of these! 

    This certainly helps explain why I couldn’t find the promo code anywhere in the order. 

    I believe the promo phrase box is helpful, so I may try doing that and making sure the box office knows what to do.

     

    Thanks all. 

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole Keating
    Sent: Wednesday, August 06, 2014 9:55 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Ticketing Forum] Promo codes/offers and tracking buyer segments

     

    Here's another thought...if you wanted to do some kind of hybrid of the two methods it is possible. You could have your current methodology for phone and window sales and just use separate sources for the web. It would take some math to get to your final results, but if you really want to avoid separate sources over the phone it may be worth it to you.

    Good luck!
    Nicole

    Sent using OWA for iPhone


    From: Tessitura Ticketing Forum <forums-ticketing@tessituranetwork.com> on behalf of Ken McSwain <bounce-kenmcswain5454@tessituranetwork.com>
    Sent: Wednesday, August 06, 2014 7:54:38 PM
    To: Nicole Keating
    Subject: Re: [Tessitura Ticketing Forum] Promo codes/offers and tracking buyer segments

     

    Hi Tiffany

    Unfortunately for what you're trying to do, I think Beth is absolutely correct here. The promo code is really just a sort of alias for the source code, as far as the system is concerned. When a web user logs on with a promo code, the website will just use it to look up the matching source code, and then throw the promo code away and use the source code from then on. It doesn't bother remembering what the promo code was. Unless you wrote code into your website to record the promo code itself into the order notes, or one of the custom order fields, it will no longer exist anywhere.

    But really, that's what source codes are supposed to be for - to identify the source of the transaction - so even though they might blow up a bit, using them to report is deeply built into Tess, so it makes sense to use them in the way they're intended to be used, and thereby get the full benefit from them.

    Ken

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 8/6/2014 5:33:35 PM

    Hi Tiffany,

    I'm sorry to say I don't have a solution for your current dilemma. As far as i know, only the source number is stored and not the specific promo code they entered. I hope that I'm wrong and someone is able to provide some assistance!

    What I can say is that having multiple sources doesn't need to be a huge hassle. We do it very often here. As long as the promo code is entered in TR_WEB_SOURCE_NO (which it sounds like you're doing if you offer them online) then your box office staff can search for that specific promo code and choose that specific source. When you open the source window in the order screen there is a Promo Phrase Like box at the bottom. If you enter the promo code there it will remove all sources that are not attached to that promo code. No digging through trying to find the right one!

    It does take a bit of extra setup from the source code side of things but it's not too terrible and we haven't had any problems with this method so far.

    Hope that helps and good luck!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!