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 in CSV or image format (PNG or PNG with results table).
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.
- 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.
The question results page defaults to weighted results. The weighting can be switched off in the survey results settings. The survey results page shows raw responses to the survey.
Consumer Surveys uses post-stratification weighting to compensate for sample deficiencies. Although Consumer Surveys attempts to build an optimal allocation of respondents to each question over the life of the survey, this is not always possible in practice due to additional constraints such as completing the survey in a timely manner, publisher inventory at the time, and competition with other surveys. Thus, post-stratification weighting is used to reduce this sample bias.
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 Question 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.
- 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.
- Screening answer: If you export the CSV for a follow-up question to a screening question, then you will get this column that includes the answer to the screening question.
- Answer: The respondent’s answer to this question.
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 or CSV 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.