What trend means, next to seasonality and one-off peaks
Seasonality recurs around comparable periods. Trend is a sustained change beyond that pattern. See Seasonality.
A one-off sales spike during a promotion or a stockout needs context before you treat it as a lasting upward trend.
How Optiply calculates the revenue-based trend
Optiply takes the revenue of the latest 30-day window and compares it with the first 30-day window. The first 30-day window starts at the earliest sale in the history Optiply queries, which covers up to 396 days. A shop whose sales history starts later gets a later first window.
The revenue calculation uses up to 396 days of sales history, so the first 30-day window moves as older sales leave the calculation. The first 30-day window is not automatically the preceding month or an exact calendar-year comparison.
Revenue combines quantities and selling values. A change in price or assortment can therefore affect the revenue-based trend even when the number of units sold tells a different story.
Optiply also uses sales history in forecasting. The forecast for a product can include a trend of its own, based on that product's own demand history. Keep the two uses separate: the revenue-based trend describes a comparison of past revenue. When you review one product, use its sales and stock history alongside the forecast instead of applying the assortment-wide revenue-based trend to it.
Example: revenue-based trend when 30-day revenue goes from €8,000 to €10,000
This example uses made-up numbers. A webshop for garden tools looks at its revenue-based trend, for the same assortment and currency in both windows:
- Revenue in the first 30-day window: €8,000
- Revenue in the latest 30 days: €10,000
The example requires a positive revenue in the first 30-day window. You cannot interpret a zero-revenue first window in this way. If revenue in the latest window is zero, the trend shows −100% against a positive first window.
- Divide €10,000 by €8,000:
1.25. - Subtract 1:
0.25. - Multiply by 100: the revenue-based trend is 25%.
Revenue is 25% higher than in the first 30-day window.
Now the latest 30 days bring in €6,000 instead of €10,000. The calculation is 6,000 ÷ 8,000 = 0.75, and minus 1 is −0.25. The revenue-based trend is therefore −25%: revenue is 25% lower than in the first 30-day window.
Before you act on either figure, open the product's sales and stock history and check what is behind the change.
Where to see trend in Optiply
Use the product's demand forecast and stock-history views to investigate a changing demand pattern. See Demand forecast and product stock history.
Home does not have a separate Trend KPI card. Check the measure and the comparison period of a report before you compare its percentage with another screen.
How to check whether a change in demand is a trend
- Open the product's demand forecast and stock-history views.
- Check whether the change in demand continues across the relevant history.
- Look for promotions, price changes, missing history and periods without available stock. See Promotions.
- Compare like-for-like products and periods before you change your plan.
How the revenue-based trend differs from a forecast and an order
- Revenue-based trend and forecast. The percentage by which a product forecast or a purchase order increases is a different number from the revenue-based trend. A unit-demand growth forecast is also a different number.
- Trend and orders. Trend is not a direct order trigger, and a revenue-based trend of 25% is not a quantity to buy. Demand does not have to rise another 25%, and an order does not need 25% more stock.