Campaign Module Direct Access Updates

Direct Access is now accessible directly from the SoundCommerce Retail Application UI!

1. Hover over the red bar on the far left of the Retail Application and select Direct Access, as shown In the image below.

Screen_Shot_2022-11-09_at_11.17.34_AM.png

Three Direct Access Views have been added to power the SoundCommerce Dashboard Templates.

1. sc_marketing_performance_metrics

2. sc_marketing_time_based_metrics

3. sc_marketing_previous_year_comparison

In addition, the following fields have been added to existing views:

Table	Field	Type	Definition
sc_customers	first_order_campaign_id	String	Campaign_id of the campaign attributed to the customer’s first order
sc_customers	first_order_campaign	String	Campaign name of the campaign attributed to the customer’s first order
sc_orders	source	String	Where the customer came from before conversion
sc_orders	medium	String	Type of marketing source
sc_orders	campaign_id	String	campaign_id
sc_orders	campaign	String	Campaign name
sc_orders	adcost	Numeric	Sum of cost on record date
sc_orders	gross_profit	Numeric	Gross_sales - total_discounts - total_refund - total_cogs
sc_orders	delivered_profit	Numeric	Gross_sales - total_discounts - total_refund - total_cogs + total_shipping_price - total_shipping_discount - total_refund_shipping - total_shipping_cost
sc_orders	contribution_profit	Numeric	Gross_sales - total_discounts - total_refund - total_cogs + total_shipping_price - total_shipping_discount - total_refund_shipping - total_shipping_cost - adcost

Search