5D Library › Cart-Abandonment Recovery Kinetics, Sunk-Data Retention Ratchets and High-Ticket B2B Qualification Mechanisms · 中文
Chapter 4. The Cost of Data Export and the Self-Selection of Annual Plans
What it costs to give users their data back
If renewal really came from a data ratchet, one-click export would weaken it. Article 20 of the EU General Data Protection Regulation sets out a right to data portability (European Parliament and Council of the European Union 2016); In Malaysia, the Personal Data Protection (Amendment) Act 2024 (Act A1727), gazetted in October 2024, inserts through its section 9 a new section 43A, “Rights to data portability”, into the Personal Data Protection Act 2010: a data subject may ask the data controller, by written notice sent electronically, to transmit his or her personal data directly to another data controller, subject to technical feasibility and compatible data formats; the section has been in force since 1 June 2025 (Parliament of Malaysia 2024). Whether or not the law requires it, holding users’ data hostage is a dark-pattern form of retention (Mathur et al. 2019).
Calculation
# Chapter 4. p07: What one-click data export costs, and what it must
# buy back. If a share e of the saved history can be exported, only
# (1 - e) of the switching cost remains. Expected months paid fall; the
# loss is recovered only if export (shown before sign-up) raises the
# sign-up rate by at least the same ratio. Uses the ratchet of p05.
import importlib.util
from math import 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")
def tenure(e, months=240):
alive, total = 1.0, 1.0
for t in range(months):
z = p05.C + (1 - e) * p05.s(t) / p05.W - p05.X
alive *= 1 / (1 + exp(-z))
total += alive
return total
if __name__ == "__main__":
full = tenure(0.0)
print(" no export: {:.1f} months paid".format(full))
for e in (0.5, 0.8, 1.0):
t = tenure(e)
print(" export share {:.1f}: {:.1f} months ({:+.1%});"
" break-even sign-up lift {:+.1%}".format(
e, t, t / full - 1, full / t - 1))
# no export: 15.9 months paid
# export share 0.5: 7.7 months (-51.8%); break-even sign-up lift +107.4%
# export share 0.8: 5.8 months (-63.7%); break-even sign-up lift +175.5%
# export share 1.0: 5.0 months (-68.4%); break-even sign-up lift +216.4%In the ratchet model of Chapter 3, without export a subscriber pays for 15.9 months on average; with half of the history exportable this falls to 7.7 months (-51.8%), and with all of it to 5.0 months (-68.4%). To make up the loss, the export feature (shown to buyers before sign-up) would have to raise the sign-up rate by 107.4% to 216.4%, which is hardly possible. But this conclusion rests entirely on the ratchet model: if rising renewal comes from selection (Chapter 3, p06), export loses no renewals at all.
Note
In practice. The real cost of data export depends on Chapter 3’s question: does retention come from lock-in or from value? Removing export before telling the two apart trades users’ trust for an untested assumption.
Annual plans: who chooses them
Calculation
# Chapter 4. p08: Annual prepay as a self-selection device. Monthly price
# RM 49; annual plan RM 490 ("two months free"). Subscribers differ in
# churn theta ~ Beta(a, b) from the sBG fit of p06 (a = 0.65, b = 2.7).
# A subscriber who knows her theta takes the annual plan when her
# expected monthly payments in the first year exceed RM 490. First-year
# revenue per subscriber: monthly only versus the menu.
import random
A, B, PRICE, ANNUAL = 0.65, 2.7, 49.0, 490.0
def expected_monthly(theta):
return PRICE * sum((1 - theta) ** k for k in range(12))
def year_revenue(menu, aware=1.0, n=200000, seed=79):
rng = random.Random(seed)
total, takers = 0.0, 0
for _ in range(n):
th = rng.betavariate(A, B)
guess = th if rng.random() < aware else rng.betavariate(A, B)
if menu and expected_monthly(guess) > ANNUAL:
total += ANNUAL
takers += 1
else:
total += expected_monthly(th)
return total / n, takers / n
if __name__ == "__main__":
m0, _ = year_revenue(False)
print(" monthly only: RM {:.2f} per subscriber in year 1".format(m0))
for aware in (1.0, 0.5, 0.0):
m1, share = year_revenue(True, aware)
print(" menu, buyers know their churn {:.0%}: RM {:.2f}"
" ({:+.1%}); annual share {:.2f}".format(
aware, m1, m1 / m0 - 1, share))
print(" annual pays off for theta below {:.3f}".format(
min(t / 1000 for t in range(1, 1000)
if expected_monthly(t / 1000) <= ANNUAL)))
# monthly only: RM 316.98 per subscriber in year 1
# menu, buyers know their churn 100%: RM 304.25 (-4.0%); annual share 0.22
# menu, buyers know their churn 50%: RM 330.15 (+4.2%); annual share 0.22
# menu, buyers know their churn 0%: RM 354.91 (+12.0%); annual share 0.22
# annual pays off for theta below 0.034The monthly price is RM 49 and the annual plan RM 490 (“two months free”). Subscribers’ churn probabilities vary according to the sBG distribution fitted in Chapter 3. With monthly billing only, each subscriber pays RM 316.98 on average in the first year. If subscribers know whether they will stay, those with a churn probability below 0.034 choose the annual plan (about 0.22 of them), and these are people who would have paid for all 12 months anyway: adding the annual plan lowers first-year revenue to RM 304.25 (-4.0%). Only when the choice is unrelated to true churn does the annual plan lock in people who would have left, raising revenue to RM 354.91 (+12.0%); with half knowing, RM 330.15 (+4.2%).
Hypothesis · not established
The author’s hypothesis (not yet tested): in the author’s subscription products, buyers of the annual plan have a monthly churn below half the overall average. What would show it wrong: after matching annual and monthly buyers on their first-month behaviour, the two groups’ underlying churn rates do not differ significantly.
Summary
In the ratchet model, one-click export cuts the average number of months paid by more than half, but in the selection model it costs nothing; find the source of retention before deciding. The annual plan is a self-selection device: the more its takers are people who would have stayed anyway, the more money it loses.
References
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).