The Social Pinpoint Learning Centre
The reporting for your forms and surveys provides a summary of results along with associated data and meta-data.
Steps to access a Form Report
The form report has four sections:
The Form Tool includes additional filters that offer more detailed insights, allowing users to create tailored views of specific responses and trends.
The Summary section shows the results for each question in a form or survey, illustrating them through dynamic visualisations and summary tables.
You can export the report as a .pdf by clicking the 'Export' button at the top-right of the page.
Responses to quantitative questions such as multiple-choice, rating, ranking, and matrix questions are automatically aggregated and analysed, while responses to open-ended questions can be summarised with Social Pinpoint's text-analysis tools (see below).
The way responses are analysed depends on the type of question asked in the form or survey.
The Multi Choice lets participants choose one or multiple answers from a list of options configured.
Single Selection: If participants can only select one option, a summary table displays the total count and percentage of each response. The percentages will sum to 100%. A doughnut chart visualizes the percentage breakdown of all responses.
Multiple Selections:
If participants can select more than one option, the summary table still shows the total count and percentages, but these may not sum to 100%. In this case, a bar chart visualizes the number of times each option was selected, with longer bars representing more frequently chosen options.
Rating questions ask participants to respond to a question on a visual, stepped scale. A weight is assigned to each step in the scale to determine a weighted average in the results.
A summary table shows the number of times each step of the rating scale (e.g. 1-5, 1-10, etc.) was selected along with the percent value for each step (percentages will always total 100% across responses), the total count or number of responses and the weighted avg. score across all responses.
A 'column' visualisation shows the percentage breakdown for each rating option, along with the average overall rating score at the upper-right.
Slider questions are similar to rating questions in that they ask respondents to respond to a question on a stepped, numerical scale. However, this is done by dragging an interactive slider element along a scale bar rather than selecting the value directly.
Slider questions also allow for negative values, so users can adjust the slider bi-directionally along the scale as opposed to just one way.
The results of a Slider question are shown as a 'column' visualisation similar to the Rating question.
A summary table shows the number of times each step of the scale was selected along with the percentage of times it was chosen. Additionally, it shows the total count (which should correspond to the number of times the question was answered), the average and median scores across all responses, and the minimum and maximum values that were selected on the scale.
Ranking questions ask participants to order a list of items in order of their preference. A weighted average 'score' is calculated for each answer choice, helping you determine the most and least preferred answer choices.
The ‘score’ is calculated by:
The 'score' weighs the results by the number of contributions so outliers do not bias the score. This is particularly useful in cases where the ranking of all options is not required.
Weights are applied in reverse order. In other words, a participant's most preferred choice (which they rank as #1) has the largest weight and their least preferred choice (which they rank in the last position) has a weight of 1.
In addition to the new ‘Score’ calculation a new column to display the ‘Average Rank’ of the choice is also available in the data report. The ‘Average Rank’ is calculated by:
This change has been applied retroactively to all previous ranking questions, and results reports will be updated.
Matrix questions ask participants to evaluate one or more questions against a common response scale.
A summary table shows results of the questions, with each question listed down the first column and the answer choices listed across the first row. The total number of responses for each answer choice is shown in each cell along with the percentage values which will always total 100%.
Additionally, the summary table shows the total count or times the question has been answered, and the average score for each question. To determine the average score, answer choices are assigned a number value depending on how many choices there are. For example, if a question askes users to respond on a scale with five steps, responses will be assigned a value from 1 to 5 respectively.
A 'bar' visulisation plots the average score to indicate were responses fell along the answer scale.
Short Text and Long Text questions collect open-ended, text-based responses from participants.
Before seeing the results for these questions, users must first analyse responses either manually, or automatically through Social Pinpoint's Analysis Assistant. Following this process, the aggregated results are available in the Summary report, shown under three key sections.
Sentiment indicates the overall emotional tone of your responses with results displayed as a 'horizontal' bar visualisation showing the distribution across four classifications: positive, mixed, negative, and neutral.
Tags are words or phrases manually assigned to responses that indicate a particular topic, theme or other categories. Results are displayed in a summary table showing the total count and percentage for each tag and visualised as a 'word cloud' providing a visual representation of the most common tags in your responses.
Featured Contributions displays selected responses to the question chosen by the user. They can be used to highlight exemplary responses and provide more context and depth to the analysis.
The summary report for a map question displays the map with all markers placed by participants. Users can click the "View Contributions" button below the map to access detailed responses for that map question.
The Overview section provides high-level information about your form or survey, giving you insight into how participants engaged with it and who they were.
It includes information on:
The Data section of the Form tool displays the full results of your survey or form in a tabular format. Each row represents one contribution (submission) from a participant, while each column represents a question, member detail, or metadata field.
This is where you can:
In addition to a column for each question, the following fields are shown in the data table:
Only contributions from participants who are registered members of the site will have data in the member fields. Member data is dynamically copied from a member's user profile meaning it gets updated when their information is changed (via their user profile).
Any custom member fields added to your site (as part of the registration form) are also added to the data table.
You can filter your data to focus on specific submissions or trends:
Applied filters will also affect any data you export.
A new function that gives you full control over which questions or fields are displayed in the table and included in the exports.
You can deselect questions, metadata or member fields. The filter will still apply to the full data set - even if a column is hidden. This feature is particularly useful when preparing reports for specific audiences or when handling sensitive data.
You can export the Form data in the following formats:
To export, apply your filters or manage columns settings as needed, select 'Export' in the top-right corner of the page, then select your desired file type.
💡NOTE: Any filters or column selections you apply will be reflected in the exported file.
When exporting large datasets, you will now see a notification when your data download is ready. This prevents you from having to wait on a loading or processing screen you can continue working while your export is prepared.
In addition to the fields common to all data tables, the map question data table includes:
Below is an example of how the data from a map question might be displayed. This data can be filtered, exported, and analyzed in the same way as other survey data.
The Analysis section lets you view individual text-based responses collected through any Short Text or Long Text questions in your forms. It also contains a number of tools that help you analyse the data, so you can summarise and present results for qualitative questions.
The following fields are shown in the data table:
All responses can be viewed together, or filtered by individual question by selecting the 'Question' dropdown at the top of the table. Clicking the 'Show Filters' button provides additional options to filter responses such as 'Tags', 'Sentiment' and whether the response is 'Featured'. Once filters have been selected, click the 'Apply Filters' button.
Data can be exported as .xls or .csv by clicking the 'Export' button at the top-right of the page, and selecting the desired file type. Any filters you have applied to the data table will also be applied in the data export.
In today’s landscape, having an online community engagement platform is essential to connect with your residents, gather feedback, and involve members in decision-making. However, simply having a community engagement platform isn’t enough. To make a real impact, you need to drive traffic to your engagement site, ensuring you hear from a diverse range of voices.
Community engagement is an ongoing process of collaboration and co-learning. When we evaluate our community engagement initiatives, we give ourselves the opportunity to measure our deeper impact and make improvements for future projects.
With the right action plan in place, we can ensure we are connecting with our community on an appropriate level to enhance public decision-making.
