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 Project(s) Data:

  1. Log in to your Social Pinpoint Admin site
  2. In the main title bar click the Comments option
  3. On the Comments page, select the 'Export CSV' option on top right of the page

 

The resulting csv file can be opened in Excel for further analysis and reporting. You can also use the CSV to create GIS files such as Shapefiles or geoJSON.


Details on the information exported are as follows:

FieldDescription
Created OnThe date and time at which the comment was submitted
TypeThe name of the Marker Type against which the comment was made, for those comments that are marker-based (including info markers and discussion points on existing markers)
Marker NumberA sequential index given to comments that are marker-based, within the context of their Marker Type. Discussion points share the same Marker Number as the parent comment to which they apply. This number is used to show comments in the Map Report.
Map LayersThe name of any map feature/shape that contains the marker associated with a comment, for comments that are marker-based (including info markers and discussion points on existing markers).
GeoSurvey StepName of the GeoSurvey step if option to 'Filter markers by GeoSurvey step' has been enabled.
CommentThe content of the comment that has been submitted
Up VotesThe number of up votes (likes) that this comment has received
Down VotesThe number of down votes (dislikes) that this comment has received
EmailThe email address of the comment submitter
PhoneThe phone number of the comment submitter (if applicable)
AddressThe address of the comment submitter (if applicable)
SuburbThe suburb of the comment submitter (if applicable)
PostcodeThe postcode of the comment submitter (if applicable)
CustomThe value of the "custom" comment field as entered by the comment submitter (if applicable)
FirstnameThe first name of the comment submitter (if applicable)
LastnameThe last name of the comment submitter (if applicable)
Review NotesAny review notes that have been entered against this comment during moderation/review
Response TextThe public response entered by an administrator against this comment (if any), as part of moderation/review
ReplyIndicates whether this comment represents a reply, or a discussion item against an info marker, a zone, or another marker
Replied Summary

For those comments representing discussion items, Replied Summary will contain a reference to the parent comment to which the discussion item applied:

  • For info marker discussions: "Information Marker: <info marker summary>"
  • For zones: "Zone: <zone name>"
  • For markers: "Comment: <receipt number>"
ReviewedIndicates whether this comment has been reviewed by an administrator (true/false)
Reviewed AtFor reviewed comments, the date & time at which the comment was reviewed
ModeratedIndicates whether this comment has been moderated (true/false)
Moderated AtFor moderated comments, the time at which the comment was moderated
ProjectThe name of the map or ideas wall project against which the comment was submitted
ReceiptThe unique receipt for this comment, as communicated to the user on submission
LatitudeThe latitude of an associated marker, for comments that are marker-based (including info markers and discussion points on existing markers).
LongitudeThe longitude of an associated marker, for comments that are marker-based (including info markers and discussion points on existing markers).
Photo URLA link to the image that was attached to the comment (if any)
IP AddressThe IP address of the device on which the respondent submitted the comment
View On MapContains a hyperlink that will open the comment on the project map
Layer InformationA column is created for each layer in the map, and for those comments that have been created against a marker, the name of the associated feature/shape in which the marker was dropped is recorded.
Survey Response Values

For those comments that are created against a marker that also involves a survey, 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
Tag InformationA column is created for each tag defined in the project, identifying the specific tags associated with each comment during the review/moderation process
Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 20 rates
  • No labels