We are looking at creating some ticketing sales trackers in v15 Analytics. I've been able to find how to report on ticket count and value, but can't see anywhere that we can pull data on an order level.
Does anyone know what data we would need to add to a widget to pull in:
Total number of orders
Average number of tickets per order
Average price per order?
Good morning Oliver,
It's definitely possible, though some of the formulas I've used to achieve this may or may not match up exactly with how you'd want to see data:
There is a data point called Order ID and you can specify that you want a count of unique Order IDs, and then you can filter down from there to get a sense of the number of Orders for a given date range or season, etc.
The other two widgets use formulas to divide Total Ticket Count against the unique Order IDs, and then Ticket Paid Amount against the unique Order IDs.
Hope that helps!
Thank you,
Brian
Thanks for this Brian.
I will give this a try - hopefully it will all work out.
Oliver