5D Library › Cart-Abandonment Recovery Kinetics, Sunk-Data Retention Ratchets and High-Ticket B2B Qualification Mechanisms · 中文

Chapter 3. A Sunk-Data Renewal Ratchet, and a Selection Curve that Rises the Same Way

The ratchet model

The more history, notes and charts a subscriber keeps in a piece of reading software, the costlier it is to move elsewhere. Write this switching cost as s(t)=S(1−e−t/T)s(t) = S\,(1 – e^{-t/T}) (in RM, with tt in months), and the monthly renewal probability as logistic(c+s(t)/w)\mathrm{logistic}(c + s(t)/w). All subscribers here are alike; rising renewal comes entirely from the data each one accumulates. How switching costs change competition and pricing is a classic question of industrial organisation (Klemperer 1987).

Calculation

# Chapter 3. p05: A sunk-data ratchet. A subscriber's saved history
# (readings, notes, charts) has a switching cost that accumulates,
# s(t) = S (1 - exp(-t / T)) in RM, t in months. Each month the
# subscriber renews with probability logistic(c + s(t) / w - x), where x
# is the price relative to w. All subscribers are alike (no selection).
from math import exp

S, T, W = 120.0, 6.0, 60.0
C, X = 1.39, 0.0             # renewal 0.80 at t = 0 without history

def s(t):
    return S * (1 - exp(-t / T))

def renew(t, ratchet=True):
    z = C + (s(t) / W if ratchet else 0.0) - X
    return 1 / (1 + exp(-z))

def survival(months, ratchet=True):
    alive, out = 1.0, []
    for t in range(months):
        alive *= renew(t, ratchet)
        out.append(alive)
    return out

def tenure(ratchet=True, months=240):
    return 1 + sum(survival(months, ratchet))

if __name__ == "__main__":
    for t in (0, 3, 6, 12, 24):
        print("   month {:2d}: switching cost RM {:5.1f},"
              " renewal {:.3f}".format(t, s(t), renew(t)))
    print("   expected months paid: with ratchet {:.1f},"
          " without {:.1f}".format(tenure(True), tenure(False)))
#    month  0: switching cost RM   0.0, renewal 0.801
#    month  3: switching cost RM  47.2, renewal 0.898
#    month  6: switching cost RM  75.9, renewal 0.934
#    month 12: switching cost RM 103.8, renewal 0.958
#    month 24: switching cost RM 117.8, renewal 0.966
#    expected months paid: with ratchet 15.9, without 5.0

Under illustrative parameters, renewal in the first month is 0.801; in month 3 the switching cost is RM 47.2 and renewal 0.898; in month 12, RM 103.8 and 0.958; in month 24, RM 117.8 and 0.966. With the ratchet a subscriber pays for 15.9 months on average; without it, only 5.0.

The same curve, another explanation

Calculation

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

The shifted-beta-geometric (sBG) model assumes that each subscriber has a fixed monthly churn probability, differing between people according to a beta distribution (Fader and Hardie 2007). Nobody becomes stickier, yet the cohort renewal rate (b+t−1)/(a+b+t−1)(b + t – 1)/(a + b + t – 1) still rises month by month, because those likely to churn leave first. Fitting it to the cohort survival curve of the ratchet model above gives a=0.65a = 0.65 and b=2.7b = 2.7, and the largest gap between the two survival curves over 24 months is only 0.011; the monthly renewal rates almost coincide (both 0.898 in month 3, both 0.958 in month 12).

The cohort survival curves of the ratchet model and of the selection model (sBG) almost coincide (p05, p06).

Yet the two models predict quite different things for an individual. Give a new subscriber a free import of 12 months of history: in the ratchet model her first renewal rises from 0.801 to 0.958; in the selection model it stays at 0.806, because the data were never the cause.

Note

Why this matters. If rising renewal comes from selection, product effort spent on “getting users to store more data” will not raise renewal, and “the more data, the harder to leave” is only a story told after the fact. The cohort curve itself cannot tell the two explanations apart; Chapter 8 gives a randomised experiment that can.

Hypothesis · not established

The author’s hypothesis (not yet tested): in the author’s subscription products, rising renewal comes mainly from selection rather than from accumulated data. What would show it wrong: randomly giving half of new subscribers an import of history raises their first renewal significantly above the control group (Chapter 8, p15).

Summary

The ratchet model and the selection model can produce almost the same cohort renewal curve (a largest gap of 0.011) while predicting opposite effects of an intervention. A rising renewal curve does not prove a data ratchet.

References

Fader, Peter S., and Bruce G. S. Hardie. 2007. “How to Project Customer Retention.” Journal of Interactive Marketing 21 (1): 76–90.
Klemperer, Paul. 1987. “Markets with Consumer Switching Costs.” The Quarterly Journal of Economics 102 (2): 375–94.

Fan, Y. (2026). Cart-Abandonment Recovery Kinetics, Sunk-Data Retention Ratchets and High-Ticket B2B Qualification Mechanisms: Multi-Pulse Follow-Up Timing, Switching-Cost Accumulation and Screening Equilibria [弃单挽回动力学、沉没数据续费棘轮与高客单顾问筛选机制] (Version 1.0.0). 5D Library. https://doi.org/10.5281/zenodo.24090209 · Licensed under Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0).