Gross Sales

gross_product_sales

Overview

Gross Sales refers to the total revenue before adjustments such as discounts, shipping, fees, taxes, and refunds.

📘

Gross Sales = Sum of Product Price x Units Sold for Each Unit Sold

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

Product Price = products_info.product_name_price --> Orders table
Units Sold = products_info.product_name_quantity_sold --> Orders table

Insights and Actions

Gross Sales (Gross Product Sales) measures total revenue before any deductions, providing a clear snapshot of initial sales performance and offering insights into the raw market demand:

• Adjust Pricing Strategies: Review Gross Sales trends to refine pricing, ensuring competitiveness and profitability.
• Promote High-Performing Products: Identify products contributing most to Gross Sales and focus marketing efforts to boost their visibility and sales.
• Evaluate Promotions and Discounts: Assess the impact of discounts on overall Gross Sales to strike a balance between attracting customers and maintaining revenue.
• Forecast Sales and Inventory Needs: Use Gross Sales data to forecast future sales trends and plan inventory procurement accordingly.

Example Use

Prompt

What are my gross sales over the past 7 days?

Response

Query

SQL

SELECT
  SUM(ot.gross_product_sales) AS gross_product_sales
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;

To compare with a breakdown of product price and units sold for each line item:

SQL

select
  order_id,
  products_info.variant_id,
  products_info.product_name_price as product_name_price,
  products_info.product_name_quantity_sold as product_name_quantity_sold,
from
  orders_table o array
  join products_info
where
  event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1