Database Reference
In-Depth Information
Google Analytics
leading web traffic analysis services. It enables you to monitor and analyze
the behavior of your users across your web properties and mobile
applications. The service records
hits
, a page view, or any other
developer-defined action from individual users and organizes them into
visits
, where a visit roughly corresponds to a session of activity. Developers
can instrument the logging to include a variety of custom dimensions or
values that are saved as part of the hit or visit. The service front end allows
you to view this data in a variety of reports and dashboards that support
a substantial amount of customization. Direct access to individual hits
organized into visits is available via BigQuery, but it requires that you have
a
Premium account
. A Premium account requires a USD 150,000 annual
contract, so the target audience is high-traffic sites that are generating a
substantial amount of data. Hopefully, in the future this feature will be
available to additional account types.
Setting Up BigQuery Access
When Google Analytics is integrated with BigQuery, it pushes a copy of your
daily traffic data into BigQuery every day. When this data is in BigQuery,
you can manage it independently of your Google Analytics account. For
example, you can control the ACL and lifetime or make additional copies
as you see fit. To start you need to contact your Premium support manager
give him two bits of information:
• BigQuery project ID that should receive your data
• Google Analytics view ID
Your Google Analytics account can handle multiple properties and each
property can have more than one view. A view is a subset of the data (defined
by custom filters) collected for a single property. By default, every property
has a single view that contains all the data for the property. Currently Google
Analytics supports only exporting a single view per property to BigQuery,
so most likely you want to have this unfiltered view pushed into BigQuery
because then you can run queries over all the data for your property. When
you submit this request, you will be instructed to modify the ACL of your
