---
updatedAt: 2025-01-29T10:29:52.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Discounts

discount_amount

# 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](https://triplewhale.readme.io/docs/orders-table) 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.

# Example Use

### Prompt

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

### Response

![](https://files.readme.io/0d28212fd5f5a9d7b30df0aa88e3811c55785465c833710a7ed08f9d0a7709cd-image.png)

### Query

```sql
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';
```