Book Marketing ROI Calculator by BookBub

	A	B	C	D	E	F	G	H	I
1
2	Book Marketing ROI Calculator
3	Instructions: Select File and Make a Copy. Complete the white cells. The blue cells will be calculated for you.
4
5	Marketing Campaign	Campaign Cost	Books Sold	Book Price	Total Revenue	Royalty Rate	Your Revenue	Your Profit	ROI
6	Add the name of your marketing campaign here.	How much did your campaign cost?	How many books did you sell?	How much did your book cost?	This is how much money your campaign generated.	What is your royalty rate?	This is how much you made after your retailer/publisher/author took their cut.	This is how much money you actually made.	This is your return on investment.
7	Campaign X	$600.00	500	$2.99	$1,495.00	70%	$1,046.50	$446.50	74%
8	Campaign Y	$1,000.00	500	$2.99	$1,495.00	70%	$1,046.50	$46.50	5%
9	Campaign Z	$500.00	1000	$2.99	$2,990.00	70%	$2,093.00	$1,593.00	319%
10	Campaign Fail	$1,500.00	300	$2.99	$897.00	70%	$627.90	-$872.10	-58%
11					$0.00		$0.00	$0.00	0%
12					$0.00		$0.00	$0.00	0%
13					$0.00		$0.00	$0.00	0%
14					$0.00		$0.00	$0.00	0%
15					$0.00		$0.00	$0.00	0%
16					$0.00		$0.00	$0.00	0%
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