Sales History
The Sales History view shows your actual historical sales data. It’s essential for understanding past performance, validating forecasts, and identifying trends.Accessing Sales History
Navigate to Demand Forecast → Sales History (or Sales History in the sidebar for Sales Rep users).Sales History is available to both Admin and Sales Rep users, making it accessible for the entire team.
What is Sales History?
Sales History displays actual sales transactions that have occurred:| Data Point | Description |
|---|---|
| Units Sold | Quantity sold |
| Revenue | Sales value (if tracked) |
| By SKU | Broken down by product |
| By Channel | Broken down by sales channel |
| By Period | Daily, weekly, or monthly |
Sales History View
Layout
The Sales History view uses a similar layout to the Forecast Dashboard:- Filter Panel (left) - Filter by channel, product, etc.
- Data Table (center) - Historical sales by period
- Time Controls (top) - Date range and aggregation
Table Columns
| Column Type | Content |
|---|---|
| Row Identifiers | SKU, Channel, Collection |
| Period Columns | Sales for each time period |
| Totals | Row and column sums |
Viewing Historical Data
Date Range Selection
Select History Period
Choose how far back to look:
- Last 30 days
- Last 90 days
- Last 12 months
- Custom range
Aggregation Levels
| Level | Best For |
|---|---|
| Daily | Recent detailed analysis |
| Weekly | Short-term trends |
| Monthly | Long-term patterns |
| Quarterly | Strategic overview |
Grouping Options
Group historical data by:- Channel
- Collection
- Product hierarchy
- SKU
Filtering Sales History
By Channel
View sales for specific channels:- Open Channel filter
- Select channels
- See only sales from those channels
By Product
Focus on specific products:- Use Collection or SKU filters
- Select products to view
- Data shows only selected items
By Time Period
Beyond date range, filter by:- Day of week
- Specific months
- Comparable periods (same month last year)
Comparing to Forecasts
Side-by-Side View
To compare sales history with forecasts:- Go to the Forecast Dashboard
- Enable both “Sales History” and “Forecast” metrics
- View actual vs. predicted in the same table
Variance Analysis
| Column | Description |
|---|---|
| Forecast | What was predicted |
| Actual | What actually sold |
| Variance | Difference (Actual - Forecast) |
| Variance % | Percentage difference |
Reading Variances
| Variance | Meaning | Action |
|---|---|---|
| Positive | Sold more than forecast | Good news, may need supply |
| Negative | Sold less than forecast | Review why, check inventory |
| Zero/Small | Forecast was accurate | Forecasting is working well |
Sales Trends
Identifying Patterns
Look for: Seasonal Patterns:- Higher sales in certain months
- Holiday peaks
- Weather-related changes
- Consistent month-over-month changes
- Year-over-year comparisons
- Product lifecycle stages
- Channel-specific seasonality
- Promotional impacts by channel
- Channel growth rates
Trend Indicators
| Pattern | What It Looks Like |
|---|---|
| Growth | Values increasing over time |
| Decline | Values decreasing over time |
| Seasonal | Regular peaks and valleys |
| Steady | Consistent values period to period |
Year-over-Year Comparison
Compare current period to same period last year:Setting Up YoY View
YoY Metrics
| Metric | Description |
|---|---|
| This Year | Current period sales |
| Last Year | Same period prior year |
| Change | Difference in units |
| % Change | Percentage growth/decline |
Exporting Sales Data
Export Options
Export Uses
- Detailed analysis in Excel
- Input to other planning tools
- Sharing with stakeholders
- Archive for records
Period Completion Status
Some views show period completion:| Status | Meaning |
|---|---|
| Complete | Full period, all data in |
| In Progress | Current period, data still coming |
| Estimated | Some data may be delayed |
Recent periods may show incomplete data if sales are still being processed or synced.
Integration with Forecasts
Sales history feeds into forecasting:How Forecasts Use History
- Baseline - Historical patterns establish baseline
- Trends - Growth/decline rates inform projections
- Seasonality - Past seasonal patterns project forward
- Model Training - Algorithms learn from history
Data Quality Impact
Better history data = better forecasts:- Complete data improves accuracy
- Consistent tracking helps patterns
- Flagged anomalies prevent distortion
Best Practices
Regular Review
Regular Review
Check sales history regularly:
- Weekly: Recent performance
- Monthly: Trend analysis
- Quarterly: Strategic review
Investigate Anomalies
Investigate Anomalies
When you see unusual patterns:
- Was there a promotion?
- Were there supply issues?
- Market event?
- Document for future reference
Compare Year-over-Year
Compare Year-over-Year
Use YoY comparisons to:
- Understand seasonal patterns
- Measure growth
- Validate forecasts
Export for Analysis
Export for Analysis
Export data for deeper analysis:
- Create charts and visualizations
- Perform statistical analysis
- Share with leadership
Troubleshooting
Missing Sales Data
Possible causes:- Integration sync delay
- Date range doesn’t include data
- Data wasn’t imported
- Check integration status
- Expand date range
- Verify data import completed
Data Doesn’t Match Source
Possible causes:- Returns not processed
- Timing differences
- Aggregation method differs
- Check if returns are included
- Verify period definitions match
- Confirm aggregation logic