• Replies 6 replies
  • Subscribers 415 subscribers
  • Views 118 views
  • Users 0 members are here
Related

Sales Reporting by Zip Codes

Christopher Short
$organization

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

  • $organization

    I ended up making things really simple.  I created a Single Ticket Buyer's list for the dates in question and ran that through an output set which pulled out the Zip Codes and from there I was able to let our partner know where the sames were coming in from.

    DUH! :)

  • $organization in reply to Christopher Short

    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.   

  • $organization in reply to Charles Buchanan

    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?

  • $organization in reply to India Haggins (Past Member)

    Hi India,

    This is a pretty quick report to build in T-Stats.  I started typing out directions and then discovered that there are instructions in the T-Stats Recipe Book for "What are the top postal codes for a specific genre".  The link is below and it starts on page 153.  Follow these directions but instead of using genre, drag season (or performance depending on how granular you want the report) into the filter/slicer. 

    http://www.tessituranetwork.com/network/Learning/Documentation/T-Stats/T-Stats%20Recipie%20Book.aspx

    Let me know if you have any trouble and good luck!

    Chuck

     

     

  • $organization
    Clean Clean false false false EN-US X-NONE X-NONE

    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 Haggins
    Sent: Friday, April 05, 2013 11:41 AM
    To: rbernard@smm.org
    Subject: 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!

  • $organization in reply to Ray Bernard

    Ray,

    That's an interesting idea.  Where are the zip codes being entered during the order for walk-ups?