Zip code capture

Hi Diamantino

When I wrote that post a few years ago I was still working at Sydney Opera House, but let me cast my mind back …!

If you have T-Stats then as Kjersten says Order Category is available there, but this doesn’t give the full picture if you have ‘real’  postcode data on data as well.

Sydney Opera House had written custom reports that worked in the way I described in the original post, cycling through the data to use either Category or Constituent Country/Postcode depending on what had been entered on the Order. As I don’t work there anymore you would need to approach them for more info on their custom work.

The basic data is in T_order, the field is called “class”. If you have someone who can write sql it wouldn’t be too difficult to do analysis on orders. Im not 100% sure what you mean by ‘buyer type’ but if its about price types then it’s a bit trickier as you’d need to join out to the sub-line items in the order.

Regards

+ Peter Nelson

+ Tessitura Network

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kjersten Schladetzky
Sent: Tuesday, 17 April 2012 01:37
To: Peter Nelson
Subject: RE: [Tessitura Ticketing Forum] Zip code capture

Right now we do all of our reporting out of T-Stats.  Order Category is a standard dimension and it would be easy to filter by constituent type or whatever else you need to break out.  As noted in my post above you have to remember that some of your zip data still lives on constituent records so make sure you're clear in exactly what you're pulling from where.

Hi Peter,

We use the same system to capture post codes at acmi (the Australian Centre for the Moving Image). I was wondering if you knew how to generate a report that would specifically allow you to see what postcaodes where collected for each buyer type?

Thanks

Diamantino

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!

Hi Diamantino

When I wrote that post a few years ago I was still working at Sydney Opera House, but let me cast my mind back …!

If you have T-Stats then as Kjersten says Order Category is available there, but this doesn’t give the full picture if you have ‘real’  postcode data on data as well.

Sydney Opera House had written custom reports that worked in the way I described in the original post, cycling through the data to use either Category or Constituent Country/Postcode depending on what had been entered on the Order. As I don’t work there anymore you would need to approach them for more info on their custom work.

The basic data is in T_order, the field is called “class”. If you have someone who can write sql it wouldn’t be too difficult to do analysis on orders. Im not 100% sure what you mean by ‘buyer type’ but if its about price types then it’s a bit trickier as you’d need to join out to the sub-line items in the order.

Regards

+ Peter Nelson

+ Tessitura Network

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Kjersten Schladetzky
Sent: Tuesday, 17 April 2012 01:37
To: Peter Nelson
Subject: RE: [Tessitura Ticketing Forum] Zip code capture

Right now we do all of our reporting out of T-Stats.  Order Category is a standard dimension and it would be easy to filter by constituent type or whatever else you need to break out.  As noted in my post above you have to remember that some of your zip data still lives on constituent records so make sure you're clear in exactly what you're pulling from where.

Hi Peter,

We use the same system to capture post codes at acmi (the Australian Centre for the Moving Image). I was wondering if you knew how to generate a report that would specifically allow you to see what postcaodes where collected for each buyer type?

Thanks

Diamantino

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!