• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 144 views
  • Users 0 members are here
Related

Zip Code Pulls

Daniel Williams
$organization

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 Manager
Flat Rock Playhouse
2661 Greenville Hwy
Flat Rock, NC 28731
Phone: (828)693-3893

Parents
  • $organization

    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!




    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!

Reply
  • $organization

    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!




    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!

Children
No Data