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: a | 0.65, b = 2.7 |
| largest survival gap over 24 months | 0.011 |
| month | 0 renewal: ratchet 0.801, selection 0.806 |
| month | 3 renewal: ratchet 0.898, selection 0.898 |
| month | 6 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
- Chapter 1 · The Timing and Number of Follow-Ups after Abandonment
- Chapter 2 · Discount Hooks and Overstated Recovery
- Chapter 4 · The Cost of Data Export and the Self-Selection of Annual Plans
- Chapter 5 · A Two-Licence Menu and Screening by Application Form
- Chapter 6 · Allocating Advisor Time, and Deposits as Signals
- Chapter 7 · The Sunzi on the Nine Grounds, the Guiguzi on Probing, and the Mozi on Paying by Merit
- Chapter 8 · The Full Ledger, an Experiment to Tell a Ratchet from Selection, and a Pre-Registered Holdout