Average number of performances per order

Hi everyone,

I'm trying to find out the average number of tickets purchased in an order during a specific season. The catch is I only want to look at orders through a specific mode of sale (or price type would also work). This doesn't seem achievable in T-Stats.

I'd be happy to pull a list of all constituents that has their total number of perfs in the orders as a column value and then just do an average on those figures.

Anyone doing something similar?

Cheers

dgh

Parents
  • Clean Clean false false false EN-US X-NONE X-NONE

    Hi David,

     

    Are you working in the tickets cube? The forum post will strip an attachment, but I ran a quick report just now, that gives me orders and number of tickets, by mode of sale, for our Omnitheater in December of last year. I’m not sure what customizations we have in the tickets cube, but you can email me directly and I can send you a copy of the report.

     

    Ray

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of David Geoffrey Hall
    Sent: Wednesday, September 17, 2014 4:01 AM
    To: rbernard@smm.org
    Subject: [Tessitura Ticketing Forum] Average number of performances per order

     

    Hi everyone,

    I'm trying to find out the average number of tickets purchased in an order during a specific season. The catch is I only want to look at orders through a specific mode of sale (or price type would also work). This doesn't seem achievable in T-Stats.

    I'd be happy to pull a list of all constituents that has their total number of perfs in the orders as a column value and then just do an average on those figures.

    Anyone doing something similar?

    Cheers

    dgh




    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!

Reply
  • Clean Clean false false false EN-US X-NONE X-NONE

    Hi David,

     

    Are you working in the tickets cube? The forum post will strip an attachment, but I ran a quick report just now, that gives me orders and number of tickets, by mode of sale, for our Omnitheater in December of last year. I’m not sure what customizations we have in the tickets cube, but you can email me directly and I can send you a copy of the report.

     

    Ray

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of David Geoffrey Hall
    Sent: Wednesday, September 17, 2014 4:01 AM
    To: rbernard@smm.org
    Subject: [Tessitura Ticketing Forum] Average number of performances per order

     

    Hi everyone,

    I'm trying to find out the average number of tickets purchased in an order during a specific season. The catch is I only want to look at orders through a specific mode of sale (or price type would also work). This doesn't seem achievable in T-Stats.

    I'd be happy to pull a list of all constituents that has their total number of perfs in the orders as a column value and then just do an average on those figures.

    Anyone doing something similar?

    Cheers

    dgh




    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!

Children
No Data