Overview
Seller Central’s Sponsored Products Ad report – which is available only for sponsored product campaigns – gives you activity information about products that have received at least one impression during your chosen time period. An impression occurs when Amazon shows your product ad to a shopper. Whenever a consumer actually clicks on that product, you pay for that click. The calculation for your click cost is:
The number of clicks x cost per click (CPC) = “Spend.”
The Sponsored Products Ad report shows a performance summary for each of your advertised products, so you can compare the performance of your ads and identify areas to optimize. Show me a sample report.
Import Sponsored Products Ad data
Automatically
The Amazon Advertising API negates the need to download information from Amazon manually and upload it into Sellercloud. This tool interacts with both Amazon and Sellercloud at the programming level, which simplifies your workflow by giving you easy access to your advertising options.
Manually
Uploading the product ad data from this report into Sellercloud gives you the ability to analyze your product’s performance more effectively since this will be accurately reflected in the P&L of those products.
This process has 2 simple steps:
1. First, you download the Sponsored Product Ad report from Seller Central. You can choose productAds, adGroups, or campaigns.
2. Second, you upload that report’s data into Sellercloud, which automatically adds it to your Profit by Product Summary and Profit by Product Details reports. There, each product’s ad amount will be displayed in the Other Channel Fees column of the following Sellercloud reports:
- Transaction Summary report – This will be the total spent amount
- Transaction Details by Date report – This will be the amount spent per day
- Profit by Product Summary report – This will be the total spent amount
- Profit by Product Details report (shown below) – This will be the amount spent per day
The Trans Type column shows this transaction as a “Product Ad” to distinguish it from other channel fees of different transaction types:
Download the report from Seller Central
1. Log in to Seller Central.
2. There are two ways to navigate, either:
- Click Reports > Advertising Reports.
- Click Advertising Tab > Campaign Manager > Menu > Reports.
3. Search for the report name in the search box.
4. Click Report Name.
5. Click Download.
Show me a sample report.
Upload the report in Sellercloud
1. Click Company Settings.
2. Click Company Name.
3. Click in your company’s Toolbox > Channels > Amazon Settings > Upload File Report.
4. Click Upload File Report.
a. Click Select Report File > Choose File > Upload Report.
b. Click Report Type > Sponsored Product Ad Report.
c. Click Upload Report.
5. A queued job is created; click the link to open and monitor the import results. When the job is done, the Log section lets you confirm that all records were uploaded.
6. The next time you run your Profit by Product Summary or Profit by Product Details report, you will see this data in the appropriate product’s Other Channel Fees column.
Show me a sample report.
- Click Settings.
- Select a Company.
- Go to Toolbox > Amazon Settings > Upload Report File.
4. Click Choose File.
a. Click Select Report File > Choose File > Open.
b. Click Report Type > Sponsored Product Ad Report.
c. Click Upload Report.
