LCV calculator

	A	B	C	D	E	F	G	H	I	J
1
2
3	Publisher type	Initial Subscribers	Lost subscribers	Gained subscribers	Final Subscribers	Churn rate	Actions taken	LCV
4	Large passive	100,000	20,000	30,000	110,000	0.2	220	0.010
5	Large active	100,000	20,000	30,000	110,000	0.2	440	0.020
6	Small passive	10,000	2,000	3,000	11,000	0.2	11	0.005
7	Small active	10,000	2,000	3,000	11,000	0.2	110	0.050	->	Disproportionately benefits small publishers with an active community.
8										(which is great!)
9
10
11
12
13
14
15	Publisher type	Subscriber actions	LCV
16	Large passive	220	0.010
17	Large active	440	0.020
18	Small passive	11	0.005
19	Small active	110	0.050
20
21
22
23
24
25
26
27	Read more	https://www.pboehler.net/lifetime-civic-value-media/
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100