Hello! How can we help?

Search our knowledge base for loads of useful advice and answers to common questions

If you're still stuck you can always submit a support request and we'll get back to you ASAP

Analysis - What analysis and reporting tools are available in Citizen Space?

Rowena Farr -

This article details a basic overview of the analysis and reporting tools available in the online survey tool in Citizen Space.

The online survey consultation dashboard includes the ability to access quick headline stats at any stage of the consultation process. There is: 

  • A one-click PDF summary report — which can be accessed via the consultation dashboard at any stage of the consultation process. This can be used to track the progress of an open consultation, or to see an overview of a closed consultation’s outcomes. The PDF summary report includes top line response numbers for each question, as well as tables and charts showing the spread of any quantitative responses.
  • A one-click editable summary report which can also be accessed via the consultation dashboard at any stage of the consultation process. The editable summary report is exported as a .docx, and includes top line figures for the consultation and each question, as well as tables and charts showing the spread of any quantitative responses. 
  • Detailed analysis functions these include the ability to access more detailed information on submitted responses at any stage of the consultation, to view in full those submitted responses and to clean, code and query the responses.

Analysis of responses

During the consultation period and after it closes, analysts can go through the submitted responses, make notes and tag (code) qualitative answers to allow for quantitative reporting.   

Top-line numbers

At all times, the consultation dashboard shows the number of complete responses, and the percentage of responses that have been analysed.

Querying and reporting

You can query responses on a per-respondent basis (for example: 'Show me all respondents who answered yes to question 1') or on a per-question basis (or 'Give me a breakdown of all responses to question 2'). Filtering and grouping tools allow for sophisticated reports to be built up. 

Exporting the raw data

There are 2 .xlsx exports of responses:

  • 'Download all responses' 
  • 'Download all responses including analyst fields'

These spreadsheets include the full data submitted by respondents, plus metadata such as submitted date and time, last modified date, pages visited, response ID, and so on. In the export including analyst fields, this includes any tags (codes), analyst notes, and answers to analyst-only questions that you may have added during the data preparation phase in the 'Analyse responses' or 'Manually add a response' sections in Citizen Space.

These exports allow those would prefer to analyse their responses directly in Excel or in dedicated external statistical programmes such as SPSS, to be able to do so easily.

Exporting response publishing data

If you have response publishing enabled, there are 2 additional .xlsx exports available:

  • Download approved responses with redactions
  • Download published responses with redactions

These exports include the response data to questions selected in the response publishing settings for the individual consultation.

The approved responses export will include response data that is automatically approved during moderation (quantitative components) and response data that has been manually approved during the moderation process, but has not been published. The export will show the redacted versions of the responses along with the unique ID and submitted date and time.

The published responses export will include the response data that has moved through the moderation process (both automatic and manual approval) that is now published on the consultation. The export will also show the redacted versions of the responses along with the unique ID, submitted date and time, and the link the published response.

Publishing results and reports

Results, findings and reports can be added to the consultation overview page, and will be published after the consultation is closed. You can type your findings directly into the 'Publish Results' section of the consultation dashboard, and/or attach them as files there for visitors to download.

 

Related articles can be found in the Managing and Interpreting Responses section of this knowledge base