Bulk Operations for Sponsored Products Campaigns

Quick Links:

Supported vs. Not Supported Actions
CSV File Breakdown
CSV File Download/Upload Configuration
Other Related Articles

Supported vs. Not Supported Actions

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

📗Supported Actions

Currently available for Sponsored Products campaigns only.
Pausing or enabling campaigns.
Applying, editing, and removing Budget Allocation Limits.

📕Not Supported Actions

Pause all the campaigns within a Segment.
- 🚨 Note 🚨 If all the campaigns belong to a Universal goal, and you wish to pause all the campaigns, an error will be triggered. Please consider pausing the entire goal instead. This can be done manually in-app, or in bulk using the Bulk Operations for Goals & Segments flow.
Pause a Keyword Boost campaign.
Add, edit, or remove a Budget Allocation Limit on campaigns that are toggled off by the user (where the "Active" column status is Paused).
Add a Budget Allocation Limit on a keyword boost or single campaign goal.
Add, edit or remove Bid Placement Multiplier. Please consider doing this in-app.

CSV File Breakdown

Column	Type of Information	Values to Enter/ Additional Instructions
A	Operation	"Update" Any rows where you're making a change must have Update included as the value in this column. If the field is left blank, Perpetua will ignore the changes made in the file when uploading into your account.
B	Goal Title (Read Only)	What your goal is named in Perpetua.
C	Goal Type (Read Only)	The type of goal this is in Perpetua. The value will state Single Campaign or Multi-Campaign.
D	Segment (Read Only)	The segment that this campaign is a part of.
E	Campaign Name (Read Only)	The name of the campaign as it appears in Perpetua.
F	Campaign ID	Auto-populated with your campaign ID.
G	Active	Enabled / Paused Reflects the user-inputted state for the campaign. Change the status accordingly depending on whether you want to pause or enable a campaign.
H	Status (Read Only)	Reflects what the overall Perpetua status of the campaign is, taking into account the goal, segment, and campaign statuses. If any of those three are paused, the campaign will also be paused and the Status column will reflect this. An example of when the Active and Status columns can be different is if the user hasn't manually paused the campaign but has paused the goal. This means the Active column would read Enabled, since the user has kept it this way, but the Status would be Paused since the goal as a whole is paused.
I	Budget Allocation Limit (learn more here)	Accepted values can range from 1-100. Sets a percentage limit for the amount of budget a campaign can consume from the associated Segment budget. 🚨Note: If a campaign's Budget Allocation Limit is set to 60%, this does not mean it will use 60% of the budget. This means that the campaign can use up to* 60% of its associated Segment budget.*🚨
L	Budget Utilization (Read Only)	Displays the percentage of the current budget that the campaign has utilized, based on spend data from the selected date range.
M	Budget (Read Only)	Displays the current budget of the campaign. This value is set by the ad engine.
N-W	Performance Metrics	Contain performance metrics for your campaigns 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.
X	Description	Indicates whether a change in a row was successfully pushed through.
Y	Result	Shows the result of the change.
Z	Errors	Specifies types of errors that need resolution before upload.
AA	Warnings	Indicates warnings that need attention before upload.

CSV File Download/Upload Configuration

The Bulk Operations tab allows you to manage and make bulk changes to your existing Perpetua campaigns(and more) all in one place. Listed below are instructions on how to download, edit and upload your CSV file.
Your download & upload history across your account can also be displayed from here.

1️⃣Navigate to the "Bulk Operations" tab in your left sidebar (1) and select the "Bulk Edit & Create" option (2). From the "Granularity Level" drop-down menu, select "Campaigns" (3).

2️⃣ The "Ad Type" will be preselected with Sponsored products (1).
Go ahead and select a "Performance Date Range" (2).
The Performance Date Range field is where you indicate the time period you'd like to be used when pulling your campaign performance data into the CSV file. This information will be presented in columns L through U and is limited to a 30-day period.
Save your edits by clicking on "Confirm" (3).

4️⃣ Download your Sheet by clicking the "Download Custom Spreadsheet" button.

5️⃣ Edit your Sheet by referring to the Supported vs Not Supported Actions and the CSV Breakdown paragraphs in this same article. Once completed, save it in a CSV format.

6️⃣ Upload your Sheet

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️⃣ Error Messages/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 of the "Download & Upload History" section. From there, re-download the CSV file and refer to the result, errors, and warnings columns on the far right of your CSV file (Colum Y, Z, AA).
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 result, errors, and warnings columns. Correct the rows with the issues, save the file, and re-upload the CSV to try again.

💡 Please don't hesitate to contact your Data Strategist or our Live Chat Support team to request further assistance if needed.

Supported vs. Not Supported Actions

CSV File Breakdown

CSV File Download/Upload Configuration

Other Related Articles