What are Negative Keywords?

Negative keywords help prevent ads from appearing on shopping results pages that don’t meet your campaign objectives. Negative keyword targeting can be used at either the campaign level or ad group level. (From Amazon Ads Advanced Tools Center)

Objective

Preparing the Search Term Report (STR)

  1. Open the Search Term Report.

  2. Click Enable editing.

  3. Add filters by hitting Ctrl+Shift+L or go to Sort & Filter then click Filter.

    Screen Shot 2023-05-24 at 1.08.24 AM.png

  4. For Campaign Name [Column E], choose one product (at a time).

    Screen Shot 2023-05-24 at 1.11.26 AM.png

  5. For Match Type [Column H], hide Exact.

    Screen Shot 2023-05-24 at 1.15.52 AM.png

  6. For 7 Day Total Sales [Column I], filter to only show $0.00 (no sales).

  7. Sort Spend [Column N] from Largest to Smallest.

    Screen Shot 2023-05-24 at 1.22.06 AM.png

  8. Highlight the rows with high spend (based on your criteria) but no sales.

  9. Remove the filter for 7 Day Total Sales [Column I].

  10. Sort by Total Advertising Cost of Sales (ACOS) [Column P] from Largest to Smallest.

    Screen Shot 2023-05-24 at 1.34.09 AM.png

  11. Highlight the rows with high ACoS (based on your criteria) and no sales.

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

    Q&A Session or Consultation

  12. Update the filter for Total Advertising Cost of Sales (ACOS) [Column P] to filter by color and only show your chosen color for the highlighted rows. The report will now only show you the:

    1. two keywords that have a high ACOS
    2. three keywords that have high spending and no sales

    Screen Shot 2023-05-24 at 1.42.42 AM.png

  13. These keywords will be added as Negatives. To do this, take note of the:

    1. Campaign Name - if you only have one Ad Group per campaign
    2. Ad Group Name - if you have more than one Ad Group per campaign