Retrieves internal Site Speed data.

Table Specific Information

Select

Google Analytics only allows up to 10 Metrics and 7 Dimensions in a single query. Therefore, when issuing a query that selects all columns, only the default Metric columns will be selected for tables with more than 10 Metrics. The default Dimensions will be used unless you explicitly select other dimension columns. The following query uses PagePath instead of the default Browser dimension:

SELECT PagePath, AvgPageLoadTime, AvgRedirectionTime, AvgDomainLookupTime, AvgServerConnectionTime, AvgServerResponseTime, AvgPageDownloadTime FROM SiteSpeed

Filters can also be used in the WHERE clause. Dimension fields support the =, !=, LIKE, and NOT LIKE operators. Metric fields support =, !=, >, >=, <, and <= operators. This query will return Page Title for all pages with an average load time of more than 1.5 on mobile devices:

SELECT DeviceCategory, PageTitle, AvgPageLoadTime FROM SiteSpeed WHERE AvgPageLoadTime > 1.5 AND DeviceCategory='mobile'

All reports in Google Analytics must cover a specific date range. The default behavior is to pull the last month of data if the StartDate and EndDate inputs are left unset. To override this behavior, the values can be set directly in the query. For example:

SELECT * FROM SiteSpeed WHERE StartDate = '90daysAgo' AND EndDate = 'Today'

Because there are more than 10 Metrics available for the SiteSpeed table, a query that selects all columns only returns the default Metrics for this table (see columns marked as default Metrics below). If you need to select other Metrics, select them explicitly instead of using '*'. The default dimension for the table will be used unless another dimension is specified in the select columns, the DefaultFilter, or the Dimensions column in the WHERE clause. See Retrieving Google Analytics Data for more information about SELECT * queries. The following queries return the same results:

SELECT Browser, AvgPageLoadTime, AvgRedirectionTime, AvgDomainLookupTime, AvgServerConnectionTime, AvgServerResponseTime, AvgPageDownloadTime FROM 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. Remember 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.
Profile	Integer				Profile ID or website URL to retrieve data from.

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.