Products Table

products_table

The Products table offers a comprehensive overview of products listed within your e-commerce platform, detailing attributes such as ID, title, vendor, status, and type. By querying this table, users can gain insights into product performance, inventory management, and sales trends, enabling strategic decisions around product listings, promotions, and stock levels.

Dimensions

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

Title	ID	Type	Description
Collections	`collections`	repeated string	Collections the product belongs to, as set within the main sales platform. Example values: `Summer Gift Guide`, `Long-Sleeve Packs`, `Christmas Collection`
Product ID	`product_id`	string	The unique ID of the product as set within the main sales platform. Example value: `3891505496131`
Product Status	`product_status`	string	The status of the product. Example values: `active`, `draft`, `archived`
Product Tags	`product_tags`	repeated string	Tags associated with the product, assigned by the seller in the main sales platform. Example values: `3-pack`, `Sale`, `discount_eligible`
Product Name	`product_name`	string	The name (or title) of the product as set within the main sales platform. Example values: `Green Soft Socks 3-Pack`, `Paring Knife Travel Case`, `Gift Subscription`
Product Type	`product_type`	string	The product type as set within the main sales platform. Example values: `Jackets`, `Coffee Mugs`, `Books`
Product Variants	`variants`	record repeated	Details about the product variants associated with the order.
Variant ID	`variants.variant_id`	string	The unique ID of the product variant as set within the main sales platform. Example value: `47095335813393`
Variant Name	`variants.variant_name`	string	The name (or title) of the product variant as set within the main sales platform. Example values: `36 S`, `Titanium / Mild`, `Black Leather`
Variant SKU	`variants.sku`	string	The SKU (Stock Keeping Unit) for the product variant as set within the main sales platform. Example values: `GP-BACK-02`, `A02630`, `POP200NAVY`
Variant Price	`variants.variant_price`	numeric	The price of a single product variant (to the buyer). Example values: `69.99`, `10`, `1200`
Variant Inventory Quantity	`variants.variant_inventory_quantity`	numeric	The number of items in stock for the product variant. Example values: `100`, `50`, `0`
Vendor	`vendor`	string	The vendor of the product variant. Example values: `Route`, `Canon`, `Corso`, `MyShop`

Measures

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

Title	ID	Type	Description
Product Inventory Quantity	`product_inventory_quantity`	numeric	The number of items in stock for the product. Example values: `100`, `50`, `0`

Title

Type

Description

Product Inventory Quantity

product_inventory_quantity

numeric

The number of items in stock for the product.

Example values: 100, 50, 0

Updated 18 days ago