Units Sold

product_quantity_sold_in_order

Overview

Units Sold refers to the total number of individual items or products that were purchased by customers.

📘

Units Sold = The total quantity of product units ordered

The calculation is based on data from the Orders table.

Insights and Actions

Units Sold is an essential metric for gauging product demand and inventory management. Efficiently leveraging Units Sold data can guide strategic business decisions:

• Inventory Management: Analyze trends in units sold to optimize inventory levels, avoiding stockouts for high-demand products and reducing excess stock for slower-moving items.
• Product Performance Analysis: Identify top-selling products to focus marketing efforts and product development on what customers prefer most.
• Pricing Strategy Adjustments: Evaluate the impact of pricing changes on units sold to find the optimal price point that maximizes revenue without deterring customers.
• Marketing and Promotion Planning: Use insights from sales trends to plan targeted promotions for products that need a sales boost or to capitalize on high-demand periods.

Example Use

Prompt

What was the total number of units sold yesterday?

Response

Query

SQL

SELECT  
  SUM(pi.product_name_quantity_sold) AS product_quantity_sold_in_order  
FROM  
  orders_table AS ot ARRAY  
  JOIN ot.products_info AS pi  
WHERE  
  ot.event_date = '2024-09-24'