I'm trying to find a good way to tag performances with information to help our marketing department. We send emails out based on past show purchasing, and instead of always remembering which show was which, I'd like to tag shows with information on conductor, composer(s), piece(s) played, soloists, soloist instruments, genre (for Pops and special rental shows),
This information can't live on the title level For instance, every week of our classical series has at least 3 different pieces written by various composers- it really needs to live on the production season level.
I'd like to know if anyone else is keywording or using the Artist/Roles features for this, and if so, how you query that information later to make this a worthwhile project. At the moment, I have all of this data in a spreadsheet, but would love it to be in Tessitura.
Thanks
Todd Barnett
Patron Services Data Manager
Pittsburgh Symphony Orchestra
In terms of the best ways to structure that data, the two that jump out to me are storing conductor as a credit and genre as a keyword. We already do genres this way, and as I'm sure you know they're very easy to search on for lists.
I believe you'd have to do a little extra work to have list criteria based on credits, but I wouldn't expect this to be difficult to put together.
For the other, more freeform or multidimensional data (composer, pieces, soloists, solo instruments), this may be a good example of where a custom screen + local system tables could be useful. There may well be some organization out there that has already put something like this together -- but if not, I think it could be a great opportunity for some collaborative development.
Has anyone created a List Criteria that looks at Credits? Hoping I don't have to start from scratch.
Thanks,
Kelly