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.

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

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.

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