What does Abandonment, Renewal and Screening conclude, in numbers, about “A Sunk-Data Renewal Ratchet, and a Selection Curve that Rises the Same Way”?

Answer: Chapter 3 writes down a sunk-data ratchet and shows that a selection model in which everyone's renewal rate is constant (sBG) fits the same cohort curve to within a largest gap of 0.011.

Scope of the numbers: Return rates, unsubscribe rates, renewal parameters, client valuations and close rates are illustrative or synthetic; all data are generated by its programs; the book is not legal advice. Marked boxes separate published evidence, runnable Python calculations (16 programs), classical sources and the author's hypotheses.

中文版

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

sBG fit to the ratchet cohort: a0.65, b = 2.7
largest survival gap over 24 months0.011
month0 renewal: ratchet 0.801, selection 0.806
month3 renewal: ratchet 0.898, selection 0.898
month6 renewal: ratchet 0.934, selection 0.930
month 12 renewal: ratchet 0.958, selection 0.958
a new subscriber given 12 months of imported history:
ratchet model renewal 0.958; selection model 0.806
Show the full program
# Chapter 3. p06: Rising renewal without any ratchet. In the shifted-
# beta-geometric (sBG) model each subscriber has a fixed monthly churn
# probability theta ~ Beta(a, b); nobody becomes stickier, yet the
# cohort renewal rate (b + t - 1) / (a + b + t - 1) rises because those
# likely to churn leave first. We fit (a, b) to the cohort survival
# curve of the ratchet model in p05 and compare the two curves.
import importlib.util
from math import lgamma, exp

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_sunk_data")
MONTHS = 24

def lbeta(a, b):
    return lgamma(a) + lgamma(b) - lgamma(a + b)

def sbg_survival(a, b, months=MONTHS):
    return [exp(lbeta(a, b + t) - lbeta(a, b)) for t in range(1, months + 1)]

def fit(target):
    best = None
    for i in range(1, 121):
        a = i * 0.05
        for j in range(1, 241):
            b = j * 0.1
            sv = sbg_survival(a, b)
            err = sum((x - y) ** 2 for x, y in zip(sv, target))
            if best is None or err < best[0]:
                best = (err, a, b)
    return best

if __name__ == "__main__":
    target = p05.survival(MONTHS)
    err, a, b = fit(target)
    sv = sbg_survival(a, b)
    gap = max(abs(x - y) for x, y in zip(sv, target))
    print("   sBG fit to the ratchet cohort: a = {:.2f}, b = {:.1f}".format(
        a, b))
    print("   largest survival gap over {} months: {:.3f}".format(
        MONTHS, gap))
    for t in (1, 4, 7, 13):
        rate = (b + t - 1) / (a + b + t - 1)
        print("   month {:2d} renewal: ratchet {:.3f}, selection {:.3f}"
              .format(t - 1, p05.renew(t - 1), rate))
    print("   a new subscriber given 12 months of imported history:")
    print("     ratchet model renewal {:.3f}; selection model {:.3f}".format(
        p05.renew(12), b / (a + b)))

Single source and citation

Fan, Y. (2026). Cart-Abandonment Recovery Kinetics, Sunk-Data Retention Ratchets and High-Ticket B2B Qualification Mechanisms (Version 1.0.0), Chapter 3: A Sunk-Data Renewal Ratchet, and a Selection Curve that Rises the Same Way. 5D Library. https://doi.org/10.5281/zenodo.24090209

DOI: 10.5281/zenodo.24090209 · Read the monograph · 5DL-B-079 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026079,
  author    = {Fan, Yafu},
  title     = {Cart-Abandonment Recovery Kinetics, Sunk-Data Retention Ratchets and High-Ticket B2B Qualification Mechanisms},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  doi       = {10.5281/zenodo.24090209},
  url       = {https://doi.org/10.5281/zenodo.24090209}
}

Other chapter answers in this book