Take control of your Social Pinpoint account with our detailed documentation.

Page tree
Skip to end of metadata
Go to start of metadata
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

 

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


Details on the information exported are as follows:

FieldDescription
ProjectThe name of the parent project against which the survey was completed
Map LayerFor 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 FeatureFor 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
MarkerFor 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 StepFor 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 NameThe name of the survey (as configured)
Created OnThe date and time at which the survey response was submitted
TypeFor 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 NameThe first name of the respondent
Last NameThe last name of the respondent
Email

The email of the respondent

IP AddressThe 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 ValuesA 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
Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 18 rates
  • No labels