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 Title	product_title	string	The 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 Title	variants.variant_title	string	The name of the product variant as set within the main sales platform. Example values: 36 S, Titanium / Mild, Black Leather
Variant Price	variants.variant_price	string	The price of a single product variant (to the buyer). Example values: 69.99, 10, 1200
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
Vendor	vendor	string	The vendor of the product variant. Example values: Route, Canon, Corso, MyShop