The following instructions relate to exporting project data into csv (Excel) format.

To export your Survey Data:

  1. Log in to your Social Pinpoint Admin site

  2. In the main title bar click the Survey Responses option

  3. On the Survey Responses page, select the 'Export' option on top right of the page

  4. You will then be sent an email allowing you to download your export (Please ensure you check your junk/spam folder if you haven't received the email. Additionally your internal IT team may have blocks in place preventing the email from being delivered.)


The resulting csv file can be opened in Excel for further analysis and reporting.


Details on the information exported are as follows:

Field

Description

Project

The name of the parent project against which the survey was completed

Map Layer

For those surveys that are completed against a specific map feature/shape, Map Feature will contain the name of the parent layer (if configured) of the feature/shape that was clicked to invoke the survey

Map Feature

For those surveys that are completed against a specific map feature/shape, Map Feature will contain the name of the shape (if configured) that was clicked to invoke the survey

Marker

For those surveys that have been completed against an Info Marker, Marker will contain the Summary that was entered for the Info Marker when it was created

GeoSurvey Step

For those surveys that have been completed as part of a user dropping a marker - and for projects in which a GeoSurvey is active - GeoSurvey Step will contain the name of the GeoSurvey step in which the marker was dropped

Survey Name

The name of the survey (as configured)

Created On

The date and time at which the survey response was submitted

Type

For those surveys that have been completed as part of a user dropping a marker, Type will contain the name of the Marker Type that was dropped

First Name

The first name of the respondent

Last Name

The last name of the respondent

Email

The email of the respondent

IP Address

The IP address of the machine on which the respondent submitted the survey

Response Values

A column is created for each question and option created for the survey, containing the value entered per response. Response values are appended identified by:

  • a combination of the name and value (.e.g: "QuestionName - OptionValue") for questions that have been defined as Checkbox or Rank questions

  • the name of the question for all other question types

For image question types, a link to the uploaded image is included as the response value

Tag Values

A column is created for each tag defined with the project, and populated with the tag value itself for those responses that have been associated with a specific tag


Filter your search by Date Range:

Click on "All Time"


And then select using a Date Range

Did this answer your question?