View and export results
Google Consumer 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 Excel.
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 our Google Opinion Rewards mobile app. Your results should become more representative of your targeted population as they continue to come in, so while we encourage you to start looking at your results as soon as they're available, we'd also recommend that you don't make any decisions until you've received the full data set.
To view your survey results:
- Sign in to Google Consumer 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, urban density, geography or income.
- While your survey will start to collect responses immediately, you'll start seeing results on the data has been processed, which usually happens in a matter of hours.
Saved views allow you to create specific views of your data and save them so that you can return at any time.
- Sign in to your account at http://www.google.com/insights/consumersurveys/.
- Click the survey title.
- Click the question that interests you.
- Depending on your question type, select the desired report settings on the left hand pane or drag and drop the answers to code your open text results.
- Under Saved views on the right, click New.
- Create a title for the Saved view and click Save.
If you’d like to share a saved view, you can add a survey owner or share the link to that saved view after making your data public. Note that all data will be viewable beyond the saved view if you make the results public. If you add a survey owner, they will also see saved views that you create and you will see any that they create.
Responses from users who only answer your screening question and not the follow up question do not count. You will only be charged for screening questions when the user answers both questions.
To export your data:
- Sign in to Consumer Surveys.
- Click on the survey you want to view on the Survey dashboard page.
- Click on the text of any question in the Survey Overview to see individual question results.
- Click on the "Export data to Excel" button that causes an Excel file to get sent to the email address you're signed in with.
Note that exported data will only include inferred demographic information on age, gender, and geography.
- Overview: This tab gives 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.
- Complete responses (tab may be titled with the number of questions in the survey, i.e. 10): This tab contains responses from users who answered all questions in your survey. The columns included in this tab are:
- Time: Date and time in UTC, in the format 2012-11-16 17:22:39.
- 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 [Country]-[Region]-[State]. For example, US-WEST-NM-Albuquerque.
- Urban density: Inferred urban density - Urban, Suburban, Rural, or Unknown.
- Income: Inferred income - $0-$24,999, $25,000-$49,999, $50,000-$74,999, $75,000-$99,999, $100,000-$149,999, $150,000+, or Unknown.
- Weight: The weighting applied to this response to match the CPS demographics. For follow-up questions to screening questions, the weight column includes the total weight to match the CPS and an additional weight to match the makeup of the respondents who answered the target answers to the screening question. Please note that for exported data, weight is only available for complete responses.
- 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.
- All responses (tab may be titled with the number of questions in the survey, i.e. 10 with incompletes): This tab contains responses from users who answered at least one question in your survey, even if they screened out or dropped off before completion. The tab contains all of the columns as in the complete responses tab with one additional column:
- 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).
- Cross-tabs: This tab provides a cross-tabulation analysis for users who answered all questions (i.e. complete responses) in your survey.
For more information on weighting and the GCS methodology, please see this article.
Cross-tab analysis is used to see the interrelation between variables in a tabular presentation. You can export the data to an Excel file and see the cross-tab.
For example: analyze result for each question-answers & by demographics (aggregate or separately).
- In a survey, e.g. those who answered YES in the screening question, you can see what they did answer in other questions.
- It also applies to demographics, e.g. what did women/men answer to Question 1, Question 2, etc.