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

g0.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.20.000
g0.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.20.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