The Products table provides the product catalog with attributes like name, type, vendor, status, and variants. One row per product. Sourced from the connected sales platform.

📋

Table Guide

What You Can Answer With This Table

• Which products or variants are out of stock or inactive? — filter where product_inventory_quantity = 0 or variants.variant_inventory_quantity = 0, group by product_status
• What products does a specific vendor supply? — filter or group by vendor

Before You Query

• This table is not time-series. No event_date filter is needed.

Key Relationships

Table	Join Key	Use This Join To
Product Analytics	product_id	Measure catalog product performance over time with revenue, orders, and units sold

When to Use a Different Table

• Use Product Analytics table when you need product sales performance over time, such as revenue, units sold, or orders by product. The Products table is for catalog attributes.
• Use Orders table when you need product data in the context of individual orders. The Products table is for the product catalog, not order-line detail.

View the full Triple Whale Data Ontology →

---

Dimensions

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

Measures

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