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.
    Click this arrow to switch projects in BigQuery.
    Project-switching options
  5. In the Add Project screen, enter google.com:analytics-bigquery
    In the Project ID field, 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]

Was this helpful?

How can we improve it?
true
Choose your own learning path

Check out google.com/analytics/learn, a new resource to help you get the most out of Google Analytics 4. The new website includes videos, articles, and guided flows, and provides links to the Google Analytics Discord, Blog, YouTube channel, and GitHub repository.

Start learning today!

Search
Clear search
Close search
Google apps
Main menu
6386647374550546045
true
Search Help Center
true
true
true
true
true
69256