I'm not sure if this falls into ticketing or marketing so I'm posting in both!
We've been asked to find out which booker has placed the largest transaction and who is the most frequent repeat booker since we opened last June.
Is there an easy way to find this out, other than manually going through the weekly sales reports?
Any adive would be gratefully received!
Thanks,
Laura
Hi Laura,
I think you could do this with List Builder or TStats.
For Booker with Largest Transaction:
You want to get a data with a column for customer_no and a column for total ticket amount. Then export that to excel and order by the total ticket amount.
You can use List Builder and an Output Set with the "Tickets - Total Amount" column.
For most frequent booker:
You want to get a data with a column for customer_no and a column for num orders or num tickets. Then export that to excel and order by the orders or tickets.
I guess you could use Output Set column "Tickets - Total Number of Unique Perfs", but it might be best to use 'num orders' in TStats.
Hope that helps,
Dara