The Author Helper Suite Help – Ads Page

When you go to the AMS sign-in page you are met with the question, “What country are you advertising in?” Please select the country you are paid in so that the correct currency is displayed in your reports.

In order to get your ads reports for Amazon up on The Author Helper Suite, please follow these steps.

STEP 1 – Make sure you’re on the main campaigns page and select the date you want to download. 

NOTE: Amazon often updates the data multiple days later, so you should always go back a few days to make sure that you have the latest data. How many days is unknown, but we tend to look back 10 days.

NOTE: DO NOT use date ranges. Amazon does not split the data up over date ranges. You must upload only ONE day at a time. If you do a date range and upload it, you’ll just see a big spike for that day. If that happens, simply download the single day’s worth of data and then upload it again.

Make sure you’re looking at all campaigns, not just one campaign.

Also, be sure you are in the multi-country view so you can capture all ad spends across all countries. You can find this setting in the upper right corner of the screen. Click on the text “Sponsored ads – Author” to see your options.

Select the specific date you want to download. Select only ONE day. Date ranges are not supported because AMS reports over 2+ days don’t identify what spend happened on which day. Click the “Export” link and download to a place on your hard drive where you can easily find it. 

STEP 3 – Upload your report to The Author Helper Suite

The key component here is that you want to make sure you select the right date for your report. This is only necessary for Amazon ads reports because–for reasons we can’t explain–Amazon does not put the date in their reports.

NOTE: The Author Helper Suite has no way of knowing if the date of the report is correct for the date you select. The good news is that if you accidentally select the wrong date you can now simply upload the report again using the right date! Just remember that you’ll also need to re-upload the report for the date you had accidentally selected.

Follow this image for details.

STEP 4 – Do sanity checks on the data

At certain intervals, you’ll want to check the data to make sure that Amazon hasn’t updated your daily spends. About 10 days into the month, take a day to fully look over the previous month’s data, for example. 

Follow these images for details.

• Status
• Campaigns
• Impressions
• Clicks
• Country
• Spend
• Sales
• Portfolio
• New-to-Brand sales
• State
  

Here’s an example that shows how to add the “Impressions” column to your report file. To find any of the other required columns, use the “Quick search” to filter them.

In the pop-window, choose the column you want to add. In this scenario, it’s the Impressions column.

Click “Apply” and export the day’s report again. The columns will now appear in the report and should upload to AHS fine.