Product View

The Product view provides dimensions and measures for the product data model.

The measures calculated by this view are:

NameMeasure TypeDescription
Product CountCountThe count of all products.

The dimensions included in this view are:

NameData TypeDescription
Content Locale CodeStringThe two character locale code, per the country code provided.
Master Catalog IDNumberInternal unique identifier for the master catalog to which this product belongs.
Manufacturer Part NumberStringThe manufacturer's part number for the product.
Product CodeStringThe unique user-defined identifier for a product.
Product Created DateDatetimeThe timestamp of the date and time the product record was created.
Product IDNumberInternal unique identifier of the product.
Product NameStringThe user supplied name of the product.
Product TypeStringUsed to classify different types of products such as "Standard" or "Gift Certificate."
Product Type IDNumberThe internal unique identifier for the product type.
Product Updated DateDatetimeThe timestamp of the date and time the product record was most recently updated.
Root Product IDNumberThe root of the product's unique identifier or the product code.
UPCStringThe universal product code (UPC) is the barcode defined for the product. The UPC is unique across all sales channels.