What does Reactivation, Thresholds and Flash Clearance conclude, in numbers, about “The Incremental Ledger of a Reactivation Coupon: Survival, Leakage to Sure Returners and the Coupon Band”?

Answer: A reactivation coupon has four destinations, and only one of them is incremental. Regulars who have just ordered are the most likely to come back anyway, so a coupon sent to them is mostly a gift. Long-dormant regulars are unlikely to be alive, so a coupon sent to them is mostly a leaflet into an empty room. Incremental value peaks in the middle band: under illustrative parameters a coupon of RM 6 pays only for gap ratios between 0.85 and 11.37, and the band is narrower for regulars with clearer rhythms. Redemption accounting overstates the increment more than tenfold, so one group must always receive nothing.

Scope of the numbers: Parameters are illustrative and correspond to no real customer, order or supplier of HOMIE-X, every price in the book is illustrative, and all calculations are generated by the book's programs. This is general business analysis, not personalised business, tax or legal advice.

中文版

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.85, 11.37

gP_aliveanyway blift ugainleaknet RM
0.00.8500.2830.1081.4871.442-0.205
0.50.8030.2640.1101.4491.272-0.074
1.00.7490.2480.1131.3931.1150.028
2.00.6330.2210.1171.2420.8380.154
3.00.5150.1990.1201.0680.6150.203
4.00.4080.1810.1230.8970.4430.204
6.00.2470.1530.1270.6220.2270.145
9.00.1170.1250.1310.3860.0870.049
12.00.0590.1050.1340.2780.037-0.010
16.00.0270.0870.1370.2150.014-0.049
coupon RM 6: net > 0 for g in [0.85, 11.37], best g 3.49, 0.208 RM per send
coupon RM 4: net > 0 for g in [0.00, 14.34], best g 1.68
coupon RM 8: no gap ratio pays
KAPPA2.0: net > 0 for g in [0.29, 20.00], best 3.64
KAPPA7.0: net > 0 for g in [1.83, 6.89], best 3.64
KAPPA 11.0: no gap ratio pays
Show the full program
# Chapter 3. p31: incremental value of one reactivation coupon by gap.
# Gap ratio g = days since the last order / the buyer's shrunk personal
# median gap (p12). A live buyer orders as a Poisson process whose rate
# lam is uncertain: lam ~ Gamma(KAPPA, KAPPA / LAM0), LAM0 = ln 2 (median
# gap 1), KAPPA = n + K0 = 4 (one own gap plus the K0 = 3 of p12).
# After an order she stays active with probability PI = 0.85.
#   L(g)    = (1 + g LAM0 / KAPPA) ** -KAPPA     P(no order by g | live)
#   P_alive = PI L / (PI L + 1 - PI)
#   b       = 1 - ((KAPPA/LAM0 + g) / (KAPPA/LAM0 + g + W)) ** KAPPA
#             (a live buyer orders in the next window anyway)
#   u       = THETA (1 - b)       coupon converts some who would not
#   net     = P_alive (u (m - c) - b c) + (1 - P_alive) RHO (m - c) - s
# Illustrative: window W = 0.5 median, THETA 0.15, a lapsed buyer comes
# back on a coupon with RHO 0.01, margin m RM 22, coupon c RM 6, and s =
# RM 0.25 per touch (message credits and opt-out risk, illustrative).
import math

PI, THETA, RHO, W, SEND = 0.85, 0.15, 0.01, 0.5, 0.25
KAPPA, LAM0 = 4.0, math.log(2.0)
M, C = 22.0, 6.0


def parts(g, m=M, c=C, kappa=KAPPA):
    beta = kappa / LAM0
    lg = (beta / (beta + g)) ** kappa
    pa = PI * lg / (PI * lg + 1.0 - PI)
    b = 1.0 - ((beta + g) / (beta + g + W)) ** kappa
    u = THETA * (1.0 - b)
    gain = pa * u * (m - c) + (1.0 - pa) * RHO * (m - c)
    leak = pa * b * c
    return pa, b, u, gain, leak, gain - leak - SEND


def band(c=C, kappa=KAPPA):
    grid = [i / 100.0 for i in range(0, 2001)]
    pos = [g for g in grid if parts(g, c=c, kappa=kappa)[5] > 0.0]
    best = max(grid, key=lambda g: parts(g, c=c, kappa=kappa)[5])
    return pos, best


if __name__ == "__main__":
    print("   g  P_alive  anyway b  lift u   gain   leak  net RM")
    for g in (0.0, 0.5, 1.0, 2.0, 3.0, 4.0, 6.0, 9.0, 12.0, 16.0):
        pa, b, u, gain, leak, net = parts(g)
        print("{:>4}   {:.3f}    {:.3f}    {:.3f}   {:.3f}  {:.3f}  {:6.3f}"
              .format(g, pa, b, u, gain, leak, net))
    pos, best = band()
    print("coupon RM 6: net > 0 for g in [{:.2f}, {:.2f}], best g {:.2f},"
          " {:.3f} RM per send".format(pos[0], pos[-1], best,
                                       parts(best)[5]))
    for c in (4.0, 8.0):
        pos, best = band(c=c)
        if pos:
            print("coupon RM {:.0f}: net > 0 for g in [{:.2f}, {:.2f}],"
                  " best g {:.2f}".format(c, pos[0], pos[-1], best))
        else:
            print("coupon RM {:.0f}: no gap ratio pays".format(c))
    for kappa in (2.0, 7.0, 11.0):
        pos, best = band(kappa=kappa)
        if not pos:
            print("KAPPA {:>4.1f}: no gap ratio pays".format(kappa))
            continue
        print("KAPPA {:>4.1f}: net > 0 for g in [{:.2f}, {:.2f}], best {:.2f}"
              .format(kappa, pos[0], pos[-1], best))

Single source and citation

Fan, Y. (2026). Repeat-Buyer Reactivation in Private-Channel Commerce, Threshold Bundle Margin Design and Flash-Clearance Dynamics (Version 1.0.0), Chapter 3: The Incremental Ledger of a Reactivation Coupon: Survival, Leakage to Sure Returners and the Coupon Band. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-353 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026353,
  author    = {Fan, Yafu},
  title     = {Repeat-Buyer Reactivation in Private-Channel Commerce, Threshold Bundle Margin Design and Flash-Clearance Dynamics},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book