The Web Analytics table tracks user interactions on your website, including page views, session lengths, and actions like adding items to carts or completing purchases. Querying this table helps uncover patterns in visitor behavior, website performance, and the effectiveness of marketing strategies, guiding optimizations for better engagement and conversion rates.

📘

Note

event_date is a required field for queries on this table.

A session in Triple Whale is defined as a visit on your website from a Direct, Referral, or UTM source. Sessions are unique per visitor and per tab. A new session starts after 30 minutes of inactivity, or when navigating to a URL with different UTM parameters. Learn more

Dimensions

Dimensions are immutable properties that can be used for grouping data.

NameTypeDescriptionSource
event_datedateThe date the session started. Based on the time zone of the shop at the start time of the session.Triple Pixel
event_date.daydateThe day the session started. Derived from event_date.Triple Pixel
event_date.weekdateThe Sunday of the week during which the session started. Derived from event_date.Triple Pixel
event_date.monthdateThe month during which the session started. Derived from event_date.Triple Pixel
event_date.quarterdateThe first month of the quarter during which the session started. Derived from event_date.Triple Pixel
event_date.yeardateThe year during which the session started. Derived from event_date.Triple Pixel
event_hourstringThe hour of the day the session started, according to a 24-hour clock. Based on the time zone of the shop at the start time of the session.

Example values: 07, 16, 21
Triple Pixel
landing_pagestringThe URL path (without query parameters) of the page the visitor landed after clicking on an ad or link, indicating the first page viewed in a session.

Example value: /myshop/collections/green_sweater
Triple Pixel
devicestringThe type of device used by the visitor for the session.

Example values: desktop, tablet, mobile, wearable
Triple Pixel
browserstringThe web browser used by the visitor for the session.

Example values: Chrome WebView, Opera Touch, Huawei Browser
Triple Pixel
countrystringThe country from which the session originated.

Example values: Canada, United States, Australia
Triple Pixel
citystringThe city from which the session originated.

Example values: Sydney, Manchester, New York
Triple Pixel

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

NameTypeDescriptionSource
order_revenuenumericThe total order revenue generated. By default shown in the shop's currency.Triple Pixel, Shopify, Amazon
orders_quantitynumericThe total number of orders placed.Triple Pixel, Shopify, Amazon
session_page_viewsnumericThe count of page views.Triple Pixel
time_on_sitenumericTotal time spent on the site, measured in seconds.Triple Pixel
bouncesnumericThe number of single-page sessions, where the visitor left the site after a single page view.Triple Pixel
sessionsnumericTotal number of online store sessions. Note that Triple Whale defines and tracks sessions differently from Shopify. Learn moreTriple Pixel
new_usersnumericThe count of first-time site visitors, as detected by Triple Pixel's attribution service.Triple Pixel
add_to_cartsnumericThe number of times items were added to the shopping cart.Triple Pixel