Top 10 Returned Products Metric
Essential knowledge
Intended Audience:
Business User
Author:
Holger Lierse
Changed on:
9 Dec 2025
Overview
Learn about the Top 10 Returned Products Metric in Fluent Analytics
Key points
- High-return products significantly impact profitability and operations
- Product return patterns can guide improvement priorities
- May indicate misaligned customer expectations or quality issues
What it measures
Top 10 most frequently returned products by volume for return orders created in the selected time period.
When to use this metric
- Identify products with quality or expectation issues
- Guide product improvement and quality control efforts
- Assess the effectiveness of product descriptions and marketing
- Prioritize inventory and purchasing decisions
How to interpret
- Good performance: Return patterns are predictable and manageable
- Potential issues: High return volumes may indicate systematic product problems
- Benchmark guidance: Monitor trends and investigate sudden changes
Technical details
Formula:
SUM(returnOrder.items.quantity) where return.status = {STATUS_COMPLETE}
grouped by product, ordered by sum desc, limited to top 10
within the selected time period
Reference Filter Parameters:
`return_order.created_date`: Filters the metric to return orders created within the selected time period`return_order.status`: {STATUS_COMPLETE} - Status definitions for complete returns (default: COMPLETE)`return_order.type`: Filters the metric to return orders of specific order types`retailer.ref`: Filters the metric to return orders from the selected retailer
