sc_marketing_performance_metrics

In this article

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

Summary

The sc_marketing_performance_metrics view is a BI-focused view. This means that it was created specifically to aid in generating marketing-related BI dashboards. The view summarizes marketing metrics to the customer, order, and campaign level. 

• View Grain: Each record uniquely identifies customer-level data, including order and campaign-level information. 
• Primary (Composite) Key(s): 
  • scid
• Foreign Key(s): 
  • cuid
  • order_id
  • campaign_id

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

• Marketing performance metrics considered customer-level information with no canceled orders and their related campaign information.
• The view accurately captures active orders and their corresponding ad spend.

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 Marketing Module Overview

Return to SoundCommerce Retail Modules