sc_customer_reporting_metrics

In this article

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

Summary

The sc_customer_reporting_metrics view is a BI-focused view that can be used for customer-related BI reporting and dashboards. The view summarizes customer metrics at the customer, order, and campaign levels. Core customer reporting metrics include CLV, CLS, order recency and frequency metrics, and average order value. 

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

• How does my average customer analysis metric compare across time, geography, or campaign?

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 results. This view should only be used with dimensional views and tables to enrich the output further.

Return to SoundCommerce Retail Modules