Bulk Operations - Launch & Edit your Goals/Segments

🚨 Note🚨
With Bulk Operations you can currently manage Sponsored Products only.

For Bulk Actions on Campaigns, learn more here.
For Bulk Actions on Targets, learn more here.
For Bulk Actions on Keyword Boost Campaigns, learn more here.
For Bulk Actions on Sponsored Brands goals, please review this article.

Quick Links:

Supported Actions and Factors to Consider
How to Launch/Edit a Classic (Multi-Campaigns) Goal in Bulk
How to Launch/Edit a Custom (Single-Campaign) Goal in Bulk

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 (Ex. From Universal to Brand-Based, etc)
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. 🚨

How to Launch/Edit a Classic (Multi-Campaigns) Goal in Bulk

1️⃣ Navigate to the "Bulk Operations" tab in your left sidebar and select "Bulk Edit & Create".

2️⃣ Set "Granularity Level", "Ad Type" and "Performance Date Range"

From the "Granularity Level" drop-down list, select "Goals & Segments".
The "Ad Type" is set by default with "Sponsored Products".
The "Performance Date Range" field is where you indicate the time period you'd like to be used when pulling your goal performance data into the CSV file.
A "Last 7 Days" or "Last 30 Days" time range can be applied.
🚨 Note: This information will be presented in columns S through AD and is limited to a 30-day period. 🚨

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

5️⃣ Edit the Spreadsheet

Before jumping on the CSV file edit, it is important to understand how Goals and Segments must be defined on the spreadsheet.
Below is a table demonstrating how "Classic Goals" and their associated segments will appear on it, based on the targeting type you select.

Classic Goal = MultiCampaign_Goal

Targeting Type	Segment(s)	CSV File Value
Universal	Universal	MultiCampaign_U
Brand-Based	Branded Unbranded	MultiCampaign_B MultiCampaign_UB
Advanced	Branded Category Competitor	MultiCampaign_B MultiCampaign_CA MultiCampaign_CO

CSV Overview

Follow the actions from the table below that will instruct you how to fill the Spreadsheet, by considering the "Supported Actions & Factors to Considers" mentioned here.

Action	Column	Row	Values to Enter
Define Goal Type	B	Any (From 2 onwards)	MultiCampaign_Goal
Define Goal Segments	B	Below MultiCampaign_Goal	According to Goal's type you wish to launch/edit: MultiCampaign_U MultiCampaign_B MultiCampaign_UB MultiCampaign_CA OR MultiCampaign_CO Learn more
Add Product(s) row(s)	B	Below the respective Goal Segment's Type	Add a "Product" row for each ASIN you wish to advertise in the goal.
Add Goal Title	D	MultiCampaign_Goal	Name of your goal (Max 60 characters).
Define the Status of your Goal(s)/Segments	F	MultiCampaign_Goal or the Goal Segment's Type (Ex. MultiCampaign_UB)	Enabled/Paused
Add ASIN(s)	G	Product	If advertising multiple ASINs, add one ASIN to each Product row.
Define the Status of your ASIN(s)	F	Product	Enabled/Deleted Pausing an ASIN is not supported in Bulk Deleting all the ASINs from the goal, will not delete the goal.
Add Daily Budget	H	Goal Segment's Type (Ex. MultiCampaign_UB)	Valid values are whole number ≥10.
Add Target ACOS	I	Goal Segment's Type (Ex. MultiCampaign_UB)	Valid values are whole numbers ≥1
Define your Branded/Competitor Segment Phrases	L	MultiCampaign_B and/or MultiCampaign_CO	Branded or Competitor phrases. Separate them by a comma if adding multiple.
Enter your Keywords	M, N, O	MultiCampaign_Goal	Enter your EXACT/PHRASE/BROAD keywords Separate them by comma if adding multiple. Ensure no commas are entered as the last value at the end of your list.
Enter your PAT Targets	P	MultiCampaign_Goal	Enter your PAT Separate them by comma if adding multiple. Ensure no commas are entered as the last value at the end of your list.
Enter your Negative Matches	Q, R	MultiCampaign_Goal	Enter your EXACT/PHRASE negative matches. Separate them by comma if adding multiple. Ensure no commas are entered as the last value at the end of your list. 🚨 Note🚨 Negative Broad match type keywords are not supported.
Segment Min/Max Bid	T, U	Goal Segment's Type (Ex. MultiCampaign_UB)	Whole and decimal numbers ≥0.

Read Only Columns

Column	Name	Description
A	Company Name	Your Perpetua account name and the marketplace you advertise in.
C	Goal Id	Gets auto-populated with your goal ID.
From V to AH	Performance Metrics	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 before downloading the CSV.
AI, AJ, and AK	Result, Errors and 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.

6️⃣ Upload your File to Perpetua
Once all of your desired adjustments have been executed in the CSV file, upload it to your Perpetua account. In the Bulk Operation tab, go to step 3 "Upload Spreadsheet with Edits" and click on the "Select or drag & drop to upload" option.
You'll see the progress bar update in the "Download & Upload History" section below.

7️⃣ Upload Status and Warnings
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 (AI, AJ, and AK).

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.

If you need further support, please don't hesitate to reach your Data Strategist or our Live Chat Support.

How to Launch/Edit a Custom (Single-Campaign) Goal in Bulk

Below is a table demonstrating how a Custom goal will appear on the spreadsheet, based on the targeting type you select.

Targeting Type	CSV File Value
Keyword Targeting	SingleCampaign_KW
Product Attributed Targeting	SingleCampaign_PAT