The Newsfeed tool allows you to post project updates and for your community to leave comments on them. When your consultation ends, there are three ways you can collate and analyze your Newsfeed data:
You can analyze your data while the consultation is ongoing for some preliminary insights, but you will not be looking at your 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 comment, 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 NewsFeed tab to see your data. Each tool instance has its own tab, so multiple NewsFeed tabs may exist.
The Newsfeed tab contains three sections to explore:
Summary information: Columns A and B provide an overview of participation and a breakdown of the participant type (registered, unverified, anonymous, or admin). It also contains the contribution count, including comments.
Contribution information: Columns D-H provide contribution details such as the contribution date, the comment left, the poster’s screen name, and the number of votes received.
Signup Questions: Columns J and onwards contain each question 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 Newsfeed Tool Report
The Newsfeed Tool Report will provide useful graphs and insights into your Newsfeed article comments.
Go to Reporting > Tool Reports > News Feed to generate the report. You can explore the following sections once you filter to the relevant Projects and date range.
Overview
This section includes:
The number of Newsfeed articles, including Published, Draft, and Archived articles.
The Visitor Summary lists the Visitors, Contributors, Contributions count, and the participant type. You can use the drop-down menu to choose a specific tool’s statistics.
The Engagement Summary bubble graph. In this graph, larger bubbles indicate more contributions, the vertical axis indicates the number of visitors, while the horizontal axis indicates when it was published. The hamburger icon lets you download the graph as a JPEG, PNG, SVG, or PDF.
Newsfeeds Visitor Statistics
This section includes the project and Newsfeed article title and the number of:
Visitors
Contributors
Comments
Votes
Comments by Admin
This information can help you compare your Newsfeeds between projects to see which articles received more visitors and contributions.
Newsfeed Insights
This section lists all the comments on a Newsfeed article, including the date submitted, the screen name, and the content.
You can use the drop-down menu to switch between articles and the Signup Form Question dropdown to filter by demographics.
Text Analysis
In Text Analysis, you can analyze the free text of Newsfeed comments using tags to organize them, demographic filtering, and sentiment analysis.
You can also download the Text Analysis report to help extract this data.