Database Reference
In-Depth Information
project so that Google Analytics can write data to your project. Specifically,
you will be asked to add edit permissions on the project for the account:
After you have done this, support updates your account configuration so
that a nightly job pushes your data into the project. A dataset will be created
with a name equal to the view ID you specified in the request, and within
that dataset a daily table will be created some time after the end of the day.
The tables have the following naming pattern:
ga_sessions_YYYYMMDD
Table Schema
Fortunately, you can experiment with this feature without going through all
this setup or even signing up for a Premium account. The Google Analytics
team provides a sample dataset that you can use to understand the nature
of the data generated. You can add this data to your view in the BigQuery
project menu (the drop-down next to the project name, Switch to Project
Display Project). Alternately, you can navigate to the BigQuery UI link
After you add the project, the sample dataset (LondonCycleHelmet) appears
in the navigation panel. It contains two tables:
•
ga_sessions_20130910
•
refunds_201309
For now you can ignore the second table. The first table is the sample
table that contains data that corresponds to what Google Analytics collects
when users interact with a web property. Selecting the table displays a
complicated schema that has a large number of fields, as shown in
Figure
14.1
.
