Access the BigQuery sample dataset

NOTE: This data set will be removed in May 2018. Please migrate to the new data set.

To help you get familiar with the Analytics 360 BigQuery Export, we have generated a small sample dataset for the imaginary website London Cycle Helmet. This data set contains a single day's worth of data from the website, including pageviews, custom dimensions, events, and ecommerce transactions.

To access the dataset:

1. Go to http://bigquery.cloud.google.com.
2. If you're new to BigQuery, or you don't have a project set up yet, create a BigQuery project.
3. Click the small arrow next to your project name.
4. Open the menu next to your project name, and click Switch to project > Display project.

   

   Project-switching options

5. In the Add Project screen, enter google.com:analytics-bigquery

   

   Add Project screen

6. Click OK.
   
   You should now see a dataset named google.com:analytics-bigquery added to the project.
7. Select this project from the list, and click the ga_sessions table in the project to see the schema and details.
8. Click Query Table to run a query.
   
   Try a sample query like:
   
   SELECT SUM(totals.pageviews) as TotalPageviews
FROM [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]