sc_customers

In this article

• Summary
• Supported Use Cases
• Identity Resolution in SoundCommerce
• When not to use the view

Summary

The sc_customers view provides anonymized information about customers who have made purchases. In this view, you will find aggregated information for a given customer, including historical sales, projected customer lifetime value, first and last order date, days between orders, etc. 

• View Grain: Customer-level details. Each record identifies a single customer.
• Primary (Composite) Key(s):
  • cuid
• Foreign Key(s): N/A

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_customers and other views. This list should not be assumed to be comprehensive. 

• I want to identify customers that meet certain criteria (i.e., high value, long amount of time between orders, made their first purchase in a given category) and see what their overall lifetime value is.
• I want to see the overall profitability of customers that have not made purchases in the last month.

Identity Resolution in SoundCommerce

SoundCommerce offers a deterministic identity resolution process to group purchases by customers. By default, SoundCommerce will use the recorded email address as the primary condition for identity resolution, but more identifying attributes can be added. The result of this deterministic identity resolution process is the cuid, or the CUstomer IDentifier. This value is propagated throughout the entire SoundCommerce data model and allows for powerful customer-level analysis of your data, from orders to fulfillments to campaign analytics.  

When not to use the view

The sc_customers view does not include personal identifiable information (PII). All metrics calculated in the sc_customers view are associated with an anonymized cuid. By itself, users will not be able to tie in purchase history or other information with a specific customer. To tie records to specific customers (and expose names, emails, phone numbers, etc.), use the cuid to join onto the sc_customer_pii view (more information is in the sc_customer_pii section). 

The sc_customers view does not contain specifics about the following:

• Campaign-related metrics (i.e., clicks, impressions, conversions, ad spend)
• Product-related metrics (i.e., warehouse inventory for a given product)
• Customer PII-related values (i.e., first and last names, emails, phone numbers, addresses)
• Order-related metrics (i.e., sales, profitability)

Return to SoundCommerce Retail Modules