5D Library › Affiliate Network Power Laws, Influencer Portfolio Optimization and Incentive Stability Bounds · 中文
Chapter 3. Mean-Variance Allocation across a Creator Portfolio
How much does “20% head, 80% micro” cut the swings?
Markowitz’s portfolio theory shows that spreading money across assets that are not highly correlated can lower volatility at a similar expected return (Markowitz 1952). Applied to creator marketing, a common claim is that putting 20% of the budget on head creators and 80% across many micro creators cuts the variance of customer acquisition cost (CAC) by more than 60%. p05 compares two plans for a budget of a hundred thousand ringgit a month: all of it to two head creators, or one head creator plus thirty-two micro creators. All creators share a common factor (platform algorithm, season, news), and is the correlation between any two creators’ log customer counts.
Calculation
# Chapter 3. p05: Head creators or many micro creators? A month's budget
# of RM 100,000. Customers per RM 10,000 of spend are lognormal: head
# creators mean 25 with coefficient of variation 1.2, micro creators
# mean 28 with CV 1.5. All creators share a common factor F (platform
# algorithm, season, news): log outcome = mu + sigma (sqrt(rho) F +
# sqrt(1 - rho) e), so rho is the correlation between any two creators'
# log outcomes. Plan A: two head creators at RM 50,000 each. Plan B: one
# head creator at RM 20,000 and 32 micro creators at RM 2,500 each.
# 20,000 simulated months per rho, seed 87.
import random
from math import exp, log, sqrt
def params(mean, cv):
s2 = log(1 + cv * cv)
return log(mean) - s2 / 2, sqrt(s2)
HEAD, MICRO = params(25.0, 1.2), params(28.0, 1.5)
def draw(rng, p, f, rho):
mu, s = p
return exp(mu + s * (sqrt(rho) * f + sqrt(1 - rho) * rng.gauss(0, 1)))
def month(rng, rho, plan):
f = rng.gauss(0, 1)
if plan == "A":
return sum(5.0 * draw(rng, HEAD, f, rho) for _ in range(2))
return 2.0 * draw(rng, HEAD, f, rho) + sum(
0.25 * draw(rng, MICRO, f, rho) for _ in range(32))
def stats(xs):
m = sum(xs) / len(xs)
v = sum((x - m) ** 2 for x in xs) / (len(xs) - 1)
cac = sorted(100000.0 / max(x, 1.0) for x in xs)
return m, v, cac[len(xs) // 2], cac[int(0.9 * len(xs))]
if __name__ == "__main__":
rng = random.Random(87)
print(" rho plan customers sd variance CAC median CAC 90th")
print(" mean cut (RM) (RM)")
for rho in (0.0, 0.1, 0.3, 0.5):
out = {}
for plan in ("A", "B"):
out[plan] = stats([month(rng, rho, plan) for _ in range(20000)])
for plan in ("A", "B"):
m, v, med, p90 = out[plan]
cut = 1 - v / out["A"][1]
print(" {:3.1f} {} {:9.0f} {:5.0f} {:8.3f} {:10,.0f}"
" {:8,.0f}".format(rho, plan, m, sqrt(v), cut, med, p90))
# rho plan customers sd variance CAC median CAC 90th
# mean cut (RM) (RM)
# 0.0 A 250 209 0.000 520 1,274
# 0.0 B 274 86 0.833 386 528
# 0.1 A 249 215 0.000 530 1,354
# 0.1 B 274 126 0.657 404 683
# 0.3 A 250 235 0.000 550 1,486
# 0.3 B 277 192 0.333 440 978
# 0.5 A 250 259 0.000 564 1,632
# 0.5 B 273 253 0.048 497 1,331At = 0 the spread plan cuts the variance by 0.833, indeed more than 60%, and the mean number of customers is slightly higher (274 against 250); the 90th percentile of CAC falls from 1,274 ringgit to 528. But at = 0.1 the cut is 0.657, at = 0.3 only 0.333, and at = 0.5 there is almost no effect (0.048). Spreading removes only the creators’ own swings, not the common factor; when the platform changes its algorithm, thirty-two creators get worse together.
The exact frontier and the estimated one
p06 computes the mean and standard deviation exactly, using the covariance formula for lognormal variables, as the head share runs from 0 to 1, and then supposes that a firm has only twelve months of data and picks the minimum-variance share from its sample variance.
Calculation
# Chapter 3. p06: The mean-variance frontier of p05, worked exactly, and
# what happens when it is estimated from a year of data. A share w of
# RM 100,000 goes to two head creators, the rest to 32 micro creators.
# For lognormal outcomes with log correlation rho, cov(X, Y) =
# m_x m_y (exp(rho s_x s_y) - 1). Then a firm that sees only 12 months
# of the two totals picks the minimum-variance w from its sample
# covariance; 2,000 such firms, rho = 0.1, seed 87.
import importlib.util
import random
from math import exp, sqrt
def load(name):
spec = importlib.util.spec_from_file_location(name, name + ".py")
m = importlib.util.module_from_spec(spec)
spec.loader.exec_module(m)
return m
p05 = load("p05_kol_portfolio")
GRID = [i / 10 for i in range(11)]
def moments(w, rho):
(mh, sh), (mm, sm) = p05.HEAD, p05.MICRO
eh, em = exp(mh + sh * sh / 2), exp(mm + sm * sm / 2)
items = [(5.0 * w, eh, sh)] * 2 + [(10.0 * (1 - w) / 32, em, sm)] * 32
mean = sum(c * e for c, e, _ in items)
var = 0.0
for i, (ci, ei, si) in enumerate(items):
for j, (cj, ej, sj) in enumerate(items):
r = 1.0 if i == j else rho
var += ci * cj * ei * ej * (exp(r * si * sj) - 1)
return mean, sqrt(var)
def totals(rng, rho):
f = rng.gauss(0, 1)
h = sum(5.0 * p05.draw(rng, p05.HEAD, f, rho) for _ in range(2))
m = sum(10.0 / 32 * p05.draw(rng, p05.MICRO, f, rho)
for _ in range(32))
return h, m
if __name__ == "__main__":
print(" head share w mean sd (rho 0.1) sd (rho 0.3)")
for w in GRID:
m1, s1 = moments(w, 0.1)
_, s3 = moments(w, 0.3)
print(" {:12.1f} {:5.0f} {:12.0f} {:13.0f}".format(
w, m1, s1, s3))
best = min(GRID, key=lambda w: moments(w, 0.1)[1])
print(" true minimum-variance share at rho 0.1: {:.1f}".format(best))
rng = random.Random(87)
picks = []
for _ in range(2000):
data = [totals(rng, 0.1) for _ in range(12)]
def sd_hat(w):
xs = [w * h + (1 - w) * m for h, m in data]
mu = sum(xs) / 12
return sum((x - mu) ** 2 for x in xs)
picks.append(min(GRID, key=sd_hat))
picks.sort()
worse = sum(1 for w in picks
if moments(w, 0.1)[1] > 1.2 * moments(best, 0.1)[1])
print(" chosen from 12 months: median {:.1f}, 10% to 90% {:.1f} to"
" {:.1f}".format(picks[1000], picks[200], picks[1800]))
print(" firms whose pick has sd 20% above the best: {:.3f}"
.format(worse / 2000))
# head share w mean sd (rho 0.1) sd (rho 0.3)
# 0.0 280 123 194
# 0.1 277 118 189
# 0.2 274 118 185
# 0.3 271 122 184
# 0.4 268 129 186
# 0.5 265 140 189
# 0.6 262 153 194
# 0.7 259 167 202
# 0.8 256 184 211
# 0.9 253 201 222
# 1.0 250 219 234
# true minimum-variance share at rho 0.1: 0.2
# chosen from 12 months: median 0.2, 10% to 90% 0.0 to 0.6
# firms whose pick has sd 20% above the best: 0.158At = 0.1 the true minimum-variance share is exactly 0.2, with a standard deviation of 118, against 219 with everything on head creators. But picking from twelve months of data, although the median pick is 0.2, eight firms in ten land anywhere from 0 to 0.6, and 0.158 of firms pick a plan whose standard deviation is more than a fifth above the best. Twelve months of heavy-tailed data are not enough to estimate variance reliably.
Hypothesis · not established
The author’s interpretation (not yet tested): on Southeast Asian short-video and live-commerce platforms, the correlation of monthly customer counts between micro creators is below 0.1, so a 20/80 head-to-micro allocation cuts the variance of monthly customers by more than 60%. What would show it wrong: in at least twenty-four months of campaign data, the average correlation of monthly log customer counts between micro creators is above 0.2, or the spread allocation cuts variance by less than 40%.
Summary
“20% head, 80% micro, variance down 60%” holds only when the correlation between creators is below about 0.1; the stronger the common factor, the smaller the benefit of spreading. The minimum-variance share happens to be about 20% under the illustrative settings, but a year of data can hardly pin it down.
References
Fan, Y. (2026). Affiliate Network Power Laws, Influencer Portfolio Optimization and Incentive Stability Bounds: Heavy-Tailed Productivity, Markowitz Traffic Allocation and Single-Tier Commission Equilibria [分销网络幂律激活、网红矩阵组合优化与激励稳定边界] (Version 1.0.0). 5D Library. https://doi.org/10.5281/zenodo.24090229 · Licensed under Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0).