Hello! I am in charge of creating and sending nightly surveys to our patrons. We currently create the surveys in SurveyMonkey and send them out to scanned ticket holders through Tessitura and Prospect 2. We are currently looking for a more automated way of collecting and disseminating the survey data to the proper channels, as our process is quite manual right now. What do you use to wrap up your surveys, if you send them out? Do you have software that works with Tessitura and makes this process easier for you? Just looking for suggestions to bring to the table before our next season starts!
Have you identified or implemented a system for recording this into Tessitura already? If not you'll want to start there. Data can be imported numerous ways, but it has to have a place to go first. I expect you would want to the data to viewable on the customer record, reportable in aggregate, and searchable. You can put (very small) pieces of date in Attributes, but they won't relate to anything. CSIs relate to more things, but searching/reportability, while not zero, is very limited. A custom table would give you the information you need, configuring it as a DataService would give you lots of options for filling it, but then you would need a display option. Now, a report or two might cover that, or perhaps you would want a custom screen to quickly access survey results for a specific customer. A report with copious parameters might also resolve your searching needs, but you might also want to be able to identify some standardized survey items in Lists and Extractions?
Using WordFly as an example
You could schedule a nightly triggered email pointing to the survey in WordFly pages and that would write back to their record in Tessitura.
Does it take a lot of customization to get the pages to write back to the Tessitura record? I asked Kirk from WF about it at TLCC and he had no idea if it was even possible!
None. It's simple as. If you want it to update your attributes, write a pipe delimited CSI ... special activities update requires a little bit of understanding but it works. If you want to self custom it saves the data in local tables and you can do a nightly update from your own procs if you wan tpretty simply.