sc_product_performance_metrics

In this article

• Summary
• Supported Use Cases
• When not to use the view

Summary

The sc_product_performance_metrics view is a BI-focused view that can be used for merchandising-related BI reporting and dashboards. The view summarizes merchandising metrics at the order, customer, and product levels. 

• View Grain: Order-Item level revenue/sales-transactions metrics
• Primary (Composite) Key(s): 
  • scid
  • item_uid
  • sku
• Foreign Key(s): 
  • cuid
  • order_id
  • order_date

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_product_performance_metrics. This list should not be assumed to be comprehensive. 

• What are my merchandising performance metrics for non-canceled orders aggregated to the product category level, and how do these compare across geography or time?

When not to use the view

This view is built to be optimized for BI analysis. Because of this, there are inherent limitations in the data. For example, this dataset will not include canceled orders as the view logic has been designed to exclude canceled orders. Connecting other metric-based views and tables to this view is unnecessary, as the aggregations and filtering may result in misleading results. This view should only be used with dimensional tables to enrich the output further.

Return to SoundCommerce Retail Modules