Skip to main content
Reporting on Stories Data

Understand how to interpret data collected using the Stories tool

Vishwas Prasad avatar
Written by Vishwas Prasad
Updated over 2 months ago

The Stories tool allows your participants to submit long-form text responses to your project. When your consultation ends, there are two main ways you can collate and analyze your Stories data:

You can analyze your data while the consultation is ongoing for some preliminary insights, but you will not be looking at the final dataset. To report on the final dataset, please ensure that the project or tool is archived so there will be no more contributions.

Using the Detailed Excel Report

The Detailed Report will show you overall tool statistics, each Stories submission, and relevant participant data. To generate the report:

  1. Go to Reporting > Project Reports, choose the relevant Projects and date range, then select Update.

  2. Expand the Download Report menu and select Excel under Detailed Report. This option is only available when you have selected five or fewer projects.

  3. Once the download is complete, open the zip file and the relevant project file. There will be an Excel file for each selected project.

  4. Go to the Stories tab to see your data. Each tool instance has its own tab, so multiple Stories tabs may exist.

The Stories tab contains three sections to explore:

  • Summary information: columns A and B provide an overview of participation and a breakdown of the participation type (registered, unverified, anonymous, or admin). It also contains the contribution count, including new stories, comments, and votes.

  • Contribution information: columns D-K provide contribution details such as the contribution date, story title and details, the user’s screen name, and whether it’s a story or comment.

  • Signup Questions: columns N and onwards contain each of the questions in your Signup Form and your users' answers. We provide this information so you can filter your submissions using demographic data. Please note that this information is only available if a contributor is registered and logged in when they submit.

Using the Stories Tool Report

The Stories Tool Report will provide useful graphs and insights into your Stories submissions.

To generate the report, go to Reporting > Tool Reports > Stories. You can explore the following sections once you filter to the relevant Projects and date range.

Overview

This section contains:

  • The number of Stories, including Newly Added, Accepted, and Rejected stories.

  • A visitor summary counting Visitors, Contributors, Contributions and the participation type. You can also use the dropdown menu to choose a specific tool’s statistics.

  • The Engagement Summary bubble graph. On this graph, larger bubbles indicate more contributions. The vertical axis indicates the number of visitors, while the horizontal axis indicates when it was published. You can use the hamburger icon to download this graph as a JPEG, PNG, SVG, or PDF.

Demographics

In this section, you can use Signup Form Questions to see graphed participant data from registered users who contributed to the tool. If you don’t use registration or used unverified participation, there will be no data here.

You can use the hamburger icon to download the graph as a JPEG, PNG, SVG, or PDF.

Stories Visitor Statistics

This section includes the project and story tool title and the number of:

  • Accepted and Rejected stories

  • Visitors to the tool page

  • Authors and Admin Authors

  • Comments and Admin Comments

  • Votes

This information can help you compare different Stories tools to see which tools received more visitors and contributions.

Stories Insights

The Stories Insights will list every story that was submitted to the tool. You can use the dropdown to switch between story tools and the Signup Form Question dropdown to filter by demographics.

Each story submission will show the date it was submitted, the screen name of the contributor, and the content of the story.

Did this answer your question?