Analyze Phase

In the Analyze phase, the data collection is over. The full data set is available in the Data Center for review, downloads, and analysis. You can either download survey data set as Excel documents from the Data Center for your own analysis or use the Print mode feature to share or export the data center results and graphs.

Welcome Screen

Interactive Reports
  • Visitor: Anyone who visits the Survey URL
  • Participant: A subset of Visitors that submits at least 1 data point on the Survey
Cumulative Traffic: Line graph illustrating the cumulative number of participants throughout the Survey. Daily Traffic: Bar graph illustrating the number of participants per day. Participation Rate: Pie chart illustrating the ratio of participants to visitors. Platform Breakdown: Pie chart illustrating the ratio of visitors who accessed the Survey from the web version vs the mobile version.

Daily Traffic by URL: Bar graph illustrating the number of participants per day for each survey URL(If there is only one Live URL, this will be identical to the Daily Traffic graph)

Daily Traffic by Campaign: Bar graph illustrating the number of participants per day for each survey Campaign

Survey Data Points
  • The number of total data points submitted by all participants
  • Data points include rankings, ratings, map marker placements, Survey question responses, and comments.
  • The average number of data points per participant
  • A pie chart breaking down the data points for each screen
  • A list featuring the quantities of the different types of data points on each screen
Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Traffic Data
    1. Total by URL: The total number of visitors and participants for each Live URL.
    2. Aggregated by Day: A breakdown of the visitors and participants on each day
    3. All Visit: A line by line breakdown of every visitor. Displays Visit ID, Visit Time (in UTC-7), the URL visited, whether or not they were a participant, and the IP address.
  • Crosstab Data
    1. A comprehensive spreadsheet is displaying all activities of every participant. This includes all the information in the Traffic Data “All Visits” sheet, in addition to the platform used (Web or Mobile), the browser, and specific data they inputted on each screen (How many items ranked/rated, comments, demographic question answers, etc.)
  • Session Data
    1. Another comprehensive spreadsheet is displaying line by line each data point submitted by every participant. This can be useful for detecting duplicate “ballot box stuffers.”

Image Rating Screen

Interactive Reports

Dropdown 

Vertical Title Bar graph displaying the total number of individual images ranked on each tab. Each tab on the screen has its own Dropdown, which is a sub-heading for each individual image. Tab Name A double axis graph. On the left axis is the number of times each image is rated in each position, marked by blue bars. On the right axis is the average rating of each image, marked by plotted points forming a red line. Single bar graphs of both Times Rated and Average are also available for each tab. Each individual image has its own bar graph displaying the number of times each was rated from Strongly Disagree to Strongly Agree. Comments Bar graph displaying the number of individual comments on each image, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Ratings Bar Chart 
    1. Table displaying the number of times each image was rated at each different rating, from Strongly Disagree to Strongly Agree. A bar graph for each tab is generated from these numerical results. 
  • Ratings Summary 
    1. Table displaying the number of times each image was rated at each different rating, from Strongly Disagree to Strongly Agree. This separates mobile and web version data. 
  • All Ratings 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the rating of the strategy in question, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments
    1. Table displaying all comments made on any image. This includes VisitID, visit time, platform used, and the image the comment was left on. 

Map Marker Screen

Interactive Reports

Dropdown

  1. Google map overlaid with every marker placed.
  2. Clicking on a marker shows the date placed, exact latitude and longitude coordinates, and any comments, if applicable.
  3. When zoomed out, the map is a heatmap showing areas with the highest volume of markers, while zooming in displays each individual marker

 

  1. Screen Title – Marker Count – Bar graph displaying the times each marker was placed
  2. A section is reserved for each marker and labeled by name. This features a single bar graph showing the number of times the marker has been placed
  1. A word cloud of the most frequently used words in the comment section
  1. Comments – Bar graph displaying the number of individual comments on each marker, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads.
Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Mapping Chart
    1. Table and associated bar graph displaying the total amount placed and comments left for each marker
  • Map Marker Summary
    1. Table displaying the number of each marker placed, separated into each URL on mobile and web platforms
  • All Mappings
    1. Comprehensive list of all markers placed by any participant. Contains information including visit time, site visited, platform used, latitude and longitude, drop order, and answers to the marker questions
  • Comments
    1. A list of general screen comments and the time at which they were submitted

Budget Allocation Screen

Interactive Reports

Dropdown 

Vertical Title – Average Bar graph displaying the average total value of coins given to each item. Each tab on the screen has its own Dropdown, which is a sub-heading for each individual image. Vertical Title – Distribution Bar graph displaying the number of times each item was given at least one coin, which counts as a “response”. Each item on the screen has its own bar graph, which displays the number of times (vertical axis) the item in question was given each value of coins (horizontal axis). Comments Bar graph displaying the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Ratio Charts
    1. Table displaying the average value of coins given to each item, up to two decimal places. A bar graph is generated from these numerical results.
  • Ratios Summary
    1. Table displaying the number of times each item was given different coin values. Any value given at least once will be displayed.
  • All Ratios
    1. Table displaying every individual data point for this screen. This includes information such as VisitID, visit time, platform used, the coin value given to each item, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen.
  • Comments
    1. Table displaying all general screen comments. This includes VisitID, visit time, platform used, the comment itself, and its associated Sentiment Analysis score.

Funding Balance Screen

Interactive Reports

Dropdown 

Vertical Title – Average : Bar graph displaying the average number of notches each item was given. Vertical Title - Distribution : Bar graph displaying the number of times each item was given at least one notch of funding, which counts as a “response”. Each item on the screen has its own bar graph, which displays the number of times (vertical axis) the item in question was given each number of notches (horizontal axis). Comments:  Bar graph displaying the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Ratio Charts
    1. Table displaying the average number of notches given to each item, up to two decimal places. A bar graph is generated from these numerical results.
  • Ratios Summary
    1. Table displaying the number of times each item was given each number of notches.
  • All Ratios
    1. Table displaying every individual data point for this screen. This includes information such as VisitID, visit time, platform used, the number of notches given to each item, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen.
  • Comments
    1. Table displaying all general screen comments. This includes VisitID, visit time, platform used, the comment itself, and its associated Sentiment Analysis score.

Priority Ranking Screen

Interactive Reports

Your Priorities: An overview of all priorities that can be viewed in three different types of graphs.

Distribution: A double axis graph. On the left axis is the number of times each priority is ranked in each position, marked by blue bars. On the right axis is the average ranking of each priority, marked by plotted points forming a red line. Individual distribution is also available for each priority. Average: A scatter point graph displaying the average ranking on each priority with a single point. Responses: A bar graph displaying the total times each priority was ranked at any level. Comments: Bar graph displaying the number of individual comments on each priority, in addition to the number of general screen comments. This is just numerical data; the actual words are displayed in the excel downloads. Lastly, a table view is also accessible by clicking the grid icon to the right of the dropdown. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Rankings Bar Chart 
    1. Table showing the average ranking and number of times each priority is ranked 
    2. Pre-made bar graph displaying times ranked and line graph displaying average ranking based on data from the table 
  • Ranking Summary 
    1. Table displaying the number of times each priority was ranked in each position for both the mobile and web versions of the site 
  • All Rankings 
    1. Table showing the individual rankings of each participant. This includes their visitor ID, the platform used, and age demographic question range. 
  • Comments 
    1. Shows all comments submitted, including the visitor ID, visit time, the platform used, and which priority the comment was made on 

Scenario Rating Screen

Interactive Reports

Dropdown 

Vertical Title – Distribution : Bar graph displaying the total number of individual scenarios ranked on each tab. Vertical Title – Average : Bar graph displaying the average rating of each scenario. Vertical Title – Responses: Bar graph displaying the number of times each scenario was rated. Scenario Name: Bar graph displaying the number of times each scenario was rated at each star rating. Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Ratings Bar Chart 
    1. Table displaying the number of times each scenario was rated at each star rating, from one to five. A bar graph is generated from these numerical results. 
  • Ratings Summary 
    1. Table displaying the number of times each scenario was rated at each star rating, from one to five. This separates mobile and web version data. 
  • All Ratings 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the rating of the scenario in question, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all comments made on any scenario, or general screen comments. This includes VisitID, visit time, platform used, and the scenario the comment was left on. 

Project Selection Screen

Interactive Reports

Dropdown 

Vertical Title – Distribution : Bar graph displaying the number of times a decision was made on each project (Either “Yes” or “No” chosen) Each project on the screen has its own Dropdown. Project Title : Bar graph displaying the number of times “Yes” or “No” was chosen for each project Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Ratings Bar Chart 
    1. Table displaying the number of times “Yes” or “No” was selected for each project. A bar graph is generated from these numerical results. 
  • Ratings Summary 
    1. Table displaying the number of times “Yes” or “No” was selected for each project. This separates mobile and web version data. 
  • All Ratings 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, and the selection (Yes or No) of the project in question, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all general screen comments. This includes VisitID, visit time, platform used, and the actual screen comment. 

Standard Survey Screen

Interactive Reports

Dropdown 

Vertical Title – Distribution : Bar graph displaying the number of times any question on each specific tab was answered.  Tab Name: A bar graph displaying a further breakdown of the number of times each question is answered. This graph lists each question on the specific tab. Question Title: For Dropdown, Button, and Checklist question types: A third bar graph displaying the number of times each answer was selected for a specific question.  For Comment question types: Both a Word Cloud and a Sentiment Analysis (link SA article) are available for any comments made on the question.  Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Survey Data Charts 
    1. Table displaying the number of times each potential answer to each question was selected. A pie chart for each question is generated from these numerical results. 
  • All Categories 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the specific question set, and answer selected. It also includes the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all comments, including comments on textbox type questions and general screen comments. This includes VisitID, visit time, platform used, and the actual comment. 

Strategy Rating Screen

Interactive Reports

Dropdown 

  Vertical Title: Bar graph displaying the total number of individual strategies ranked on each tab     Each Category on the screen has its own Dropdown, which a sub-heading for each individual strategy.   Vertical Title – Responses: A double axis graph. On the left axis is the number of times each strategy is rated in each position, marked by blue bars. On the right axis is the average rating of each strategy, marked by plotted points forming a red line. Single bar graphs of both Times Rated and Average are also available for each tab.         Each individual strategy has its own bar graph displaying the number of times each was rated from one to five stars.     Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads.           Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Ratings Bar Chart 
    1. Table displaying the number of times each strategy was rated at each star rating, from one to five. A bar graph for each tab is generated from these numerical results. 
  • Ratings Summary 
    1. Table displaying the number of times each strategy was rated at each star rating, from one to five. This separates mobile and web version data. 
  • All Ratings 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the rating of the strategy in question, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all comments made on any strategy. This includes VisitID, visit time, platform used, and the strategy the comment was left on. 

Tradeoff Screen

Interactive Reports

Dropdown 

Vertical Title – Distribution: A double axis graph. On the left axis is the number of times each tradeoff is rated in each position, marked by blue bars. On the right axis is the average rating of each tradeoff, marked by plotted points forming a red line. In this case, 1 represents the far left, 3 is neutral, and 5 represents the far right.  Vertical Title – Average: Bar graph displaying the average rating of each tradeoff  Vertical Title – Responses: Bar graph displaying the number of times each tradeoff was rated. Each tradeoff tab on the screen has its own Dropdown. Left Tradeoff vs Right Tradeoff – Bar graph displaying the number of times the tradeoff was rated at each position. Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • All Ratings Bar Chart 
    1. Table displaying the number of times each tradeoff was rated at each position, from Far Left to Far Right. A bar graph is generated from these numerical results. 
  • Ratings Summary 
    1. Table displaying the number of times each tradeoff was rated at each position, from Far Left to Far Right. This separates mobile and web version data. 
  • All Ratings 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the rating of the tradeoff in question, along with the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all general screen comments. This includes VisitID, visit time, platform used, and the actual screen comment. 

Visual Preference Screen

Interactive Reports

Dropdown 

Vertical Title – Distribution: Bar graph displaying the number of times a preference was selected from each set of images.  Each set of images on the screen has its own Dropdown. Tab Title: Bar graph displaying the number of times each image from this set was selected Comments:  Bar graph displaying the number of individual comments on each scenario, in addition to the number of general screen comments. This is just numerical data; the actual comments are displayed in the excel downloads. Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Survey Data Charts 
    1. Table displaying the number of times each image was selected. A pie chart for each image set is generated from these numerical results. 
  • All Categories 
    1. Table displaying every individual data point for this screen. This includes information including VisitID, visit time, platform used, the image set in question, and image selected. It also includes the answers to the Demographic questions of the Survey’s Wrap-Up screen. 
  • Comments 
    1. Table displaying all comments, including comments on image sets and general screen comments. This includes VisitID, visit time, platform used, and the actual comment. 

Vision Statement Screen

Interactive Reports

Dropdown 

  Horizontal Screen Title Single bar graph displaying the number of written responses left by participants.       Vision Feedback Both a Word Cloud and a Sentiment Analysis are available for any comments made on the screen.                 Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Comments Aggregated by Type 
    1. Table displaying the number of participants who left a response on either the mobile or web version of the survey 
  • All Comments 
    1. Table displaying the Visitor ID, visit time, platform used, and every written response submitted on the screen 

Wrap Up Screen

Interactive Reports
  1. Screen Title and Bar graphs displaying the number of times each question was answered. This applies to all questions including dropdown, button, checklist, textbox and comment answer variables, except for the private question.
  2. Dropdown menu allows you to navigate among different questions with a bar graph of the answers and how many times each was selected.
  1. Bar graph and Table view toggle:  Please see the image on the right for the table example.

Question Variables:

  1. Dropdowns, Buttons, and Checklist: There is a bar graph of the answers and how many times each was selected.
  1. Textboxes and Comments: WordCloud displaying keywords from responses
  1. Sharing: Bar graph displaying the number of times the Facebook and Twitter icons were clicked to share the Survey.
  1. Comments: Bar graph displaying the list of comment questions including Screen general comment and the number of comments left.
Excel Downloads

These are spreadsheets containing numerical Data. You can download onto your computer for analysis.

  • Demographic Charts
    1. Table displaying the number of times each demographic question option was selected. A pie chart is made for each question based on these results. Additionally, the number of times the survey was shared on Facebook and Twitter is also reported.
  • Demographic 
    1. Table displaying Visitor ID and time, platform used, specific question answered, and option selected for all dropdown and button questions.
  • Private
    1. Table displaying Visitor ID and time, platform used, specific question answered, and text submitted for all private textbox questions. The most used private variable question is “What is your email?”
  • Other
    1. Table displaying Visitor ID and time, platform used, specific question answered, and option(s) selected for all checkbox questions.
  • Comments
    1. Table displaying Visitor ID and time, platform used, specific question answered, and text submitted for all longer comment questions.
  • Sharing
    1. Table displaying Visitor ID and time, platform used, and social media site (Facebook/Twitter) shared on
Heatmap Zip/Postal Codes

The Heat Map for zip/postal codes is a feature in your Survey settings that allow you to view the map in the Data Center for codes that have been submitted by participants on the Wrap up Screen. Survey managers will be able to easily view and download the heat map in the Data Center and collect data on where the participants are taking the Survey from.

 

 

1) In your Wrap Up Survey Screen, create a question requesting the participant’s zip/postal code. Go into your Survey you would like to add this feature to and toggle the zip/postal code option on.

2) Once your Survey is in the engage phase, participants who enter a valid zip/postal codes will be collected for the data canter.

3) Once your Survey has completed the Engage phase and is now ready to analyze, you can go into the Data Center and select Screen 5 or the Wrap Up Screen to see the data your Survey has collected.

 

 

Please note that only valid zip/postal codes will be collected and shown in your Heatmap. Any invalid zip/postal codes will not be displayed on the heat map. However, the data will still be collected and visible in the excel report.

Related Articles:

  • Data Center Introduction: You can access the Data Center during the Engage and Analyze phase through your Survey Dashboard. The Data Center is where you check out interactive reports and the Excel files with your data set.
  • Ballot Box Stuffing: MetroQuest removes barriers, such as email sign-ups and restrictions on IP Addresses, to participation. It is recommended that you filter your data set to fit your criteria during the Analyze Phase.
  • Statistical Significance: You can find more information about public involvement and statistical significance. Online engagement tool’s contribution to public engagement success.
Engage Phase