Tables

Table of Contents

Overview

The RUM Archive specifies two types of tables:

  • page_loads: Browser page load experiences
  • resources: Third party resource fetches

All tables are partitioned by the DATE column to assist with reducing the amount of data queried. We suggest you limit all queries to a specific date (or date range) to limit your BigQuery query costs.

Page Loads

Page Loads represent browser navigation experiences, whether from a traditional Multi-Page App (MPA) or Single-Page App (SPA). SPA navigations can be broken down into both Hard Navigations (the first navigation to the page) and Soft Navigations (in-page route changes).

Data is aggregated for each date.

Schema

CREATE TABLE `%PROJECT%.%DATASET%.%PREFIX%_page_loads`
(
SOURCE STRING,
SITE STRING,
DATE DATE,
DEVICETYPE STRING,
USERAGENTFAMILY STRING,
USERAGENTVERSION STRING,
DEVICEMODEL STRING,
OS STRING,
OSVERSION STRING,
BEACONTYPE STRING,
COUNTRY STRING,
VISIBILITYSTATE STRING,
NAVIGATIONTYPE STRING,
PROTOCOL STRING,
IPVERSION STRING,
LANDINGPAGE BOOLEAN,
BEACONS INTEGER,
PLTHISTOGRAM STRING,
PLTAVG FLOAT64,
PLTSUMLN FLOAT64,
PLTCOUNT INTEGER,
DNSHISTOGRAM STRING,
DNSAVG FLOAT64,
DNSSUMLN FLOAT64,
DNSCOUNT INTEGER,
TCPHISTOGRAM STRING,
TCPAVG FLOAT64,
TCPSUMLN FLOAT64,
TCPCOUNT INTEGER,
TLSHISTOGRAM STRING,
TLSAVG FLOAT64,
TLSSUMLN FLOAT64,
TLSCOUNT INTEGER,
TTFBHISTOGRAM STRING,
TTFBAVG FLOAT64,
TTFBSUMLN FLOAT64,
TTFBCOUNT INTEGER,
FCPHISTOGRAM STRING,
FCPAVG FLOAT64,
FCPSUMLN FLOAT64,
FCPCOUNT INTEGER,
LCPHISTOGRAM STRING,
LCPAVG FLOAT64,
LCPSUMLN FLOAT64,
LCPCOUNT INTEGER,
RTTHISTOGRAM STRING,
RTTAVG FLOAT64,
RTTSUMLN FLOAT64,
RTTCOUNT INTEGER,
RAGECLICKSHISTOGRAM STRING,
RAGECLICKSAVG FLOAT64,
RAGECLICKSSUMLN FLOAT64,
RAGECLICKSCOUNT INTEGER,
CLSHISTOGRAM STRING,
CLSAVG FLOAT64,
CLSSUMLN FLOAT64,
CLSCOUNT INTEGER,
FIDHISTOGRAM STRING,
FIDAVG FLOAT64,
FIDSUMLN FLOAT64,
FIDCOUNT INTEGER,
TBTHISTOGRAM STRING,
TBTAVG FLOAT64,
TBTSUMLN FLOAT64,
TBTCOUNT INTEGER,
TTIHISTOGRAM STRING,
TTIAVG FLOAT64,
TTISUMLN FLOAT64,
TTICOUNT INTEGER,
REDIRECTHISTOGRAM STRING,
REDIRECTAVG FLOAT64,
REDIRECTSUMLN FLOAT64,
REDIRECTCOUNT INTEGER,
INPHISTOGRAM STRING,
INPAVG FLOAT64,
INPSUMLN FLOAT64,
INPCOUNT INTEGER
) PARTITION BY DATE
;

Dimensions

The dimensions below are characteristics of the Page Load experience.

The Cardinality column is an estimate from the mPulse dataset.

Dimension Description Example values Cardinality
SOURCE Source of the data, e.g. provider mpulse 1
SITE Site being measured example.com (multiple) 1
DATE Date of aggregation 2022-01-01 (grows each day)
DEVICETYPE Device type Mobile Desktop Tablet 3
USERAGENTFAMILY User Agent family Chrome Mobile Safari ~100
USERAGENTVERSION User Agent major version 124 12 (Safari: 17.4) ~350
DEVICEMODEL Device model Apple iPhone Samsung Android 11 ~2000
OS Operating System family Android OS Windows iOS ~30
OSVERSION Operation System major version 10 15 (iOS: 17.4) ~75
BEACONTYPE Beacon type page view spa hard spa bfcache 4
COUNTRY Country US GB GB ~230
VISIBILITYSTATE Visibility state visible hidden partial 3
NAVIGATIONTYPE Navigation type navigate back forward reload 3
PROTOCOL HTTP protocol h2 http/1.1 h3 ~10
IPVERSION IP version IPv4 IPv6 3
LANDINGPAGE Landing page true false 3

Timers and Metrics

The BEACONS column contains how many Page Loads that row represents.

Each Timer or Metric has 4 columns:

  • *HISTOGRAM (JSON): Histogram
  • *AVG (FLOAT64): Weighted average
  • *SUMLN (FLOAT64): Sum of the natural logarithms
  • *COUNT (INTEGER): Number of measurements taken for this timer or metric
Timer or Metric Column Name Prefix
Page Load Time PLT
DNS DNS
TCP TCP
TLS TLS
Time to First Byte TTFB
First Contentful Paint FCP
Largest Contentful Paint LCP
Round Trip Time RTT
Rage Clicks RAGECLICKS
Cumulative Layout Shift (*1000) CLS
First Input Delay FID
Interaction to Next Paint INP
Total Blocking Time TBT
Time to Interactive TTI
Redirect REDIRECT

Third-Party Resources

Third-Party Resources represent URLs (such as JavaScript, CSS, images, etc) have been seen across multiple websites and are third-party components such as libraries, analytics scripts, widgets, fonts, etc.

Data is aggregated for each date.

Schema

CREATE TABLE `%PROJECT%.%DATASET%.%PREFIX%_resources`
(
SOURCE STRING,
SITE STRING,
DATE DATE,
URLGROUP STRING,
URL STRING,
DEVICETYPE STRING,
USERAGENTFAMILY STRING,
USERAGENTVERSION STRING,
DEVICEMODEL STRING,
OS STRING,
OSVERSION STRING,
BEACONTYPE STRING,
COUNTRY STRING,
PROTOCOL STRING,
INITIATORTYPE STRING,
ASSETTYPE STRING,
FETCHES INTEGER,
TOTALHISTOGRAM STRING,
TOTALAVG FLOAT64,
TOTALSUMLN FLOAT64,
TOTALCOUNT INTEGER,
DNSHISTOGRAM STRING,
DNSAVG FLOAT64,
DNSSUMLN FLOAT64,
DNSCOUNT INTEGER,
TCPHISTOGRAM STRING,
TCPAVG FLOAT64,
TCPSUMLN FLOAT64,
TCPCOUNT INTEGER,
TLSHISTOGRAM STRING,
TLSAVG FLOAT64,
TLSSUMLN FLOAT64,
TLSCOUNT INTEGER,
REQUESTHISTOGRAM STRING,
REQUESTAVG FLOAT64,
REQUESTSUMLN FLOAT64,
REQUESTCOUNT INTEGER,
RESPONSEHISTOGRAM STRING,
RESPONSEAVG FLOAT64,
RESPONSESUMLN FLOAT64,
RESPONSECOUNT INTEGER,
TTFBHISTOGRAM STRING,
TTFBAVG FLOAT64,
TTFBSUMLN FLOAT64,
TTFBCOUNT INTEGER,
DOWNLOADHISTOGRAM STRING,
DOWNLOADAVG FLOAT64,
DOWNLOADSUMLN FLOAT64,
DOWNLOADCOUNT INTEGER,
REDIRECTHISTOGRAM STRING,
REDIRECTAVG FLOAT64,
REDIRECTSUMLN FLOAT64,
REDIRECTCOUNT INTEGER,
CACHEDHISTOGRAM STRING,
CACHEDAVG FLOAT64,
CACHEDSUMLN FLOAT64,
CACHEDCOUNT INTEGER,
ENCODEDSIZEHISTOGRAM STRING,
ENCODEDSIZEAVG FLOAT64,
ENCODEDSIZESUMLN FLOAT64,
ENCODEDSIZECOUNT INTEGER,
DECODEDSIZEHISTOGRAM STRING,
DECODEDSIZEAVG FLOAT64,
DECODEDSIZESUMLN FLOAT64,
DECODEDSIZECOUNT INTEGER,
TRANSFERSIZEHISTOGRAM STRING,
TRANSFERSIZEAVG FLOAT64,
TRANSFERSIZESUMLN FLOAT64,
TRANSFERSIZECOUNT INTEGER
) PARTITION BY DATE
;

Dimensions

The dimensions below are characteristics of the Page Load experience.

The Cardinality column is an estimate from the mPulse dataset.

Dimension Description Example values Cardinality
SOURCE Source of the data, e.g. provider mpulse 1
SITE Site being measured example.com (multiple) 1
DATE Date of aggregation 2022-01-01 (grows each day)
URLGROUP Group the URL belongs to https://thirdparty.com/analytics/*.js ~20
URL Third-Party Resource URL https://thirdparty.com/analytics/v1.js < 1000
DEVICETYPE Device type Mobile Desktop Tablet 3
USERAGENTFAMILY User Agent family Chrome Mobile Safari ~100
USERAGENTVERSION User Agent major version 124 12 (Safari: 17.4) ~350
DEVICEMODEL Device model Apple iPhone Samsung Android 11 ~2000
OS Operating System family Android OS Windows iOS ~30
OSVERSION Operation System major version 10 15 (iOS: 17.4) ~75
BEACONTYPE Beacon type page view spa hard spa bfcache 4
COUNTRY Country US GB GB ~230
PROTOCOL HTTP protocol h2 http/1.1 h3 ~10
INITIATORTYPE Initiator Type fetch link css iframe img xmlhttprequest beacon script other 9
ASSETTYPE mPulse Asset Type img font html js bcn xhr css other 8

Timers and Metrics

The FETCHES column contains how many resource fetches that row represents.

Each Timer or Metric has 4 columns:

  • *HISTOGRAM (JSON): Histogram
  • *AVG (FLOAT64): Weighted average
  • *SUMLN (FLOAT64): Sum of the natural logarithms
  • *COUNT (INTEGER): Number of measurements taken for this timer or metric
Timer or Metric Column Name Prefix
Total Time TOTAL
DNS Time DNS
TCP Time TCP
TLS Time TLS
Request Time REQUEST
Response Time RESPONSE
Time to First Byte TTFB
Download Time DOWNLOAD
Redirect Time REDIRECT
Cached CACHED
Encoded Body Size ENCODEDSIZE
Decoded Body Size DECODEDSIZE
Transfer Size TRANSFERSIZE