BFCM tier-sizing worksheet

Size a full-price gift-tier offer from your own order data.

The question

“If you stop discounting, what do you give customers on Black Friday instead?”

The assignment

Group a full-price month's orders by value, find the median order and the average item price, and set your first gift rung about one item above the median.

The whole write-up →

Size any gift tiers from orders placed at full price, because a discount inflates the basket you would be measuring. The first rung sits about one average item above the median order; the second where your top tenth begins.

01A recent full-price month
02Orders in that month
03Median order value at list price
$
04Average item price
$
05Where the top tenth of orders begins
$
06First rung (leave blank to use median + one item)
$
07Second rung (leave blank to use the top tenth)
$
08Gift card value on the first rung
$
09Expected redemption
%
10Share of orders expected to land on the first rung
%
11What this year's discount cost, as a share of list price
%
12Redemption rules, written before the creative

What your numbers say

First rung $0, second rung $0. The gift costs about $0 per order across all orders, NaN% of the median order, against 0% for this year's discount.

0 of 12 answered · kept in this browser only until you save.

Have a brand in mind?Ask Alen about your brand →