On Monday, the 6th of January 2019 Amazon changed the campaign dashboard and introduced enhancements to the reporting, as well as changes to the ad features. To export your campaign file please make sure that:

  • You have no filter activated
  • You have set the date range to ‘Lifetime’

It’s important that you check these two settings, otherwise, your campaign file does not contain all necessary data. After you have exported your campaign file, you can set the filter and date range back to how you prefer it.

On the top right corner on your screen, you see a little icon that looks like a bell. Whenever you see a number after it, you have a new notification. From time to time BookAdReport will release new features or improve on existing ones. Whenever that happens you get a notification.

Click on the bell or the number and you will see a menu with all notifications topics.

Click on one of the topics, and you will get into the user notification section. Here you can read what has changed or what’s new. If you are done with reading, check the box next to ‘Mark as read’, and the notification will be archived.

At the bottom of your dashboard, you will see two circle charts. These charts show the percentage of your sales and advertising spend in relation to your set target amount.

With the help of these both charts, you have an eye on your monthly goals. You can set these targets in the Settings panel under ‘Monthly Target’.

If you are just getting started with advertising think about a realistic goal for your sales and the amount of advertising cost you want to spend per month.

Tip: If you don’t want to show these two charts simply uncheck them in your Settings panel.

Once a few days have passed, and you have uploaded your amazon campaign data every day, your dashboard will start to show your campaign stats in various forms.

You can either select from the calendar menu by choosing a start and end date, or by selecting from the date menu next to it. It allows the following choices:

  • 90 Days
  • 60 Days
  • 30 Days
  • 14 Days
  • 7 Days
  • Month to Date
  • Last Month
  • Calendar

Once you choose a time frame it will save that choice automatically. You may always want to check on the current month or the last 30 days. Whenever you come back to your dashboard it will show your data based on this last choice.

On top, you will see up to 10 different data cards.

Most of these data cards are self-explanatory and contain a summary or an average value based on the number of days in the current month.

  • Gross Profit is calculated by sales minus ad spending cost.
  • Avg CPC is your average cost per click on all campaigns
  • Avg ACoS is your average Advertising Cost of Sales
  • Avg CTR is your average Click Through Rate on all campaigns
  • Avg Sales/day is all sales divided by the number of days until today

Tip: You can select which data card you want to include on your dashboard. Go to the Settings menu and check or uncheck the elements.

Below the card elements, you will see up to 10 different charts, which show you the daily movements of these stats. Below you see the chart for impressions and clicks.

Compare Performance
What you won’t see yet is the little number on the right top. This number will show up once you have at least one month of data uploaded. It shows you the percentage change of this month performance compared to last month performance in the same time frame.

It is green when the performance has improved and red when it’s worse than last month.

Tip: You can select which chart you want to include on your dashboard. Go to the Settings menu and check or uncheck the chart elements.

After you have uploaded your first campaign file you will be redirected to the Statistic – Last Imported menu. Here you will see your campaign data listed in a table. Depending on the number of campaigns you have this list may be shorter or longer than the example list below.

Tip: If you don’t see all columns use the arrow symbol on top, next to the Book Ad Report logo to collapse the menu to its minimum size.

Depending on the number of campaigns you have this list may be shorter or longer than the example list below.

This table shows you the latest data compared to the data from your last upload. If you upload data on a daily task, which we highly recommend, you see in this table your daily sales, advertising cost, and all other campaign data.

All columns are sortable. You can sort the table by clicking on the table column header. For example, you could sort by sales to see your best performing campaigns.

Visible Rows
On the bottom of the first table, you will see a selector where you can change the number of campaigns per view. The default value is 25. On the right side, you can click on the numbers to go to the next page view.

A second table at the bottom shows you a quick summary of all campaign data. Here you can see your daily sales summary, daily spend summary as well as the gross profit.

Book Ad Report imports all campaigns with either ‘Running’ or ‘Pause’ status. This means that you may see campaigns with zero data until you are switching them back to ‘Running’. To make it easier to compare data you can temporarily delete these campaigns from the view by clicking on the red X icon.

Summary Table
Below the table of your imported campaigns, you see a summary table. You can delete certain campaigns from this view to better compare campaign groups. In that case, the summary table gets automatically updated.

Please go to your Amazon marketing service campaign overview page, which should look similar to the example below. You may have more or fewer campaigns listed than the example shown below.

Export Campaigns
At the top to your right is the date range selector. Please click on Date range and select ‘Lifetime’ from the menu. If you don’t select lifetime your campaign file will not contain all the data!

Also, please make sure that no filter is selected. If you have a filter currently selected please reset your filter. After exporting you can set this filter again.

Scroll down and click the ‘Export’ button next to the ‘Columns’ Selector button.

You will see a pop-up window. Save the campaign file to your desktop, download folder or any other folder. Go back to your Book Ad Report dashboard, select the Upload menu and choose the option ‘Campaign File’. Then click on ‘Select Campaign File’.

A pop-up window appears, where you now select the campaign file that you have downloaded previously from your amazon marketing service. After clicking on ‘open’ your campaign file will be imported.

You will see the progress on the import, and after the import is finished the program will redirect you to the Statistic – Last Imported section. Here you can see the complete data from your imported campaign in a table.

We recommend that you delete this campaign file after you have uploaded it to your Book Ad Report account. This way it’s impossible to upload any campaign files from previous days.

No campaign data is lost when you upload only once in a while. The last upload always contains all of your ad campaign data. See explanation below.

Book Ad Report will start working and shows you relevant stats after the second upload. It needs a minimum of two campaign sets to calculate your data. Amazons’ campaign file does not contain a date stamp – only accumulated data. Therefore, you can only upload one campaign file per day. During the upload, this campaign data will be date stamped.

The longer you use it, the more relevant data you see, and the more useful stats you have to work with.

Account Levels
Based on your account type you can upload a file with up to 300 campaigns. The Starter account allows up to 5 campaign, the Standard account up to 20, and the Pro account up to 300. The program only counts running campaign, but also imports all paused campaigns.

Upload Cycle
It is recommended, but not necessary to upload your campaign file daily to get the most benefits from this program. Daily uploading your campaign stats gives you exact information on your ad performance every single day.

If you skip a day or a few days no data is lost. The program will use the data from your last uploaded campaign file to automatically calculate the data between the missing days.

Let’s assume you upload data on the 5th and the impression count for a particular campaign is 10,000. Then you upload again on the 10th and the impression count of that campaign is now 20,000 then the program will calculate the dates from the 6th to the 10th with an impression count of 2,000 for each day. The same calculation will be done for all other metrics of this and all other campaigns in the campaign file.

Historical Data
Once you uploaded your campaign for today’s day you won’t be able to upload another campaign file. That’s a built-in security feature to prevent you from overwriting already existing data.

The campaign file itself does not contain any date information!

Currently, it’s not possible to upload historical campaign data. However, we are already working on this, and we will inform you when this feature is available.