Not everyone has this feature. See this article for more information.
If you manage multiple Bing Ads accounts -- or multiple customers, who may have multiple accounts -- you can make updates across any and all of their campaigns at the same time using bulk upload.
The first thing you need to do is download the campaign information you want to see and change. See this article for more information on downloading spreadsheets. Once you have downloaded your spreadsheet, you can edit, add, or remove data, and then upload your changes in bulk.
You can remove columns that are not required, but make sure you keep the columns that are necessary to the change you are making. For example, if you want to pause keywords, you must include the Status column. If you want to create a new campaign, you will need to include all campaign columns.
Note: To make sure you don't delete any required columns, you could instead hide the unnecessary columns to make navigating the spreadsheet easier.
To add an ad, keyword, extension, or any other entity:
You could instead simply create a new row in your downloaded spreadsheet and fill in all the necessary columns, but starting with an existing campaign's information as a template is advised.
To remove an ad, keyword, extension, or any other entity:
Deleted entities cannot be restored after you upload the edited spreadsheet.
Each row of your spreadsheet represents a different entity, such as a campaign, ad group, ad, keyword, negative keyword, ad extension, or target. The entities you see in the spreadsheet were determined by the filters and output settings you specified when you set up the query for your bulk download (see Download a spreadsheet for bulk upload for more information).
Exactly which kind of entity a row represents is called out in the first column of the downloaded spreadsheet: the Type column. For detailed explanations of each type and its relevant columns, take a look at this MSDN article (note: MSDN refers to types as "Record types").
Types have parent-child relationships with one another. For example, in the following diagram, the keywords and ads are children of the parent "Electronics for Kids" ad group. This ad group in turn is the child (or one of several children) of a campaign.
In your downloaded spreadsheet, child types are always listed below their parent types. The relationship is made clear by the entities' ID and Parent ID column values. For linear cases such as Account-Campaign-Ad group, each entity's ID is unique and its Parent ID is the ID of its parent:
|Account [X]||[Account X's ID number]||[Customer W's ID number]|
|Campaign [Y]||[Campaign Y's ID number]||[Account X's ID number]|
|Ad Group [Z]||[Ad group Z's ID number]||[Campaign Y's ID number]|
In cases such as ad extensions, entities further down the parent-child chain can have multiple parents. For example, a campaign Sitelink Extension does not have a unique ID, but instead inherits the ID of the overall Sitelink Ad Extension, and its Parent ID is the campaign's ID. Take a look at the "Adding Sitelink Extensions through bulk upload" section below for more information.
For a detailed look at type hierarchy -- including each type's limits -- take a look at this MSDN article.
If you want to add, say, a new campaign and new ad groups all at once through bulk upload, how do you associate the child ad groups to the parent campaign without having an ID for the new campaign? You'd use either a logical reference key or a negative reference key:
Logical reference key:
Here's what it would look like in your spreadsheet:
|Type||ID||Parent ID||...||Campaign||Ad Group|
|Ad Group||...||Fresh Flowers||Tulip season|
|Ad Group||...||Fresh Flowers||Lily season|
Negative reference key:
Here's what this would look like in your spreadsheet:
|Campaign||[-1]||[existing account ID number]|
Each downloaded spreadsheet comes with columns for all Bing Ads data points. Most columns will be irrelevant — and therefore blank — for any given entity's row. Feel free to delete columns that are blank or unnecessary to your edits, but remember that you must retain the following columns: Type (for example, Campaign, Ad Group, or Keyword), ID, Parent ID, Account ID, and Name.
Sitelink Extensions are a type of ad extension. In Bing Ads, you create a Sitelink Extension and associate it to a campaign or an ad group. Bing Ads considers the overall Sitelink Extension (called here "Sitelink Ad Extension") the parent of either a Campaign Sitelink Ad Extension or an Ad Group Sitelink Ad Extension, depending on whether it's associated with a campaign or an ad group. The Sitelink Ad Extension is considered the child of the account. This relationship looks like this in a downloaded spreadsheet:
|Campaign [B]||[Campaign B's ID number]||[Account A's ID number]|
|Sitelink Ad Extension [C]||[Sitelink Ad Extension C's ID number]||[Account A's ID number]|
|Campaign Sitelink Ad Extension [D]||[Sitelink Ad Extension C's ID number]||[Campaign B's ID number]|
If you want to create a new Sitelink Extension through bulk upload, you need to add a row for both a Sitelink Ad Extension and either a Campaign Sitelink Ad Extension or an Ad Group Sitelink Ad Extension. What's more, you need to associate the child to the parent Sitelink Ad Extension even though the Sitelink Ad Extension does not yet have an ID. To do this, you'd use a negative reference key:
For example, here's what it would look like to add two new Sitelink Ad Extensions — one associated to an existing campaign, and one to an existing ad group:
|Sitelink Ad Extension||[-123]||[Existing account ID number]|
|Sitelink Ad Extension||[-456]||[Existing account ID number]|
|Campaign Sitelink Ad Extension||[-123]||[Existing campaign ID number]|
|Ad Group Sitelink Ad Extension||[-456]||[Existing ad group ID number]|
For your reference, here's an Excel template for uploading Sitelink Extensions.
Call Extensions are a type of ad extension. In Bing Ads, you create a Call Extension and associate it to a campaign or an ad group.
For your reference, here's an Excel template for uploading Call Exensions.
Location Extensions are a type of ad extension. In Bing Ads, you create a Location Extension and associate it to a campaign or an ad group.
For your reference, here's an Excel template for uploading Location Extensions.
Callout Extensions are a type of ad extension. In Bing Ads, you create a Callout Extension and associate it to a campaign or an ad group.
Review Extensions are a type of ad extension. In Bing Ads, you create a Review Extension and associate it to a campaign or an ad group.
Targeting is showing ads only to specific groups of Bing Ads customers by adjusting bids for these groups. Here is how you add targeting through bulk upload:
|Type||Targeting method||What goes in the Target column||Bid adjustment range||Other relevant columns|
|Campaign Location Target||Area targeting||Postal code or name of city, DMA, state, or country/region||-90 to +900||
: City, Metro Area, Country, State, or Postal Code
Physical Intent: PeopleInOrSearchingForOrViewingPages, PeopleSearchingForOrViewingPages, or PeopleIn
|Campaign Radius Target||Radius targeting||Leave Target blank for radius targeting||-90 to +900||
: PeopleInOrSearchingForOrViewingPages, PeopleSearchingForOrViewingPages, or PeopleIn
Name: The postal code, city, etc. you are pinpointing
Radius: The number of units around the point to include
Unit: Miles or Kilometers
|Campaign Age Target||Age targeting||EighteenToTwentyFive, TwentyFiveToThirtyFive, ThirtyFiveToFifty, FiftyToSixtyFive, or SixtyFiveAndAbove||-90 to +900||None|
|Campaign DayTime Target||Ad scheduling||Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, or Sunday||-90 to +900||
: The hour of the day (in 24-hour time) for the start time
From Minute: The minute of the From Hour for the start time
To Hour: The hour of the day (in 24-hour time) for the end time
To Minute: The minute of the To Hour for the end time
|Campaign Gender Target||Gender targeting||Male or Female||-90 to +900||None|
|Campaign DeviceOS Target||Device targeting||Smartphones or Tablets||
: -100 or -90 to +300
Tablets: -20 to +300
Leaving a new target's ID column blank (or entering a unique number) will overwrite any existing targeting you have set up for this campaign. To avoid this, use the same ID number as your existing targets.
For your reference, here's an Excel template for uploading targeting.
Participation level in Bing Native Ads is set by a bid adjustment at the campaign or ad group level. To adjust your native ad bid through bulk upload:
For your reference, here's an Excel template for adjusting bids for native ads.
Bing Shopping Campaigns make it easier for you to advertise your products from your Bing Merchant Center store online.
To create a Bing Shopping Campaign through bulk upload, you'll need to add a row for:
An Ad Group Product Partition is part of what is referred to elsewhere in Bing Ads as a "product group." There is a one-to-one relationship between ad groups and product groups. If you were creating a product group in Bing Ads, you would divide it into different levels based on attributes (see Understand and use product groups for more information). These divisions are referred to as Ad Group Product Partitions in bulk upload.
You can't add product ads themselves using bulk upload. After you upload your new Bing Shopping Campaign, you will need to edit it in Bing Ads to add product ads.
For your reference, here's an Excel template for uploading a Bing Shopping Campaign.
Once you have made all your changes, you are ready to upload your spreadsheet. Keep in mind a few things:
For instructions on how to upload your spreadsheet, check out Upload an edited spreadsheet.