MuleSoft Connector for Google Analytics

Build 20.0.7587

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 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 the note on Establishing a Connection for a limitation with some tools. The following queries return the same results:
SELECT * FROM SiteSpeed
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. 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587