Split testing is available in the Pro account and helps you compare two campaigns. The result shows you which of the two campaigns created more profit.

For this, to work, you need at least two campaigns, which you can compare in terms of the same amount of impressions. Of course, you will never have exactly the same one – that’s just not possible the way Amazon runs your ads. However, they should not be more than 25% apart. The program will give you a notice if that’s the case.

Read more

From the Amazon Advertising main dashboard scroll down, until you see the table where your campaigns are listed. Then select the campaign, where you want to export the keywords. The screen should look similar like this:

On the right side at the top of the screen select ‘Date Range: Lifetime’. This is important, otherwise, you don’t have all the data in your exported file. Now, scroll down until you see the screen below:
Click the ‘Export’ button next to the ‘Columns’ button and then follow the instructions on the screen to download the file to your desktop. We recommend that you change the file name to the campaign name, once your file is downloaded. Amazon gives your export file an arbitrary file name, which does not contain the name of your ad campaign.

Amazon gives you the ACoS as a measurement on the performance of your ads. The lower the ACoS, the better performs your ad campaign and the more money you make. The ACoS is calculated by using the cost of spending and dividing it by sales.

Let assume your paperback sells for $14.95 and you sell five copies per day. That’s $74.75 in gross sales for this day. Now, let’s further assume that you spent $25 in advertising for this day. To calculate your ACoS, you divide $25 by $74.75 and multiplicate it by 100 to get it in percentage. Your ACoS for this example is 33,4%.

This number doesn’t tell you anything until you have figured out your break-even point. The break-even point can be defined as a point where total costs (expenses) and total sales (revenue) are equal.

Let’s presume your paperback royalty on your book is $4.83. You will find this number in your KDP bookshelf under the third tab Paperback Rights & Pricing.
This example is based on 60% paperback royalty and 274 pages. If you use the Paperback calculator and enter these numbers you will get the break-even point of 32.3%. Now you can compare the break-even point with the ACoS from Amazon.

In our example above Amazon reported an ACOs of 33.4%. Our break-even point is lower than that with 32.3%. We hardly make any money – basically we just break-even.

In order to profit from the ad campaign, the ACoS needs to be lower than our break-even point!

For this reason, we have developed the royalty and break-even calculator for Kindle, paperback, and book summary.

Paperback Analysis

Enter your paperback sales price and your page count. You will see your royalty and break-even point automatically on the right side. This calculator is interactive – just change any number and you’ll see the result immediately.

The paperback royalty in the US is 60% and for the extended distribution 40%. From that, you have to deduct the printing cost based on the b&w/color option and page count.

For example, here’s how Amazon calculates the printing cost of a 300-page black ink paperback sold on the US marketplace:

$0.85 (fixed cost) + (300 (page count) * $0.012 (per page Cost)) = $4.45 (printing cost).

Kindle Analysis

Enter your Kindle sales price and your file size, then choose your royalty plan.

You’ll find the file size in your KDP bookshelf under the third tab Kindle Ebook Pricing. Don’t use the file size on your Amazon book page, which usually shows a bigger file size.

You will see your royalty and break-even point automatically on the right side. This calculator is interactive – just change any number and you’ll see the result immediately.

The Kindle royalty is either 35% or 70%. If you are on the 70% royalty plan you pay an extra delivery fee based on the file size of your ebook. In the US this is $0.15 per MB.

Please keep in mind, that when you sell your ebooks to customers outside of the US a sales tax applies. See the list by country here.

Summary Analysis

If you sell Paperback and Kindle books you want to know your ‘overall’ break-even point from these two combined numbers. Fill in both numbers and then calculate from your past month the ratio between Paperback sales and Kindle sales.

For example, if you sold last month 100 Kindle books and 100 Paperback books than your ration is 50%:50%. Simply change the slider to the ratio and you will see your final overall break-even point.

How to Calculate the Ratio
1. Add your Kindle and Paperback sales together
2. Divide the number by 100
3. Use that number as a divider for your Kindle or Paperback sales

Kindle Ratio = Kindle / ((Kindle + Paperback) / 100)
Paperback Ratio = Paperback / ((Kindle + Paperback) / 100)

The dashboard, group campaign and single campaign statistic show trendlines, as well as trend indicators in all charts. The trendline in grey color shows you the overall trend for the selected time span. The trend indicator on the top right corner of each chart shows you the trend calculated in percentage. A green label indicates a positive change, and a red label indicates a negative change.

Trend Line & Indicators

Note: Trendlines in your charts start showing with a selected time frame of 30 days or more. At least 20 sales are needed for the given time frame to show trendlines and indicators in the sales and ACoS chart. Also, they only show on charts without any date gaps at the beginning or the end.

You can change these settings under preferences:

The dashboard shows trendlines when you select the calendar and choose a time frame of at least 30 days. When you select the Month to Date range you will only see trendlines, but no trend indicators. Instead of trend indicators, you will see the percentage of change compared to the date range from last month.

If you look in your dashboard on the 18th of this month, and you have data uploaded for last month period, then every chart shows you the change in percentage from the last month from the 1st to the 18th.

For example, you may see the number +23 on your impression chart with a green label. This means that in the days from the 1st of this month until the 18th of this month your campaigns have received 23% more impressions than from the 1st until the 18th in last month.

The average ACoS is your advertising cost of sales over the complete time your ad campaign runs. Every day it is new calculated – based on new sales and advertising cost.

This means – that over time – this metrics will change less and less, because there is more data accumulated. This also means, that when you change the parameters for your ad campaign e.g. keywords, your average ACoS will hardly change at all. This is a huge disadvantages when it comes to tracking any changes you are doing with your ad campaign.

If you don’t see these columns please make sure you scroll the table all the way to the right. You can also filter any columns you don’t need from the table columns selector on the top right of the table. All settings are automatically saved for you.

The real ACoS is calculated based on the time frame you select in your report. The report will only take ad cost and sales for this time frame, and calculate the ACoS. This will give you an exact number, and it is very helpful to track changes over time.

In the All Campaigns overview we use the average ACoS and the real ACoS to calculate a trend value. If the real ACoS is higher than the average ACoS than you see a green up trend indicator. If the real ACoS is less than the average ACoS you will see a red down indicator.

Tip: Move over the indicator with your mouse cursor to see the change of this value.

Campaign groups let you group different campaigns under a new name. You will find the group feature under the Statistics menu. To create groups go to the Settings menu.

You can use groups to bundle all campaigns for a particular book. You may use different ad campaigns – Product Display and Sponsored Products – for one book. You may also have different campaigns – using keywords to target more than one market – for one book. When you group them together you can see the summary of these campaigns.

You can also use groups to track a book series or compare a single book to a book series. By using groups you can easily track your summary on sales and ad spending.

Go to the Settings menu and select Groups. You will see the following:

On this page, you can create, modify and delete groups. Groups are formed by selecting various campaigns under a name of your choice. It’s like a super campaign that contains other campaigns.

Create Groups

To create a new group please select your campaigns from the campaign selector.

In the step give your group a name (at least 8 characters) and after that click the create button.

Once you have at least one group created you will see an overview of your groups and the campaigns it contains at the bottom.

Modify Groups

Once you have at least one group created you can modify it by changing the included campaigns. Simply select the group name from the list.

And for the second step change the campaigns that you want to have in that group. Click on an entry to select it and click twice to de-select it. Any selected entry will show with a checkmark at the end of the campaign name.

Finish your group modification by clicking the Modify button. Your group is modified and you can see the results instantly at the list on the bottom.

Delete Groups

Select the group you want to delete from the list of groups and hit the Delete button.

You will find a month to month statistic of your campaigns under the Statistic menu – it is called Trending. When you select this option the calendar is automatically set to the beginning month of the date of your first campaign upload, and to the ending month to the date of your last campaign upload.

Click the ‘show’ button and your statistic over the chosen time period will show up. Please note that the monthly bars can only be as accurate as the campaign data you have uploaded. If you don’t upload data on a daily basis then the monthly stats may not show the actual values.

The program takes the first and the last entry of every month and calculates the difference. Let’s say you have uploaded your first campaign data on October 2018 on the 5th and the last on the 31st, then the summary shows only these days and nothing from the 1st to the 4th.

On top of your month to month overview you will see the three boxes showing you the month of your top profit, top sales, and top ACoS. Below you will see bar charts for monthly impressions, clicks, CTR, Sales & Ad Spending, ACOS, CPC and detailed page views (DPV).

It is recommended, but not necessary to upload campaign data once per day. You should do this around the same time, in order to get accurate daily statistic reports. You can only upload one campaign file per day. This should be the campaign file that you have downloaded before from your Amazon Advertising dashboard.

When you are at the Upload menu section you will see the current date at the top. This date reflects the server date and may not be identical with your local time zone. To check the time zone of the server please have a look at your user status, which you will find under the User menu section.

If you try to upload the same or any other file again the program will first check the database if there are data already uploaded for the current date. Please keep in mind that the Amazon campaign file you download does not contain a date stamp. This date stamp is provided when your campaign file is uploaded into your account database.

You will see this message when you try to upload your campaign file a second time for today. Keep in mind that your date may already be changed but not the server date. Simply check under the user account menu what date you will see there.

During the import of your campaign file, you may get the following message: ‘Campaign file contains data older or the same than the last imported’. If everything runs fine you should never receive such a message.

As you may know, your downloaded Amazon campaign file does not contain a date stamp. This means, that theoretical it would be possible to upload an old campaign file with a newer date stamp. This would certainly screw up your statistic, as the program relies on accumulated data.

For this reason, the program checks the last uploaded campaign file against the new one. It looks into all ‘Running’ and ‘Paused’ campaign files and calculates the sum of all campaign impressions. The new file should have a larger sum of impressions than the old one.

It happened only once since BookAdReport is online, that Amazon provided inconsistent data in the campaign files. These inconsistencies resulted in less or even zero impressions for one or even several campaigns. Also, these problems occurred over a time span of 2-3 days.

To prevent importing inconsistent (wrong) data the program gives you a warning and prevents you from importing your campaign file.