Data Dictionary

Overview

Net Sales represent the actual revenue after deducting discounts from Gross Sales. It reflects the real income generated from completed transactions and provides a more accurate measure of sales performance.

Formula

Insights and Actions

• Profitability Tracking — Net Sales show how much revenue the business retains after adjustments.
• Discount Efficiency — Identifies how discounts or returns affect real sales performance.
• Customer Retention — A high return rate may signal product quality or satisfaction issues.
• Sales Quality — Differentiates between inflated gross sales and sustainable net revenue.
• Campaign Evaluation — Useful to measure how much revenue promotions actually retain.

Detailed Breakdown

• Net Sales Gross_sales
• Discount_amount

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT SUM(net_sales_amount) AS net_sales FROM orders WHERE order_date BETWEEN :start AND :end;