Quickly calculate your average profit margin and impact multipliers using your KDP Royalty reports with our Simplified Calculator. Using your KDP Reports and order and KENP royalties from your Amazon Ad Console, your paid to organic ratios are used to calculate your maximum impact multipliers across your entire KDP account.
Download the Sheets file as .xlsx format: File > Download > Microsoft Excel. You can upload to your own Google Drive or use Excel.
Download KDP Royalty Report
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.
Copy entire Combined Sales sheet from your report and paste into A1 of "Paste Summary 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.
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.
Your Impact Multipliers and Average Profit Margin will be calculated for you.
This calculator gives you a more nuanced approach to calculating your impact multiplier for up to three series with ten books each by calculating the series read-through conversion rate and estimated extended page reads outside the 14-day attribution window.
Download the Sheets file as .xlsx format: File > Download > Microsoft Excel. You can upload it to your own Google Drive or use Excel.
Download KDP Royalty Report
Estimate your extended page reads using the 14-Day Read Through (%), entering the estimated percent of page reads that occur within the 14-day attribution window. To exclude this from the calculation, use a value of 100%.
If you’re using Amazon Attribution, use the optional External Orders field to exclude Amazon orders and page reads from other platforms.
Use your KDP reports to enter the total orders and pages read for each book in a series. Do the same for the ad attributed orders and page reads using the same date range from you Amazon ad console.
Using Impact Multipliers
Use the multipliers on your orders, sales, KENP reads, and estimated royalties figures in you Amazon ad console to get a truer picture of your advertising impact.
As a Merch Jar user, you can set your Profit Margin and Impact Multipliers in your Ad Account Settings. These settings will be used to calculate your adjusted and blended metrics throughout the app, including Blended Profit and Blended ACOS.
