Columns

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

Column Name Data Type Notes
​_DATE Date The date of the session formatted as YYYYMMDD.
​_DAY String(255) The day of the month, a two-digit number from 01 to 31.
​_DAYOFWEEK String(255) Day of the week, a one-digit number from 0 (Sunday) to 6 (Saturday).
​_DAYOFWEEKNAME String(255) Name (in English) of the day of the week.
​_HOUR String(255) A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. If the timezone follows daylight savings time, there will be an apparent bump in the number of sessions during the changeover hour (e.g., between 1:00 and 2:00) for the day per year when that hour repeats. A corresponding hour with zero sessions will occur at the opposite changeover. (Google Analytics does not track user time more precisely than hours.)
​_MONTH String(255) Month of the session, a two digit integer from 01 to 12.
​_WEEK String(255) The week of the session, a two-digit number from 01 to 53. Each week starts on Sunday.
​_YEAR String(255) The year of the session, a four-digit year from 2005 to the current year.
​_YEARMONTH String(255) Combined values of ga:year and ga:month.
DOMAINLOOKUPTIME Integer The total time (in milliseconds) all samples spent in DNS lookup for this page.
ENDDATE Date
PAGEDOWNLOADTIME Integer The total time (in milliseconds) to download this page among all samples.
PAGELOADSAMPLE Integer The sample set (or count) of pageviews used to calculate the average page load time.
PAGELOADTIME Integer Total time (in milliseconds), from pageview initiation (e.g., a click on a page link) to page load completion in the browser, the pages in the sample set take to load.
PAGEVIEWS Integer The total number of pageviews for the property.
REDIRECTIONTIME Integer The total time (in milliseconds) all samples spent in redirects before fetching this page. If there are no redirects, this is 0.
SEGMENTID String(255)
SERVERCONNECTIONTIME Integer Total time (in milliseconds) all samples spent in establishing a TCP connection to this page.
SERVERRESPONSETIME Integer The total time (in milliseconds) the site's server takes to respond to users' requests among all samples; this includes the network time from users' locations to the server.
SPEEDMETRICSSAMPLE Integer The sample set (or count) of pageviews used to calculate the averages of site speed metrics. This metric is used in all site speed average calculations, including avgDomainLookupTime, avgPageDownloadTime, avgRedirectionTime, avgServerConnectionTime, and avgServerResponseTime.
STARTDATE Date
VIEWID String(255)