Fluent Commerce Logo
Docs

Total Return Orders Metric

Essential knowledge

Intended Audience:

Business User

Author:

Holger Lierse

Changed on:

16 Nov 2025

Overview

Learn about the Total Return Orders Metric in Fluent Analytics

Key points

  • Return volume affects operational costs and customer satisfaction
  • Seasonal patterns are normal for many product categories
  • Volume spikes may indicate specific product or process issues

What it measures

Total number of return orders created within the selected time period irrespective of the return order status.

No alt provided

When to use this metric

  • Monitor return volume trends and patterns
  • Plan return processing capacity and staffing
  • Assess the effectiveness of return prevention initiatives
  • Compare return volumes across time periods

How to interpret

  • Good performance: Return volumes are stable and manageable
  • Potential issues: Increasing return volumes may indicate quality or operational issues
  • Benchmark guidance: Varies by industry; track trends more than absolute numbers

Technical details

Formula: 

COUNT(returnOrders) where status = {STATUS_COMPLETE} for specific 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