Sales - Tables and columns

Need help with something?

Talk to data expert

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