Hello All,
Happy Wednesday to you.
I have a reporting puzzle to work out. We used a pricing event to increase prices about a month in to the on-sale after an early bird period. This is causing the "performance revenue gain-loss" report to be not great in looking at results of actual dynamic pricing that have occurred closer to each performance. Is there some way to filter or show a detail of pricing events?
Thanks,
Kanani
We use Dynamic Pricing as well, and it's been great for revenue! The first thing that popped into my head was to include a row for 'Paid Amount'. This would display the price at which each number of tickets was bought.
You could filter by Order Date, or by Price Type, or Paid Amount, or Pricing Rule, or whatever you need to! Does that help?
Great idea! Thanks.
Hi there! I'm trying to build similar dahsboard for one of our events but I'm a bit stuck as our event has 2 price layers (a ticket layer + a VAT layer) which means that the 'Ticket Paid Amounts' are split into ticket 'prices' and VAT 'prices' which makes it very confusing. Does anyone know if there is a way to show the full amount? Thanks!
Hi Leonor,
You could apply a filter to the widget on Price Layer Category and limit the results to only Ticket Price layers. Rename that [Ticket Paid Amount] on Rows to [Ticket Price Amount]. Then add a value for Ticket Price that is the total price including VAT for that Ticket Price:
MAX ( [SLI ID] , ( SUM ( [Ticket Paid Amount] ) , ALL ( [Price Layer Category] ) ) )
And another value for the Ticket Paid Amount that includes VAT
SUM ( [SLI ID] , ( SUM ( [Ticket Paid Amount] ) , ALL ( [Price Layer Category] ) ) )
Then if you'd like, to hide the Ticket Layer Amount column, rename it to just "." a period and change the formatting to be a number with 0 decimals. Then shrink the column width as much as it will allow.
Leonor, is the "VAT Layer" an additional pricing layer that allows you to add your Dynamic price to your base price? As in, Ticket layer = $20 and VAT layer = $5, net ticket price = $25. If so, that is an interesting take on a dynamic pricing setup.