Skip to main content

Customer Returns

The data model includes measures such as Restock, Return Amt, Return Amt HC, Trade Disc Amt, Transaction Amount, Transaction Amount HC, Ext Amt, Freight Amt, Restock Amt, Trade Disc Amt, Unit Price, Unit Price Ovrd, Quantity Shipped, and Curr Exch Rate. Views include Returns by Item for analyzing return trends by product, and Customer Returns for assessing customer return patterns. The model enables evaluating restocking revenue, refunds, trade discounts, transaction amounts, and currency impacts in customer returns and shipping processes.

Benefits of This Data Model​

  • Improved Product Insights: Analyze returns data by item to identify trends and problematic products quickly.
  • Enhanced Customer Understanding: Gain detailed views of return patterns by customer to assess loyalty and satisfaction levels effectively.
  • Comprehensive Revenue Evaluation: Evaluate restocking revenue, discounts, and transaction amounts accurately to optimize financial performance.
  • Efficient Currency Impact Assessment: Understand the impact of currency fluctuations on customer returns and shipping processes for better decision-making.

Key Performance Indicators (KPIs)​

  • Restock: The amount of revenue generated from restocking returned items.
  • Return Amt: The total amount of money refunded to customers for returned products.
  • Return Amt HC: The total return amount in the home currency.
  • Trade Disc Amt: The amount of discounts given on returned products.
  • Transaction Amount: The total sales transaction amount, including returns.
  • Transaction Amount HC: The total transaction amount in the home currency.
  • Ext Amt: The extended amount, which is the product of quantity shipped and unit price.
  • Freight Amt: The total amount charged for shipping returns.
  • Restock Amt: The amount specifically related to restocking returned items.
  • Trade Disc Amt: The total trade discount amount applied.
  • Unit Price: The price of a single unit of a product before any discounts or overrides.
  • Unit Price Ovrd: The unit price after any overrides or modifications.
  • Quantity Shipped: The total quantity of products shipped in a transaction.
  • Curr Exch Rate: The current exchange rate used to convert between currencies.

Available Visualizations​

View NameDescription
Returns by ItemAnalyzes returns data by item to identify trends and problematic products.
Customer ReturnsProvides a detailed view of return patterns by customer to assess loyalty and satisfaction.