psss... don't forget to confirm your email to receive your playbook.
Instructions
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
Your Impact Multipliers and Average Profit Margin will be calculated for you.
Download your Amazon Ads reports. Go to Sponsored ads reports
5. Create a report. Any time period should work, just be sure to match the time period in your KDP reports
6. Run the report and wait for it to complete.
7. Refresh the page, the click download
Input data. Use the 'Combined Sales' and 'KENP Read' sheets from your royalty reports. For the Advertised Product Report, select the marketplaceC
Reports sheet. This contains the reports that will be used to compile the raw data sheet. You don't need to do anything here, unless you want to clean up the data.
10. This is used to get royalties from page reads for the KENP report. It uses historical rates.
11. Raw Data sheet. Data from the reports sheet is compiled from reports. The refresh sales button must be used to pull in the data. It is also located on the dashboard. Use the clear button on the Raw Data sheet to remove all existing data.
12. Series Organization. This pulls unique titles from the Raw Data sheet. You can enter the names of your series in column A, associate the series with titles in column B, and set the order of the title in column C.
Book details. Here you can set the length of your book, in order to calculate the number of borrows from KENP reads.
Series conversion. Clicking refresh will pull in all series and titles from Series organization and puts them in sequential order, calculating conversion rates from title to title using total orders or KENP.
Halo orders and KENP use conversion rate from total orders to calculate halo sales from paid orders and KENP.
The 14-day read through percentage is used to calculate Extended KENP for reads outside 14-day attribution window. This is the total number of direct and indirect paid KENP. It is calculated by: (1-read through%)*Paid KENP + Paid KENP
Dashboard. Using the dropdown on the right side, you can choose which marketplace you want to see data for. You can refresh the sales data, doing a complete refresh of the raw sales data table from the inputs table. You can use the currency conversion to convert everything to your local currency.
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.
