I am trying to calculate how successful some of our appeals were but looking at the number of solicitations versus the number of responses and can't seem to figure out how to do the percentage. I would want to use the Count of Appeal (which is the number of solicitations we sent out) against the count of gift amount which is the number of responses. And possibly also see the average gift amount of each of the appeals as well. Any help is appreciated.
Appeal Description SumOfGift Amount CountOfGift Amount Count of Appeal 12AAA 1stMail $2,483,799.03 10821 26231 12AAA 1stMail - New Adds $5,150.00 40 6252 12AAA 1stMail Sybunt $121,463.24 828 18060 12AAA 2ndMail $313,444.00 1734 20796 12AAA 3rdMail $16,691.33 160 20722 12AAA DirectSolicitation $960,012.74 233
12AAA In House Phone $1,200.00 1
12AAA InPew $3,030,022.69 15619
12AAA Internet $186,370.05 433
12AAA Matching Gifts $35.00 1
12AAA Payroll $20,606.14 35
12AAA Phone $209,414.00 1268