Confirmed users
85
edits
Connected Devices/Projects/Metrics/Database and Visualization: Difference between revisions
Jump to navigation
Jump to search
m
Connected Devices/Projects/Metrics/Database and Visualization (view source)
Revision as of 00:23, 16 June 2016
, 16 June 2016→Table Schema: minor
m (→BigQuery: minor) |
m (→Table Schema: minor) |
||
| Line 12: | Line 12: | ||
==== ga_sessions Tables ==== | ==== ga_sessions Tables ==== | ||
The Analytics data is exported into a series of tables, which are named as follows: | The Analytics data is exported into a series of tables, which are named as follows: | ||
* ''' | * '''ga_sessions_YYYYMMDD''' - This table contains all event data recorded on the date in the table name. A new table is created for each day's data. | ||
* ''' | * '''ga_sessions_intraday_YYYYMMDD''' - This table contains all event data that has been exported for the current day, and batches of data will be appended to it several times during the day. | ||
If you are familiar with Google Analytics data and/or working with multi-dimensional data, you are welcome to query these tables directly. You can find the schema reference here: https://support.google.com/analytics/answer/3437719 | If you are familiar with Google Analytics data and/or working with multi-dimensional data, you are welcome to query these tables directly. You can find the schema reference here: https://support.google.com/analytics/answer/3437719 | ||