How to do Cohorts on a spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Customer IDDate
Purchase Rate
Join DateCohortsAge by days
Age by month
2
1018/8/201418/8/2014Aug-201400
3
3396/19/201416/19/2014Jun-201400
4
5776/20/201416/20/2014Jun-201400Unfortunately, pivot tables are not yet a feature in Google spreadsheet so I cannot represent that here, but refer to my post for details on how to use a pivot table to calculate your Cohorts in Excel. Mail me at ayemijohnson[at]gmail.com if you have questions
5
8159/17/201419/17/2014Sep-201400
6
105311/16/2014111/16/2014Nov-201400
7
129111/22/2014111/22/2014Nov-201400
8
129111/22/2014211/22/2014Nov-201400
9
15295/12/201415/12/2014May-201400
10
17674/17/201414/17/2014Apr-201400
11
200511/29/2014111/29/2014Nov-201400
12
224312/9/2014112/9/2014Dec-201400
13
24815/2/201415/2/2014May-201400
14
24815/2/201425/2/2014May-201400
15
27192/7/201412/7/2014Feb-201400
16
29579/26/201419/26/2014Sep-201400
17
31953/9/201413/9/2014Mar-201400
18
343310/18/2014110/18/2014Oct-201400
19
367110/3/2014110/3/2014Oct-201400
20
39099/8/201419/8/2014Sep-201400
21
41477/2/201417/2/2014Jul-201400
22
43855/16/201415/16/2014May-201400
23
462310/8/2014110/8/2014Oct-201400
24
486110/31/2014110/31/2014Oct-201400
25
50993/28/201413/28/2014Mar-201400
26
53373/26/201413/26/2014Mar-201400
27
55757/7/201417/7/2014Jul-201400
28
58137/15/201417/15/2014Jul-201400
29
58137/17/201427/15/2014Jul-201420
30
60517/23/201417/23/2014Jul-201400
31
62891/27/201411/27/2014Jan-201400
32
62899/24/201421/27/2014Jan-20142408
33
65276/6/201416/6/2014Jun-201400
34
67655/9/201415/9/2014May-201400
35
70033/3/201413/3/2014Mar-201400
36
724110/16/2014110/16/2014Oct-201400
37
74795/9/201415/9/2014May-201400
38
77171/13/201411/13/2014Jan-201400
39
77171/24/201421/13/2014Jan-2014110
40
79558/12/201418/12/2014Aug-201400
41
79558/14/201428/12/2014Aug-201420
42
81937/2/201417/2/2014Jul-201400
43
843112/2/2014112/2/2014Dec-201400
44
843112/3/2014212/2/2014Dec-201410
45
866911/19/2014111/19/2014Nov-201400
46
89079/20/201419/20/2014Sep-201400
47
91453/24/201413/24/2014Mar-201400
48
938311/3/2014111/3/2014Nov-201400
49
96212/4/201412/4/2014Feb-201400
50
985910/22/2014110/22/2014Oct-201400
51
985910/22/2014210/22/2014Oct-201400
52
985910/22/2014310/22/2014Oct-201400
53
985910/22/2014410/22/2014Oct-201400
54
100973/10/201413/10/2014Mar-201400
55
103351/24/201411/24/2014Jan-201400
56
105733/10/201413/10/2014Mar-201400
57
108119/8/201419/8/2014Sep-201400
58
1104910/4/2014110/4/2014Oct-201400
59
112877/9/201417/9/2014Jul-201400
60
115251/21/201411/21/2014Jan-201400
61
1176311/16/2014111/16/2014Nov-201400
62
120014/23/201414/23/2014Apr-201400
63
122398/4/201418/4/2014Aug-201400
64
124775/5/201415/5/2014May-201400
65
124776/2/201425/5/2014May-2014280
66
127154/3/201414/3/2014Apr-201400
67
129537/23/201417/23/2014Jul-201400
68
1295310/29/201427/23/2014Jul-2014983
69
1295311/12/201437/23/2014Jul-20141123
70
1295312/2/201447/23/2014Jul-20141324
71
1295312/3/201457/23/2014Jul-20141334
72
1295312/18/201467/23/2014Jul-20141484
73
131913/8/201413/8/2014Mar-201400
74
134295/27/201415/27/2014May-201400
75
136674/28/201414/28/2014Apr-201400
76
1390512/8/2014112/8/2014Dec-201400
77
1414311/12/2014111/12/2014Nov-201400
78
143818/15/201418/15/2014Aug-201400
79
1461911/15/2014111/15/2014Nov-201400
80
148573/11/201413/11/2014Mar-201400
81
1509510/15/2014110/15/2014Oct-201400
82
153337/23/201417/23/2014Jul-201400
83
155711/3/201411/3/2014Jan-201400
84
155711/4/201421/3/2014Jan-201410
85
1580911/6/2014111/6/2014Nov-201400
86
160476/3/201416/3/2014Jun-201400
87
160476/3/201426/3/2014Jun-201400
88
162852/1/201412/1/2014Feb-201400
89
165238/27/201418/27/2014Aug-201400
90
167613/14/201413/14/2014Mar-201400
91
169993/6/201413/6/2014Mar-201400
92
172379/2/201419/2/2014Sep-201400
93
1747511/18/2014111/18/2014Nov-201400
94
177138/26/201418/26/2014Aug-201400
95
177138/26/201428/26/2014Aug-201400
96
179512/19/201412/19/2014Feb-201400
97
181893/19/201413/19/2014Mar-201400
98
184271/26/201411/26/2014Jan-201400
99
186652/4/201412/4/2014Feb-201400
100
189038/26/201418/26/2014Aug-201400
Loading...
 
 
 
Sheet1
Sheet2
 
 
Main menu