All Collections
How To Use Perpetua's Features
Bulk Operations
Bulk Operations Tab for Sponsored Products Goals & Segments
Bulk Operations Tab 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

Mitchell Bergin avatar
Written by Mitchell Bergin
Updated this week

🚨 Note🚨

  • The current functionality of this tab is limited to managing Sponsored Products only (specifically at the creation/edit of Goals/Segments).

  • 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.

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



Quick Links:



Supported Actions and Factors to Consider

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

📗Supported Actions

  • Launching new Classic & Custom goals with different targeting types (universal, brand-based, advanced).

    • 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 Daily 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".

  • Adding targets to existing goals.

  • Adding negative matches to existing goals.

  • Editing branded/competitor phrases for existing goals.

⚠️ Factors to Consider

  • 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 requires 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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.

    • Must be entered in the goal-level row (defined by column B).

  • 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 set up 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 "Bulk Edit & Create".

2️⃣ From the "Granularity Level" drop-down list, select "Goals & Segments":



3️⃣ The "Ad Type" is set by default with "Sponsored Products.
4️⃣ 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. ⚠️

5️⃣ Click the "Download Custom Spreadsheet" button.


6️⃣ After downloading and opening the template, all the changes will be made within. Please refer to the CSV Breakdown & Supported Actions and Factors to Considers section in this article to understand how to edit the spreadsheet and the actions you can apply to adjust/launch your goals.

7️⃣ Once all of your desired adjustments have been executed in the CSV file, upload it to your Perpetua account. You'll see the progress bar update in the Download & Upload History section below.

8️⃣ After the upload is complete, if there are 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 April 2024. If you find this information to be out of date, please contact hello@perpetua.io

Did this answer your question?