Fluent Commerce Logo
Docs

Top 10 Returned Products Metric

Essential knowledge

Intended Audience:

Business User

Author:

Movyn John

Changed on:

20 Oct 2025

Overview

Learn about the Top 10 Returned Products Metric in Fluent Analytics

Key points

  • High-return products tie up inventory and increase operational costs
  • Return patterns may indicate broader product line or supplier issues
  • Seasonal products may show expected return spikes after gift-giving periods
  • Return reasons should be analyzed alongside volume data

What it measures

Products with the highest return volumes by quantity for the selected time period.

When to use this metric

  • Identify products with quality or customer satisfaction issues
  • Guide inventory purchasing decisions to avoid problematic products
  • Assess the impact of returns on inventory planning and availability
  • Prioritize product improvement or discontinuation decisions

How to interpret

  • Good performance: Return volumes are distributed across many products with no dominant patterns
  • Potential issues: High return volumes for specific products indicate systematic quality, sizing, or expectation problems
  • Benchmark guidance: Products appearing consistently in top returns need investigation and potential action

Technical details

Formula: 

SUM(inventoryQuantity.qty) where type = {TYPE_RETURNED}
grouped by product_id, ordered by SUM DESC, limited to top 10
within the selected time period

Configuration:

  • TYPE_RETURNED: Type definitions for inventory quantity reservations