Top 10 Frequently Purchased Products Metric
How-to Guide
Author:
Holger Lierse
Changed on:
16 Sept 2025
Key Points
- Products purchased most often by customers (by transaction frequency, not volume).
Steps
What it measures
Products purchased most often by customers (by transaction frequency, not volume).
When to use this metric
- Identify customer favorites and core products
- Guide merchandising and promotional strategies
- Optimize product placement and availability
- Assess customer satisfaction with product offerings
How to interpret
- Good performance: Frequently purchased items align with strategic priorities
- Potential issues: Over-reliance on few products creates business risk
- Benchmark guidance: Monitor changes in purchase frequency patterns
Key considerations
- Purchase frequency differs from sales volume (many small vs. few large orders)
- Frequently purchased items often drive customer loyalty
- May indicate essential or consumable product characteristics
Technical details
Formula:
SUM(inventoryQuantity.qty) where type = {SALE_TYPE} grouped by product_id, ordered by SUM DESC, limited to top 10 within the selected time period
Configurable elements:
- SALE_TYPE: Type definitions for inventory quantity sales (default: SALE)
