Bulk Operations for Targets

How to make bulk changes to your keyword and ASIN targets in your Sponsored Products goals using Perpetua's CSV upload feature

Gloria Steiner avatar
Written by Gloria Steiner
Updated over a week ago

Quick Links:

Things to Note:

  • To learn how to conduct bulk operations for your goals & segments, please review this article.

  • To learn how to conduct bulk operations for your campaigns, please review this article.

CSV Breakdown & Bulk Actions for Targets

Listed below are the current actions you can perform on your Sponsored Products targets using the bulk CSV file:

  • Pause and enable targets

  • Add new targets and negative matches

  • Apply fixed and AI-powered bid adjustments

🚨 Things to be aware of:

  • You cannot archive targets

  • You cannot apply a negative match to a category target

  • The maximum bid multiplier you can use if 5x for a dynamic bid adjustment

CSV Breakdown

  • COLUMN A (Is Negative?)

    • This is where you can indicate whether a target is a negative match or not

    • Set the status as YES if it is and NO if it isn't for changing the target status.

  • COLUMN B (Status)

    • Refers to the status of your target

    • It will say Enabled if the target is active and Paused if it's inactive

  • COLUMN C (Target)

    • Displays the target itself

  • COLUMN D (Type)

    • Specifies the target type.

    • For keywords, this will be BROAD, PHRASE, or EXACT.

    • For ASIN or category targets, it will say TARGETING_EXPRESSION.

  • COLUMN E (Bid Adjustment - Fixed) and F (Bid Adjustment Multiplier)

    • These columns are used to apply bid adjustments. Only one of the two columns need to be completed.

    • Enter a value (ex. 1.00) in column E if you want to apply a fixed bid.

    • Enter a value between 0.05 to 5 in column F if you want to use an AI-powered, dynamic bid multiplier.

  • COLUMN G (Duration)

    • Used to set the duration for your bid adjustment. You have 3 options, a value between 1-30, Always, or Ended.

      • Entering a value between 1 and 30 means you want the experiment to expire. For example, 7 means that the bid adjustment will only run for 7 days.

        • Note: If I start a bid adjustment today at 11AM and select a 7-day duration, it would end at 11AM on the 7th day.

      • ENDED means the bid adjustment experiment is stopped.

        • Reminder: You must input ENDED to stop a bid adjustment. Deleting the row will do nothing.

      • ALWAYS means that the experiment will be ON and never end.

  • COLUMNS H (Description), I (Errors), and J (Warnings)

    • If any errors exist after trying to upload the file, the details of those errors will be displayed here. Resolve the states issues, save the file, and re-upload to try again.

    • These columns will be empty unless the system detected errors in the template.

Performing Bulk Changes for Targets

  1. Click on Sponsored Products on the left sidebar and then your goal in the table below goal. Once you are in the goal, click the Targets tab.

  2. Press the Bulk Operations icon on the upper right corner of the Targets list.

  3. Select Download CSV Template to generate and download the file.

4. After opening the file, make your desired changes by changing the column contents. If you want to add targets, you will need to fill out a new row on the spreadsheet. For a complete breakdown of each column in the CSV and what its function is, please refer to the column breakdown above.

5. Save the changes in the template. Upload the updated .csv file to Perpetua by repeating steps 1-2 but clicking on Upload CSV instead. After you select the file, you will see a progress bar showing the completion rate of the upload.

6. Once the upload is successful, a pop-up message will appear in the upper right corner to confirm that the changes have been updated. If the upload fails, a red error message will appear instead. The section below reviews the steps you can take to resolve the problems.

Article last updated August 2023. If you find this information to be out of date, please contact hello@perpetua.io

Did this answer your question?