Amazon Ad Profitability Calculator: Setup (1/2)

download the Amazon Ads calculator

This calculator can crunch revenue per click, profit per click, conversion, and cost per unit for you. All you need to do after entering your revenue per sale, revenue per borrow, and KENPC numbers is copy and paste your Amazon Ad data in. The calculator will do the rest.

You can only use this calculator to analyze ads that are (1) running for Book 1 or Box Set 1 and (2) include only a single book being advertised in the Amazon Ad campaign (e.g., you can’t have all the books in your series being advertised in the same campaign because it skews the sales and reads numbers). Otherwise the analysis will be inaccurate.

It does not work with Sponsored Brand ads, since they require you to have 3+ books in the campaign.

The setup walkthrough and analysis videos are both linked in the sheet, along with a link to make an additional copy of the calculator. For the walkthrough on how to use the calculator to analyze your ads’ performance, check out the Analysis Walkthrough video.