SiteSpeed
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 SiteSpeedFilters 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 Google アナリティクスデータの取得 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
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Segments | String | Segments the data returned for your request. Either a SegmentId or a custom segment. |