D01 Order Analysis

The Order Analysis dashboard shows the volume of orders over time, featuring orders received, shipped, cancelled, or returned.

Filters

The filter pane for this dashboard includes the following filters.

Date: specify a range of dates for this dashboard's data.
Seller Name
Fulfillment Location
Include Reship: select Non-Reship, Reship, or both.

Data Items

Demand

Orders shows the number of orders received. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Demand Order Details table (see more information below). The new dashboard opens in a new browser tab.

Units shows the number of units in orders received.

Value shows the total monetary value of orders received. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Demand Order Details table (see more information below). The new dashboard opens in a new browser tab.

Avg Value shows the average monetary value per order received.

Shipments

Orders shows the number of orders shipped. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Fulfillment Order Details table (see more information below). The new dashboard opens in a new browser tab.

Units shows the number of units shipped.

Value shows the total monetary value of units shipped.Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Fulfillment Order Details table (see more information below). The new dashboard opens in a new browser tab.

Avg Value shows the average monetary value per order shipped.

Cancelled

Orders shows the total number of cancelled orders. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Cancel Order Details table (see more information below). The new dashboard opens in a new browser tab.

Units shows the total number of units in cancelled orders.

Value shows the total monetary value of units that were cancelled. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Cancel Order Details table (see more information below). The new dashboard opens in a new browser tab.

Avg Value shows the average monetary value per cancelled order.

Returned

Orders shows the total number of orders that included returned units. Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Return Order Details table (see more information below). The new dashboard opens in a new browser tab.

Units shows the number of units returned by customers.

Value shows the total monetary value of units that were returned.Click the number to jump to the second-level Order Analysis (Details) dashboard, which includes the Return Order Details table (see more information below). The new dashboard opens in a new browser tab.

Avg Value shows the average monetary value of returned items per returned order.

Unit Trend

This line graph shows the unit trend over time for Cancellations, Demand, Shipments, and Returned.

Order Trend

This line graph shows the order trend over time for Cancellations, Demand, Shipments, and Returned.

Demand Orders by Ordering System

This pie chart shows, for demand orders, the share of orders for each ordering system.

Shipped Orders by Ordering System

This pie chart shows, for shipped orders, the share of orders for each ordering system.

Order Analysis (Details)

Order Analysis (Details) is a second-level dashboard. You can reach it by clicking the numeric value under Demand, Shipments, Cancelled, or Returned in the main Order Analysis dashboard. The details dashboard opens in a new browser tab. To return to the main Order Analysis dashboard, close the tab for the second-level dashboard.

The filters panel for the details dashboard offers the same filter options as the main Order Analysis dashboard. Note that the details dashboard's filters operate independently from the filters of the main dashboard. You can change the filters of the details dashboard without affecting the data in the main dashboard.

The details dashboard contains five tables. See below for the details of each table.

Order Currency Details

The Order Currency Details table summarizes order value information for the selected time period, organized by Date, Seller and Currency.

Column	Description
Week	The numbered calender week for the order date.
Month	The month that includes the order date.
Quarter	The calendar quarter that includes the order date.
Year	The year that includes the order date.
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Date	The order date for the data summarized in this set of rows.
Currency	The code for the currency in which the order was paid.
Demand Orders	The number of demand orders that were placed on the specified date.
Demand Units	Total quantity of items across orders that were placed on the specified date.
Demand Net	The total net demand for the product and shipping after all promotions (excluding tax).
Fulfillment Units	Total quantity of items across orders that were shipped on the specified date.
Fulfillment Orders	The number of orders that were shipped on the specified date.
Fulfillment Net	Net amount for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Cancel Orders	The number of orders that were cancelled.
Cancel Units	Total number of cancelled items within the order.
Cancel Net	Total amount the customer was charged for cancelled items, including freight and all promotions (excludes tax).
Return Orders	Total number of orders with returned items.
Return Units	Total number of returned items within the order.
Return Net	The total net amount the customer was charged for returned items, including shipping and all promotions (excludes tax).

Demand Order Details

The Demand Order Details table summarizes order value information for demand orders in the selected time period, organized by Date, Seller, and Currency.

Column	Description
Date	The order date for the data summarized in this set of rows.
Week	The numbered calender week for the order date.
Month	The month that includes the order date.
Quarter	The calendar quarter that includes the order date.
Year	The year that includes the order date.
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Currency	The code for the currency in which the order was paid.
Demand Orders	The number of demand orders that were placed on the specified date.
Demand Units	Total quantity of items across orders that were placed on the specified date.
Demand Gross	Total retail price for the product, including freight, but prior to product and freight promotion(s).
Demand Gross Product	Current retail price for the product prior to product promotions.
Demand Gross Freight	Freight charges for the product prior to freight promotions.
Demand Net	The total net demand for the product and shipping after all promotions (excluding tax).
Demand Net Product	Total price charged to the customer for the product after applying product promotions (excludes tax).
Demand Net Freight	Total freight charges after applying freight promotions (excludes tax).
Demand Tax	Tax on sales and shipping for the order.
Demand Promo Product	Total product promotions (excludes tax).
Demand Promo Freight	Total freight promotions (excludes tax).

Fulfillment Order Details

The Fulfillment Order Details table summarizes order value information for shipped orders in the selected time period, organized by Date, Seller, and Currency.

Column	Description
Date	The order date for the data summarized in this set of rows.
Week	The numbered calender week for the order date.
Month	The month that includes the order date.
Quarter	The calendar quarter that includes the order date.
Year	The year that includes the order date.
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Currency	The code for the currency in which the order was paid.
Fulfillment Orders	The number of orders that were shipped on the specified date.
Fulfillment Units	Total quantity of items across orders that were shipped on the specified date.
Fulfillment Gross	The total gross amount for product and shipping (excludes promotions and tax) of items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Gross Product	Gross product amount for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Gross Freight	Gross freight amount for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Net	Net amount for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Net Product	Net product amount for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Net Freight	Net freight charges for items that were shipped on the specified date, after applying freight promotions (excludes tax). Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Tax	Total tax for items that were shipped on the specified date. Orders may not be tied to the same orders represented in demand. Orders may ship over multiple days but only shipments occurring on the specified date will appear in this total.
Fulfillment Promo Product	Total product promotions (excludes tax).
Fulfillment Promo Freight	Total freight promotions (excludes tax).

Return Order Details

The Return Order Details table summarizes order value information for returned orders in the selected time period, organized by Seller and Currency.

Column	Description
Date	The order date for the data summarized in this set of rows.
Week	The numbered calender week for the order date.
Month	The month that includes the order date.
Quarter	The calendar quarter that includes the order date.
Year	The year that includes the order date.
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Currency	The code for the currency in which the order was paid.
Return Orders	Total number of orders with returned items.
Return Units	Total number of returned items within the order.
Return Gross	The total gross amount the customer was charged for returned items, including shipping and all promotions (excludes tax).
Return Gross Product	Price of the returned items after product promotions that is credited to the customer (excludes tax). Promotions are pro-rated at the unit level.
Return Gross Freight	Freight charges for the returned items after freight promotions (excludes tax). Promotions are pro-rated at the unit level.
Return Net	The total net amount the customer was charged for returned items, including shipping and all promotions (excludes tax).
Return Net Product	Price of the returned items after product promotions that is credited to the customer (excludes tax). Promotions are pro-rated at the unit level.
Return Net Freight	Freight charges for the returned items after freight promotions (excludes tax). Promotions are pro-rated at the unit level.
Return Tax	Total tax amount on sales and shipping for returned units.
Return Promo Product	Total product promotions (excludes tax) for returned units.
Return Promo Freight	Total freight promotions (excludes tax) for returned units.

Cancel Order Details

The Cancel Order Details table summarizes order value information for cancelled orders in the selected time period, organized by Date, Seller, and Currency.

Column	Description
Date	The order date for the data summarized in this set of rows.
Week	The numbered calender week for the order date.
Month	The month that includes the order date.
Quarter	The calendar quarter that includes the order date.
Year	The year that includes the order date.
Seller Name	The name of the seller or sub-client, as set up in the order management system.
Currency	The code for the currency in which the order was paid.
Cancel Orders	The number of orders that were cancelled.
Cancel Units	Total number of cancelled items within the order.
Cancel Gross	Total amount of the cancelled lines within the order (excludes promotions and tax).
Cancel Gross Product	Total amount of the cancelled items (excludes promotions and tax). Promotions are pro-rated at the unit level.
Cancel Gross Freight	Total amount of freight costs for the cancelled line (excludes promotions and tax).
Cancel Net	Total amount the customer was charged for cancelled items, including freight and all promotions (excludes tax).
Cancel Net Product	Net amount of the cancelled items, after product promotions, that is credited to the customer (excludes tax). Promotions are pro-rated at the unit level.
Cancel Net Freight	Freight charges for the cancelled items after freight promotions (excludes tax). Promotions are pro-rated at the unit level.
Cancel Tax	Total tax amount on cancelled product (including freight).
Cancel Promo Product	Total product promotions (excludes tax) for cancelled units.
Cancel Promo Freight	Total freight promotions (excludes tax) for cancelled units.