Sponsored Products Placement Report
Who is this for: Intended for marketers, advertising specialists, and e-commerce professionals who are responsible for managing and optimizing advertising campaigns for products on Amazon. By following this SOP, these individuals can gain a better understanding on how to leverage Sponsored Products Placement Reports to improve their advertising strategies and drive more sales for their products.
Objective: The objective of this SOP is to provide step-by-step guidelines for creating and analyzing Sponsored Products Placement Reports on Amazon. The report analysis will help advertisers identify the best placements for their ads, optimize their bids, and increase the overall effectiveness of their advertising campaigns.
STEPS:
Step 1: Click on the three-line bar located on the top left side of Amazon seller central homepage, then select "Advertising," and choose "Campaign Manager".
Step 2: Click the "Measurement & Reporting" icon and then select "Sponsored ads reports"
Step 3: Click on the "Create report" button.
Step 4: Choose "Sponsored Products" as the campaign type and select "Placement" as the report type. You can also choose the time unit and date range for the report.
Step 5: Label your report and schedule a delivery time if necessary. It's recommended to have a regular monthly report to keep track of the performance of the campaigns.
Step 6: Click on the "Run Report" button to generate the file. 
Step 7: Download the report and upload it to a Google Sheet
Step 8: Select all the data and create a Pivot Table
Step 9: Build the pivot table. We will build it like this:
- Set Placement as rows
- Under values, we should put:
- SUM of Spend
- SUM of 7-Day Total Sales
- SUM of Impressions
- SUM of clicks
- SUM of 7 Days Total Orders (#)
This way, we can build some KPIs by placement such as
- ACOS = Spend/Sales
- CTR = Clicks/Impressions
- CVR = 7 Days Total Orders (#)/Clicks
We will be able to understand how we are performing in terms of ACOS, CTR, and CVR in the different advertising placements.
