• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 146 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

    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



    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Daniel Williams <bounce-danielwilliams2218@tessituranetwork.com>
    Sent: 17 July 2016 00:45
    To: Sandra Ashby
    Subject: [Tessitura Technical Forum] Zip Code Pulls
     

    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




    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

    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



    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> on behalf of Daniel Williams <bounce-danielwilliams2218@tessituranetwork.com>
    Sent: 17 July 2016 00:45
    To: Sandra Ashby
    Subject: [Tessitura Technical Forum] Zip Code Pulls
     

    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




    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