In this article
Summary
The sc_products view provides information about the products your organization sells. This view can be treated similarly to a Product-Item Master (PIM) as it contains the product SKU, product title, list and sale price, associated cost, and product category information.
- View Grain: Product-level details. Each record identifies a single product.
- Primary (Composite) Key(s): sku
- Foreign Key(s): N/A
One product is defined as a unique offering with differing titles, sizes, colors, or other variations. Multiple versions of the same product will be treated as a unique product if each version is assigned its own SKU value. Typically, versions of the same product may differ by the color or size of the product and thus be assigned a different identifying value.
Supported Use Cases
The following use cases are examples and only provide a subset of all potential use cases that can be addressed with data found in sc_products and other views. This list should not be assumed to be comprehensive.
- Of the products SKUs I have identified as meeting specific criteria (i.e., most frequently bought in a first order, least likely bought in a given season), what category does that product belong to?
When not to use the view
The sc_products view is a dimensional view; in other words, it generally contains descriptive attributes. To get the most out of this view, it is beneficial to join it with other views for in-depth analysis. While some attributes can be used in calculations (i.e., cost, list_price), these attributes describe a specific product SKU.
The sc_products view does not contain specifics about the following:
- Campaign-related metrics (i.e., clicks, impressions, conversions, ad spend)
- Customer-related metrics (i.e., customer historical sales, customer CLV)
- Customer PII-related values (i.e., first and last names, emails, phone numbers, addresses)
- Order-related metrics (i.e., sales, profitability)
Return to SoundCommerce Retail Modules
Comments
0 comments
Please sign in to leave a comment.