Steps on How to Advertise Product Report

Steps on How to Advertise Product Report

1. Go to the Campaign Manager

1. Click on one of the campaigns

1. Go to AD Group-> Copy the title of the AD Group you are interested in

4**. Check the ASINs that you’re targeting and decide which one you should continue running.**

1. Go to measurement and reports

1. Create a Report

1. Choose an Advertised Product/ Summary for the last 30 days

1. Open the downloaded report

   • It shows all of the different campaigns with the ad groups, with which ASIN and which SKU was advertised, and what the results are.

   

   1. CTRL+F and search for the AD Group copied earlier

   2. Create a Pivot table:

      a. Advertised ASIN -> Rows.

      • It selects the full range

      

      b. Clicks, Spend, Total Sales, Impressions -> Columns

      • Put it into a new worksheet.

      • In a new worksheet.

        • Choose what you want to show. Like advertised ASIN or SKU, whatever you prefer.

        

        c. Formulas to add “= Sales/ Spend”, “=Clicks/ Impressions” (+format the column for %)

        

        1. Highlight the ASINs that brought the most Sales and decide which Campaigns should continue running and which ones should be stopped. Then, go back to the Campaigns and turn off the ones that are not performing well.

        

      Want a Quick Chat for you Brand ? Connect me here 👉

      Q&A Session or Consultation