Hi All,
We are fairly new to Tess and just had our ticketing history pulled in from our legacy system yesterday. We need to pull some information on Zip Codes for Marketing. I was trained on T-Stats but I just found out that history that is brought into the system is not able to be pulled on in T-Stats.
What I need to pull:
Zip Codes from the last 2 years and the $ amounts we have sold to them as well as the number of constituents in that Zip Code that we sold to. It would also be great if we could have the number of tickets that were sold to that Zip Code but is not necessary if we can't. The bad part is I need this by Monday.
Thanks in advance for any advice!
Sincerely,Daniel
Box Office ManagerFlat Rock Playhouse2661 Greenville HwyFlat Rock, NC 28731Phone: (828)693-3893
Daniel
You could use a List in List Manager to find the people with postcodes you require, then use an Output Set to output the information you are after.
There are some standard Output Set elements that might do the trick. Otherwise look at the Output Set Builder Cookbook as there might be some you can use as is or as a starting point to get what you are after. http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Marketing/~/media/Learning%20and%20Resources%20documents/Webinar%20docs/2014/Output_Set_Builder_Cookbook_for_v12.doc
Cheers
Sandra
Sincerely, Daniel
Box Office Manager Flat Rock Playhouse 2661 Greenville Hwy Flat Rock, NC 28731 Phone: (828)693-3893
Thanks, Brian. Works like a charm!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom Sent: Wednesday, October 12, 2016 3:46 PM To: Sara Nemeth <SNemeth@thegilmore.org> Subject: RE: [Tessitura Technical Forum] Zip Code Pulls
Then write a view, and point t_keyword to that view.
BRIAN WILBUR GRUNDSTROM | Database Administrator SHAKESPEARE THEATRE COMPANY Recipient of the 2012 Regional Theatre Tony Award® 516 Eighth Street, SE | Washington, DC 20003-2834 p 202.547.3230 ext. 2216 | c 917.952.7957 bwg@shakespearetheatre.org www.shakespearetheatre.org www.brianwilbur.com 2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sara Nemeth Sent: Wednesday, October 12, 2016 3:31 PM To: Brian W. Grundstrom Subject: RE: [Tessitura Technical Forum] Zip Code Pulls
I'm trying to create a criteria in List Manager that only looks at the Primary Postal Code. I'd originally thought just having the Primary Address Flag criteria in my List would limit it, but that doesn't appear to be the case.
Unfortunately everything I've tried thus far won't work. I can make it work in SSRS, but can't figure out where to put my WHERE clause in the T_KEYWORD table since I don't want the criteria to be a dropdown.
Any help is greatly appreciated. Thanks!
Sara
From: Ken McSwain <bounce-kenmcswain5454@tessituranetwork.com> Sent: 7/20/2016 2:06:14 AM
Or, indeed, if you've transitioned to v12.x and adopted the new standard ticket history format, it would be T_TICKET_HISTORY.... Or if you were in our consortium, with a re-customised version, it would be LT_TICKET_HISTORY
Ken
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!