What does Whitelisting, Attribution and Dual-Track Fees conclude, in numbers, about “Whitelist Amplification: Paid-to-Organic Spillover, Mega-Sale Confounding and Marginal Return”?
Answer: The net spillover \(\rho\) of whitelisting is set by two forces, interception and spillover, and can be positive or negative. In the illustrative model, interception of three tenths with no spillover leaves a true return of only 2.240, below the line; moderate spillover brings it back to 3.508; small interception with strong spillover lifts it to 5.416. Measuring spillover during a mega-sale by before and after reads +0.037 in a world with no spillover and +0.340 in a world whose true \(\rho\) is +0.102; difference-in-differences reads -0.201 and +0.104, close to the truth. On a saturating curve the marginal ROAS may have fallen through the line long before the average ROAS does; the best spend is RM 1,273 a day, while adding budget by average ROAS goes on all the way to RM 2,806.
Scope of the numbers: Chapter 1 takes apart an illustrative order priced at RM 59.90: the goods margin is 0.6837, but after platform fees, returns and refused cash-on-delivery parcels the contribution rate is 0.3467. The book is not financial, legal or tax advice and promises no income or return.
Data table
The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: -0.201, 0.037, 0.102, 0.104, 0.340
| g | 0.0: true rho -0.200 | before-after +0.037 | diff-in-diff -0.201 (sd 0.059) |
| share of campaigns where before-after reads rho > 0.2 | 0.000 |
| g | 0.4: true rho +0.102 | before-after +0.340 | diff-in-diff +0.104 (sd 0.062) |
| share of campaigns where before-after reads rho > 0.2 | 0.992 |
Show the full program
# Chapter 3. p32: why a before-and-after reading of "organic lift" is confounded by a mega-sale.
# One treated SKU is whitelisted for 21 days (days 28..48); a mega-sale lifts organic demand of
# EVERY SKU by 1.6 on days 35..41. Eight untreated sibling SKUs serve as controls. Cannibalisation
# c = 0.2. Spillover g is either 0 (none) or 0.4. 2,000 simulated campaigns, fixed seed.
import math
import random
rng = random.Random(351)
PAID, LAM, BASE, DAYS, START, STOP = 33.7, 0.90, 40.0, 49, 28, 49
C, N_CTRL, RUNS = 0.2, 8, 2000
def demand(d):
return BASE * (1.6 if 35 <= d <= 41 else 1.0)
def mean_path(g, treated):
a, out = 0.0, []
for d in range(DAYS):
paid = PAID if (treated and START <= d < STOP) else 0.0
a = LAM * a + (1.0 - LAM) * paid / BASE
out.append(demand(d) * (1.0 + g * a) - C * paid)
return out
def draw(mu):
return max(0.0, round(rng.gauss(mu, math.sqrt(max(mu, 1.0)))))
def window(xs, lo, hi):
return math.fsum(xs[lo:hi]) / (hi - lo)
paid_n = PAID * (STOP - START)
for g in (0.0, 0.4):
t_mu, c_mu = mean_path(g, True), mean_path(g, False)
true_rho = math.fsum(t_mu[d] - c_mu[d] for d in range(START, STOP)) / paid_n
naive, did = [], []
for _ in range(RUNS):
t = [draw(m) for m in t_mu]
ctrl = [[draw(m) for m in c_mu] for _ in range(N_CTRL)]
cbar = [math.fsum(row[d] for row in ctrl) / N_CTRL for d in range(DAYS)]
dt = window(t, START, STOP) - window(t, 0, START)
dc = window(cbar, START, STOP) - window(cbar, 0, START)
naive.append(dt * (STOP - START) / paid_n)
did.append((dt - dc) * (STOP - START) / paid_n)
mn, md = math.fsum(naive) / RUNS, math.fsum(did) / RUNS
sd = math.sqrt(math.fsum((x - md) ** 2 for x in did) / (RUNS - 1))
hi_share = sum(1 for x in naive if x > 0.2) / RUNS
print("g = {:.1f}: true rho {:+.3f} | before-after {:+.3f} | diff-in-diff {:+.3f} (sd {:.3f})".format(
g, true_rho, mn, md, sd))
print(" share of campaigns where before-after reads rho > 0.2: {:.3f}".format(hi_share))Single source and citation
Fan, Y. (2026). Southeast Asian Social-Commerce Whitelist Amplification, Cross-Channel Attribution and Dual-Track Commission Growth (Version 1.0.0), Chapter 3: Whitelist Amplification: Paid-to-Organic Spillover, Mega-Sale Confounding and Marginal Return. 5D Library. DOI pending
DOI pending · monograph page goes live after publication · 5DL-B-351 · v1.0.0 · CC-BY-NC-ND-4.0
BibTeX
@book{fan2026351,
author = {Fan, Yafu},
title = {Southeast Asian Social-Commerce Whitelist Amplification, Cross-Channel Attribution and Dual-Track Commission Growth},
year = {2026},
publisher = {5D Library},
edition = {1.0.0},
note = {DOI pending}
}Other chapter answers in this book
- Chapter 1 · The Account of One Order: Platform Fees, Returns and Cash on Delivery
- Chapter 2 · The Break-Even Point of Advertising: Contribution Rate, Sensitivity and Four Routes
- Chapter 4 · Attribution Stacking: Double Counting On and Off the Platform, Deduplication Rules and the Sum of ROAS
- Chapter 5 · Incrementality Experiments: Holdouts, Geographic Tests and the Shapley Split
- Chapter 6 · The Dual-Track Contract: Fixed Licensing Fee, Tiered Commission and the Arithmetic of Principal and Agent
- Chapter 7 · The Classics Examined: Bai Gui, the Fair Merchant, the Commenda and Adam Smith
- Chapter 8 · The Conversion Tool: Break-Even, Attribution Dedup and Dual-Track Contract Calculator, with a Pre-Registered Test