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
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:
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
Updated 13 days ago