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

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

Resources

Coming soon!