sc_email_campaign_engagement

In this article

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

Summary

The sc_email_campaign_engagement view provides the necessary metrics to perform analysis on the engagement of a given email marketing campaign. In this view, you will find information about how often emails for a given campaign were sent, opened by a customer, clicked on, marked as spam, or unsubscribed. You’ll also get information about how many emails were sent and how many converted to an actual placed order. 

• View Grain: Email subject lines for a given campaign
• Primary (Composite) Key(s):
  • send_date
• Foreign Key(s): 
  • campaign
  • traffic_source

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

• I want to understand the proportion of “marked as spam” emails for a campaign to the total number of emails sent out. If I were to run a similar campaign later, would I receive the same reaction?

When not to use the view

This view contains information from a given email campaign. No customer information or specific orders are provided in this data. As such, tying this data in with the rest of SoundCommerce modeled data relies on the campaign attribute.

This view does not necessarily contain specifics about the following:

• 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 PII-related values (i.e., first and last names, addresses)
• Customer-related metrics (i.e., customer-aggregated sales, lifetime value, running order counts)

Return to SoundCommerce Retail Modules