Hello friends!
My theatre is looking at implementing rankings for our subscribers, memberships, artists, board members, etc. This is a whole new world for us! And while I think I understand the technical fundamentals of rankings, I was hoping some folks would be willing to share their experiences, processes or policies around how they build their ranking structure and perhaps what you use your rankings for.
Many thanks in advance!
Hi Kristine,
We use rankings primarily to determine the order we seat our subscriptions in. We only have one rank that applies to everyone; there's not a separate one for board members and one for subscribers etc. We are a black box theater and each show has a different seating arrangement, so at the beginning of the year we sell unseated subscription packages, and then go through and manually seat them all once we have the seating configurations. We want our big donors and long time subscribers to be seated first, so we came up with a formula that takes into account things like years and amount donated, years subscribed, and amount of single ticket purchases. The formula we use was created before my time, but it's just a SQL query we run right before we start the seating process that calculates and updates everyone's rank with the most current information.
Hope that helps!
Sara