Hi Everyone,
I was wondering if anyone has come up with an easy way to do some ticket price proofing. We are on 12.1 so we have the price grid. What would ultimately be most amazing is if you could export the whole price grid to an Excel document for proofing but I don't see that as an option. Is there a new report I'm missing that helps with proofing or have any of you created a custom report (that you'd be willing to share) that helps with price proofing.
Any insight from fine people would be most wonderful.
Chris
Unknown said: I was wondering if anyone has come up with an easy way to do some ticket price proofing. We are on 12.1 so we have the price grid. What would ultimately be most amazing is if you could export the whole price grid to an Excel document for proofing but I don't see that as an option. Is there a new report I'm missing that helps with proofing or have any of you created a custom report (that you'd be willing to share) that helps with price proofing.
I've done a couple custom reports over the years for stuff like this (we have a lot of price types). If the sample screenshot below looks interesting, I'd be glad to share the report.
I always have a little giggle at posts like these where someone posts about a custom report they have and then 20 people reply saying that they want a copy.
At the risk of starting a waterfall of requests... Chris, that looks strikingly similar to a report that on my "to build" list here. If I don't have to reinvent the wheel then that frees up a lot of my time!
If you don't mind sharing can you please send me a copy? bhawryluk@winspearcentre.com
Unknown said: This looks interesting Chris. Do you have selection parameters in the report that allow you to pick specific performances, days of week, etc? I only ask because we have different prices on different days of the week. Also, the price might be different from performance run to performance run.
Yes; the only parameter is a perf dropdown, for selecting just such different perfs as you describe, e.g. a Friday Evening, a Wednesday Mat, or whatever, typically during season setup.
Unknown said: You’re definitely on to something here. Could you post in the Shared Reports of TASK? Thanks!
Sounds like a good idea: this report shouldn't require much additional customization for other sites, so would I think make a good candidate for sharing via TASK. I'll submit shortly...
I've submitted the report to the network. I'll update this thread when I hear that it's been posted.
I run a TStats report using the Seats cube and the Seat Price Types dimension. Use Capacity as the measurement. Then it can be exported to excel and you’ve got your list.
Ellen Holt
Box Office Manager
Celebrity Series of Boston
20 Park Plaza, Suite 1032
Boston, MA 02116
617-598-3224 (p)
617-598-3291 (f)
www.celebrityseries.org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Cuhel Sent: Tuesday, July 28, 2015 12:26 PM To: Ellen Holt Subject: [Tessitura Ticketing Forum] Ticket Pricing Proofing
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 looks interesting Chris. Do you have selection parameters in the report that allow you to pick specific performances, days of week, etc? I only ask because we have different prices on different days of the week. Also, the price might be different from performance run to performance run.
Christopher Cuhel | Database Coordinator
The 5th Avenue Theatre
1308 5th Avenue Theatre, Seattle WA 98101
p 206.971.7916 f 206.292.9610
Seattle's Acclaimed Non-Profit Musical Theater Company
Website | Facebook | Twitter | Youtube
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris JensenSent: Tuesday, July 28, 2015 12:38 PMTo: Christopher CuhelSubject: Re: [Tessitura Ticketing Forum] Ticket Pricing Proofing
Christopher Cuhel:I was wondering if anyone has come up with an easy way to do some ticket price proofing. We are on 12.1 so we have the price grid. What would ultimately be most amazing is if you could export the whole price grid to an Excel document for proofing but I don't see that as an option. Is there a new report I'm missing that helps with proofing or have any of you created a custom report (that you'd be willing to share) that helps with price proofing.
Christopher Cuhel:
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com>Sent: 7/28/2015 12:21:20 PM
You’re definitely on to something here. Could you post in the Shared Reports of TASK? Thanks!
Shelley Espinoza
System Services Manager
524 Trinity Avenue, St. Louis, MO 63130
Direct 314 561 4885
www.cocastl.org
Now Registering for SPARK 2015: Risk Creativity, September 2, 2015
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Tuesday, July 28, 2015 3:09 PM To: Shelley Espinoza Subject: RE: [Tessitura Ticketing Forum] Ticket Pricing Proofing
Christopher Cuhel: This looks interesting Chris. Do you have selection parameters in the report that allow you to pick specific performances, days of week, etc? I only ask because we have different prices on different days of the week. Also, the price might be different from performance run to performance run.
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 7/28/2015 7:46:47 PM
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Tuesday, July 28, 2015 12:38 PM To: Christopher Cuhel Subject: Re: [Tessitura Ticketing Forum] Ticket Pricing Proofing
Christopher Cuhel: I was wondering if anyone has come up with an easy way to do some ticket price proofing. We are on 12.1 so we have the price grid. What would ultimately be most amazing is if you could export the whole price grid to an Excel document for proofing but I don't see that as an option. Is there a new report I'm missing that helps with proofing or have any of you created a custom report (that you'd be willing to share) that helps with price proofing.
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 7/28/2015 12:21:20 PM
Hi All,
For those of you interested in Chris' report, it has been posted to the Shared Reports workspace in TASK as solution #348.
Thanks for sharing, Chris!
Bryan
Unknown said: Hi All, For those of you interested in Chris' report, it has been posted to the Shared Reports workspace in TASK as solution #348. Thanks for sharing, Chris! Bryan
Thank you, Bryan.
To all, I'm happy to answer any questions, please e-mail me offline any time.