Badger Sheets reads the bulk operations spreadsheet that Amazon Ads generates for your account. Here is how to get one.
Steps
-
Sign in to Amazon Advertising and pick the account and marketplace you want audited.
-
Open Bulk operations from the left rail, or go to https://advertising.amazon.com/bulk-operations.
-
Choose the option to create or download a custom spreadsheet.
-
Pick a date range of 30 to 60 days. Shorter windows make the per-month figures jumpy, and longer ones make the file large.
-
Include every ad type you run. Sponsored Products, Sponsored Brands and Sponsored Display all come out in one workbook.
-
Tick the option that includes Sponsored Products search term data. It adds a Search Term Report tab, which is what the Search Terms tab and the N-Gram Analyzer read. Without it, the audit still runs but those parts stay empty.
-
Wait for Amazon to generate the file. It usually takes a few minutes, and longer for big accounts. Download the .xlsx when it is ready.
-
Drop the downloaded file at https://sheets.adbadger.com.
Two things not to do
Do not rename the file. Amazon puts the date range in the filename, and The Badger uses it to show your spend, sales and orders per month and to place you in the right spend tier. A renamed file still audits, but the report shows file totals instead.
Do not open the file and save it again from Excel, Google Sheets or Numbers. A re-saved copy is not the same workbook and The Badger cannot read it. Drop the original download.
Console language
Amazon writes the bulk file in whatever language your Ad Console uses. The Badger reads English and Italian files. If your console is set to another language, switch it to English, download the file again, and drop that one.