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 (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 | 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
|
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 |
|
|
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 |
|
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 | Valid values are whole numbers ≥1 |
Define your Branded/Competitor Segment Phrases | L |
|
|
Enter your Keywords | M, N, O | MultiCampaign_Goal |
|
Enter your PAT | P | MultiCampaign_Goal |
|
Enter your Negative Matches | Q, R | MultiCampaign_Goal |
|
Segment Min/Max Bid | T, U | Goal Segment's Type (Ex. MultiCampaign_UB) |
|
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 |
|
| 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 |
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). | SingleCampaign_KW or SingleCampaign_PAT |
Add Product(s) row(s) | B | Below its respective Single Campaign Goal Type. | Add a "Product" row for each ASIN you wish to advertise in the goal. |
Add Goal Title | D | SingleCampaign_KW or SingleCampaign_PAT | Name of your goal (Max 60 characters). |
Define the Status of your Goal(s) | F | SingleCampaign_KW or SingleCampaign_PAT | |
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 |
|
Add Daily Budget | H | SingleCampaign_KW or SingleCampaign_PAT | Valid values are whole number ≥1. |
Add Target ACOS | I | SingleCampaign_KW or SingleCampaign_PAT | Valid values are whole numbers ≥1 |
Enter your Keywords
|
M, N, O |
SingleCampaign_KW |
|
Enter your PAT |
P |
SingleCampaign_PAT |
|
|
Q, R |
or SingleCampaign_PAT |
|
Segment Min/Max Bid | T, U | SingleCampaign_KW or SingleCampaign_PAT |
|
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 |
|
| 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. |
1️⃣ 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.
2️⃣ 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 any more help, please don't hesitate to reach out to your Data Strategist or our Live Chat Support.
Other Related Articles
Explore additional resources in our Help Centre that may assist you with other Bulk-Actions-related questions.
Please don't hesitate to reach out to your Data Strategist or our Live Chat Support Team if you have any further questions.
Article last updated October 2024. If you find this information to be out of date, please contact hello@perpetua.io