Activation Velocity Curve - Template

	A	B	C	D	F	G
1		Cohort Month Start
2		January	February	March

3	Total Users in Cohort (who started)	33	32	35
4					Example:	Assume you sell a freemium product. In January 95, users started a free trial.
5	# users Activated				Activation:	When a user upgrades to a paid version of the software
6	Weeks since Cohort Start	January	February	March
7	1	1	5	6	In cell B7: # of users who signed up in the 1st week of January who activated in the 1st week of January.
8	2	5	5	5	In cell B8: # of users who signed up in the 1st week of January who activated in the 2nd week of January + # of users who signed up in the 2nd week of Jan who activated in the 2nd week of Jan
9	3	4	2	5
10	4	2	8	1	Cells highlighted in yellow are where you input your data. The rest calculate automatically.
11	5	2	4	4
12	6	4	2	3	Use the 'Raw Data' worksheet to organize the data so you can then fill in the highlighted yellow parts
13	7	5	1	2
14	8	3	1	1
15	9	3	0	1
16	10	1	1	1
17
18	% Activated	90.91%	90.63%	82.86%
19
20	Cumulative Activation
21	Weeks since Cohort Start	January	February	March
22	1	1	5	6
23	2	6	10	11
24	3	10	12	16
25	4	12	20	17
26	5	14	24	21
27	6	18	26	24
28	7	23	27	26
29	8	26	28	27
30	9	29	28	28
31	10	30	29	29
32
33	% Cumulative Activation
34	Weeks since Cohort Start	January	February	March
35	1	3.0%	15.6%	17.1%
36	2	18.2%	31.3%	31.4%
37	3	30.3%	37.5%	45.7%
38	4	36.4%	62.5%	48.6%
39	5	42.4%	75.0%	60.0%
40	6	54.5%	81.3%	68.6%
41	7	69.7%	84.4%	74.3%
42	8	78.8%	87.5%	77.1%
43	9	87.9%	87.5%	80.0%
44	10	90.9%	90.6%	82.9%
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