Sales - Tables and columns
Sales - Tables and columns
This document provides details on the dashboard sub-categories, tables, and columns for all metrics used in the dashboards under the sales tab on Pulse.
For information on the formulas and definitions, click here.
Dimensions
Attributes or fields that categorize data for sorting, grouping, and labelling, such as dates, locations, and channel.
| Dimensions | Dashboard Sub-Category | Table | Column |
|---|---|---|---|
| Brand | Executive Snapshot | Executive_Dashboard_pbi | brand_name |
| Executive Trends | Executive_Dashboard_pbi | brand_name | |
| Channel Comparison | Executive_Dashboard_pbi | brand_name | |
| Account Overview Amazon | Amazon_account_overview_customer_section_cumul, Amazon_account_overview_sales, Amazon_account_overview_feedback, amazon_account_overview_sales_marketing_profit, amazon_account_overview_product_cumul, Amazon_account_overview_listings_cumul, amazon_account_overview_customer_rfm_cumul | brand_name, brand, brand_name, brand_name, brand, brand, brand_name | |
| Account Overview Shopify | Shopify_account_overview_customer_cumul, Shopify_account_overview_sales, Shopify_Account_Overview_Sales_Marketing_Profits, Shopify_account_overview_product_cumul, Shopify_account_overview_customer_rfm_cumul | brand_name, brand, brand_name, brand_name, brand, brand, brand_name | |
| Country | Executive Snapshot | Executive_Dashboard_pbi | store_name |
| Executive Trends | Executive_Dashboard_pbi | store_name | |
| Channel Comparison | Executive_Dashboard_pbi | store_name | |
| Account Overview Amazon | Amazon_account_overview_customer_section_cumul, Amazon_account_overview_sales, Amazon_account_overview_feedback, amazon_account_overview_sales_marketing_profit, amazon_account_overview_product_cumul, Amazon_account_overview_listings_cumul, amazon_account_overview_customer_rfm_cumul | store_name, store_name, store_name, store_name, store_name, store_name, store_name | |
| Account Overview Shopify | Shopify_account_overview_customer_cumul, Shopify_account_overview_sales, Shopify_Account_Overview_Sales_Marketing_Profits, Shopify_account_overview_product_cumul, Shopify_account_overview_customer_rfm_cumul | store_name, store_name, store_name, store_name, store_name, store_name, store_name | |
| Customer Segment | Account Overview Amazon | Amazon_account_overview_customer_rfm_cumul | total_customers, rfm_segment |
| Account Overview Shopify | Shopify_account_overview_customer_rfm_cumul | total_customers, rfm_segment | |
| Date | Executive Trends | Executive_Dashboard_pbi | date |
| Channel Comparison | Executive_Dashboard_pbi | date | |
| Account Overview Amazon | Amazon_account_overview_customer_section_cumul, Amazon_account_overview_sales, Amazon_account_overview_feedback, amazon_account_overview_sales_marketing_profit | acquisition_date, date, date, date | |
| Account Overview Shopify | Shopify_account_overview_customer_cumul, Shopify_account_overview_sales, Shopify_Account_Overview_Sales_Marketing_Profits | acquisition_date, date, date, date | |
| Previous Period | Executive Snapshot | Executive_Dashboard_pbi | |
| Previous Period% | Executive Snapshot | Executive_Dashboard_pbi | |
| Previous year | Executive Snapshot | Executive_Dashboard_pbi | |
| Sales Channel | Executive Snapshot | Executive_Dashboard_pbi | platform_name |
| Executive Trends | Executive_Dashboard_pbi | platform_name | |
| Channel Comparison | Executive_Dashboard_pbi | platform_name | |
| Spend Type | Account Overview Amazon | Shopify_Account_Overview_Marketing | adspend, adsales |
| Account Overview Shopify | Shopify_Account_Overview_Marketing | adspend, adsales | |
| YoY (Year on Year)% | Executive Snapshot | Executive_Dashboard_pbi | |
| Yesterday | Executive Snapshot | Executive_Dashboard_pbi | Date |
| 07 Days, 30 Days, 60 Days, 90 Days | Executive Snapshot | Executive_Dashboard_pbi | Date |
| This Week | Executive Snapshot | Executive_Dashboard_pbi | Date |
| Last Week | Executive Snapshot | Executive_Dashboard_pbi | Date |
| This Month | Executive Snapshot | Executive_Dashboard_pbi | Date |
| Last Month | Executive Snapshot | Executive_Dashboard_pbi | Date |
| This Year | Executive Snapshot | Executive_Dashboard_pbi | Date |
| Last Year | Executive Snapshot | Executive_Dashboard_pbi | Date |
| 30d, 60d, 90d, 12 months | Account Overview Amazon | Amazon_account_overview_customer_section_cumul | revenue (value field), date (condition field), acquisition_date (condition field) |
| Account Overview Shopify | Shopify_account_overview_customer_cumul | revenue (value field), date (condition field), acquisition_date (condition field) |
Measures
Measure are quantitative metrics or values that can be aggregated and analyzed, such as sales, profit, and traffic.
| Measures | Dashboard Sub-Category | Table | Column |
|---|---|---|---|
| Ad Sales | Executive Snapshot | Executive_Dashboard_pbi | ad_sales |
| Executive Trends | Executive_Dashboard_pbi | ad_sales | |
| Channel Comparison | Executive_Dashboard_pbi | ad_sales | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_sales | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_sales | |
| Ad Spend | Executive Snapshot | Executive_Dashboard_pbi | ad_spend |
| Executive Trends | Executive_Dashboard_pbi | ad_spend | |
| Channel Comparison | Executive_Dashboard_pbi | ad_spend | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_spend | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_spend | |
| ASINs | Account Overview Amazon | Amazon_account_overview_listings | asin |
| Capex (Capital expenditure) | Executive Snapshot | Executive_Dashboard_pbi | capex_value |
| Executive Trends | Executive_Dashboard_pbi | capex_val | |
| Channel Comparison | Executive_Dashboard_pbi | capex_val | |
| Clicks | Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_clicks |
| Customers | Account Overview Amazon | Amazon_account_overview_sales | customer_id |
| Account Overview Shopify | Shopify_account_overview_sales | customer_id | |
| Impressions | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_impressions |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_impressions | |
| Inventory on Hand | Account Overview Amazon | Amazon_account_overview_listings | available, sales_price |
| Account Overview Shopify | Shopify_account_overview_product_cumul | available, sales_price | |
| New Customers | Account Overview Amazon | Amazon_account_overview_sales | customer_id, new_or_existing |
| Account Overview Shopify | Shopify_account_overview_sales | customer_id, new_or_existing | |
| OOS (Out of stock) | Executive Snapshot | Executive_Dashboard_pbi | oos_flag |
| Account Overview Shopify | Shopify_account_overview_product_cumul | sku, availability | |
| Executive Trends | Executive_Dashboard_pbi | oos_flag | |
| OOS Count (Out of stock count) | Channel Comparison | Executive_Dashboard_pbi | OOS_Count |
| OOS ASINS (Out of stock ASINS) | Account Overview Amazon | Amazon_account_overview_listings | oos_asins |
| Profit | Executive Snapshot | Executive_Dashboard_pbi | profit |
| Refund | Executive Snapshot | Executive_Dashboard_pbi | refund_amount |
| Executive Trends | Executive_Dashboard_pbi | refund_amount | |
| Channel Comparison | Executive_Dashboard_pbi | refunded_amount_by_order_date | |
| Revenue | Account Overview Amazon | amazon_account_overview_sales_marketing_profit | total_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_revenue | |
| Sales | Executive Snapshot | Executive_Dashboard_pbi | total_price |
| Executive Trends | Executive_Dashboard_pbi | revenue | |
| Channel Comparison | Executive_Dashboard_pbi | total_price | |
| Sessions | Executive Trends | Executive_Dashboard_pbi | sessions |
| Channel Comparison | Executive_Dashboard_pbi | sessions | |
| SKUs (Stock keeping unit) | Account Overview Shopify | Shopify_account_overview_product_cumul | sku |
| Total Discounts | Executive Trends | Executive_Dashboard_pbi | total_order_discount |
| Channel Comparison | Executive_Dashboard_pbi | total_order_discount | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_discount | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_discount | |
| Total Reviews | Executive Snapshot | Executive_Dashboard_pbi | review_count |
| Executive Trends | Executive_Dashboard_pbi | review_count | |
| Channel Comparison | Executive_Dashboard_pbi | review_count | |
| Traffic | Executive Snapshot | Executive_Dashboard_pbi | sessions |
Derived Measures
Calculated fields created from existing dimensions or measures using mathematical or logical operations to provide additional insights.
| Derived Measures | Dashboard Sub-Category | Table | Column |
|---|---|---|---|
| % of ASINs forming 80% of sales | Account Overview Amazon | Amazon_account_overview_listings_cumul | asins_80p_cnt |
| Account Overview Shopify | Shopify_account_overview_product_cumul_cumul | skus_80p_cnt | |
| ACOS (Advertising Cost of Sales) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_spend (numerator), total_ad_sales (denominator) |
| Active ASINs | Account Overview Amazon | Amazon_account_overview_product_cumul | active_asins |
| Ad AOV (Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_sales (numerator), total_marketing_conversions (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_sales (numerator), total_marketing_conversions (denominator) | |
| Ad Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | ad_discounts |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | ad_discounts | |
| Ad Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | ad_profits, total_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | ad_profits, total_revenue | |
| Ad Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_sales |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_sales | |
| Ad RR (Ad return rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | ad_refunds(numerator), total_ad_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | ad_refunds(numerator), total_ad_quantity (denominator) | |
| Ad Sales % | Executive Trends | Executive_Dashboard_pbi | ad_sales |
| Channel Comparison | Executive_Dashboard_pbi | adsales,total_price | |
| Executive Snapshot | Executive_Dashboard_pbi | ad_sales,revenue | |
| AOV (Average order Value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_revenue (Numerator), total_orders (Denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_revenue (Numerator), total_orders (Denominator) | |
| ASINs ineligible for Ads | Account Overview Amazon | Amazon_account_overview_product_cumul | ineligible_asins |
| ASINs with Buy box < 80% | Account Overview Amazon | Amazon_account_overview_product_cumul | bb_asins |
| Average Discount | Executive Snapshot | Executive_Dashboard_pbi | total_order_discount,discounted_order_cnt |
| Average Rating | Channel Comparison | Executive_Dashboard_pbi | rating, review_count |
| Executive Snapshot | Executive_Dashboard_pbi | rating,review_count | |
| B2B AOV (B2B Average order Value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2b_revenue (numerator), b2b_orders (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2b_revenue (numerator), b2b_orders (denominator) | |
| B2B Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2b_item_discount |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2b_item_discount | |
| B2B Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2b_profits, b2b_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2b_profits, b2b_revenue | |
| B2B Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2b_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2b_revenue | |
| B2B RR (B2B Return rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2b_refunded_quantity_by_order_date (numerator), b2b_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2b_refunded_quantity_by_order_date (numerator), b2b_quantity (denominator) | |
| B2C AOV (Average order Value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2c_revenue (numerator), b2c_orders (numerator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2c_revenue (numerator), b2c_orders (numerator) | |
| B2C Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2c_item_discount |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2c_item_discount | |
| B2C Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2c_profits, b2c_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2c_profits, b2c_revenue | |
| B2C Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2c_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2c_revenue | |
| B2C RR (B2B Return rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | b2c_refunded_quantity_by_order_date(numerator), b2c_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | b2c_refunded_quantity_by_order_date(numerator), b2c_quantity (denominator) | |
| Bottom 10 ASIN's by Total Revenue | Account Overview Amazon | Amazon_account_overview_sales | product_id, total_revenue |
| Account Overview Shopify | Shopify_account_overview_sales | product_id, total_revenue | |
| CAC (Customer Acquisation Cost) | Executive Trends | Executive_Dashboard_pbi | revenue,new_customers_count |
| CLV (Customer Lifetime Value) | Account Overview Amazon | Amazon_account_overview_customer_section_cumul | revenue (value field), date (condition field), acquisition_date (condition field) |
| CLV (Customer Lifetime Value) | Account Overview Shopify | Shopify_account_overview_customer_cumul | revenue (value field), date (condition field), acquisition_date (condition field) |
| CR (Conversion Rate)% | Channel Comparison | Executive_Dashboard_pbi | conversions,clicks |
| CPA (Cost per acquisition) | Executive Snapshot | Executive_Dashboard_pbi | ad_spend,clicks |
| Channel Comparison | Executive_Dashboard_pbi | ad_spend,clicks | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_spend (numerator), total_marketing_conversions (denominator) | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_spend (numerator), total_marketing_conversions (denominator) | |
| CPC (Cost per click) | Executive Trends | Executive_Dashboard_pbi | ad_spend,clicks |
| Channel Comparison | Executive_Dashboard_pbi | revenue,new_customers_count | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_spend (numerator), total_clicks (denominator) | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_ad_spend (numerator), total_clicks (denominator) | |
| CTR% (Click-through rate) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_clicks (numerator), total_impressions (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | total_clicks (numerator), total_impressions (denominator) | |
| DOH (Days of Inventory on Hand) | Account Overview Amazon | Amazon_account_overview_product_cumul | available (Numerator), velocity_30_day_average (Denominator) |
| Account Overview Shopify | Shopify_account_overview_product_cumul | available (Numerator), velocity_30_day_average (Denominator) | |
| Existing Customer AOV (Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | existing_customer_revenue (numerator), existing_customer_orders (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | existing_customer_revenue (numerator), existing_customer_orders (denominator) | |
| Existing Customer Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | existing_customer_item_discount |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | existing_customer_item_discount | |
| Existing Customer Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | existing_customer_profits, existing_customer_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | existing_customer_profits, existing_customer_revenue | |
| Existing Customer Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | existing_customer_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | existing_customer_revenue | |
| Existing Customer RR (Return Rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | existing_customer_refunded_quantity_by_order_date (numerator), existing_customer_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | existing_customer_refunded_quantity_by_order_date (numerator), existing_customer_quantity (denominator) | |
| Inactive available ASINs | Account Overview Amazon | Amazon_account_overview_product_cumul | inactive_available_asins |
| Inventory older than 90d | Account Overview Amazon | Amazon_account_overview_product_cumul | inv_age_91_to_180_days,inv_age_181_to_270_days,inv_age_271_to_365_days,inv_age_365_plus_days |
| Mobile Traffic | Channel Comparison | Executive_Dashboard_pbi | mobile_sessions |
| New Customer AOV (Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | new_customer_revenue (numerator), new_customer_orders (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | new_customer_revenue (numerator), new_customer_orders (denominator) | |
| New Customer Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | new_customer_item_discount |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | new_customer_item_discount | |
| New Customer Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | new_customer_profits, new_customer_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | new_customer_profits, new_customer_revenue | |
| New Customer Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | new_customer_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | new_customer_revenue | |
| New Customer RR (Return Rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | new_customer_refunded_quantity_by_order_date (numerator), new_customer_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | new_customer_refunded_quantity_by_order_date (numerator), new_customer_quantity (denominator) | |
| New Customer Sales % | Executive Trends | Executive_Dashboard_pbi | new_customer_sales,revenue |
| Channel Comparison | Executive_Dashboard_pbi | new_customer_sales,total_price | |
| Organic AOV (Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | organic_sales (numerator), organic_conversions (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | organic_sales (numerator), organic_conversions (denominator) | |
| Organic Discounts | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | organic_discounts |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | organic_discounts | |
| Organic Profit % | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | organic_profits, total _revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | organic_profits, total _revenue | |
| Organic Revenue | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | organic_sales |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | organic_sales | |
| Organic RR (Return Rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | organic_refunds(numerator), organic_quantity(denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | organic_refunds(numerator), organic_quantity(denominator) | |
| OTP AOV (One-time purchase Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | One_Time_Purchase_revenue (numerator), One_Time_Purchase_orders (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | One_Time_Purchase_revenue (numerator), One_Time_Purchase_orders (denominator) | |
| OTP Profit % (One-time purchase profit%) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | One_Time_Purchase_profits, One_Time_Purchase_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | One_Time_Purchase_profits, One_Time_Purchase_revenue | |
| OTP Revenue (One-time purchase Revenue) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | One_Time_Purchase_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | One_Time_Purchase_revenue | |
| OTP RR (One time purchase Return Rate)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | One_Time_Purchase_refunded_quantity_by_order_date (numerator), One_Time_Purchase_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | One_Time_Purchase_refunded_quantity_by_order_date (numerator), One_Time_Purchase_quantity (denominator) | |
| Profit% | Executive Trends | Executive_Dashboard_pbi | profit, total_price |
| Account Overview Amazon | amazon_account_overview_sales_marketing_profit | profit, total_revenue | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | profit, total_revenue | |
| Channel Comparison | Executive_Dashboard_pbi | profit, total_price | |
| Return Rate % | Executive Trends | Executive_Dashboard_pbi | returned_orders_cnt,orders |
| Channel Comparison | Executive_Dashboard_pbi | refunded_quantity_by_order_date,quantity | |
| Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | refunded_quantity_by_order_date (Numerator), total_quantity (Denominator) | |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | refunded_quantity_by_order_date (Numerator), total_quantity (Denominator) | |
| ROAS (Return on ad spends) | Channel Comparison | Executive_Dashboard_pbi | ad_sales,ad_spend |
| Sales by Product Category | Account Overview Amazon | Amazon_account_overview_sales | revenue, product_category |
| Account Overview Shopify | Shopify_account_overview_sales | revenue, product_category | |
| SKUs per Asin | Account Overview Amazon | Amazon_account_overview_listings | sku (Numerator), asin (denominator) |
| SNS AOV (Subscription Average order value) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | Subscription_Order_revenue (numerator), Subscription_Order_orders (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | Subscription_Order_revenue (numerator), Subscription_Order_orders (denominator) | |
| SNS Profit (Subscription Profit)% | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | Subscription_Order_profits, Subscription_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | Subscription_Order_profits, Subscription_revenue | |
| SNS Revenue (Subscription revenue) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | Subscription_Order_revenue |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | Subscription_Order_revenue | |
| SNS RR% (Subscription return rate%) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | Subscription_Order_refunded_quantity_by_order_date (numerator), Subscription_Order_quantity (denominator) |
| Account Overview Shopify | Shopify_Account_Overview_Sales_Marketing_Profits | Subscription_Order_refunded_quantity_by_order_date (numerator), Subscription_Order_quantity (denominator) | |
| Suppressed ASINS | Account Overview Amazon | Amazon_account_overview_product_cumul | search_suppressed_asins |
| TACOS (Total Advertising Cost of Sales) | Account Overview Amazon | Amazon_account_overview_sales_marketing_profits | total_ad_spend (numerator), total_revenue (denominator) |
| Top 10 ASIN's by Total Revenue | Account Overview Amazon | Amazon_account_overview_sales | product_id, total_revenue |
| Account Overview Shopify | Shopify_account_overview_sales | product_id, total_revenue |
