Spreadsheet: 29186d1224032130-counting-the-number-of-dates-in-an-aging-bucket-aging-dates
Sheet: METech

Summary Statistics | Number | % of Total
# Clients | 282
Service Campaign Stats
Service Campaigns Run in last 0-30 Days | 129 | 0.4574468085106383
Service Campaigns Run in last 31-60 Days | 71 | 0.25177304964539
Service Campaigns Run in last 61-90 Days | 48 | 0.1702127659574468
Service Campaigns Run in last 91-120 Days
Service Campaigns Run in last 121+ Days
Client | RM | Last Svc Campaign Complete
1 | 1 | 2008-09-30 00:00:00
2 | 2 | 2008-09-12 00:00:00
3 | 3 | 2008-08-31 00:00:00
4 | 4 | 2008-09-30 00:00:00
5 | 5 | 2008-09-30 00:00:00
6 | 6 | 2008-09-30 00:00:00
7 | 7 | 2008-07-18 00:00:00
8 | 8 | 2008-09-30 00:00:00
9 | 9 | 2008-08-31 00:00:00
10 | 10 | 2008-07-31 00:00:00
11 | 11 | 2008-09-30 00:00:00
12 | 12 | 2008-09-30 00:00:00
13 | 13 | 2008-09-30 00:00:00
14 | 14 | 2008-09-30 00:00:00
15 | 15 | 2008-09-30 00:00:00
16 | 16 | 2008-09-30 00:00:00
17 | 17 | 2008-08-31 00:00:00
18 | 18 | 2008-09-30 00:00:00
19 | 19 | 2008-09-30 00:00:00
20 | 20 | 2008-09-30 00:00:00
21 | 21 | 2008-10-09 00:00:00
22 | 22 | 2008-09-30 00:00:00
23 | 23 | 2008-09-30 00:00:00
24 | 24 | 2008-07-31 00:00:00
25 | 25 | 2008-09-30 00:00:00
26 | 26 | 2008-09-30 00:00:00
27 | 27
28 | 28 | 2008-09-30 00:00:00
29 | 29 | 2008-09-15 00:00:00
30 | 30 | 2008-06-18 00:00:00
31 | 31 | 2008-10-04 00:00:00
32 | 32 | 2008-09-19 00:00:00
33 | 33 | 2008-09-15 00:00:00
34 | 34 | 2007-03-15 00:00:00
35 | 35 | 2008-10-03 00:00:00
36 | 36 | 2008-10-04 00:00:00
37 | 37 | 2008-09-22 00:00:00
38 | 38 | 2008-09-15 00:00:00
39 | 39 | 2008-09-30 00:00:00
40 | 40 | 2008-09-30 00:00:00
41 | 41 | 2008-10-05 00:00:00
42 | 42 | 2008-09-30 00:00:00
43 | 43 | 2008-09-30 00:00:00
44 | 44 | 2008-09-30 00:00:00
45 | 45 | 2008-06-30 00:00:00
46 | 46 | 2008-09-30 00:00:00
47 | 47 | 2008-10-11 00:00:00
48 | 48 | 2008-05-02 00:00:00
49 | 49 | 2008-09-30 00:00:00
50 | 50 | 2008-04-30 00:00:00
51 | 51 | 2008-09-30 00:00:00
52 | 52 | 2008-09-30 00:00:00
53 | 53 | 2008-09-30 00:00:00
54 | 54
55 | 55 | 2008-08-31 00:00:00
56 | 56 | 2008-09-30 00:00:00
57 | 57 | 2008-09-30 00:00:00
58 | 58 | 2008-08-31 00:00:00
59 | 59 | 2008-07-31 00:00:00
60 | 60 | 2008-08-31 00:00:00
61 | 61 | 2008-09-30 00:00:00
62 | 62 | 2008-08-30 00:00:00
63 | 63 | 2008-08-30 00:00:00
64 | 64 | 2008-09-30 00:00:00
65 | 65 | 2008-09-30 00:00:00
66 | 66 | 2008-09-12 00:00:00
67 | 67 | 2008-09-13 00:00:00
68 | 68 | 2008-03-31 00:00:00
69 | 69 | 2008-09-30 00:00:00
70 | 70 | 2008-09-30 00:00:00
71 | 71 | 2008-09-30 00:00:00
72 | 72 | 2008-08-20 00:00:00
73 | 73 | 2008-08-30 00:00:00
74 | 74 | 2008-06-08 00:00:00
75 | 75 | 2008-09-04 00:00:00
76 | 76 | 2008-09-30 00:00:00
77 | 77 | 2008-09-18 00:00:00
78 | 78 | 2008-09-18 00:00:00
79 | 79 | 2008-03-31 00:00:00
80 | 80 | 2008-06-14 00:00:00
81 | 81 | 2008-09-30 00:00:00
82 | 82 | 2008-08-31 00:00:00
83 | 83 | 2008-08-31 00:00:00
84 | 84 | 2008-03-22 00:00:00
85 | 85 | 2008-09-14 00:00:00
86 | 86 | 2008-06-08 00:00:00
87 | 87 | 2007-03-27 00:00:00
88 | 88 | 2004-07-03 00:00:00
89 | 89 | 2004-07-03 00:00:00
90 | 90 | 2008-09-23 00:00:00
91 | 91
92 | 92
93 | 93
94 | 94
95 | 95
96 | 96 | 2008-09-30 00:00:00
97 | 97 | 2007-02-16 00:00:00
98 | 98 | 2008-09-30 00:00:00
99 | 99 | 2008-09-30 00:00:00
100 | 100 | 2008-07-10 00:00:00
101 | 101 | 2008-09-20 00:00:00
102 | 102 | 2008-08-31 00:00:00
103 | 103 | 2008-09-30 00:00:00
104 | 104 | 2008-09-30 00:00:00
105 | 105 | 2008-09-01 00:00:00
106 | 106 | 2008-09-01 00:00:00
107 | 107 | 2008-09-01 00:00:00
108 | 108 | 2008-09-30 00:00:00
109 | 109 | 2008-10-01 00:00:00
110 | 110 | 2008-08-18 00:00:00
111 | 111 | 2008-09-10 00:00:00
112 | 112 | 2008-09-30 00:00:00
113 | 113 | 2008-09-30 00:00:00
114 | 114 | 2008-07-31 00:00:00
115 | 115 | 2008-09-30 00:00:00
116 | 116 | 2008-09-30 00:00:00
117 | 117 | 2008-09-30 00:00:00
118 | 118 | 2008-10-09 00:00:00
119 | 119 | 2008-09-30 00:00:00
120 | 120 | 2008-09-30 00:00:00
121 | 121 | 2008-09-30 00:00:00
122 | 122 | 2008-10-12 00:00:00
123 | 123 | 2008-09-30 00:00:00
124 | 124 | 2008-09-30 00:00:00
125 | 125 | 2008-10-03 00:00:00
126 | 126 | 2008-10-04 00:00:00
127 | 127 | 2008-09-30 00:00:00
128 | 128 | 2008-09-30 00:00:00
129 | 129 | 2008-09-30 00:00:00
130 | 130 | 2008-09-08 00:00:00
131 | 131 | 2008-10-03 00:00:00
132 | 132 | 2006-08-31 00:00:00
133 | 133 | 2008-09-12 00:00:00
134 | 134 | 2008-09-06 00:00:00
135 | 135
136 | 136 | 2007-12-13 00:00:00
137 | 137 | 2007-12-13 00:00:00
138 | 138
139 | 139 | 2008-02-02 00:00:00
140 | 140 | 2008-02-02 00:00:00
141 | 141 | 2008-05-31 00:00:00
142 | 142 | 2006-12-02 00:00:00
143 | 143 | 2008-09-21 00:00:00
144 | 144 | 2008-09-15 00:00:00
145 | 145 | 2008-09-30 00:00:00
146 | 146 | 2008-09-26 00:00:00
147 | 147 | 2008-04-30 00:00:00
148 | 148
149 | 149 | 2008-06-30 00:00:00
150 | 150
151 | 151 | 2008-02-29 00:00:00
152 | 152 | 2008-10-04 00:00:00
153 | 153 | 2008-09-30 00:00:00
154 | 154
155 | 155 | 2008-09-30 00:00:00
156 | 156 | 2008-09-10 00:00:00
157 | 157 | 2008-09-13 00:00:00
158 | 158 | 2008-08-15 00:00:00
159 | 159 | 2008-09-10 00:00:00
160 | 160 | 2005-11-23 00:00:00
161 | 161 | 2006-10-18 00:00:00
162 | 162 | 2008-09-30 00:00:00
163 | 163 | 2008-09-03 00:00:00
164 | 164 | 2007-12-31 00:00:00
165 | 165 | 2008-09-30 00:00:00
166 | 166 | 2008-08-31 00:00:00
167 | 167 | 2008-08-31 00:00:00
168 | 168
169 | 169 | 2008-02-29 00:00:00
170 | 170 | 2008-08-31 00:00:00
171 | 171 | 2008-07-31 00:00:00
172 | 172 | 2008-09-30 00:00:00
173 | 173 | 2008-09-30 00:00:00
174 | 174 | 2008-09-30 00:00:00
175 | 175 | 2008-08-31 00:00:00
176 | 176 | 2008-09-01 00:00:00
177 | 177 | 2008-09-30 00:00:00
178 | 178 | 2008-09-30 00:00:00
179 | 179 | 2008-06-12 00:00:00
180 | 180 | 2008-10-04 00:00:00
181 | 181 | 2008-10-08 00:00:00
182 | 182 | 2008-09-30 00:00:00
183 | 183 | 2008-09-30 00:00:00
184 | 184 | 2008-09-30 00:00:00
185 | 185 | 2008-09-30 00:00:00
186 | 186 | 2008-09-30 00:00:00
187 | 187 | 2008-07-31 00:00:00
188 | 188 | 2008-10-09 00:00:00
189 | 189 | 2008-10-03 00:00:00
190 | 190
191 | 191 | 2008-10-04 00:00:00
192 | 192 | 2008-08-31 00:00:00
193 | 193 | 2008-09-30 00:00:00
194 | 194 | 2007-02-28 00:00:00
195 | 195 | 2008-09-12 00:00:00
196 | 196 | 2008-08-31 00:00:00
197 | 197 | 2008-09-14 00:00:00
198 | 198 | 2008-09-30 00:00:00
199 | 199 | 2008-08-31 00:00:00
200 | 200 | 2008-09-30 00:00:00
201 | 201 | 2008-09-30 00:00:00
202 | 202 | 2008-04-29 00:00:00
203 | 203 | 2008-10-04 00:00:00
204 | 204 | 2008-09-15 00:00:00
205 | 205 | 2007-11-30 00:00:00
206 | 206 | 2008-08-30 00:00:00
207 | 207 | 2008-09-30 00:00:00
208 | 208 | 2008-09-30 00:00:00
209 | 209 | 2008-09-26 00:00:00
210 | 210 | 2008-09-30 00:00:00
211 | 211 | 2008-10-11 00:00:00
212 | 212 | 2008-09-30 00:00:00
213 | 213 | 2008-09-27 00:00:00
214 | 214 | 2008-08-31 00:00:00
215 | 215 | 2008-09-30 00:00:00
216 | 216 | 2008-08-31 00:00:00
217 | 217 | 2008-10-11 00:00:00
218 | 218 | 2008-09-30 00:00:00
219 | 219 | 2008-10-01 00:00:00
220 | 220 | 2008-07-31 00:00:00
221 | 221 | 2008-07-31 00:00:00
222 | 222 | 2008-07-31 00:00:00
223 | 223 | 2008-07-31 00:00:00
224 | 224
225 | 225 | 2008-07-31 00:00:00
226 | 226 | 2008-08-31 00:00:00
227 | 227 | 2008-07-31 00:00:00
228 | 228 | 2008-08-31 00:00:00
229 | 229 | 2008-09-30 00:00:00
230 | 230 | 2008-07-19 00:00:00
231 | 231 | 2008-09-30 00:00:00
232 | 232 | 2008-09-30 00:00:00
233 | 233 | 2008-08-31 00:00:00
234 | 234 | 2008-10-05 00:00:00
235 | 235 | 2007-10-24 00:00:00
236 | 236 | 2008-01-31 00:00:00
237 | 237 | 2008-09-13 00:00:00
238 | 238 | 2008-09-30 00:00:00
239 | 239 | 2008-10-04 00:00:00
240 | 240 | 2008-09-30 00:00:00
241 | 241 | 2008-09-30 00:00:00
242 | 242
243 | 243
244 | 244
245 | 245 | 2008-09-13 00:00:00
246 | 246 | 2008-08-30 00:00:00
247 | 247 | 2008-07-18 00:00:00
248 | 248 | 2008-09-13 00:00:00
249 | 249 | 2008-10-08 00:00:00
250 | 250 | 2008-06-14 00:00:00
251 | 251 | 2008-07-31 00:00:00
252 | 252 | 2008-08-13 00:00:00
253 | 253 | 2008-08-30 00:00:00
254 | 254 | 2008-09-30 00:00:00
255 | 255 | 2008-07-31 00:00:00
256 | 256 | 2008-09-30 00:00:00
257 | 257 | 2008-10-02 00:00:00
258 | 258 | 2008-02-29 00:00:00
259 | 259 | 2008-08-09 00:00:00
260 | 260 | 2006-10-14 00:00:00
261 | 261 | 2008-06-08 00:00:00
262 | 262 | 2008-08-15 00:00:00
263 | 263 | 2008-04-30 00:00:00
264 | 264 | 2008-07-12 00:00:00
265 | 265 | 2008-06-30 00:00:00
266 | 266 | 2008-08-09 00:00:00
267 | 267 | 2008-08-31 00:00:00
268 | 268 | 2008-10-11 00:00:00
269 | 269 | 2008-09-18 00:00:00
270 | 270 | 2008-05-09 00:00:00
271 | 271 | 2008-09-30 00:00:00
272 | 272 | 2008-09-05 00:00:00
273 | 273 | 2008-09-05 00:00:00
274 | 274 | 2008-08-17 00:00:00
275 | 275 | 2008-08-31 00:00:00
276 | 276 | 2008-08-08 00:00:00
277 | 277 | 2008-08-31 00:00:00
278 | 278 | 2008-08-31 00:00:00
279 | 279 | 2007-12-08 00:00:00
280 | 280 | 2008-02-02 00:00:00
281 | 281 | 2008-03-31 00:00:00
282 | 282 | 2008-03-31 00:00:00