Skip to main content

Item Transaction History

The Item Transaction History data model tracks item level transactions over time, covering sales, inventory movements, and returns. It includes measures like total sales, average price, quantity sold, revenue trends, and profit margin. Use it to review transaction history by item or category, identify top sellers, and analyze return activity.

How to use this data model​

  • Review transaction history by item to see what was sold, at what price, and in what quantity over time.
  • Break down sales by category to compare performance across product groups.
  • Identify top selling items based on sales volume or revenue.
  • Track return transactions to spot items with high return rates and understand why.
  • Analyze profit margins across items and categories to find where profitability varies.

Available views​

ViewTypeWhat it shows
Item TransactionsWorksheetLists all item transactions with sales amounts, quantities, prices, and dates.