Sales velocity — the rate at which your products sell over time — directly affects your Buy Box percentage, inventory planning, and reorder timing. Most Amazon sellers track total sales but miss the velocity component that Amazon's algorithm actually weighs. This guide walks through three methods to track sales velocity accurately, from basic spreadsheet formulas to automated dashboards.
What Sales Velocity Actually Measures (And Why Amazon Cares)
Sales velocity is units sold per day over a defined period. A product selling 10 units per day has higher velocity than one selling 100 units per month, even though monthly totals are similar.
Amazon's algorithm uses velocity to determine:
- Buy Box eligibility — products with declining velocity lose Buy Box share even when pricing stays competitive
- Search ranking adjustments — sustained velocity increases organic placement over time
- IPI score calculations — low-velocity inventory drags down your Inventory Performance Index
- Storage fee assessments — aged inventory with poor velocity triggers long-term storage charges
The critical difference: Amazon measures velocity trends, not just current rates. A product selling 5 units/day consistently outperforms one that averaged 8 units/day last month but dropped to 3 this month.
The Basic Sales Velocity Formula
At minimum, track this calculation weekly:
Sales Velocity = Total Units Sold ÷ Number of Days in Period
For a 30-day period where you sold 240 units: 240 ÷ 30 = 8 units per day.
But the basic formula misses trends. You need to compare velocity across periods to spot acceleration or deceleration:
Velocity Change Rate = (Current Period Velocity - Previous Period Velocity) ÷ Previous Period Velocity × 100
Example: Last month's velocity was 8 units/day. This month is 10 units/day. Change rate: (10 - 8) ÷ 8 × 100 = 25% increase.
Track both metrics. Current velocity tells you reorder timing. Change rate tells you whether your Buy Box share will improve or decline.
The Seven-Day Rolling Average Method
Daily sales fluctuate wildly due to weekends, promotions, and Amazon's algorithm experiments. A seven-day rolling average smooths noise while staying responsive to real trends.
Calculate it by summing the last seven days of units sold, then dividing by seven. Recalculate daily. When the seven-day average trends upward for three consecutive days, velocity is genuinely improving. When it declines for five consecutive days, investigate immediately.
Method 1: Manual Tracking with Spreadsheets
Best for sellers with fewer than 20 SKUs who want full control over calculations.
Set up a Google Sheet or Excel file with these columns:
| Column | Purpose | Formula |
|---|---|---|
| Date | Track daily | Manual entry |
| SKU | Product identifier | Manual entry |
| Units Sold Today | Daily sales | From Business Reports |
| 7-Day Total | Rolling sum | =SUM(C2:C8) |
| 7-Day Velocity | Units per day | =D2/7 |
| 30-Day Velocity | Monthly rate | =AVERAGE(E2:E31) |
| Velocity Trend | Direction indicator | =IF(E2>F2,"UP","DOWN") |
Pull "Units Sold Today" from Seller Central → Reports → Business Reports → Detail Page Sales and Traffic by Child Item. Download the report daily and paste the "Units Ordered" column into your sheet.
Add conditional formatting: highlight cells green when seven-day velocity exceeds 30-day velocity by 15% or more (acceleration), yellow when they're within 15% (stable), red when seven-day velocity falls 15% or more below 30-day velocity (deceleration).
When Manual Tracking Makes Sense
This method works if you:
- Have a small catalog where daily data entry takes under 15 minutes
- Sell products with stable, predictable demand patterns
- Want to add custom calculations like profit per velocity unit or PPC cost per velocity point
- Need historical data going back 12+ months without paying for software
Manual tracking fails when you have 50+ SKUs, high daily order volumes, or products with unpredictable spikes. The data entry burden outweighs insights gained.
Method 2: Amazon Business Reports Automation
Amazon's native Business Reports provide velocity data without third-party tools. The limitation: you must manually export and analyze reports — there's no live dashboard.
Navigate to Seller Central → Reports → Business Reports → Detail Page Sales and Traffic by Child Item. Set the date range to "Last 30 Days" and download the report as CSV.
Key columns for velocity tracking:
- Units Ordered — total units sold in the period
- Sessions — product page views
- Unit Session Percentage — conversion rate (units sold per 100 sessions)
- Buy Box Percentage — how often you held the Buy Box when available
Calculate velocity by dividing "Units Ordered" by the number of days in your report period. Track this weekly and compare to the previous week's calculation.
The Buy Box Velocity Threshold
Amazon doesn't publish exact thresholds, but observable patterns emerge: products maintaining 85%+ Buy Box percentage typically show stable or increasing seven-day velocity. When velocity declines 20% or more over two weeks, Buy Box percentage tends to drop within 7-10 days, even when pricing remains competitive.
Monitor the relationship between your velocity trend and Buy Box percentage. If velocity drops but Buy Box holds steady for more than 10 days, check for suppressed competition (competitors out of stock). When they restock, your Buy Box share will decline unless you restore velocity through promotions or PPC.
Business Reports Advanced Calculation: Velocity Per Session
Divide your seven-day velocity by average daily sessions to get "velocity per session" — a normalized metric that accounts for traffic fluctuations.
Example: Product A sells 10 units/day with 500 daily sessions = 0.02 units per session. Product B sells 15 units/day with 1,200 daily sessions = 0.0125 units per session. Product A has better velocity efficiency despite lower absolute sales.
Use this metric to identify products where conversion improvements (better images, A+ content, review management) will yield disproportionate velocity gains.
Method 3: Third-Party Dashboard Integration
For sellers with 30+ SKUs or multiple marketplaces, automated dashboards eliminate manual calculations and provide real-time alerts.
Most Amazon analytics platforms calculate velocity automatically by connecting to Amazon's SP-API (Selling Partner API). They pull hourly sales data and compute rolling averages without manual exports.
Key features to look for in velocity tracking software:
- Multi-period comparison — view 7-day, 30-day, and 90-day velocity side by side
- SKU-level trend alerts — notifications when velocity drops below custom thresholds
- Velocity-based reorder points — automatic stock alerts tied to current velocity, not fixed reorder quantities
- Marketplace segmentation — separate velocity tracking for amazon.com, amazon.ca, amazon.co.uk if you sell internationally
- Historical velocity charts — visualize seasonal patterns and year-over-year comparisons
SageSeller's inventory dashboard calculates seven-day and 30-day velocity automatically for all active SKUs, with color-coded alerts when velocity trends diverge from historical patterns. The system also projects stockout dates based on current velocity rather than average monthly sales, giving more accurate reorder timing.
Decision Matrix: Which Tracking Method to Use
| Catalog Size | Best Method | Why |
|---|---|---|
| 1-20 SKUs | Manual spreadsheet | Data entry takes under 15 min/day; full customization |
| 20-50 SKUs | Business Reports + basic spreadsheet formulas | Weekly exports manageable; use templates to reduce setup time |
| 50-200 SKUs | Third-party dashboard | Manual tracking becomes error-prone; ROI on software is clear |
| 200+ SKUs | Third-party dashboard with API integration | Manual methods fail entirely; need automated alerts and batch analysis |
How to Use Velocity Data for Inventory Decisions
Raw velocity numbers are useless without action triggers. Set these thresholds based on your specific products:
Reorder Point Formula
Reorder Quantity = (Current 7-Day Velocity × Lead Time in Days) + Safety Stock
If your product sells 8 units/day and your supplier's lead time is 30 days, your reorder point is: (8 × 30) + safety stock = 240 units + safety stock.
Safety stock should equal 7-14 days of velocity for stable products, 20-30 days for products with high variance. Calculate variance by tracking the standard deviation of your seven-day velocity over 90 days. High standard deviation (velocity swings wildly week to week) requires larger safety stock.
Velocity-Based Promotion Triggers
Run promotions when seven-day velocity drops 25% below 30-day velocity and stays suppressed for five consecutive days. This indicates a genuine slowdown rather than normal fluctuation.
Discount depth should scale to velocity gap: 15-20% velocity decline warrants a 10-15% promotion, 30-40% decline warrants 20-25% off or Lightning Deal, 50%+ decline signals fundamental demand problems requiring repricing or improved listing content before promotions will help.
PPC Budget Adjustments
When organic velocity declines, increase PPC spend to maintain total velocity and protect Buy Box share. Calculate "velocity maintenance budget" as:
Additional PPC Budget = (Velocity Decline in Units/Day) × Target ACoS × Average Selling Price
If velocity drops from 10 units/day to 7 units/day, you need to generate 3 additional units/day through PPC. With a $30 product and 25% target ACoS: 3 units × 0.25 × $30 = $22.50 additional daily PPC spend.
This approach treats PPC as a Buy Box defense mechanism, not just an acquisition channel. The alternative — letting velocity continue declining — typically costs more in lost organic rank and Buy Box percentage than the incremental PPC investment.
Common Velocity Tracking Mistakes
Mistake 1: Tracking only total sales — A product that sold 300 units last month and 300 this month appears stable, but if last month was 31 days and this month is 30 days, velocity actually declined from 9.68 to 10 units/day. The increase masks a concerning trend if you don't normalize to daily rates.
Mistake 2: Ignoring weekend patterns — Many categories (home goods, kitchen items) see 40-60% higher weekend sales. If you calculate velocity on Thursday using the past seven days, you're overweighting weekdays. Always include at least two full weekends in velocity calculations, or track weekday velocity and weekend velocity separately.
Mistake 3: Not segmenting by fulfillment method — FBA and FBM units for the same ASIN have different velocity patterns. FBA typically has higher velocity due to Prime eligibility. If you switch 30% of inventory from FBA to FBM to reduce storage fees, your overall velocity will drop even if demand stays constant. Track FBA velocity and FBM velocity separately.
Mistake 4: Comparing velocity across different price points without normalization — A $15 product selling 20 units/day and a $150 product selling 3 units/day have similar revenue velocity ($300/day vs $450/day) despite very different unit velocity. When comparing products for inventory investment decisions, use revenue velocity or contribution margin velocity, not just units.
Mistake 5: Reacting to single-day velocity spikes — One Lightning Deal can generate 200 units in a day, artificially inflating your seven-day velocity for a week. Exclude promotion days from velocity calculations, or track "base velocity" (non-promotion days only) separately from "total velocity" (all days included).
Advanced Velocity Metric: Acceleration Rate
Once you've tracked velocity for 90+ days, calculate acceleration — the rate at which velocity itself is changing. This predicts future inventory needs more accurately than static velocity.
Velocity Acceleration = (Current Week Velocity - Previous Week Velocity) ÷ Previous Week Velocity
Positive acceleration (velocity increasing week over week) means you should order more aggressively than current velocity suggests. Negative acceleration means reduce order quantities even if absolute velocity still looks healthy.
Example: Product velocity is currently 12 units/day, up from 10 units/day last week (20% acceleration). Your 30-day lead time order should account for continued acceleration: order as if velocity will be 14-15 units/day by the time inventory arrives, not 12.
This prevents the common scenario where sellers order based on current velocity, but by the time inventory arrives 30-45 days later, demand has increased and they immediately stock out again.
Velocity Tracking Checklist
Implement these actions this week:
- Choose your tracking method based on the decision matrix above (manual, Business Reports, or third-party software)
- Download 90 days of historical data from Business Reports → Detail Page Sales and Traffic by Child Item
- Calculate baseline seven-day and 30-day velocity for each SKU using the formulas in this guide
- Set up your tracking system (spreadsheet template or software dashboard) and input baseline data
- Define your personal thresholds: what velocity decline percentage triggers a promotion? What acceleration rate triggers increased PPC spend?
- Add a weekly calendar reminder to review velocity trends and adjust inventory/PPC decisions accordingly
- After 30 days, review which SKUs had the largest velocity changes and correlate those changes with Buy Box percentage shifts
Sales velocity tracking turns reactive inventory management into predictive planning. The products you order today should reflect velocity trends from the past 30 days and projected acceleration over your lead time, not just last month's total sales. Sellers who track velocity proactively maintain higher Buy Box percentages, avoid stockouts during growth periods, and reduce excess inventory when demand softens.
