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:
Go to Reporting > Project Reports, choose the relevant Projects and date range, then select Update.
Expand the Download Report menu and select Excel under Detailed Report. This option is only available when you have selected five or fewer projects.
Once the download is complete, open the ZIP file and the relevant project file. There will be an Excel file for each selected project.
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 drop-down 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 drop-down to switch between story tools and the Signup Form Question drop-down 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.
