sc_email_customer_metrics

In this article

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

Summary

The sc_email_customer_metrics view is a protected view that provides summary information about a given customer and pertinent email 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 can access 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: Email level
• Primary (Composite) Key(s): 
  • cuid
  • email
• Foreign Key(s): 
  • phone
  • email_opt_in/email_opt_out

One cuid could theoretically be associated with multiple emails (depending on how the cuid logic is configured). If this is the case, different recorded emails in the sc_email_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_email_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 email marketing.
• I want to see how long a customer lasts between signing up for email 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 email 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