What does Reactivation, Thresholds and Flash Clearance conclude, in numbers, about “Buy-Till-You-Die: the Probability of Being Alive and Next Quarter's Expected Orders”?

Answer: The most striking part of the table is its lower right corner. A customer with 12 repeat purchases still has a 0.583 probability of being alive after 8 weeks of silence, but this falls to 0.126 after 14 weeks and to 0.009 after 20 weeks. A customer with a single repeat purchase still has 0.587 after 20 weeks of silence and 0.314 after 34 weeks. The second table compresses the point into one column: the silence needed before the probability of being alive drops below one half is 26 weeks for one repeat purchase, 21 weeks for two, 16 weeks for four, only 12 weeks for eight and only 9 weeks for twelve.

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.009, 0.126, 0.314, 0.583, 0.587, 12

P(alive) at the end of a 39-week window
weeks silent0 4 8 14 20 26 34
x1 0.754 0.731 0.704 0.653 0.587 0.496 0.314
x2 0.812 0.777 0.732 0.643 0.520 0.358 0.123
x4 0.872 0.820 0.742 0.567 0.333 0.124 0.010
x8 0.922 0.843 0.689 0.324 0.068 0.006 0.000
x12 0.944 0.838 0.583 0.126 0.009 0.000 0.000
silence at which P(alive) first drops below 0.5
x1: 26 weeks
x2: 21 weeks
x4: 16 weeks
x8: 12 weeks
x12: 9 weeks
mean purchase rate of a live buyer 0.0551 per week
mean drop-out chance per order a / (a + b)0.2463
Show the full program
# Chapter 2. p21: BG/NBD probability that a buyer is still active.
# P(alive | x, t_x, T) = 1 / (1 + [x > 0] * a / (b + x - 1)
#                        * ((alpha + T) / (alpha + t_x)) ** (r + x))
# x = repeat orders in the calibration window, t_x = week of the last
# order, T = length of the window in weeks. Parameters are the published
# CDNOW estimates (r 0.243, alpha 4.414, a 0.793, b 2.426, weeks,
# T = 39, fitted on a sample of 2,357 buyers); they illustrate the shape
# only and are not a reseller's data.
import math

R, ALPHA, A, B, T = 0.243, 4.414, 0.793, 2.426, 39.0


def p_alive(x, tx, big_t=T):
    if x == 0:
        return 1.0
    ratio = (ALPHA + big_t) / (ALPHA + tx)
    return 1.0 / (1.0 + A / (B + x - 1.0) * ratio ** (R + x))


if __name__ == "__main__":
    print("P(alive) at the end of a 39-week window")
    print("weeks silent    0      4      8     14     20     26     34")
    for x in (1, 2, 4, 8, 12):
        row = []
        for silent in (0, 4, 8, 14, 20, 26, 34):
            row.append("{:.3f}".format(p_alive(x, T - silent)))
        print("x = {:>2}      ".format(x) + "  ".join(row))
    print("silence at which P(alive) first drops below 0.5")
    for x in (1, 2, 4, 8, 12):
        s = 0
        while s < 39 and p_alive(x, T - s) >= 0.5:
            s += 1
        txt = "never inside 39 weeks" if s == 39 else "{} weeks".format(s)
        print("  x = {:>2}: {}".format(x, txt))
    mean_rate = R / ALPHA
    print("mean purchase rate of a live buyer {:.4f} per week".format(
        mean_rate))
    print("mean drop-out chance per order a / (a + b) = {:.4f}".format(
        A / (A + B)))

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 2: Buy-Till-You-Die: the Probability of Being Alive and Next Quarter's Expected Orders. 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