Accessing detailed Form Reports

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

  1. Go to the "Dashboard" > "Reports"
  2. Select "Results" in the left-hand menu
  3. Find your survey in the list and click the 'View Results' link
  4. 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 visualisations.
  • Overview - Shows meta-information about the activity, including when participants' 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

Summary

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.

If the number of steps in the numerical scale exceeds 11, the bar visualisation will automatically combine responses into a smaller number of breakpoints so the graph is still legible. The full, detailed results are visible in the summary table.

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:

  • 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 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.

Overview

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

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 analyse the data, so you can summarise 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.