sc_sms_customer_metrics

In this article

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

Summary

The sc_sms_customer_metrics view is a protected view that provides summary information about a given customer and pertinent SMS marketing signup information. This view contains protected information (i.e., phone number, email), so it has been relegated to a different schema with greater protections. If you have access to this schema (“priv”), you can track when a specific customer opts in and out for SMS marketing messages and their subscription types and statuses. 

• View Grain: Phone number level
• Primary (Composite) Key(s): 
  • cuid
  • phone
• Foreign Key(s):
  • email
  • sms_opt_in_datetime/sms_opt_out_datetime

One cuid could theoretically be associated with multiple phone numbers (depending on how the cuid logic is configured). If this is the case, different recorded phone numbers in the sc_sms_customer_metrics view may be associated with the same cuid 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_sms_customer_metrics and other views. This list should not be assumed to be comprehensive. 

• I want to understand the time difference between when a customer first makes a purchase and when they sign up for SMS marketing.
• I want to see how long a customer lasts between signing up for SMS marketing and opting out of this type of messaging. Do we get an influx of unsubscriptions during a certain time?

When not to use the view

This view contains customer and phone records to track SMS marketing opt-ins and outs. As such, it does not contain information about a given customer. This view may also contain multiple phone numbers for a given customer.

This view does not necessarily contain specifics about the following:

• Campaign-related metrics (i.e., clicks, impressions, conversions)
• Fulfillment-related metrics (i.e., shipment partner, tracking number, fulfillment breakdown of constituent items)
• Item-related metrics (i.e., sku-level price, sku-level cost, sku-level discounts)
• Product-related metrics (i.e., warehouse inventory for a given product)
• Customer-related metrics (i.e., customer-aggregated sales, lifetime value, running order counts)

Return to SoundCommerce Retail Modules