The following instructions relate to exporting project data into csv (Excel) format.
To export your Survey Data:
Log in to your Social Pinpoint Admin site
In the main title bar click the Responses option
On the Responses page, select the 'Export' option on top right of the page
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 |
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:
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