Order Metrics
Essential knowledge
Changed on:
3 July 2025
Overview
[Warning: empty required content area]Key points
- Order metrics reveal the efficiency of order processing and highlight supply chain bottlenecks.
- Key order metrics include order accuracy, order cycle time, and fill rate. These metrics ensure that customer demands are met promptly and accurately, enhancing customer satisfaction.
- Monitoring order metrics allows businesses to optimize inventory management, reduce costs, and improve delivery times, improving operational efficiency and competitive advantage.
Order Summary
- Total Revenue: Value of Orders
- Number (In dollars)
- Total Orders: Order Processing Time
- Number
- Average Order Value: Value of Orders
- Number (In dollars)
- Average Order Items: Order Processing Time
- Number (decimal)
- Rejection Rate: Order Rejection/Bounce Rate
- Percentage
- Order Cancellation Rate: Cancelled Order Rate
- Percentage
- Orders by Order Type (order count with revenue over time/weeks): Order Processing Time and Value of Orders
- Graph Chart
- Average Orders by Hour of Day: Order Processing Time
- Bar chart
Order Processing Time
For example, the average time it takes for an order to move from CREATED to COMPLETE indicates how long it would generally take for an order to complete its life cycle. The states in between can also be monitored and can be used as indicators to further drill down and analyze trends.
| Data Element Description | Source | Source DB | Domain Entity/GraphQL Entity | Custom Attribute Name | Custom Attribute Data Type |
| Order - Time in status x (hours) | Custom Attribute | CORE | Order | time_in_status_list | JSON array, value fields in hours |
| Order - Time in process (hours) | Custom Attribute | CORE | Order | time_in_processing | hours |
| Dashboard - Avg. order time in status x (hours) | Calculated Value | CORE | Order | ||
| Dashboard - Avg. order processing time (hours) | Calculated Value | CORE | Order | ||
| Dashboard - At risk Orders (number that have been open more than x hours) | Calculated Value | CORE | Order | ||
| Setting - At risk orders threshold (hours) | Custom Attribute | CORE | Setting | order_time_at_risk_threshold | hours |
Order Rejection Rate
Tracks the ratio of rejected/expired fulfillment against total fulfillment placed, by location, for the time period.Order rejections can happen for 3 reasons:
- Automatic rejection from order sourcing logic due to no available stock (partial or full)
- Rejection by the fulfillment store and/or warehouse (partial or full)
- Expiry of the fulfillment due to the pick SLA being exceeded. By default, Fluent will reallocate those items/quantities to other locations to not lose the sale
| Data Element Description | Source | Source DB | Domain Entity (= GraphQL Entity) | Custom Attribute Name | Custom Attribute Data Type |
| Order - Number of fulfilments | Custom Attribute | CORE | Order | total_fulfiment_count | integer |
| Order - Number of fulfilments that were rejected (based on fulfillment status) | Custom Attribute | CORE | Order | rejected_fulfilment_count | integer |
| Order - Number of fulfilments that were expired (based on fulfillment status) | Custom Attribute | CORE | Order | expired_fulfilment_count | integer |
| Dashboard - Rejection Rate (last 7 days) | Calculated Value | CORE | Order | ||
| Location - Max fulfilments per day | Custom Attribute | CORE | Location | max_fulfilments_daily | integer |
| Dashboard - Location - Fulfilments received (last 7 days) | Calculated Value | CORE | Location | ||
| Dashboard - Location - Fulfilments rejected (last 7 days) | Calculated Value | CORE | Location | ||
| Dashboard - Location - Fulfilments expired (last 7 days) | Calculated Value | CORE | Location | ||
| Dashboard - Location - Rejection Rate (last 7 days) | Calculated Value | CORE | Location | ||
| Dashboard - Location - Expiration Rate (last 7 days) | Calculated Value | CORE | Location | ||
| Dashboard - Locations with highest rejection or/and expiration rate | Calculated Value | CORE | Retailer / Network |
Cancelled Order Rate
Tracks the ratio of cancelled orders against total orders placed for the time period.There are two types of Order cancellation:
- Cancellation via Customer Service
- Cancellation by self service (e.g. My Account page)
| Data Element Name Description | Source | Source DB | Domain Entity (= GraphQL Entity) | Custom Attribute Name | Custom Attribute Data Type |
| Order - Canceled (yes/no) | Custom Attribute | CORE | Order | is_canceled | boolean (TRUE/FALSE) |
| Order - Cancellation reason code | Custom Attribute | CORE | Order | cancel_reason | string (code as per setting enumeration) |
| Dashboard - Canceled order rate (past x days) | Calculated Value | CORE | Order |
Appeasements
Tracks the order revenue for the time period.Order Value
Tracks the number of orders and revenue over a time period.| Data Element Description | Source | Source DB | Domain Entity (=GraphQL Entity) | Custom Attribute Name | Custom Attribute Data Type |
| Order - total paid amount w tax (include delivery cost) | Data Model | CORE | Order | number | |
| Order - total paid tax amount | Data Model | CORE | Order | number | |
| Order - total paid amount w/o tax (include delivery cost) | Custom Attribute | CORE | Order | total_paid_price_excl_tax | number |
| Order - financial transaction total value | Calculated Value | CORE | FinancialTransaction | number | |
| Order - financial transaction currency | Data Model | CORE | FinancialTransaction | string | |
| Order items - total paid value w tax (exclude delivery price) | Data Model | CORE | Order | number | |
| Order items - total paid value w/o tax (exclude delivery price) | Custom Attribute | CORE | Order | order_items_total_paid_price | number |
| Order items - currency | Data Model | CORE | Order | number | |
| Order fulfilment price (=delivery price as captured at checkout) - total w tax | Data Model | CORE | Order | number | |
| Order fulfilment price (=delivery price as captured at checkout) - total w/o tax | Calculated Value | CORE | Order | number | |
| Order fulfilment price - currency | Data Model | CORE | Order | number | |
| Dashboard - value of open orders (order items paid price w tax excl delivery price) | Calculated Value | CORE | Order | ||
| Dashboard - value of delivered orders (order total price w tax incl. delivery price) in past 7 days | Calculated Value | CORE | Order |
