Sales Analyzer Dashboard
Online Sales Performance - November 2025
Upload Data File
×
Current Data Source
Sample Data (November 2025)
Reset to Sample
Drop your file here or click to browse
Supports Excel (.xlsx, .xls) and CSV (.csv) files
Required Columns
Date
Platform
Category
Total Sales
Units Sold/Orders
GMV/Ads Sales
Ad Spent
ROAS
Start Date
End Date
Platform
All Platforms
Category
All Categories
Total Sales
?
Total Sales Revenue
The sum of all revenue generated across selected platforms and categories. Includes both organic sales and ad-driven sales.
Higher is better. Compare week-over-week to track growth trends.
-
Units Sold
?
Total Units / Orders
Number of items sold or orders placed. Use with Total Sales to calculate Average Order Value (AOV = Sales / Units).
Books: ~$10/unit avg | Online Courses: ~$500/unit avg
-
GMV / Ads Sales
?
Gross Merchandise Value from Ads
Revenue directly attributed to advertising campaigns. This is the portion of Total Sales generated from paid ads.
If GMV is low compared to Ad Spent, your campaigns need optimization.
-
Ad Spent
?
Advertising Expenditure
Total amount spent on advertising across platforms. Compare against GMV to evaluate ad efficiency.
Keep Ad Spent below GMV for profitable campaigns. Aim for ROAS > 2x.
-
Avg ROAS
?
Return on Ad Spend
Average revenue generated per dollar spent on ads. Formula: GMV / Ad Spent. Higher ROAS = more efficient advertising.
Below 2x - Losing money
2x - 4x - Profitable
Above 4x - Excellent
-
Daily Sales Trend
Daily
Weekly
Monthly
Sales by Platform
Sales by Category
Platform Performance Comparison
ROAS by Platform
💡
Insights & Recommendations
Analyzing data...
Start Date
End Date
Platform
All Platforms
Category
All Categories
Total Sales
?
Total Sales Revenue
Sum of all revenue generated.
-
Units Sold
?
Total Orders
Number of items sold.
-
GMV Ads
?
GMV from Ads
Revenue from ad campaigns.
-
Avg ROAS
?
Return on Ad Spend
Revenue per dollar spent.
-
Daily Sales Trend
Sales by Platform
ROAS by Platform
Drill Down
×