sc_sales_performance_metrics

In this article

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

Summary

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

• View Grain: Order-level transactions. 
• Primary (Composite) Key(s): 
  • scid
• Foreign Key(s): 
  • cuid
  • order_id
  • source and medium
  • campaign_id
  • order_date/first_order_date/last_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_sales_performance_metrics. This list should not be assumed to be comprehensive. 

• What are my sales performance metrics for non-canceled orders aggregated to the customer 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. As another example, this dataset will only include information about active customers. Connecting other metric-based views and tables to this view is unnecessary as the aggregations and filtering may result in misleading outputs. This view should only be used with dimensional views and tables (like sc_products) to enrich the output further.

Return to SoundCommerce Retail Modules