Data Dictionary

Overview

Measures the percentage of revenue reduced through discounts relative to gross sales. Essential for understanding promotional impact and margin control.

Formula

Insights and Actions

• Track how discounts influence sales volume.
• Identify if heavy discounts are hurting profitability.
• Evaluate if discounts are driving repeat purchases.
• Optimize discount levels for maximum ROI.
• Compare discount rates across periods to detect overuse.

Detailed Breakdown

• Discount Rate Total Discount Amount
• Gross Sales= Gross Sales = Net Sales + Discount Amount
• 100

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT SUM(discount_amount) * 100.0 / NULLIF(SUM(net_sales_amount + discount_amount), 0) AS discount_rate FROM orders WHERE order_date BETWEEN :start AND :end;