Hello,
What are you using at your organization to check ticket limits? I'm talking beyond setting a first line of defense with ticket limits via offers and pricing rules.
Here in Nashville, every morning Tessitura sends an Excel sheet of the previous day's orders for a show that has a limit. We then paste the data into a master excel sheet that checks for duplicate email addresses, duplicate mailing addresses, and duplicate names. Then the macros runs on the master sheet and highlights any accounts that exceed the ticket limit.For example, let's say Hamilton is coming to our venue and the ticket limit is 8. Every morning I paste the previous day of sales into the master Excel document. John Scalper has 2 accounts in our system. Account A is John Scalper, 123 Main Street, Nashville, TN and his email address is johnscalper@gmail.com. Then he has another account Account B Johnny Scalper, 123 Broadway, Phoenix, AZ and his email is also johnscalper@gmail.com. Different name and address, but the excel sheet notices that his email is being used twice and sees that between these 2 accounts he has 16 tickets. We then go into the order and do a little research. If the account raises a flag, we refund without question with a blanket email statement and go on about our day.
The issue that I'm having is for a show with multiple week runs and is typically a blockbuster, the checking process takes a good hour of my morning. The macros on the excel sheet takes forever to process. Then I have to manually check the orders myself and do a little research to see if indeed an account has exceeded the limit. Maybe there's a college campus nearby where many students utilize the same campus mail address. My excel sheet appears that an account has 25 tickets, but I can research and say, "Oh wait. That's a Vanderbilt address. These tickets are fine."
Has anyone else perfected their ticket limit checking with in a more timely manner?