Data Dictionary

Overview

Total Sales represents the overall revenue generated from all completed orders within a selected period. It serves as a key performance indicator of business health, reflecting the combined impact of marketing, pricing, product mix, and customer demand. Monitoring Total Sales helps assess growth trends, evaluate campaign effectiveness, and guide strategic decisions across sales, finance, and operations.

Formula

Insights and Actions

• Revenue Growth Tracking — Identify periods of strong performance and potential slowdowns.
• Product Performance Evaluation — Analyze Total Sales by product or category to spot bestsellers and underperformers.
• Pricing & Discount Strategy — Sudden rises or drops indicate customer responses to pricing, promotions, or discounts.
• Market Demand Insights — Seasonal spikes reveal changing customer demand patterns.
• Profitability & Forecasting — Use Total Sales trends to support revenue forecasting and profit planning.

Detailed Breakdown

• Total Sales Net_sales_amount
• Shipping_amount
• Tax_amount

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT SUM(net_sales_amount + shipping_amount + tax_amount) AS total_sales FROM orders WHERE order_date BETWEEN :start AND :end;