-
Notifications
You must be signed in to change notification settings - Fork 2
/
index.html.md.erb
79 lines (72 loc) · 2.71 KB
/
index.html.md.erb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
---
title: GOV.UK Universal Analytics flattened tables
weight: 5
last_reviewed_on: 2024-05-23
review_in: 6 months
---
# GOV.UK Universal Analytics flattened tables
The UA flattened tables contain [GOV.UK Universal Analytics](/data-sources/ga/ua/) data processed into a flat format.
## Access
Everyone with a @digital.cabinet-office.gov.uk account (all GDS staff) has access to the data.
### Location
This is stored in BigQuery in the dataset `govuk-bigquery-analytics.FlattenedDailyData`.
Each daily table is sharded in the format flattened_daily_ga_data_YYYYMMDD.
For more information on our Google Cloud Platform projects, see our [GCP project documentation](/gcp/#universal-analytics).
## Schema
| field name | type | mode |
| --- | --- | --- |
| name | STRING | NULLABLE |
| visitId | INTEGER | NULLABLE |
| visitNumber | INTEGER | NULLABLE |
| visitorid | INTEGER | NULLABLE |
| visitstarttime | INTEGER | NULLABLE |
| date | STRING | NULLABLE |
| hitNumber | INTEGER | NULLABLE |
| time | INTEGER | NULLABLE |
| hour | INTEGER | NULLABLE |
| minute | INTEGER | NULLABLE |
| VisitStartTimestamp | TIMESTAMP | NULLABLE |
| Seconds | FLOAT | NULLABLE |
| Hit_TimeStamp | TIMESTAMP | NULLABLE |
| fullvisitorid | STRING | NULLABLE |
| userid | STRING | NULLABLE |
| clientid | STRING | NULLABLE |
| channelGrouping | STRING | NULLABLE |
| socialEngagementType | STRING | NULLABLE |
| visits | INTEGER | NULLABLE |
| hits | INTEGER | NULLABLE |
| timeonsite | INTEGER | NULLABLE |
| bounces | INTEGER | NULLABLE |
| transactions | INTEGER | NULLABLE |
| transactionrevenue | INTEGER | NULLABLE |
| newVisits | INTEGER | NULLABLE |
| screenviews | INTEGER | NULLABLE |
| uniquescreenviews | INTEGER | NULLABLE |
| timeonscreen | INTEGER | NULLABLE |
| totaltransactionrevenue | INTEGER | NULLABLE |
| sessionqualitydim | INTEGER | NULLABLE |
| referralPath | STRING | NULLABLE |
| campaign | STRING | NULLABLE |
| source | STRING | NULLABLE |
| medium | STRING | NULLABLE |
| keyword | STRING | NULLABLE |
| adContent | STRING | NULLABLE |
| istruedirect | BOOLEAN | NULLABLE |
| campaignCode | STRING | NULLABLE |
| browser | STRING | NULLABLE |
| browserVersion | STRING | NULLABLE |
| browserSize | STRING | NULLABLE |
| operatingSystem | STRING | NULLABLE |
| operatingSystemVersion | STRING | NULLABLE |
| isMobile | BOOLEAN | NULLABLE |
| mobileDeviceBranding | STRING | NULLABLE |
| mobileDeviceModel | STRING | NULLABLE |
| mobileInputSelector | STRING | NULLABLE |
| mobileDeviceInfo | STRING | NULLABLE |
| mobileDeviceMarketingName | STRING | NULLABLE |
| flashVersion | STRING | NULLABLE |
| javaEnabled | BOOLEAN | NULLABLE |
| language | STRING | NULLABLE |
| screenColors | STRING | NULLABLE |
| screenResolution | STRING | NULLABLE |
## Retention