Custom Expenses

Overview

Custom Expenses refers to the sum of all expenses not otherwise accounted for (including custom expenses marked as ad spend), as manually set in Triple Whale admin. These expenses are deducted when calculating Net Profit.

πŸ“˜

Custom Expenses = The total amount of custom expenses

The calculation is based on data from the Custom Spend table.

Insights and Actions

Custom Expenses are crucial for a comprehensive understanding of your business's financial health, encompassing costs not captured by standard expense categories (including advertising spend, cost of goods, shipping costs, payment gateway costs, handling fees, and taxes). Efficiently leveraging Custom Expenses data can guide strategic business decisions:

  • Expense Tracking and Management: Regularly review custom expenses to ensure they're necessary and optimized for cost-efficiency, helping to reduce overhead and improve net profit.
  • Budget Allocation: Analyze trends in custom expenses to better allocate budgets across different areas of your business, ensuring funds are directed towards high-ROI activities.
  • Financial Planning: Use insights from custom expenses to inform financial planning and forecasting, anticipating future costs and setting realistic financial goals.
  • Operational Efficiency: Identify any recurring custom expenses that can be reduced or eliminated through operational changes, such as negotiating with vendors or finding more cost-effective solutions.

Example Use

Prompt

Give me total custom expenses for the past 30 days

Response

Query

SELECT
  SUM(cs.amount) AS total_expenses
FROM
  custom_spend_table AS cs
WHERE
  cs.event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY);