Customer cohorts tool.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
COMPANY COHORTS
2
3
Customer IDUnique Customer IDTransaction DateTransaction MonthTransaction YearMonth last BookingUnique Month Last TransactionCustomer Cohort
4
000100013/13/202132021Mar-21Mar-21Mar-21CohortJan-20Feb-20Mar-20Apr-20May-20Jun-20Jul-20Aug-20Sep-20Oct-20Nov-20Dec-20
5
000200024/10/202142021Apr-21Apr-21Apr-21Jan-20866773222201
6
0003000311/4/2020112020Nov-20Nov-20Nov-20Feb-2051111111111
7
000312/31/2020122020Dec-20Dec-20Nov-20Mar-201000100011
8
00033/4/202132021Mar-21Mar-21Nov-20Apr-20220000000
9
00034/12/202142021Apr-21Apr-21Nov-20May-2021111010
10
0004000410/4/2020102020Oct-20Oct-20Oct-20Jun-205121112
11
000410/8/2020102020Oct-20Oct-20Jul-20100000
12
000412/20/2020122020Dec-20Dec-20Oct-20Aug-2042222
13
00041/7/202112021Jan-21Jan-21Oct-20Sep-2012633
14
000500054/8/202142021Apr-21Apr-21Apr-21Oct-20613
15
000600061/28/202112021Jan-21Jan-21Jan-21Nov-20116
16
000700074/29/202142021Apr-21Apr-21Apr-21Dec-2024
17
00074/29/202142021Apr-21Apr-21
18
000800084/16/202142021Apr-21Apr-21Apr-21
19
000900094/3/202142021Apr-21Apr-21Apr-21
20
00094/24/202142021Apr-21Apr-21
21
001000101/4/202112021Jan-21Jan-21Jan-21
22
001100113/3/202032020Mar-20Mar-20Mar-20RetentionJan-20Feb-20Mar-20Apr-20May-20Jun-20Jul-20Aug-20Sep-20Oct-20Nov-20Dec-20
23
00117/25/202072020Jul-20Jul-20Mar-20Jan-20100%75%75%88%88%38%25%25%25%25%0%13%
24
001111/28/2020112020Nov-20Nov-20Mar-20Feb-20100%20%20%20%20%20%20%20%20%20%20%
25
001112/5/2020122020Dec-20Dec-20Mar-20Mar-20100%0%0%0%100%0%0%0%100%100%
26
001112/17/2020122020Dec-20Mar-20Apr-20100%100%0%0%0%0%0%0%0%
27
001200127/8/202072020Jul-20Jul-20Jul-20May-20100%50%50%50%50%0%50%0%
28
001300133/7/202132021Mar-21Mar-21Mar-21Jun-20100%20%40%20%20%20%40%
29
00133/15/202132021Mar-21Mar-21Jul-20100%0%0%0%0%0%
30
00133/21/202132021Mar-21Mar-21Aug-20100%50%50%50%50%
31
00133/26/202132021Mar-21Mar-21Sep-20100%50%25%25%
32
00133/26/202132021Mar-21Mar-21Oct-20100%17%50%
33
00134/9/202142021Apr-21Apr-21Mar-21Nov-20100%55%
34
00133/26/202132021Mar-21Mar-21Mar-21Dec-20100%
35
00133/26/202132021Mar-21Mar-21
36
00133/26/202132021Mar-21Mar-21
37
00133/26/202132021Mar-21Mar-21
38
00133/26/202132021Mar-21Mar-21
39
00133/29/202132021Mar-21Mar-21
40
001400142/19/202122021Feb-21Feb-21Feb-21
41
001500152/7/202122021Feb-21Feb-21Feb-21
42
00152/28/202122021Feb-21Feb-21
43
00153/16/202132021Mar-21Mar-21Feb-21
44
001600162/8/202022020Feb-20Feb-20Feb-20
45
00162/8/202022020Feb-20Feb-20
46
001700174/17/202142021Apr-21Apr-21Apr-21
47
00174/17/202142021Apr-21Apr-21
48
00174/27/202142021Apr-21Apr-21
49
0018001812/29/2020122020Dec-20Dec-20Dec-20
50
001812/29/2020122020Dec-20Dec-20
51
001812/29/2020122020Dec-20Dec-20
52
001900192/27/202122021Feb-21Feb-21Feb-21
53
00192/27/202122021Feb-21Feb-21
54
00193/8/202132021Mar-21Mar-21Feb-21
55
002000201/3/202112021Jan-21Jan-21Jan-21
56
00201/4/202112021Jan-21Jan-21
57
00201/4/202112021Jan-21Jan-21
58
002100215/28/202052020May-20May-20May-20
59
00216/4/202062020Jun-20Jun-20May-20
60
00216/13/202062020Jun-20May-20
61
0022002211/24/2020112020Nov-20Nov-20Nov-20
62
002212/12/2020122020Dec-20Dec-20Nov-20
63
002212/21/2020122020Dec-20Nov-20
64
00221/1/202112021Jan-21Jan-21Nov-20
65
00221/19/202112021Jan-21Nov-20
66
00222/5/202122021Feb-21Feb-21Nov-20
67
00222/20/202122021Feb-21Nov-20
68
00223/12/202132021Mar-21Mar-21Nov-20
69
00223/26/202132021Mar-21Nov-20
70
00223/28/202132021Mar-21Nov-20
71
00223/28/202132021Mar-21Nov-20
72
0023002312/19/2020122020Dec-20Dec-20Dec-20
73
00231/5/202112021Jan-21Jan-21Dec-20
74
002400242/6/202122021Feb-21Feb-21Feb-21
75
002500251/20/202012020Jan-20Jan-20Jan-20
76
00252/3/202122021Feb-21Feb-21Jan-20
77
002600262/17/202122021Feb-21Feb-21Feb-21
78
002700273/28/202132021Mar-21Mar-21Mar-21
79
00273/28/202132021Mar-21Mar-21
80
00274/25/202142021Apr-21Apr-21Mar-21
81
002800284/16/202042020Apr-20Apr-20Apr-20
82
00284/17/202042020Apr-20Apr-20
83
00284/17/202042020Apr-20Apr-20
84
00284/17/202042020Apr-20Apr-20
85
00285/14/202052020May-20May-20Apr-20
86
00285/26/202052020May-20Apr-20
87
00285/26/202052020May-20Apr-20
88
002900294/13/202142021Apr-21Apr-21Apr-21
89
00294/17/202142021Apr-21Apr-21
90
00294/21/202142021Apr-21Apr-21
91
00294/24/202142021Apr-21Apr-21
92
003000304/29/202142021Apr-21Apr-21Apr-21
93
003100319/14/202092020Sep-20Sep-20Sep-20
94
003110/7/2020102020Oct-20Oct-20Sep-20
95
003110/14/2020102020Oct-20Sep-20
96
003110/22/2020102020Oct-20Sep-20
97
003110/31/2020102020Oct-20Sep-20
98
003111/8/2020112020Nov-20Nov-20Sep-20
99
003111/24/2020112020Nov-20Sep-20
100
003111/24/2020112020Nov-20Sep-20
Loading...
Main menu