Analysis of theatre experience

Date of data collection: from 2024-10-10 to 2024-12-14Geographic location of data collection: Music theatre Kapsäkki, Hämeentie 68, FI-00550 Helsinki, Finland

File List: 

Variables.xlsxList of variables in data files, with brief explanation.

UKK_booths_master_data.xlsx    Ratings given at customer satisfaction kiosks, with date, time, and number of show (out of 20 shows in total) per rating/answer on each row. Total number of ratings (rows) is 1,887. - Number of variables: 7- Number of cases/rows: 1,887

UKK_no_of_audience_per_show.xlsxInformation on number of members of audience, number and % of ratings given at customer satisfaction kiosks, and number and % of answer to questionnaire per show on each row. Total number of shows (rows) is 20.- Number of variables: 10- Number of cases/rows: 20

UKK_questionnaire_Likert_open_answers_UK.xlsxQuantitative ratings on Likert-scale and qualitative open-ended answers to questionnaire. Answers per respondent, with information on which show they relate to, are on each line, with variables in columns. Total number of answers (rows) is 458. Open-ended answers in this file are translated into English from the original open-ended answers given in Finnish. Total number of open-ended answers is 268. The 190 MISSING values for open-ended answers indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.- Number of variables: 24- Number of cases/rows: 458

UKK_questionnaire_open_answers_FI.xlsxOriginal open-ended answers given in Finnish, per respondent. Total number of open-ended answers is 268. The 190 missing values indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.- Number of variables: 2- Number of cases/rows: 458. The 190 MISSING values indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.

Relationship between files:1. Original open-ended answers in Finnish in file UKK_questionnaire_open_answers_FI.xlsx are connected with quantitative ratings on Likert-scale and qualitative open-ended answers translated into English in file UKK_questionnaire_Likert_open_answers_UK.xlsx using ID in the first column in both files.2. Show number (1 to 20) is used in files UKK_booths_master_data.xlsx, UKK_no_of_audience_per_show.xlsx, and UKK_questionnaire_Likert_open_answers_UK.xlsx.

Description of methods used for data collection are described in detail in publication Measuring audience experience across 20 showings of the same theatre performance using customer feedback kiosks and a questionnaire by Sams et al. (2025) (manuscript, no link yet). In short, 1,887 ratings of overall enjoyment were given by members of audience to 20 performances in customer satisfaction kiosks at the theatre immediately following each show. Total number of members of audience to the 20 performances was 2,812, who gave 458 answers to questionnaire after the show by filling in an online questionnaire. 

Methods for processing the data:Raw data from ratings given at customer satisfaction kiosks were read from server of the service provider (popupbuddies.fi) as .csv files. Raw data from answers to questionnaires were extracted from Webropol server as .csv files and imported in MS Excel. The original number of respondents was 477. After removing incomplete answers that e.g. only contained demographic data, and answers given more than 7 days after the show, the total number of respondents is 458. Then we replaced missing values in cells with the text 'MISSING'. We checked the quality of the data for missing values and correct date and time values by visual inspection of the data and charts drawn based on the data in MS Excel.All data is in .xlsx files that have one sheet per file. No specific packages or libraries are needed. We have separate python scripts for data analysis that are proprietary.