How do I download survey data?

Survey Results Data

Survey results data can be exported and downloaded from the survey list in Insights module. Please note that this is a permission-based feature.

Hover over the distribution of your choice, and select the download icon. A pop up message will be displayed to inform that download is in progress. After few minutes select the download icon again and if the message says ‘export successful’ a spreadsheet will saved to your computer.

The Survey Results Export File

The excel file will consist of 6 tabs:

  • Survey summary
  • Respondent count by hierarchy
  • Metrics by hierarchy
  • Closed responses by hierarchy
  • (language) Themes by hierarchy
  • Text responses by hierarchy

Employee privacy thresholds (DPA) are maintained within the export file.

If you are unable to see the export data icon, please reach out to support@qlearsite.com.

How to analyse the Engage score:

The product excel export tabs are filtered by hierarchy. We recommend starting with a single point in the hierarchy as the excel provides every single answer, for all hierarchy levels which can be a lot of data to view at one time.

The Aggregated Metric Value is the questions that have been marked positively in the survey form – all select one type questions should be marked with a Blue Tick for the positive answers Strongly Agree + Agree.

Using the Metric by Hierarchy tab to calculate the Engage score per department:

  • Apply data filters to the top row, columns headers
  • Within Metrics by hierarchy, Column G . ‘Metric name’ – select the 4 engagement questions used in the survey form. This can include:
    • I am motivated to respond to the changing needs of our organisation.
    • At our organisation, I feel motivated to persevere to find solutions to challenge
    • Our organisation inspires me to contribute more and do my best work every day.
    • I would recommend this organisation as a great place to work.
  • Column A – select the hierarchy / department you want to view
  • The average of those questions scores in Column H Aggregate Metric Value is the Engage score

Please note, all scores are percentages within the file.