Order Revenue

order_revenue

Overview

Order Revenue refers to the total revenue generated across all sales channels after adjustments such as discounts, shipping, fees, and taxes (but before refunds).

📘

Order Revenue = Gross Sales - Discounts + Shipping + Tax

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

Gross Sales = sum(gross_product_sales) --> Orders table
Discounts = sum(discount_amount) --> Orders table
Shipping = sum(shipping_price) --> Orders table
Taxes = sum(taxes) --> Orders table

Insights and Actions

Order Revenue provides a holistic view of your revenue, combining sales from Shopify and Amazon to assess overall business performance. Efficiently leveraging Order Revenue data can guide strategic business decisions:

• Evaluate Overall Sales Health: Use Order Revenue as a benchmark to assess the health and growth of your business across all platforms, identifying trends and seasonal impacts.
• Optimize Multi-Channel Strategy: Analyze the contribution of each platform to Order Revenue to allocate resources effectively and optimize sales strategies for each channel.
• Identify Cross-Platform Opportunities: Look for patterns in sales data that suggest opportunities for cross-promotion or bundled sales across Shopify and Amazon.
• Adjust Marketing Spend: Based on the performance insights from Order Revenue, adjust your marketing budget to focus on the channels and strategies yielding the highest return.

Example Use

Prompt

What's my total order revenue across all shops over the past 7 days?

Response

Query

SQL

SELECT
  SUM(ot.order_revenue) AS total_order_revenue
FROM
  orders_table AS ot
WHERE
  ot.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;