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
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;
Updated 2 months ago