SiteSpeed

Columns

Name

Type

Dimension

DefaultMetric

DefaultDimension

Description

Date

Date

True

The date of the session formatted as YYYYMMDD.

Year

Integer

True

The year of the session. A four-digit year from 2005 to the current year.

Month

Integer

True

The month of the session. An integer from 01 to 12.

Week

Integer

True

The week of the session. A number from 01 to 53. Each week starts on Sunday.

Day

Integer

True

The day of the month. A number from 01 to 31.

Hour

Integer

True

An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.

Country

String

True

The country of users, derived from IP addresses.

City

String

True

The cities of property users, derived from IP addresses.

Browser

String

True

True

The names of browsers used by users to your website. For example, Internet Explorer or Firefox.

DeviceCategory

String

True

The type of device: desktop, tablet, or mobile.

PagePath

String

True

A page on your website specified by path and/or query parameters. Use in conjunction with host name to get the full URL of the page.

PageTitle

String

True

The title of a page. Keep in mind that multiple pages might have the same PageTitle.

AvgPageLoadTime

Double

False

True

The average amount of time in seconds it takes for pages from the sample set to load, from initiation of the page view (e.g., a click on a page link) to load completion in the browser.

AvgRedirectionTime

Double

False

True

The average amount of time in seconds spent in redirects before fetching this page. If there are no redirects, the value for this metric is expected to be 0.

AvgDomainLookupTime

Double

False

True

The average amount of time in seconds spent in DNS lookup for this page.

AvgServerConnectionTime

Double

False

True

The average amount of time in seconds spent in establishing the TCP connection for this page.

AvgServerResponseTime

Double

False

True

The average amount of time in seconds your server takes to respond to a user request, including the network time from the location of the user to your server.

AvgPageDownloadTime

Double

False

True

The average amount of time in seconds to download this page.

PageLoadTime

Integer

False

The amount of time (in milliseconds) it takes for pages from the sample set to load from initiation of the page view (e.g., a click on a page link) to load completion in the browser.

PageLoadSample

Integer

False

The sample set, or count of page views used to calculate the average page load time.

DomainLookupTime

Integer

False

The total amount of time (in milliseconds) spent in DNS lookup for this page among all samples.

PageDownloadTime

Integer

False

The total amount of time (in milliseconds) to download this page among all samples.

RedirectionTime

Integer

False

The total amount of time (in milliseconds) spent in redirects before fetching this page among all samples. If there are no redirects, the value for this metric is expected to be 0.

ServerConnectionTime

Integer

False

The total amount of time (in milliseconds) spent in establishing the TCP connection for this page among all samples.

ServerResponseTime

Integer

False

The total amount of time (in milliseconds) your server takes to respond to a user request among all samples, including the network time from the location of the user to your server.

SpeedMetricsSample

Integer

False

The sample set, or count, of page views used to calculate the averages for site speed metrics. This metric is used in all site speed average calculations.

DomInteractiveTime

Integer

False

The time the browser takes (in milliseconds) to parse the document (DOMInteractive), including the network time from the location of the user to your server. At this time, the user can interact with the Document Object Model even though it is not fully loaded.

DomContentLoadedTime

Integer

False

The time the browser takes (in milliseconds) to parse the document and execute deferred and parser-inserted scripts (DOMContentLoaded), including the network time from the location of the user to your server. Parsing of the document is finished and the Document Object Model is ready, but referenced style sheets, images, and subframes may not be finished loading. This event is often the starting point for JavaScript framework execution; e.g., JQuery's onready() callback.

DomLatencyMetricsSample

Integer

False

The sample set, or count, of page views used to calculate the averages for site speed DOM metrics. This metric is used in the AvgDomContentLoadedTime and AvgDomInteractiveTime calculations.

AvgDomInteractiveTime

Double

False

The average time in seconds, including the network time from the location of the user to your server, that it takes the browser to parse the document and execute deferred and parser-inserted scripts.

AvgDomContentLoadedTime

Double

False

The average time in seconds it takes the browser to parse the document.

StartDate

String

Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

EndDate

String

End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

Dimensions

String

A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.

Metrics

String

A comma-separated list of metrics to retrieve in addition to the columns defined in the schema.

CohortTypes

String

Available only when using the V4 API. A comma-separated list of cohort types. The default value is FIRST_VISIT_DATE

CohortStartDates

Date

Available only when using the V4 API. A comma-separated list of cohort start dates.

CohortEndDates

Date

Available only when using the V4 API. A comma-separated list of cohort end dates.

SamplesReadCounts

String

Comma separated list of samples read counts when the response data is sampled.

SamplingSpaceSizes

String

Comma separated list of samples space sizes counts when the response data is sampled.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Segments

String

Segments the data returned for your request. Either a SegmentId or a custom segment.

Profile

String

The Profile ID or website URL to retrieve data from.

Last updated