Online Surveys

We have sent out surveys when we were doing our website redevlopment; but we have never tied them in to Tessitura/Constituent Records usign custom procedures; it is an interesting idea though.

When you say sent out to constiuents you mean via email?  Since all the survey results are stored you could with each survey link you send out to customers,  have the customer number as a query string variable to be sent to the survey. 

You could have a custom table that stores all the customers that where targeted in a survey.  When the customer clicks the link to take the survey , it has the customer number, then you can mark the customer survey record appropriatly.  You can also store the results of the survey  by customer. 

Then in tessitura you could have a custom constiuent screen that shows all the surveys that were targeted to the customer.  Maybe also have a details view for the survey to see there answers. 

When you say sent out to constiuents you mean via email?  Since all the survey results are stored you could with each survey link you send out to customers,  have the customer number as a query string variable to be sent to the survey. 

You could have a custom table that stores all the customers that where targeted in a survey.  When the customer clicks the link to take the survey , it has the customer number, then you can mark the customer survey record appropriatly.  You can also store the results of the survey  by customer. 

Then in tessitura you could have a custom constiuent screen that shows all the surveys that were targeted to the customer.  Maybe also have a details view for the survey to see there answers. 

Good morning, all!

We are in the process of creating online surveys to be sent out to constituents (for the purpose of measuring constituent satisfaction with our concerts, etc) and were wondering if anyone out there has done something similar and if you've been able to implement custom procedures in Tessi for capturing survey results.

Thanks so much!

Mark McCormack

Nashville Symphony 

We are in the process of providing online surveys via email to our patrons after they attend a production. We will ask them to provide their patron ID (provided to them in the initial email) in the first part of the survey, so we can associate the data with their Tess account.

We plan to import the survey information into participants' accounts, but are currently trying to determine the best way to enter this data so we can then use it in lists and extractions without clogging up our attributes too much.

Has anyone had success in associating survey data with Tess accounts? Jamie--I wasn't at the conference this past year, was any headway made at the breakfast session on this topic?

Thanks!
Sarah
Goodman Theatre
312.443.3822

Hi all,

We send out an email survey to a sample of bookers following each one of our productions.  We have imported key measures from this back into Tessitura but tend not to do this anymore.

We use an external research agency operating under the Market Research Society guidelines (mrs.org.uk).  For most surveys we assure people that their responses are confidential and will not be linked to their records - because we need to ask social grade, income, ethnicity and other sensitive questions to meet Arts Council and our own reporting needs.  For those surveys we wouldn't be permitted to link responses to Tessitura given we are providing assurances of confidentiality.

For other surveys without that statement of assurance, we started to import back key measures such as 'new to theatre' or 'Excellent rating' for the production.  I found that we didn't use these very often for marketing or analysis so decided not to link them to Tessitura ID's anymore.

I'm sure there are reasons it's important - it's worth mapping out what measures you want to map back and how you would use them.  In terms of methodology we supplied a research agency with the data including Tessitura IDs, they responded with the responses flagged against Tessitura ID's and we conducted an import to create the answers as attributes.

Thanks

Mary Butlin

Royal Shakespeare Company

Along these lines, I know this is an old thread but I thought I'd add my .02 since it's an issue we're up against here:

Our marketing department wants survey response tracked through CSI's. The old process worked (briefly) like this:

1. Survey responses are collected in a big excel sheet and our marketing department responds to those needing a response.
2. Responses are copied into the big excel sheet and sent to customer care.
3. Customer care reads the survey response and codes each survey with a category, activity and origin (in some circumstances) from our CSI setup in Tessitura.
4. This excel sheet is sent to me and I import it into a SQL database and run a procedure against it that creates a CSI using the category/activity/origin from the excel sheet and puts the survey response and our response back in the notes field.

The problem we've run into is that now folks are responding to more than one issue in the comments and Marketing wants to track all of the issues they respond to.  A quick pull from SQL tells me there's 112 combinations of category/activity/origin and right now we're debating how to get these into the csi format.  Quick example:

Survey comes back and says (a) we cuss too much in our shows (b) our carpets are a tad messy and (c) parking is mess.  We would need 3 separate CSI's to accurately count how many complaints we had about our parking situation.

It can be done, but I'm hoping someone has an alternative idea how this can be tracked in Tess besides a custom screen?