The reporting section for the Form tool has many different views and features based on the question types used:
See example reports and key notes at the bottom of this article.
Accessing detailed Form Reports
Steps to access a Form Report
- Go to the "Dashboard" > "Reports".
- Select "Results" in the left-hand menu.
- Find your survey in the list and click the 'View Results' link.
- Select the desired date range from the dropdown menu at the upper-right of the report. By default, the last seven days are shown.
The form report has four sections:
- Summary - Shows the results of your forms and surveys using summary tables and dynamic visualizations.
- Overview - Shows meta-information about the activity, including when participant's left contributions, what devices they used, and known demographic information for registered members.
- Data - Shows results in a tabular format that can be exported in .xlsx, .csv and .pdf formats.
- Analysis - Lets you view text-based responses to open-ended questions and use text analysis tools.
📃 Summary
The Summary section shows the results for each question in a form or survey, illustrating findings through dynamic visualizations 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 analyzed, while responses to open-ended questions can be summarized with Social Pinpoint's text-analysis tools.
The way responses are analyzed depends on the type of question asked in the form or survey.
The Multi Choice question type 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 donut 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 displays 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 percentage value for each step (percentages will always total 100% across responses), the total count or number of responses and the weighted average score across all responses.
A 'column' visualization 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 participants 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' visualization 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 organize 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:
- Summing up the weight of each ranked position.
- Multiplying the response count for each position choice.
- Dividing by the total responses of the question.
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:
- Summing up the ranked position of the choice,
- Multiplied by the response count for the position choice and then;
- Dividing by the ‘Count’ of the choice.
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 asks users to respond on a scale with five steps, responses will be assigned a value from 1 to 5 respectively.
A 'bar' visualization 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 analyze 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 visualization 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 visualized 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.
🔍 Overview
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:
- Form Details - Provides information about the form or survey including its title, description, whether the form is open or closed and the number of unique contributors and total contributions collected.
- Participant Type - Shows the number of unique contributors and total contributions coming from registered members and anonymous participants.
- Contribution Activity - Provides a 'line' graph showing the total number of contributions collected per day, split between registered members and anonymous participants.
- Technology - Indicates the device types and browser types used by your participants when making a contribution to the form.
- Member demographics - Shows the demographic details of any registered members including age, gender, age by gender, location, and categories and locations of interest.
📈 Data
Form Submissions
The Data section contains the full results of your survey in a tabular format. Each row of the table represents one contribution from a single participant, and each column contains the individual question, member information or other meta-data.
In addition to a column for each question, the following fields are shown in the data table:
- Contribution ID - Provides a unique number to identify the contribution.
- Date Submitted - The date and time the contribution was submitted.
- IP Address - The IP address of the participant, which is 'masked' to protect privacy. This can be used to detect contributions coming from the same place.
- Member Status - Whether the member status is 'Active' or 'Inactive'.
- Member ID - The unique ID number of the member.
- Member Username - The member's unique username.
- Member Email - The member's email address.
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.
Data can be filtered by clicking the 'Show Filters' button at the top of the table, selecting which filters to apply, and clicking the 'Apply Filters' button.
⬇️ Data can be exported as .xls, .csv or .pdf 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.
💡 We’ve added a new notification area that lets you know when your Form Data download or other item is ready, to prevent you from having to wait for a loading or processing message.
Map Question Data
In addition to the fields common to all data tables, the map question data table includes:
- Map Question Title: The title of the map question.
- Address: The address specified by the participant.
- Latitude: The latitude coordinate of the specified location.
- Longitude: The longitude coordinate of the specified location.
- Your comment: Any additional comments provided by the participant related to the map question.
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.
📊 Analysis
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 analyze the data, so you can summarize and present results for qualitative questions.
The following fields are shown in the data table:
- ID - Provides a unique number to identify the response.
- Date submitted - The date and time the response was submitted.
- Question - The question title that participants responded to.
- Contribution - The response submitted to the question.
- Sentiment - The sentiment classification assigned to the response ('positive', 'mixed', 'negative', and 'neutral').
- Tags - Words or phrases assigned to the response as determined by the user.
- Featured - Responses that are selected to appear in the 'Featured Contributions' section of the Summary report.
- Actions - Additional functions that allow you to view the entire contribution and its data in a pop-up window.
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.
- Example PDF report for Form tool PDF (2.81 MB)
-
MS Excel (21.40 KB)
⚠️ IMPORTANT:
-
If you want to test the survey/form you are building, please use the preview button within the tool. Do not test in the actual page.
-
Social Pinpoint staff will not delete data from Form reports without good reason. This includes test data as a preview function is available.
-
The Form tool does not allow Users to remove, change or manipulate submitted data. This is for openness and transparency reasons.