Order Revenue

Overview

Order Revenue refers to the total revenue generated across all sales channels (e.g. Shopify, Amazon).

📘

Order Revenue = Total order revenue across all shops

The calculation is based on data from the 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(od.order_revenue) AS total_revenue
FROM
  orders_table AS od
WHERE
  od.event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY);