Hello Tessiturians!
I think I may have to go to T-Stats for this, but I thought I'd throw this question to the forum to see if anyone else has tried something else that may work.
We have a presenter who has increased their print marketing and have seen a return on that increased marketing. They'd like to know what cities these sales are coming in from in order to target more marketing materials over the next two weeks. Outside of T-Stats does anyone know a way to pull this information for them?
As always, your help is greatly appreciated.
Cheers!Short
Our zip codes reside in the Tickets cube/Dimension ConstSum/General.
We have also customized our Category field in for walk-up orders to capture zip codes of anonymous transactions; this show in T-Stats in the Ticket Orders dimension.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of India HagginsSent: Friday, April 05, 2013 11:41 AMTo: rbernard@smm.orgSubject: Re: [Tessitura Ticketing Forum] Sales Reporting by Zip Codes
I'd like to run a report that shows our top zip codes by sales performance. I have t-stats but don't know how to pull this information.
How do I do this?
From: Charles (Chuck) Buchanan <bounce-charlesbuchanan5408@tessituranetwork.com>Sent: 12/4/2012 3:49:25 PM
I know you mentioned T-Stats.
T-Stats is actually great for Zip Code/Geographic location reporting. It is particularly helpful to filter by top 20 or 30 zip codes by household. We use this to understand the differences in our audiences program by program. It can be really helpful with targeting your marketing efforts to particularly strong areas for your programs.
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!
Ray,
That's an interesting idea. Where are the zip codes being entered during the order for walk-ups?