Currently when our box has to call a list of people for marketing purposes they use a spreadsheet. This seems inefficient especially if the constituent is on several spreadsheets.
They also use spreadsheets to track people who are hoping to buy tickets that are sold out.
What does your company do to avoid using spreadsheets to track information about activities that are tied to Tessitura information?
The overwhelming majority of our marketing mail lists are built out of Extractions in Tessitura: after all, that's our best source of information about people. Do you have other sources of leads that your marketing department relies on instead?
As to waiting lists, back when we had a custom site I build functionality such that a keyword could be applied to a sold out show and it would still be selectable from the calendar, but would take you to a page where (once you logged in) you could click a button to ask to be put on the waiting list. This attached a CSI to the account, where the CSI was attached to the performance in question (used a similar mechanism to create a post-show comments page). The box office could then use the CSI report to pull all relevant customers in first come order to seat people if seats became available.
Now that we're on TNEW we just rely on other web sign-up list tools (I think we've used a few, not sure what they're using right now). On the minus side, it's not kept within Tessitura, but on the positive you don't have to have an account to sign up.