Columns

The OVERVIEW view contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type Notes
​_BROWSER String(255) The name of users' browsers, for example, Internet Explorer or Firefox.
​_CITY String(255) Users' city, derived from their IP addresses or Geographical IDs.
​_COUNTRY String(255) Users' country, derived from their IP addresses or Geographical IDs.
​_DATE Date The date of the session formatted as YYYYMMDD.
​_LANGUAGE String(255) The language, in ISO-639 code format (e.g., en-gb for British English), provided by the HTTP Request for the browser.
​_NETWORKLOCATION String(255) The names of the service providers used to reach the property. For example, if most users of the website come via the major cable internet service providers, its value will be these service providers' names.
​_OPERATINGSYSTEM String(255) Users' operating system, for example, Windows, Linux, Macintosh, or iOS.
​_SCREENRESOLUTION String(255) Resolution of users' screens, for example, 1024x738.
AVGSESSIONDURATION Time The average duration (in seconds) of users' sessions.
BOUNCERATE Percent The percentage of single-page session (i.e., session in which the person left the property from the first page).
ENDDATE Date
PAGEVIEWS Integer The total number of pageviews for the property.
PAGEVIEWSPERSESSION Float The average number of pages viewed during a session, including repeated views of a single page.
PERCENTNEWSESSIONS Percent The percentage of sessions by users who had never visited the property before.
SEGMENTID String(255)
SESSIONS Integer The total number of sessions.
STARTDATE Date
USERS Integer The total number of users for the requested time period.
VIEWID String(255)