Hey friends,
I am wondering if any of you amazing people have built a dashboard (or custom report) that can find accounts that a total ticket count for a show that is higher (or equal to) your published ticket limits. We are trying to find an easy way to find accounts who have either: A) purchased to the ticket limit (or over somehow) on web orders and/or B) accounts that have placed multiple orders that bring them to a total ticket amount that is equal to or more than your ticket limit.
We have been getting slammed by chargebacks and we need to find every way possible to find these accounts as soon as possible to return those tickets before a chargeback would happen.
Any and all advice is appreciated.
Chris
I created a couple dashboard for analytics that seem to be doing what we want. We have two: one that looks at people who are at our ticket limit (8 tickets) across one or more orders and the other is looking for orders with 9 or more tickets across one or more orders. Remember to change the data source to your local Seats & Tickets cube. Hopefully you all can find them useful. If you want to see different ticket amounts, there is a filter on each widget that controls the total ticket count to see.
PotentialBrokers-8ticketsonly.dashPotentialBrokers-9andabove (1).dash
Thank you for posting! We have an issue with people booking too many tickets (over a 100 sometimes!) on our free days and this will help us weed some of those folks out.
There is a filter inside the widget of each where you can enter the amount of tickets to display. For museum entry, you may have to play with the dashboard a little for filtering based on how you build the events for entry, etc. Happy data diving.