Sponsored Products Ad Report

Click here for information on this function in Sellercloud's original interface.

Understanding the Sponsored Products Ad Report

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:

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.

Understanding Amazon Advertising API 

The Amazon Advertising API negates the need to download information from Amazon and upload it into Sellercloud. This tool interacts with both Amazon and Sellercloud at the programming level, which simplifies your life by giving you easy access to your advertising options.

Authorizing the Sponsored Products Ad Report using Amazon Advertising API

The client setting Amazon Advertising API was recently added. If you do not see it, please request an update.
  1. Go to Sellercloud Settings > Client Settings > Amazon > Enable Amazon Advertising API.sellercloud sponsored products ad report
    1. Once enabled, you will be able to view new Amazon settings in your Company Settings.
      1. Go to your Company > Toolbox > Amazon Settings > General Settings.                                     
  2. Go to your Company > Toolbox > Amazon Settings > General Settings > Select Action > Authorize SellerCloud for Amazon PPC > Go. 
  3. A popup tab will appear that prompts you to login to your Seller Central account. After authorizing Sellercloud, you will then be redirected to Sellercloud.
  4. Sellercloud will fetch your company profile. Only for unified accounts: If you have multiple profiles, select the one matching the country code of your company from the Advertising API Profile drop down menu.
    1. To view the Advertising API Profile drop down menu, go to your Company > Toolbox > Amazon Settings > General Settings > Advertising API Profile > Select your choice.                                                                                                                                                                                         
  5. Take the following steps based on your account type:
    • For non-unified accounts: You are finished. Sellercloud will automatically download your Sponsored Products Ad report each night.
    • For unified accounts: The action Authorize Sellercloud for Amazon PPC will only appear for the parent company. However, the credentials will carry over to the child companies.
      • For each child company,  you will need to begin again at Step 4, and select the appropriate Advertising API Profile.

 

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:

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.

Uploading the product data into Sellercloud

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.

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 total ad “Spend” amount per product per day appears in the Other Channel Fees column, as shown below.

In the Profit by Product Summary report – This will be the total spend amount

In the Profit by Product Details report (shown below) – This will be the per-day spend amount

Also, notice that the Trans Type column shows this transaction as “Product Ad” to distinguish it from other channel fees of different transaction types:

Downloading the report from Seller Central

1. Login 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 report name in the search box.

4. Click Report Name.

5. Click Download.

Show me a sample report.

Uploading the report to 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.

 

Was this article helpful?

Yes No

Related Articles