Free shipping threshold
Compares profit at two free shipping thresholds by the distribution of checks and not by the average check: how many orders stop being free and how much money that saves, what share of customers from the band under the new threshold will add items to reach it (catch-up) and what margin this gives, how many orders are lost because of the new delivery fee. Runs through the thresholds at band boundaries and shows the best.
At a glance
- What question does it answer?
- Which free shipping threshold gives the highest profit per order at your distribution of checks.
- What data is needed?
- The distribution of checks by band.
- How to read the result?
- Compare the saving, catch-up and losses by threshold: a profitable threshold is where the delivery saving exceeds the lost margin. Example on the default values: Free orders: now: 60%; Free orders: after the change: 42.5%; Delivery saving per order: RUB 52.5; Catch-up margin per order: RUB 18. The figures are illustrative: enter your own to see your result.
Why and how to reason
The free shipping threshold changes three things at once: how many orders are free, how many customers add items to reach the threshold and how many leave because of the fee. In the example moving the threshold 3,000 → 4,000 cuts the share of free orders from 60% to 42.5%: a saving of RUB 52.50 and a catch-up margin of RUB 18 minus losses of RUB 16.80 give +RUB 53.70 per order.
When to use it
Apply when setting or changing the delivery threshold, relying on the distribution of checks and not the average check.
How to read the result
Look at the saving, catch-up and losses separately and at the best threshold among band bounds.
Common mistakes
They rely on the average check and ignore the loss of conversion.
What data is needed?
- The distribution of checks by band.
- The delivery cost for the shop.
- The share catching up, the added check, margin and the share of lost orders from a test.
- An example: bands <2,000: 15%, 2–3 thou.: 25%, 3–4: 25%, 4–5: 15%, ≥5: 20%, delivery RUB 300, threshold 3,000 → 4,000: free orders 60% → 42.5%, +RUB 53.7 per order (illustrative numbers).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Delivery cost for the shop | ₽ | 300 | What the delivery of one order costs you when it is free for the customer. The example value is illustrative. |
| Current free shipping threshold | ₽ | 3,000 | Must coincide with the lower bound of one of the bands in the table. The example value is illustrative. |
| New threshold | ₽ | 4,000 | Also a band lower bound. If equal to the current one, there is no change. The example value is illustrative. |
| Share of catching up from the band under the new threshold | % | 30 | What part of orders from the band right under the threshold will add items to reach it: from a test or past threshold changes. The example value is illustrative. |
| By how much the catching-up customer raises the check | ₽ | 600 | The average amount they add. The example value is illustrative. |
| Margin on the added item | % | 40 | The margin on the added amount. The example value is illustrative. |
| Share of lost orders among those who start to pay | % | 8 | How many customers will leave because of the new delivery fee. The example value is illustrative. |
| Margin of a lost order | ₽ | 1,200 | The average margin of an order from these bands. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Free at the threshold | the share of orders with a check not below the threshold; at the new threshold plus the share of catching up from the band under it |
| Saving | (free before − free after) × delivery cost |
| Catch-up | share catching up × share of the band under the threshold × added check × margin |
| Losses | share lost × share starting to pay × order margin |
| Result | saving + catch-up − losses |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Free orders: now
- 60 %
- Free orders: after the change
- 42.5 %With the catch-up.
- Delivery saving per order
- 52.5 ₽
- Catch-up margin per order
- 18 ₽
- Losses from paid delivery per order
- −16.8 ₽
- Change in profit per order
- +53.7 ₽
- Change in profit per 1,000 orders
- +53,700 ₽
- Best threshold among band bounds
- 5,000 ₽Change per order 83.22 ₽.
Data as a table
| Measure | Change per order |
|---|---|
| 2,000 | −77.7 |
| 3,000 | 0 |
| 4,000 | 53.7 |
| 5,000 | 83.2 |
Thresholds at band bounds
| Threshold | Free orders | Saving per order | Catch-up per order | Losses per order | Change per order |
|---|---|---|---|---|---|
| 2,000 | 89.5 % | −88.5 ₽ | 10.8 ₽ | −0 ₽ | −77.7 ₽ |
| 3,000 | 60 % | 0 ₽ | 0 ₽ | −0 ₽ | 0 ₽ |
| 4,000 | 42.5 % | 52.5 ₽ | 18 ₽ | −16.8 ₽ | 53.7 ₽ |
| 5,000 | 24.5 % | 106.5 ₽ | 10.8 ₽ | −34.08 ₽ | 83.22 ₽ |
Among the band bounds a threshold of 5,000 ₽ is better: 83.22 ₽ per order.
The model is simple: the distribution of checks is taken at the current threshold, the catch-up is counted only for the band under the new threshold, the losses only for those who start to pay. Check the threshold with a test on part of the traffic.
What to do with the result: the threshold must be clear to the buyer and not above the threshold of competitors on platforms; take paid delivery to the pickup point into account.
A typical mistake: relying on the average check and not the distribution, and ignoring the loss of conversion.
Nuances and limits
- Relying on the average check and not on the distribution.
- Ignoring the loss of conversion.
- Changing the threshold without a test on part of the traffic.