• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 123 views
  • Users 0 members are here
Related

Recreate Tessitura ticketing setup pricing grid in Analytics?

James Davis
$organization

Hi all,

I'm interested in recreating the 'Ticketing Setup' pricing grid from within Tessitura in analytics.

I have got as far as having price types listed vertically and zones horizontally across the top. 

Then I have chosen 'Seat Current Base Value' in VALUES. I want to be able to see the current price as a value but at the moment I can only work out how to see MAX, MIN or AVERAGE price. See the image below.

Is there anyway to see the current price for today here?

Thanks

  • $organization

    I would love to have that available, but I don't see how it's possible! Given that Analytics is delayed, the closest you could get would be the sold price for yesterday (as of 11pm, when the data updates. 

    I don't know of a way to show price event prices, besides when that price is sold (you could show it then as 'Ticket Paid Amount' as a row, or something like that. I'm interested in this concept as well! We use Dynamic Pricing, so a succinct way to show the current prices by zone would be super helpful.

  • $organization

    Hi James,

    The short answer here may be that Analytics was not designed to produce the results you're looking for.

    I would expect the Seat Current Base Value to be the current base value, always, and that within a Performance ID + Zone ID + Price Layer, would return the same result regardless of MAX, MIN, or AVERAGE. For sold seats, the value returns the BASE value, regardless of which price types were used to purchase the seat - meaning it will be the same across all price types within a zone. And since unsold seats are not associated with a price type in Analytics, they'll all be listed under the (none) price type.

    The current value of price types are only present in Analytics in the form of the Ticket Value (sold seats) against the latest Order Date. So price type + zone combinations without sales will not have data in Analytics. Within each Price Type + Zone, we could take the total ticket value of the most recent order

    MAX ( [Days in Date] ,
      IF ( 
        [Max Order ID] = ( [Max Order ID] , ALL( [Days in Date] ) )
        , MAX ( [SLI ID] , [Total Ticket Value] )
        , NULL
      )
    )