ABCDEFGHIJKLMNOPQRST
1
SegmentDonation valueVolumeResponse DDResponse one-offDD valueOne-off valueTotal ResponseTotal ValueResponse RateAverage Gift% of responses DDsCostProfitProfit per nameROI (1 year)Potential volume for 2nd mailing (as at 28 Dec)
2
1£5-£202801141£ 568.00£ 20.0015£ 588.000.5%£ 39.2097%£ 1,162.45-£ 574.45-£0.210.5112,081
3
2£20-£501680243£ 1,204.00£ 90.0027£ 1,294.001.6%£ 47.9393%£ 697.22£ 596.78£0.361.865,598
4
3£50+50253£ 364.00£ 200.008£ 564.001.6%£ 70.5065%£ 208.34£ 355.66£0.712.711,863
5
TOTAL4983437£ 2,136.00£ 310.0050£ 2,446.001.00%£ 48.9287%£ 2,068.00£ 378.00£0.081.1819,542
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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