Dashboard: Marketing Overview

Table of Contents

1. How to Access this Report
2. How to Use this Report
3. Filters
4. Dashboard Template Sections
5. Source Datasets

How to Access this Report

1. Follow the instructions sent by Sigma via email to create your account
2. Navigate to: https://app.sigmacomputing.com/soundcommerce/login
3. Enter your email and password
4. Click “Shared with me”
   
5. Click the folder labeled "Production"
6. Click a dashboard to view
7. Optional: Turn on explore mode to create custom visualizations and conduct ad-hoc analysis

How to Use this Report

Use the Marketing Overview Dashboard as your one-stop to unpacking your digital marketing performance. Track key metrics like CAC and ROAS, see the role discounts play in your sales performance, and understand which marketing sources drive the most sales and associated return at a high level through the Ad Performance rollup, or at a granular level through the Ad Performance Breakdown. This data reflects both your analytics source attribution (same-day, last click) and first-party order data, which gives you a more accurate picture of attribution than your analytics provider alone.

Filters

Report Date Range: Defaults to the last 365 days, or this filter can be adjusted to include a smaller or larger window, a range of specific dates, or before or after a particular date.
Canceled: Defaults to False which excludes canceled orders.
Channel: Defaults to all Sales Channels, or you can select certain sales channels to get a granular view.

Source: Defaults to all Marketing Sources, or you can filter by select Marketing Sources.

Campaign Name: Defaults to all Marketing Campaigns, or you can filter by select Campaign Names.

Dashboard Template Sections

Key Metrics Tiles

Customer Overview

Ad Performance Rollup

Ad Performance Breakdown

Source Datasets

This dashboard is built using the following DirectAccess views. You should be able to construct queries to calculate similar metrics using the below:

• sc_marketing_performance_metrics
• sc_nrf_date
• sc_orders
• sc_marketing_campaign_performance