Confirmed users
85
edits
Connected Devices/Projects/Metrics/Database and Visualization: Difference between revisions
Jump to navigation
Jump to search
Connected Devices/Projects/Metrics/Database and Visualization (view source)
Revision as of 16:18, 15 June 2016
, 15 June 2016→Table Schema: schema details in progress
(Initial) |
(→Table Schema: schema details in progress) |
||
| Line 10: | Line 10: | ||
== Table Schema == | == Table Schema == | ||
==== 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_20160613''' - This table contains all event data recorded on 2016-06-13. A new table is created for each day's data. | * '''ga_sessions_20160613''' - This table contains all event data recorded on 2016-06-13. A new table is created for each day's data. | ||
| Line 16: | Line 17: | ||
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 | ||
==== Simplified Views ==== | |||
With the Connected Devices metrics solution, we are only using a relatively small subset of the data available in Google Analytics. To simplify the picture, we have created a couple of views to allow easier access to the information. These views are flattened and can be queried with simple SQL. | |||
** schema | |||
There are currently two primary views available: | |||
* AllEvents_7Day | |||
* AllEvents_30Day | |||
The schema for these tables is identical: | |||
{| class="wikitable" | |||
|- | |||
! Column !! Data Type !! Description | |||
|- | |||
| HitTimestamp || Example || Example | |||
|- | |||
| HitTimestampUsec || Example || Example | |||
|- | |||
| EventTimestamp || Example || Example | |||
|- | |||
| FullVisitorId || Example || Example | |||
|- | |||
| VisitId || Example || Example | |||
|- | |||
| VisitNumber || Example || Example | |||
|- | |||
| HitNumber || Example || Example | |||
|- | |||
| AppName || Example || Example | |||
|- | |||
| EventCategory || Example || Example | |||
|- | |||
| EventAction || Example || Example | |||
|- | |||
| EventLabel || Example || Example | |||
|- | |||
| EventValue || Example || Example | |||
|- | |||
| EventValueFP || Example || Example | |||
|- | |||
| OS || Example || Example | |||
|- | |||
| OSVersion || Example || Example | |||
|- | |||
| Device || Example || Example | |||
|- | |||
| Arch || Example || Example | |||
|- | |||
| AppPlatform || Example || Example | |||
|- | |||
| AppBuildID || Example || Example | |||
|} | |||
(For reference, the query used to create these views can be found at: https://github.com/dylano/metrics/tree/master/sql) | |||
If these views are insufficient for your project or you'd like to discuss other ways to view or use the data, feel free to contact the CD Metrics team. (#cd-metrics, :doliver) | |||
Data/Vis | Data/Vis | ||