sc_customer_pii

In this article

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

Summary

The sc_cusotmer_pii view provides non-anonymized information about customers who have made purchases. In this view, you will find specific personal identifiable information (PII) for each customer. Because this view contains PII, it is quarantined to a different dataset governed by different permissions. Users will need to be given special permissions to access this data. This view does not contain metrics.

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

• I want to generate a list of customers that meet certain criteria (i.e., high value, long amount of time between orders, made their first purchase in a given category) and send out targeted email promotions.

When not to use the view

The sc_customer_pii view includes PII. No metrics are provided in this view, so it cannot be used for analysis on its own. It must be joined with other SoundCommerce views to have descriptive value. 

The sc_customer_pii 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-related metrics (i.e., customer historical sales, customer CLV)
• Order-related metrics (i.e., sales, profitability)

Return to SoundCommerce Retail Modules