Has your program been running postering & flyering campaigns using the Postering, Flyering, or Manual challenge types, or would you like to just get a general sense of where your ambassadors are submitting content from? At the end of your program, or as it’s running, you have the ability to export map data to get a bird’s-eye view of all submissions to these types of challenges.
Map Data Overview
All submissions to Postering, Flyering, and Manual challenge types record the submission’s location data. This location data is listed along with several columns of relevant information in the Google Drive Map Export Datareport, accessed via the Reporting tab on the portal. You can also view separate reports for each of the individual challenge dates.
The following submission information is listed in the report:
Campaign Nameis the tagged campaign, if present, on the challenge to which this content was submitted.
Status refers to the current status of the submission.
Approved: Submission has been approved by reviewer
Submission Comment is the comment provided by the user in-app upon submission of the content.
Rejection Comment is the comment made by a reviewer in the portal when submissions are rejected.
Link to Proof is a link to the content of a particular submission.
Date Reviewed refers to the date the content was reviewed in the portal, whether accepted or rejected.
Reviewer refers to the portal user that interacted with the submission.
Viewing Map Data in Google Maps
The information found in the Google Drive Map Export Data report is formatted for easy viewing in Google Maps. Follow the steps below to view all submission data as location pins in Google Maps.
Export your Google Drive Map Export Data report and prepare it for viewing. The report lists all submissions to all relevant challenge types for the entirety of the program; if you’d like to filter out based on date, challenge name, or any other information found in the report, you should do so by editing the exported .csv file. For example, many users will want to cut out the Manual challenge submission data for challenges that have nothing to do with location. In this case, simply sort the spreadsheet by the challenge name column and remove the rows belonging to irrelevant challenges.
Click on the red “Create A New Map” button to start a new map. Once you’ve created a new map, import the prepared data from the Google Drive Map Export data report. Click on “Import” (circled in red in the image below) and select the .csv file prepared earlier using the pop-up window.
Select your location data columns. The next screen will prompt you to identify the location data columns in the uploaded .csv. The “Latitude” and “Longitude” columns should already be checked for you, as in the screen below. Click “Continue” to proceed to the next screen.
Set the pin label column. This screen will allow you to set labels for the pins on the map. Most users will want to choose Submission Comment for this, but this label function can be used with whichever column is most useful! Press “Finish” once you have selected the label column to place the pins on the map.
View your map! Once you click on “Finish”, the map will display with pins for all submission locations! You can click on individual pins to drill down & access the rest of the information on each submission.
Map Data Tips & Tricks
Be aware of null location submissions when viewing your report - and when creating challenges! While all submissions to Manual, Postering, and Flyering challenge types attempt to gather location data, not all challenges require it. This will lead to submissions having null location data. You can filter these submissions by sorting your exported spreadsheet by the Latitude or Longitude column and deleting all submissions at 0, 0. If you’d like to ensure that all of your submissions have accurate location data, make sure to enable the location requirement when creating challenges!
Design your experience by thinking about your map data during challenge creation. Set up your challenges such that you’re getting all of the information you’d like to view with each submission point. If, for example, it’s important that ambassadors submit from the location at which they postered or flyered, note that in the challenge Call to Action. Similarly, instruct ambassadors if they should be providing specific information in their submission comment. Help your ambassadors help you!