How could I pull a list of all of the performances valid for a specific promo code?
In List Manager you can pull it from the Promotions Tab and then Source Number, or you could use T-stats.
From: Shelley Salinas [mailto:bounce-shelleysalinas8221@tessituranetwork.com] Sent: Thursday, January 13, 2011 10:32 AMTo: Nicole KeatingSubject: [Tessitura Ticketing Forum] Promo code shows
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 see how that brings up patrons who’ve used the promo code but how can I see at a glance which shows are available to purchase using that code? Right now we keep a spreadsheet at the Box Office to know what shows are valid. I was hoping there was a way to pull it up in Tessitura though.
Thanks,
Shelley Salinas
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole Keating Sent: Thursday, January 13, 2011 9:56 AM To: Shelley Salinas Subject: RE: [Tessitura Ticketing Forum] Promo code shows
From: Shelley Salinas [mailto:bounce-shelleysalinas8221@tessituranetwork.com] Sent: Thursday, January 13, 2011 10:32 AM To: Nicole Keating Subject: [Tessitura Ticketing Forum] Promo code shows
Sorry, I misread your post.
We use the Custom Tab on the Performance Information screen to show what promo codes are available for that performance. I don’t know of a report that would pull the promo codes associated with a performance prior to the promo code being used.
From: Shelley Salinas [mailto:bounce-shelleysalinas8221@tessituranetwork.com] Sent: Thursday, January 13, 2011 11:16 AMTo: Nicole KeatingSubject: RE: [Tessitura Ticketing Forum] Promo code shows
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole KeatingSent: Thursday, January 13, 2011 9:56 AMTo: Shelley SalinasSubject: RE: [Tessitura Ticketing Forum] Promo code shows
COCA524 Trinity Ave.St. Louis, MO 63130(314) 725-6555 (Main)(314) 725-6222 (Fax)www.cocastl.orgThis 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!
Right, it works to see what promo codes are good per show but not the other way around in seeing what shows are good per promo code. I’ll keep investigating.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicole Keating Sent: Thursday, January 13, 2011 10:31 AM To: Shelley Salinas Subject: RE: [Tessitura Ticketing Forum] Promo code shows
From: Shelley Salinas [mailto:bounce-shelleysalinas8221@tessituranetwork.com] Sent: Thursday, January 13, 2011 11:16 AM To: Nicole Keating Subject: RE: [Tessitura Ticketing Forum] Promo code shows
COCA 524 Trinity Ave. St. Louis, MO 63130 (314) 725-6555 (Main) (314) 725-6222 (Fax) www.cocastl.org 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!
Hi Shelley,
It's not a report, but in TR_WEB_SOURCE_NO, for each source number I use the Promo Code Column to indicate conditions for a source code including amount of discount, all valid performances for the promo code and the Price Type to use for booking the tickets. Mos and Parent Key columns are left blank for this purpose.
For example, for one source code in this column I have entered Soulpepper members - 20% off Kingfisher, all shows except opening night GAF20
Then when the box office staff pull up the Source Code window, conditions are populated in the line below the Source code name and number. They can also then use the Promo Phrase Like: box at the bottom of this window to quickly filter down to all source codes that are applicable to a specific production.
Duane
To clarify my last post, if a source code has a promo code attached to it, then two separate line entries are made in TR_WEB_SOURCE_NO for that code - 1) assign promo code to MOS, 2) list of discount, performance and price type conditions.
That’s perfect, Duane, I’ll do it!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Duane Woods Sent: Thursday, January 13, 2011 2:22 PM To: Shelley Salinas Subject: Re: [Tessitura Ticketing Forum] Promo code shows
From: Shelley Salinas <bounce-shelleysalinas8221@tessituranetwork.com> Sent: 1/13/2011 9:30:43 AM