Average Return Order Items Metric
Essential knowledge
Intended Audience:
Business User
Author:
Holger Lierse
Changed on:
16 Nov 2025
Overview
Learn about the Average Return Order Items Metric in Fluent Analytics
Key points
- Multi-item returns increase processing complexity and costs
- May indicate systemic fulfillment or quality issues
- Return item patterns can guide process improvements
What it measures
Average number of items per return orders completed in the selected time period.
When to use this metric
- Monitor return complexity and processing requirements
- Assess customer return behavior patterns
- Plan return processing capacity and workflows
- Evaluate product bundling impact on returns
How to interpret
- Good performance: Low items per return indicates isolated product issues
- Potential issues: High items per return may suggest order fulfillment problems
- Benchmark guidance: Should be lower than average order items
Technical details
Formula:
COUNT(returnOrder.items) / COUNT(returnOrders) where status = {STATUS_COMPLETE}
within the selected time period
Configurable elements:
- STATUS_COMPLETE: Status definitions for complete returns (default: COMPLETE)
Reference Parameters:
`return_order.created_date`: Filters the metric to return orders created within the selected time period`retailer.ref`: Filters the metric to return orders from the selected retailer`return_order.type`: Filters the metric to return orders of specific order types
