All Collections
How To Use Perpetua's Features
Bulk Operations
Bulk Operations for Sponsored Products Goals & Segments
Bulk Operations for Sponsored Products Goals & Segments

Learn how to use Perpetua's Bulk Operations tab to manage all of your Sponsored Products goals and segments at the same time

Serghei Barbulat avatar
Written by Serghei Barbulat
Updated over a week ago

Quick Links:

Things to note:

  • The current functionality of this tab is limited to managing Sponsored Products only. Additional capabilities for this tab will be released in the near future and this article will be updated accordingly to reflect that.

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

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

CSV Breakdown & Bulk Actions for Goals & Segments

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

  • Launch new goals

    • This includes the entire setup like indicating your targeting type, setting your target ACoS and budget, adding branded/competitor phrases, keyword/ASIN targets, and so on

  • Adjust budgets and target ACoS for existing goals

  • Pause goals (you cannot delete goals)

  • Adding and removing ASINs within existing goals (ASINs cannot be paused)

    • Removing all ASINs within a goal will not delete the goal

    • If you want to delete ASINs, you can set the status as "Deleted"

🚨 Things to be aware of:

  • You cannot update the targeting type for an existing goal through bulk operations

  • Deleting an ASIN from a goal and adding it to a different goal cannot be done in one spreadsheet and require two separate uploads

  • You can only update goal names, not campaign names

    • If you update the goal name in Perpetua, it will not reflect on Amazon

CSV Breakdown

  • COLUMN A (Company Name)

    • Your Perpetua account name and the marketplace you advertise in.

  • COLUMN B (Type)

    • Type of goal you have, targeting type you're using, and the products within it.

    • The first row of a goal will always state the type it is, like MultiCampaign_Goal, SingleCampaign_KW, or SingleCampaign_PAT.

    • The next row refers to the targeting type, like MultiCampaign_U for Universal targeting, MultiCampaign_B for Branded, and so on.

    • The following row(s) will be for the products within that goal and will all be labeled as Product.

  • COLUMN C (Goal Title)

    • What your goal is named in Perpetua.

  • COLUMN D (Goal ID)

    • Gets auto-populated with your goal ID.

    • If you're launching a new goal using this spreadsheet, leave this field blank.

  • COLUMN E (Status)

    • Status of your goal.

    • If your goal is active, it will say Enabled, but if it's paused, it will say Paused.

    • Change the status in this column accordingly for any non-product rows if you're launching a new goal or pausing an existing one.

    • To delete an ASIN from a goal, make the status in this column Deleted.

  • COLUMN F (Daily Budget)

    • Daily budget you set for the goal and specific targeting type.

    • This number will only be populated in the targeting type row so any edits should be made there.

  • COLUMN G (Target ACoS)

    • Target ACoS you set for the goal and specific targeting type.

    • This number will only be populated in the targeting type row so any edits should be made there.

  • COLUMN H (ASIN)

    • ASIN for your product.

    • This value will only appear in the product-specific rows.

  • COLUMN I (Branded/Competitor Segment Phrases)

    • Contains any branded or competitor phrases you've added to those segments of your goal.

    • If you're launching a new Brand-Based or Advanced goal and are using the Branded and/or Competitor segments, you'll enter those specific phrases here.

  • COLUMN J (New Keyword Targets - EXACT)

    • You can add exact match keyword targets to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN K (New Keyword Targets - PHRASE)

    • You can add phrase match keyword targets to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN L (New Keyword Targets - BROAD)

    • You can add broad match keyword targets to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN M (New PAT Targets)

    • You can add PAT targets to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN N (Negative Match Keywords - EXACT)

    • You can add exact match negative keywords to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN O (Negative Match Keywords - PHRASE)

    • You can add phrase match negative keywords to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMN P (Negative Match ASIN)

    • You can add ASIN negative matches to your new and existing goals here.

    • Make sure to separate them by comma if adding multiple.

  • COLUMNS Q (Segment Min Bid) and R (Segment Max Bid)

    • Set minimum and maximum bids for your individual goal segments here.

  • COLUMNS S - AE

    • Contain performance metrics for your goals like attributed sales, spend, ACoS, CVR, and more.

    • The timeframe of the data is controlled by the Performance Date Range field prior to downloading the CSV.

  • COLUMNS AF (Result), AG (Errors), and AH (Warnings)

    • Show you whether a change in a row was successfully pushed through and, if not, what kinds of errors/warnings need to be resolved before trying the upload again.

Navigating the Bulk Operations Tab

The Bulk Operations tab allows you to manage and make bulk changes to your existing Perpetua goals all in one place. Listed below are instructions on how to setup your CSV file, download and upload it, and view the download & upload history across your account.

1. Navigate to the Bulk Operations tab in your left sidebar and select "Make changes to existing Perpetua campaigns".

2. The Performance Date Range field is where you indicate the time period you'd like to be used when pulling in your goal performance data into the CSV file. This information will be presented in columns S through AD and is limited to a 30-day period.

3. Set the Ad Type dropdown to Sponsored Products and the Granularity Level dropdown to Goals & Segments.

4. Click the Download Custom Spreadsheet button.

5. After downloading and opening the template, all the changes will be made within. Please refer to the column breakdown to understand how to make edits to your goals or launch new ones.

6. Once all of your desired changes have been made in the CSV file, upload it to your Perpetua account. You'll see the progress bar update in the Download & Upload History section below.

7. After the upload is complete, if there were any issues or errors with the file, you'll see those details in the Status column. From there, re-download the CSV file and refer to the Result, Errors, and Warnings columns on the far right. The successful rows will have been pushed through and there will be a message in the Result column providing you that information. Any rows that had issues and were not pushed through will have those corresponding messages in the same columns. Correct the rows with the issues, save the file, and re-upload the CSV to try again.

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?