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

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

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

Filter your search by Date Range:

Click on "All Time"

Image Added

And then select using a Date Range

Image Added