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

# Handling Fees

handling_fees

# Overview

Handling Fees represent the costs associated with boxing, packaging, or other services needed to prepare products for shipment.

> 📘 Handling Fees = Total Handling Fees during the selected time period

The calculation is based on data from the [Orders](https://triplewhale.readme.io/docs/orders-table) table.

***

### Detailed Breakdown

The formula above is derived from the following components:

* **Handling Fees** = `SUM(handling_fees)` --> [Orders](https://triplewhale.readme.io/docs/orders-table) table

# Insights and Actions

Handling Fees represent the costs incurred for preparing products for shipment, providing insights into operational expenses and efficiency:

* **Monitor Operational Costs**: Regularly track handling fees to ensure they remain proportionate to revenue and identify areas where costs can be minimized.
* **Evaluate Packaging Efficiency**: Analyze trends in handling fees to identify opportunities for optimizing packaging processes or sourcing cost-effective materials.
* **Incorporate Fees into Pricing**: Use handling fee data to ensure product pricing adequately covers operational costs, protecting profit margins.

### Related Metrics

* **Shipping Costs**: Complements handling fees by providing a full view of logistics expenses, helping assess total fulfillment costs.
* **Order Revenue**: Contextualizes handling fees as a percentage of revenue, aiding in evaluating their impact on profitability.
* **Net Profit**: Tracks overall profitability, offering insights into how handling fees affect the bottom line.

# Example Use

### Prompt

> What are my handling fees for the last 30 days?

### Response

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

### Query

```sql
SELECT
  SUM(ot.handling_fees) AS total_handling_fees
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;

```