Bulk Creating or Editing Campaigns

24 Oct 2024
10 Minutes to read
Contributors

Print
Share
Dark
Light

Bulk Creating or Editing Campaigns

Updated on 24 Oct 2024
10 Minutes to read
Contributors

Print
Share
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

The Quantcast Platform makes campaign creation, editing, and archiving easy. The Bulk Upload feature allows you to edit/create multiple campaigns offline, at the same time. With the bulk upload, you can edit/create budgets, dates, allowlists/blocklists, and more. In this article:

Bulk Campaign Creation

On the Campaigns page, click Bulk Actions, then select Bulk Upload.
In the modal window, click the Excel Template link, then open the Excel file that was downloaded to your computer to bulk create. Once you have finished, save the Excel file.
Return to the Quantcast Platform. In the Bulk Upload window, click Select file.
Locate the Campaign Excel file on your computer, then click Open.

Note: This step may vary depending on your computer.

Your file will appear in the Bulk Upload window. Click Add another for more files or click Upload to continue.
A preview of your updates will appear. Review your updates and click Import Updates.

Note: The system will notify you if your updates contain errors. If you have any questions, contact [email protected].

How to Create in the Offline Excel File

Things to note when bulk-creating campaigns and/or ad sets:

Instructions to create (tab) and column definitions can be found within the Excel file
Do not delete the header (first) row
Required fields: Campaign/Ad Set Name, Campaign/Ad Set State
Add NEW to the campaign ID and/or ad set ID column for each new campaign or ad set
Create new campaigns/ad sets at the bottom of the Excel file after your existing campaigns
The Campaign Objective Amount field is only supported for CPA and ROAS campaign objectives and should be blank otherwise
If Campaign Budget Optimization is TRUE, Campaign Budget and Campaign Start fields cannot be blank

Create a Campaign With No Ad Set

The following is required in the Excel file:
* Campaign ID: NEW
* Campaign Name: Give your campaign a name
* Campaign State: Select/input the state
* All Ad Set fields: Leave blank
Fill out all other campaign fields based as desired.
* Image shows one new campaign

Repeat these steps to bulk-create multiple campaigns with no ad sets.

Create a Campaign With One Ad Set

If you are creating individual campaigns that include one ad set, the following fields are required:
* Campaign ID: NEW
* Campaign Name: Give your campaign a name
* Campaign State: Select/input the state
* Ad Set ID: NEW
* Ad Set Name: Give your ad set a name
* Ad Set State: Select/input the state
Fill out all other campaign and ad set fields as desired.

* Image only shows required fields for one campaign with one ad set

Repeat these steps to bulk-create multiple campaigns with one ad set per campaign.

Create a Campaign With Multiple Ad Sets

If you are creating individual campaigns that include one ad set, the following fields are required:
* Campaign ID: NEW (only on the first ad set line of the first campaign, Campaign ID should be blank for all ad set lines after)
* Campaign Name: Give your campaign a name (duplicate the name for each new ad set line)
* Campaign State: Select/input the state (duplicate for each new ad set line)
* Ad Set ID: NEW (per new ad set)
* Ad Set Name: Give your ad set a name
* Ad Set State: Select/input the state
Fill out all other campaign and ad set fields as desired.

* Image shows only required fields for one campaign with three new ad sets

Repeat these steps to bulk create multiple campaigns with multiple ad sets per campaign.

Create an Ad Set for an Existing Campaign

In the Excel file, insert a row after the existing campaign you would like to add a new ad set to.
If you are adding an ad set to an existing campaign, the following fields are required:
* Campaign ID: Leave blank
* Campaign Name: Duplicate the name of the existing campaign for each new ad set line
* Campaign State: Duplicate the state for each new ad set line
* Ad Set ID: NEW (per new ad set)
* Ad Set Name: Give your ad set a name
* Ad Set State: Select/input the state
Fill out all other ad set fields as desired.

* Image shows only required fields for adding one new ad set to Existing Campaign 2 and two new ad sets to Existing Campaign 3

Repeat these steps to bulk-create new ad sets for existing campaigns.

How to Bulk Edit

1. On the Campaigns page, click Bulk Actions, then select Download All Campaigns.

Bulk Upload download campaigns

2. Click Done in the modal window, then open the Campaigns Excel file that was downloaded to your computer and make your desired updates. Once you have finished, save the Excel file.

Bulk Upload Download complete

3. Return to the Quantcast Platform, click Bulk Actions, then select Bulk Upload.

4. In the Bulk Upload window, click Select File.

Bulk Upload Modal marked

5. Locate the Campaign Excel file on your computer, then click Open.

Note: This step may vary depending on your computer.

6. Your file will appear in the Bulk Upload window. Click Add another for more files or click Upload to continue.

Bulk Upload Upload

7. A preview of your updates will appear. Review your updates and click Import Updates.

Note: The system will notify you if your updates contain errors. If you have any questions, contact [email protected].

How to Edit the Offline Excel File

Open the downloaded Campaigns Excel file and ensure editing is enabled.
Things to note when editing the Campaigns Excel file:
- The header (first) row has definitions/guidance for each column
- Do not delete the header (first) row
- You can only edit the Campaigns tab
- Each row represents an ad set in a campaign
If you have multiple ad sets for one campaign, you will see multiple rows with the same campaign-level information (ID, name, state, budget optimization, budget, start and end dates, etc.).
Read-only tabs include information you can use to update the Campaigns tab for events, creatives, site lists, IP lists, IAS prebid, DV prebid, deals, interests, and demographics.
After you have finished updating, save the Excel file.

Excel File Definitions

NOTE: This is not a complete list. For all definitions, view the Note for each column in Row 1.

Name	Definition
Campaign ID	The numeric ID of an existing campaign for which you have write permission.
Campaign Name	You can rename your campaign by changing the value in this column.
Campaign State	ENABLED: allow ad sets under this campaign to run unless they were individually PAUSED. PAUSED: stop all ad sets under this campaign from running.
Campaign Budget Optimization	TRUE: indicates that Campaign Budget Optimization is turned ON for the campaign. FALSE: indicates that Campaign Budget Optimization is turned OFF for the campaign.
Campaign Budget	The amount to reach and dynamically allocate among the running ad sets under this campaign is based on performance.
Campaign Start	The campaign won't start running until this day begins in the account's time zone.
Campaign End	The campaign will stop running at the end of this day in the account's time zone. Can be left blank if the campaign budget type is DAILY.
Ad Set ID	The numeric ID of an existing ad set belonging to the campaign of column A.
Ad Set Name	You can rename this ad set by changing this column.
Ad Set State	ENABLED: run this ad set whenever the parent campaign is also ENABLED. PAUSED: stop this ad set from serving, even when the campaign is ENABLED and other ad sets may be serving.
Ad Set Budget Type	If the budget type is DAILY, the ad set budget represents a per-day spend reach. If it is Flights, the ad set budget represents the total amount to spend between the start and end date. To use Flights, you must specify an end date.
Ad Set Budget	The amount this ad set will spend, either per day or in total, depends on the Ad Set Budget Type.
Ad Set Start	The ad set won't start running until this day begins in the account's time zone.
Ad Set End	The ad set will stop running at the end of this day in the account's time zone. If the ad set budget type is DAILY, it can be left blank.
Lookalike Events Operator	Required if Lookalike Events is set. If it is ANY, Quantcast will reach people who look like any of the events in Lookalike Events. If it is ALL, Quantcast will reach people who look like all of (the intersection) of the events in Lookalike Events. You can only use pixel events if ALL is selected, and the events must be under different categories (event.A and pcat.B) that fire simultaneously.
Lookalike Events	Reach people who look like the people who did these events. You can use pixel events and DMP segments. Use semicolon (;) to join multiple events. It is acceptable to have a semicolon in the event name. Use ALL_EVENTS to include all pixel events. Use ALL_DMPS to include all DMP segments. You can find the list of events in the Events (Read-only) sheet.
Cookieless Targeting	TRUE: indicates that cookieless prospecting has been activated for the ad set. FALSE: indicates that cookieless prospecting is not activated for the ad set.
Retargeting Events Operator	Required if Lookalike Events is set. If it is ANY, Quantcast will reach people who did any of the events in Retargeting Events. If it is ALL, Quantcast will reach people who participated in all of (the intersection) of the events in Retargeting Events.
Retargeting Events	Retargeting people who did these events. You can use pixel events, DMP segments, and campaign activity. Use semicolon (;) to join multiple events. It is acceptable to have a semicolon in the event name. Use ALL_EVENTS to include all pixel events. Use ALL_DMPS to include all DMP segments. You can find the list of events in the Events (Read-only) sheet.
Targeting Type	This column is for display only. Targeting Type is derived from lookalike and retargeting events. FULL_PERFORMANCE: Both lookalike and retargeting events PROSPECTING: Lookalike events only RETARGETING: Retargeting events only
Suppression Events Operator	Required if Suppression Events is set. If it is ANY, Quantcast will not reach people who did any of the events in Retargeting Events. If it is ALL, Quantcast will not reach people who did all of (the intersection) of the events in Retargeting Events.
Suppression Events	Do not reach people who did these events. You can use pixel events, DMP segments, and campaign activity. Use semicolon (;) to join multiple events. It is acceptable to have a semicolon in the event name. Use ALL_EVENTS to include all pixel events. Use ALL_DMPS to include all DMP segments. You can find the list of events in the Events (Read-only) sheet.
Retargeting Window	The retargeting window must be between 1-90. The default retargeting window is 90 days.
Country	Which country does this ad set reach? An ad set can reach only one country, and this cannot be changed after it has been set up.
Include Geos	Restrict ad set reach to only these selected places. You can use names or standard IDs to specify states/regions/provinces/etc, cities, and postal codes. Examples: * Colorado; NM; Phoenix, AZ * State: WY * Region: WY * area: Minneapolis-St. Paul, MN * Minneapolis-St. Paul, MN * Birmingham; London; Cambridge; Canterbury; Edinburgh * City: Reno, NV; city: Las Vegas, NV
Exclude Geos	Prevent this ad set from running within these parts of the country. You can use names or standard IDs to specify states/regions/provinces/etc, cities, and postal codes. Examples: * Colorado; NM; Phoenix, AZ * State: WY * Region: WY * Area: Minneapolis-St. Paul, MN * Minneapolis-St. Paul, MN * Birmingham; London; Cambridge; Canterbury; Edinburgh * City: Reno, NV; city: Las Vegas, NV
Include Interests	Reach people who are interested in these segments. You can reach predefined categories and keywords. Semicolons should be used to OR interests together, and separate AND conditions should be on separate lines. Predefined categories should be distinguished from keywords by adding "(Category)" as shown in the example. The list of predefined categories is in the "Interests (Read-only)" sheet. Keywords can be discovered in the interests section of the ad set form. Example: Careers (Category); careers; jobs Arts & Entertainment/Music (Category); Arts & Entertainment/Television (Category) Automotive/Vehicles/Hybrid (Category)
Exclude Interests	Do not reach people who are interested in these interests. You can exclude predefined categories and keywords. Semicolons should be used to separate interests. Predefined categories should be distinguished from keywords by adding "(Category)" as shown in the example. The list of predefined categories can be found in the "Interests (Read-only)" sheet. Keywords can be discovered in the interests section in the ad set form within the platform. Example: Automotive/Vehicles/Hybrid (Category)
Enabled Creatives	A semicolon-delimited list of numeric IDs of existing creatives that you want attached to the ad set.
Paused Creatives	A semicolon-delimited list of numeric IDs of existing creatives that you want attached to the ad set in a paused state.
Viewability	Viewability must be a multiple of 5 between 35% and 90%. Blank cells will default to 55% Examples: 35%, 40%, 90%, etc.
Frequency Cap	Allows you to set the maximum number of times a user sees an ad in a given period. The frequency cap must be in the format X IMPRESSIONS/Y DAYS. Blank values mean there is no cap. The cap cannot be below 0 impressions or above 30 days. Example: 1 IMPRESSIONS/7 DAYS
Site Lists	A semicolon-delimited list of numeric IDs of existing site lists that you want attached to the ad set.
IP Suppression Lists	The numeric ID of an existing IP list that you want attached to the ad set.
IAS Prebid Configuration	A semicolon-delimited list of numeric IDs of existing Integral Ad Science (IAS) prebid configurations that you want attached to the ad set.
DV Prebid Configuration	A semicolon-delimited list of numeric IDs of existing DoubleVerify (DV) prebid configurations that you want attached to the ad set.
Deals	A semicolon-delimited list of numeric internal IDs of existing deals that you want attached to the ad set.
Demographics	For a semicolon-delimited list of demographic categories and buckets, please refer to the sheet "Demographics (Read-only)" for all valid values. Example: Gender: Male; Education: College, No College; Income: $0-50$; Ethnicity (where permitted by law)

Was this article helpful?

What's Next

Bulk Pacing

Table of contents

Bulk Campaign Creation
How to Bulk Edit
Excel File Definitions