5D Library › Order-Bump Friction Elasticity, One-Click Upsell Kinetics and Cross-Domain Recommendation Matrices · 中文
Chapter 4. Order-Value Multipliers and Bundle Pricing
Decomposing the multiplier
The average order value multiplier = 1 + the sum over bumps of (take rate × price ratio) + upsell acceptance × step-up ratio. One can therefore ask in reverse: what take rate does a claimed lift require?
Calculation
# Chapter 4. p07: What it takes to lift average order value by 22-48%.
# AOV multiplier = 1 + sum over bumps of (take x price ratio) + (upsell
# acceptance x step-up ratio). We solve for the take rate a single bump
# needs at a given price ratio, and list combinations of p02 and p03.
def needed_take(lift, ratio):
return lift / ratio
if __name__ == "__main__":
print(" target lift ratio 0.25 ratio 0.45 ratio 0.55")
for lift in (0.22, 0.30, 0.48):
row = [needed_take(lift, r) for r in (0.25, 0.45, 0.55)]
print(" {:11.0%} ".format(lift) + " ".join(
"{:10.3f}".format(x) if x <= 1 else "{:>10s}".format("impossible")
for x in row))
combos = (("one bump (p01)", 0.499 * 0.451),
("two bumps (p02)", 0.501 * 44 / 98 + 0.505 * 29 / 98),
("two bumps + upsell (p03)",
0.501 * 44 / 98 + 0.505 * 29 / 98 + 0.13 * 300 / 98))
for name, x in combos:
print(" {:26s} AOV multiplier {:.3f}".format(name, 1 + x))
# target lift ratio 0.25 ratio 0.45 ratio 0.55
# 22% 0.880 0.489 0.400
# 30% impossible 0.667 0.545
# 48% impossible impossible 0.873
# one bump (p01) AOV multiplier 1.225
# two bumps (p02) AOV multiplier 1.374
# two bumps + upsell (p03) AOV multiplier 1.772For a single bump to add 22% to order value, a price ratio of 0.45 needs a take rate of 0.489, a ratio of 0.25 needs 0.880; a 48% lift is impossible at ratios 0.25 or 0.45 (the required take rate exceeds 1) and needs 0.873 at a ratio of 0.55. Combining the previous two chapters, one bump gives a multiplier of 1.225, two bumps 1.374, and two bumps plus the post-payment upsell 1.772. A claim such as “22% to 48%” must therefore say which steps make it up.
Bundle price or checkout bump
Putting the same two items on the product page as a bundle (main item alone RM 98, both together RM 128), or adding the second at checkout (main RM 98, bump RM 44): which is better? This is Adams and Yellen’s mixed-bundling problem (Adams and Yellen 1976).
Calculation
# Chapter 4. p08: A discounted bundle on the product page, or a bump at
# checkout? Values of main item and add-on (lognormal, medians 120 and
# 45, log-s.d. 0.8, correlation rho). Strategy 1: main RM 98 + bump
# RM 44 at checkout. Strategy 2: mixed bundling - main RM 98 alone or
# both for RM 128. Revenue per visitor (Adams and Yellen 1976 logic).
import random
from math import exp, sqrt
def sim(rho, n=200000, seed=78008):
rng = random.Random(seed)
bump = bundle = 0.0
for _ in range(n):
z0 = rng.gauss(0, 1)
z1 = rho * z0 + sqrt(1 - rho * rho) * rng.gauss(0, 1)
vm, va = 120 * exp(0.8 * z0), 45 * exp(0.8 * z1)
if vm > 98:
bump += 98 + (44 if va > 44 else 0)
s_alone, s_both = vm - 98, vm + va - 128
if max(s_alone, s_both) > 0:
bundle += 128 if s_both >= s_alone else 98
return bump / n, bundle / n
if __name__ == "__main__":
print(" rho bump at checkout mixed bundle")
for rho in (-0.5, 0.0, 0.5, 0.9):
a, b = sim(rho)
print(" {:4.1f} {:16.2f} {:12.2f}".format(rho, a, b))
# rho bump at checkout mixed bundle
# -0.5 68.92 95.83
# 0.0 72.48 88.85
# 0.5 76.03 84.16
# 0.9 79.90 80.97In the illustrative model the bundle always earns more per visitor than the checkout bump: RM 88.85 against RM 72.48 with uncorrelated valuations; RM 95.83 against RM 68.92 with negative correlation (−0.5); close with strong positive correlation (0.9), RM 80.97 against RM 79.90. The bundle can also sell to visitors who would not pay RM 98 for the main item alone but value the pair at RM 128, while the checkout bump only reaches those who have already decided on the main item.
Hypothesis · not established
The author’s hypothesis (not yet tested): for the author’s report products, offering a product-page bundle and a checkout bump together earns more than offering either alone. What would show it wrong: if, in a three-arm randomised test, “both” does not earn significantly more than the better single option, the hypothesis fails.
Summary
The order-value multiplier is a sum of “take rate × price ratio” over steps; a 48% lift is nearly impossible from one bump alone. In the illustrative model, a product-page bundle also sells to visitors who find value only in the pair, and earns more than a checkout bump.
References
Fan, Y. (2026). Order-Bump Friction Elasticity, One-Click Upsell Kinetics and Cross-Domain Recommendation Matrices: Zero-Reentry Impulse Attachment, Conditional Mutual Information and Cart-Value Multipliers [结账顺手加购弹性、一键升单动力学与跨领域推荐矩阵] (Version 1.0.0). 5D Library. https://doi.org/10.5281/zenodo.24090207 · Licensed under Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0).