View and export results
Google Surveys aggregates and analyzes responses from users and presents results in a simple online interface. You can view these results online or export these results to a spreadsheet.In this article:
- How long before I will start to see results?
- How do I view my survey results?
- Why do I see more responses than I paid for?
- What happens if users don't answer all my questions or screen out?
- Why are there more responses on the survey results overview page but fewer in the question results page?
- How can I export my data?
- What data will be included in my export?
- How do I use the weights column to calculate weighted results?
- Can I do cross-tab analysis within the survey results page?
View and export results
Your survey starts collecting responses minutes after it goes live. You’ll start seeing results in your online account once the data is processed, which usually happens in a matter of hours.
Please note that while we're still collecting results, you may see that your answers are coming predominantly from one age group, gender or source. This is due to our collection methodology and which sources we're able to collect from earliest, such as the Google Opinion Rewards mobile app. Your results should become more representative of your targeted population as they continue to come in. While you're encouraged to start looking at your results as soon as they're available, you shouldn't make any decisions until you've received the full data set.
To view your survey results:
- Sign in to Google Surveys.
- Click on the survey you want to view on the survey dashboard.
- Click on the text of any question to see individual question results. Keep in mind that the responses reported for each question include all users who answered that question, even if they did not complete the survey.
- Click on the inferred demographic segments on the lefthand pane to segment the data by: inferred age, gender, or geography.
- While your survey will start to collect responses immediately, you'll start seeing results once data has been processed, which usually happens in a matter of hours.
The system errs on the side of collecting too much rather than too little data, so at times you may see a more responses than requested. However, you will only be charged for the number of completed responses you purchased.
You will not be charged for responses from users who only answer your screening question (without answering the follow up question) or who drop out midway through your survey.
The total survey responses are the unweighted results, while the question results are the weighted results. To switch off weighting and show all responses, click a question in the survey overview, then tun on the Raw counts toggle at the top of the question-results page.
There is a discrepancy between the number of unweighted and weighted responses because of respondents with unknown demographics. Google Surveys uses post-stratification weighting to compensate for sample deficiencies and reduce bias. However, weighting can only be applied to respondents whose age, gender, and geography are known. Some responses have unknown demographic values, and thus are not shown when weighting is on.
Learn more about weighting.
To export your data:
- Sign in to Google Surveys.
- Click the survey whose data you want.
- On either the survey-results or question-results page, click Download .
The Excel file is saved in your default download location.
Your exported file will include multiple tabs: Overview, Topline, Complete responses, All responses, and Crosstabs. These contain the following data:
- Overview: This tab provides a general overview of your question text, answers, and counts of responses received.
- Topline: This tab provides a breakdown of answer proportions for each of your survey questions. The data here includes all incomplete responses.
- All responses & Complete responses: These tabs contain response-level data for users who answered any question or all questions in your survey, respectively. The columns are:
- User ID: A numeric ID for each user who answers the survey. Note that you cannot match users across different surveys: the same user will have different User IDs in the Excel downloads of different surveys.
- Time: Date and time in UTC, in the format 2012-11-16 17:22:39.
- Survey Completion: Defines whether a respondent completed all questions in a survey (Complete), screened out (Screen-out), or dropped off but didn't screen out (Partial).
- Publisher Category: The kind of publisher site on which the respondent saw the survey. The categories are News, Arts & Entertainment, Shopping, Reference, Mobile App, Other, and Website Satisfaction.
- Gender: Inferred gender: Male, Female, or Unknown.
- Age: Inferred age bucket: 18-24, 25-34, 35-44, 45-54, 55-64, 65+, or Unknown.
- Geography: Inferred location encoded as a string with the format [Country]-[Region]-[State]-[City]. For example, US-WEST-NM-Albuquerque. We include the most detailed breakdown available, and will report Unknown if the country is unknown.
- Weight: The weighting applied to this response to match the CPS demographics.
- Answer: The respondent’s answer to this question.
- Response Time: The amount of time in milliseconds it took the respondent to provide an answer to that question.
- Cross-tabs: This tab provides a cross-tabulation analysis for users who answered all questions (i.e., complete responses) in your survey.
Learn more about weighting and the Surveys methodology.
Depending on which results you want, there are a few ways to calculate weighted results using the Weight column in the Excel file you export.
To calculate weighted results for complete responses to any question in the survey, start with the Complete responses tab. You can apply weights to the results by creating a pivot table where the columns are the answers to a question and the data is the sum of the weights. Note that some responses will be dropped when you look at weighted results because Surveys cannot calculate weights for responses with unknown demographics. If you look at the sum of the weights in the Complete responses tab, it's equal to the number of rows that have weights, which is usually different from the total number of rows.
To calculate weighted results for the responses to any question in the survey, start with the All responses tab.
For the first question in the survey, you can use the Weight column directly. The method to do this is the same as described above for complete responses, but use the All responses tab instead of the Complete responses tab.
Other question results
If you want to calculate results for the last question, use the weights in the Complete responses tab as described above. If you want to calculate results for any question other than the first or last question, you need to filter the rows and renormalize the weights before applying them to get results.
Here's a renormalizing example: There are 100 rows with weights in the All Responses tab, so the sum of the weights column is 100. There are only 50 rows with weights and an answer to the second question because respondents screened out or dropped out of the survey after the first question.
If you filter to only the rows that have weights and an answer to the second question, there's no guarantee that the remaining weights will add up to 50; let’s say they add up to 40 instead. You'll need to renormalize the weights column by multiplying each weight by 50 / 40 = 1.25. This will ensure that the sum of the renormalized weights is 50. You can now use these renormalized weights to calculate the results with a pivot table.
If you want to calculate weighted results for a filtered set of responses, such as 65+ Females, then you will need to renormalize those weights as well. First filter the rows to only the rows you want to see; in this example, that's only 65+ Females. Then follow the same renormalizing procedure described above.
Cross-tab analysis is used to see how different groups of users answered your survey questions. You can export the data to a spreadsheet and see the cross-tab or you can do it online.
Let's say you're starting a dog toy company. You want to better understand the relationship between price and qualities people look for in the toys they buy for their dog. You ask the following questions:
- Do you own a dog?
- Yes (target answer)
- I prefer not to say
- Which quality do you look for most when purchasing a dog toy?
- When purchasing a toy for your dog, what is the maximum amount you expect to spend?
- $1 - $5
- $6 - $10
- $11 - $15
- $16 - $20
To analyze how different users felt about price in comparison to qualities, follow these instructions:
- Sign in to Google Surveys.
- Click on the survey you want to view on the dashboard page.
- Click on the text of any question in the overview to see individual question results.
- Under Comparisons click Another question.
- Select which question you'd like to compare to.
- The results bars at the top will give you a graphic representation comparing the two questions.
- The chart at the bottom will provide a results chart comparing the two questions.
- You can also add additional layers, such as age or gender, to continue to analyze the data or add demographic filters to restrict answers from a specific population of users.
For surveys that are targeted by zip code or with geo-fencing, the smallest dimension must have at least five responses. If a given dimension does not have at least five responses that match to it, then filtering options will be disabled. If additional layers of filters (age, gender) allow a user to deduce information about the smallest dimension, those may also be disabled.