GOV.UK Universal Analytics flattened tables
The UA flattened tables contain GOV.UK Universal Analytics 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.
Schema
| field name | type | mode | description | | — | — | — | — | | name | STRING | NULLABLE | This field is deprecated | | visitId | INTEGER | NULLABLE | An identifier for the session. This is only unique to the user. For a completely unique ID, you should use a combination of fullVisitorId and visitId | | visitNumber | INTEGER | NULLABLE | The session number for this user. If this is the first session, then this is set to 1 | | visitorid | INTEGER | NULLABLE | This field is deprecated. Use “fullVisitorId” instead | | visitstarttime | INTEGER | NULLABLE | The visit start time, expressed as Unix time | | date | STRING | NULLABLE | The date of the session in YYYYMMDD format | | hitNumber | INTEGER | NULLABLE | The sequenced hit number. For the first hit of each session, this is set to 1 | | time | INTEGER | NULLABLE | The number of milliseconds after the visitStartTime when this hit was registered. The first hit has a time of 0 | | hour | INTEGER | NULLABLE | The hour in which the hit occurred (0 to 23) | | minute | INTEGER | NULLABLE | The minute in which the hit occurred (0 to 59) | | VisitStartTimestamp | TIMESTAMP | NULLABLE | The visit start time, expressed as a timestamp (UTC) | | Seconds | FLOAT | NULLABLE | The number of seconds after the visitStartTime when this hit was registered | | Hit_TimeStamp | TIMESTAMP | NULLABLE | Time time when this hit was registered, expressed as a timestamp (UTC) | | fullvisitorid | STRING | NULLABLE | The unique visitor ID | | userid | STRING | NULLABLE | This field is deprecated and returns a null value. Use “fullVisitorId” instead | | clientid | STRING | NULLABLE | Unhashed version of the Client ID for a given user associated with any given visit/session | | channelGrouping | STRING | NULLABLE | The Default Channel Group associated with the user’s session | | socialEngagementType | STRING | NULLABLE | Engagement type, either “Socially Engaged” or “Not Socially Engaged” | | visits | INTEGER | NULLABLE | The number of sessions (for convenience). This value is 1 for sessions with interaction events. The value is null if there are no interaction events in the session | | hits | INTEGER | NULLABLE | Total number of hits within the session | | timeonsite | INTEGER | NULLABLE | Total time of the session expressed in seconds | | bounces | INTEGER | NULLABLE | Total bounces (for convenience). For a bounced session, the value is 1, otherwise it is null | | transactions | INTEGER | NULLABLE | Total number of ecommerce transactions within the session | | transactionrevenue | INTEGER | NULLABLE | This field is deprecated and returns a null value. Use “totaltransactionrevenue” instead | | newVisits | INTEGER | NULLABLE | Total number of new users in session (for convenience). If this is the first visit, this value is 1, otherwise it is null | | screenviews | INTEGER | NULLABLE | Total number of screenviews within the session (screen metrics are null for GOV.UK data, refer to page metrics instead) | | uniquescreenviews | INTEGER | NULLABLE | Total number of unique screenviews within the session (screen metrics are null for GOV.UK data, refer to page metrics instead) | | timeonscreen | INTEGER | NULLABLE | The total time on screen in seconds (screen metrics are null for GOV.UK data, refer to page metrics instead) | | totaltransactionrevenue | INTEGER | NULLABLE | Total transaction revenue, expressed as the value passed to Analytics multiplied by 10^6 | | sessionqualitydim | INTEGER | NULLABLE | An estimate of how close a particular session was to transacting, ranging from 1 to 100, calculated for each session. For our data this is always 0 | | referralPath | STRING | NULLABLE | If ‘medium’ is “referral”, then this returns the path of the referrer. (The host name of the referrer is in ‘source’) | | campaign | STRING | NULLABLE | The campaign value. Usually set by the utm_campaign URL parameter | | source | STRING | NULLABLE | The traffic source, i.e. the name of a search engine, the referring hostname, or a value of the utm_source URL parameter | | medium | STRING | NULLABLE | The medium of the traffic source, i.e. “organic”, “cpc”, “referral”, or the value of the utm_medium URL parameter | | keyword | STRING | NULLABLE | If this was a search results page, this is the keyword entered | | adContent | STRING | NULLABLE | The ad content of the traffic source. Can be set by the utm_content URL parameter | | istruedirect | BOOLEAN | NULLABLE | True if the source of the session was Direct, otherwise null | | campaignCode | STRING | NULLABLE | Value of the utm_id campaign tracking parameter, used for manual campaign tracking | | browser | STRING | NULLABLE | The browser used (e.g., “Chrome” or “Firefox”) | | browserVersion | STRING | NULLABLE | The version of the browser used | | browserSize | STRING | NULLABLE | The viewport size of users’ browsers. This captures the initial dimensions of the viewport in pixels | | operatingSystem | STRING | NULLABLE | The operating system of the device (e.g. “Windows”) | | operatingSystemVersion | STRING | NULLABLE | The version of the operating system | | isMobile | BOOLEAN | NULLABLE | If the user is on a mobile device, this value is true, otherwise false | | mobileDeviceBranding | STRING | NULLABLE | The brand or manufacturer of the device | | mobileDeviceModel | STRING | NULLABLE | The mobile device model | | mobileInputSelector | STRING | NULLABLE | Selector (e.g., touchscreen, joystick, clickwheel, stylus) used on the mobile device) | | mobileDeviceInfo | STRING | NULLABLE | The branding, model, and marketing name used to identify the mobile device | | mobileDeviceMarketingName | STRING | NULLABLE | The marketing name used for the mobile device | | flashVersion | STRING | NULLABLE | The version of the Adobe Flash plugin that is installed on the browser | | javaEnabled | BOOLEAN | NULLABLE | Whether or not Java is enabled in the browser | | language | STRING | NULLABLE | The language the device is set to use. Expressed as the IETF language code | | screenColors | STRING | NULLABLE | Number of colors supported by the display, expressed as the bit-depth (e.g., “8-bit”, “24-bit”, etc.) | | screenResolution | STRING | NULLABLE | The resolution of the device’s screen, expressed in pixel width x height (e.g., “800x600”) |