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 ρ\rho 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,331

At ρ\rho = 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 ρ\rho = 0.1 the cut is 0.657, at ρ\rho = 0.3 only 0.333, and at ρ\rho = 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.

Mean and standard deviation for different head shares w (p06).

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 ww 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.158

At ρ\rho = 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.

Variance cut of the 20/80 plan relative to all-head, as the correlation changes (p06).

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

Markowitz, Harry. 1952. “Portfolio Selection.” The Journal of Finance 7 (1): 77 to 91.

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).