Customer_Retention_Revenue_Analysis.xlsx

	B	C	G	H	I	M	N
1
2
3			Active Customers	Customer Type
4	Month	Active Customers	Month	New	Returning	Month	Revenue (£)
5	2010-01	42	2010-01	42		2010-01	46,192.49
6	2010-02	49	2010-02	48	1	2010-02	47,197.57
7	2010-03	18	2010-03	18	0	2010-03	23,876.63
8	2010-05	30	2010-05	29	0	2010-05	31,361.28
9	2010-06	36	2010-06	35	1	2010-06	31,009.33
10	2010-07	23	2010-07	21	2	2010-07	53,730.96
11	2010-08	40	2010-08	38	2	2010-08	39,094.20
12	2010-09	38	2010-09	35	3	2010-09	38,193.91
13	2010-10	22	2010-10	21	1	2010-10	33,488.38
14	2010-12	19	2010-12	17	2	2010-12	17,102.35
15	2011-01	221	2011-01	185	35	2011-01	239,564.80
16	2011-02	185	2011-02	152	33	2011-02	208,854.58
17	2011-03	182	2011-03	137	45	2011-03	260,988.66
18	2011-04	231	2011-04	165	66	2011-04	328,429.99
19	2011-05	244	2011-05	168	76	2011-05	321,271.43
20	2011-06	276	2011-06	182	94	2011-06	304,643.78
21	2011-07	254	2011-07	156	98	2011-07	322,309.29
22	2011-08	243	2011-08	144	99	2011-08	256,744.30
23	2011-09	204	2011-09	112	92	2011-09	421,112.23
24	2011-10	225	2011-10	137	88	2011-10	290,996.86
25	2011-11	241	2011-11	133	108	2011-11	344,620.67
26	2011-12	175	2011-12	87	88	2011-12	204,679.39
27	Unique Customers	2997				Total Revenue (£)	3,865,463.08
28
29
30
31
32	Country	Revenue (£)	Country	Active Customers
33	United Kingdom	3,263,199.25	United Kingdom	2713
34	EIRE	97,282.79	Germany	71
35	Germany	93,933.59	France	63
36	Netherlands	89,850.96	Spain	18
37	France	85,054.61	Belgium	18
38	Australia	49,209.71	Portugal	13
39	Switzerland	27,692.51	Switzerland	11
40	Spain	24,993.20	Netherlands	8
41	Japan	17,134.16	Finland	7
42	Belgium	16,942.55	Australia	7
43	Norway	14,655.10	Channel Islands	6
44	Portugal	13,139.82	Norway	6
45	Finland	11,357.60	Italy	6
46	Sweden	9,316.36	Denmark	5
47	Singapore	8,209.58	Austria	5
48	Channel Islands	7,894.96	Cyprus	5
49	Cyprus	5,385.91	Sweden	5
50	Denmark	4,863.56	Japan	4
51	Poland	3,904.21	Poland	4
52	Italy	3,664.11	EIRE	3
53	Austria	2,999.69	USA	3
54	Iceland	2,540.29	Greece	3
55	USA	2,464.75	Unspecified	2
56	Greece	2,099.28	Canada	2
57	Canada	1,751.88	Singapore	1
58	Lithuania	1,661.06	European Community	1
59	Unspecified	1,151.78	Lithuania	1
60	United Arab Emirates	975.54	Czech Republic	1
61	Malta	833.16	Iceland	1
62	Bahrain	459.40	Bahrain	1
63	European Community	432.05	Malta	1
64	Czech Republic	277.48	Israel	1
65	Israel	132.18	United Arab Emirates	1
66	Total Revenue (£)	3,865,463.08	Unique Customers	2997
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