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 17:00, 15 June 2016

775 bytes added ,  15 June 2016
data desc
(→‎Table Schema: schema details in progress)
(data desc)
Line 29: Line 29:
! Column !! Data Type !! Description
! Column !! Data Type !! Description
|-
|-
| HitTimestamp || Example || Example
| HitTimestamp || String || The UTC datetime in which the event was received by Google Analytics. This is a timestamp with the format "YYYY-MM-DD 24:MM:SS", e.g. "2016-06-11 21:00:54".
|-
|-
| HitTimestampUsec || Example || Example
| HitTimestampUsec || Integer || The UTC time (in microseconds) in which the event was received by Google Analytics, e.g. 1465678854000000.
|-
|-
| EventTimestamp || Example || Example
| EventTimestamp || String || The UTC datetime in which the event was recorded by the ''Metrics library'', if you are using that method to record your events. Because the library may batch up your events before sending them to GA, this can be a more accurate time of the event occurrence. If you are posting your events directly via URL, you can disregard this column and use HitTimestamp instead.
|-
|-
| FullVisitorId || Example || Example
| FullVisitorId || String || A unique ID generated for the user, based on (but not equal to) the Client ID parameter in the API. Repeated events from the same client ID will result in the same FullVisitorId value.
|-
|-
| VisitId || Example || Example
| VisitId || Integer || Example
|-
|-
| VisitNumber || Example || Example
| VisitNumber || Integer || Example
|-
|-
| HitNumber || Example || Example
| HitNumber || Integer || Example
|-
|-
| AppName || Example || Example
| AppName || String || Example
|-
|-
| EventCategory || Example || Example
| EventCategory || String || Example
|-
|-
| EventAction || Example || Example
| EventAction || String || Example
|-
|-
| EventLabel || Example || Example
| EventLabel || String || Example
|-
|-
| EventValue || Example || Example
| EventValue || Integer || Example
|-
|-
| EventValueFP || Example || Example
| EventValueFP || String || Example
|-
|-
| OS || Example || Example
| OS || String || Example
|-
|-
| OSVersion || Example || Example
| OSVersion || String || Example
|-
|-
| Device || Example || Example
| Device || String || Example
|-
|-
| Arch || Example || Example
| Arch || String || Example
|-
|-
| AppPlatform || Example || Example
| AppPlatform || String || Example
|-
|-
| AppBuildID || Example || Example
| AppBuildID || String || Example
|}
|}


(For reference, the query used to create these views can be found at: https://github.com/dylano/metrics/tree/master/sql)
''(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)
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)
Doliver
Confirmed users
85

edits

Retrieved from "https://wiki.allizom.org/Special:MobileDiff/1136972"

Navigation menu