ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
1
Download the Sheets file as .xlsx format: File > Download > Microsoft Excel. You can upload to your own Google Drive or use Excel.
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
Download KDP Royalty Report
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
3
Copy entire Summary sheet from your report and paste into A1 of "Paste Summary Here" tab. Do not move or remove any columns from the default report.
43
4
Copy entire Combined Sales sheet from your report and paste into A1 of "Paste Combined Sales Here" tab. Do not move or remove any columns from the default report.
Row 1 is reserved for headers, ensure data starts in Row 2.
For most accurate results, filter by currency before pasting.
44
5
Enter your total paid orders and KENP read from your Amazon Ad console in the Results tab in the input box for the corresponding fields.
45
6
Your Impact Multipliers and Average Profit Margin will be calculated for you.
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