Overview

Discounts refers to the total discount amount applied to the order, including shipping discounts.

📘
Discounts = Total amount of discounts applied to the order

The calculation is based on data from the Orders table.

Insights and Actions

Discounts reflect the reductions given on orders, helping you understand their impact on sales and profitability:

Analyze Promotional Effectiveness: Monitor how discounts affect sales volumes and customer engagement. Are they driving the desired increase in purchases?
Optimize Discount Strategy: Determine the ideal discount level that encourages sales without significantly diminishing profit margins.
Enhance Customer Loyalty: Use insights from discount trends to improve loyalty programs, offering targeted discounts that encourage repeat business.
Refine Marketing Efforts: Adjust your marketing strategies based on the times and conditions where discounts have proven most effective in boosting sales.

What is the total amount of discounts on orders in the past month?

SELECT
  SUM(ot.discount_amount) AS total_discount_amount
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN '2024-08-25' AND '2024-09-24';