Net Profit
net_profit
Overview
Net profit is the total revenue from product sales after deducting all costs, including advertising spend, cost of goods, shipping costs, payment gateway costs, handling fees, taxes, and any other operational expenses.
Net Profit = Total Sales − Total Expenses
The calculation is based on data in the Summary Metrics table.
Detailed Breakdown
The formula above is derived from the following components:
-
Total Sales =
SUM(total_sales)--> Summary Metrics table -
Total Expenses =
SUM(total_costs) + SUM(blended_spend)--> Summary Metrics table
Insights and Actions
Net Profit provides a comprehensive view of your business's financial health, showing the revenue left after deducting all expenses, including advertising and operational costs.
- Assess Business Performance: Use net profit to understand how well your business is performing financially. A positive net profit indicates healthy operations, while a negative figure may require adjustments to reduce costs or increase revenue.
- Identify Cost-Saving Opportunities: Analyze components like Ad Spend, COGS, and Shipping Costs to pinpoint areas for cost optimization. Reducing inefficiencies can directly improve net profit.
- Guide Investment Decisions: Use net profit as a benchmark to evaluate the financial impact of expanding into new marketing channels or increasing operational expenses.
Related Metrics
- Blended ROAS: Helps gauge overall ad efficiency in driving revenue, complementing net profit analysis.
- Total Costs: Breaks down all operational expenses, offering insight into areas where cost reductions might improve net profit.
- Refunds: Tracks the financial impact of refunds on profitability, highlighting trends that may require operational improvements.
Example Use
Prompt
What's my net profit the past 7 days?
Response
Query
SELECT
SUM(summ.total_sales) - SUM(summ.total_expenses) AS net_profit
FROM
summary_metrics_tvf() AS summ
WHERE
summ.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1Updated about 1 month ago
Did this page help you?