Ă۶ąĘÓƵ

Appendix - Required bulksheet data for Microsoft Advertising accounts

To create and update Microsoft Advertising campaign data in bulk, you can use Search, Social, & Commerce bulksheet files formatted specifically for Microsoft Advertising accounts. You can either a) generate bulk sheet files for existing accounts in the required file format or b) create them manually (see “Supported Bulksheet File Formats” for general information about the supported file formats).

Each bulksheet must include the header fields and corresponding data fields required for the specific operations you want to perform (such as creating an ad). When a field isn’t required, you can omit it from the header and data rows. All custom columns are deleted when you upload the bulk sheet file.

Following are a table of all available data fields and additional tables indicating which fields are required to add, edit, or delete data for individual entities (such as campaigns and keywords).

All available data fields bulksheet-fields-all-microsoft

The following table describes all available data fields.

For the data fields relevant for account entities, see “Fields required to create, edit, or delete each account component.”

Field
Description
Platform
(Included in generated bulksheets for information purposes) The ad platform. Required unless each row includes an "AMO ID" for the entity.
Acct Name
The unique name that identifies an ad network account. Required unless each row includes an "AMO ID" for the entity.
Campaign Name
The unique name that identifies a campaign for an account. The maximum length is 128 characters.
Campaign Budget
The daily or monthly campaign budget, with or without monetary symbols and punctuation. It can’t be less than 0.05.
Channel Type
The type of channel that the campaign targets: Audience, DynamicSearchAds, Search, or Shopping.
Delivery Method

(Campaigns with daily budgets only) How quickly to show ads for the campaign each day:

  • Standard (Distributed) (the default for new campaigns): To spread your ad impressions across the day.
  • Accelerated: To display your ads as often as possible until your budget is reached. As a result, your ads may not appear later in the day.
Campaign Priority
(Shopping campaigns only) The priority with which the campaign is used when multiple campaigns advertise the same product: Low (the default for new campaigns), Medium, or High.

When the same product is included in more than one campaign, the ad network uses the campaign priority first to determine which campaign (and associated bid) is eligible for the ad auction. When all of the campaigns have the same priority, the campaign with the highest bid is eligible.
Merchant ID
(Shopping campaigns and audience campaigns linked to a merchant feed only) The customer ID of the merchant account whose products are used for the campaign.
Sales Country
(Shopping campaigns only; read-only for existing campaigns) The country in which the campaign’s products are sold. Because products are associated with target countries, this setting determines which products are advertised in the campaign.
Product Scope Filter
(Campaigns using the shopping network only) The products in your merchant account for which product ads can be created for the campaign. You can enter up to seven product dimension and attribute combinations on which to filter your products, using the format dimension=attribute. Separate multiple filters with a ">>" delimiter. For a list of available product dimensions, see "Shopping campaign product filters."

Example: "CategoryL1==Animals & Pet Supplies>>CategoryL2=Pet Supplies>>Brand=Acme Pet Supplies"

To delete the existing values, use the value [delete] (including the brackets).
DSA Domain Name
(Campaigns of type a) "DynamicSearchAds" or b) "Search" when the ExperimentId element isn’t set) The domain name of the website to target for dynamic search ads. The maximum length is 2,048 characters. If the domain name includes www, it’s trimmed and not used.

For existing campaigns, you can’t edit the domain, but you must include it to update other properties.
DSA Domain Language
(Campaigns of type a) "DynamicSearchAds" or b) "Search" when the ExperimentId element isn’t set) The language of the website pages to target for dynamic search ads. The supported domain languages are Dutch, English, French, German, Italian, Spanish, and Swedish.

For existing campaigns, you can’t edit the language, but you must include it to update other properties.
Ad Group Name
The unique name that identifies an ad group. The maximum length is 128 characters. Trailing blank characters aren’t saved (for example, "Ad Group 1 " is saved as "Ad Group 1").
Ad Group Type
(Campaigns on the search network; read-only for existing ad groups) The ad group type: Audience (for audience campaigns only), Search Dynamic (for dynamic search ads only) and Search Standard (for responsive search ads and existing expanded text ads only). Some campaign types can include multiple ad group types.
Keyword

(Campaigns on the search network only) The keyword string. The maximum length is 50 characters.

Notes:

  • To exclude a keyword at the ad group or campaign level, set the Match Type to Negative. If the row includes the ad group name, then the keyword is excluded for the ad group. If the row doesn’t include the ad group name, the keyword is excluded for the entire campaign.
  • Changing a Microsoft Advertising keyword deletes the existing keyword and creates a new one with a new keyword ID. Changing the match type, however, doesn’t delete the existing keyword.
Placement
Deprecated
Audience
The remarketing list for search ads (RLSA) target audience for the campaign or ad group.
Target Type
(RLSA targets only) The target type: Inclusion or Exclusion.
Auto Target Expression

Dynamic search targets for the ad group. For all targets, use "All Web Pages."

To target up to three dynamic search criteria, use the format <category>=<target>, where <category> can include any of the categories below. Join multiple targets for an individual category with "[blank space] and [blank space]" and join multiple categories with "[blank space] and [blank space]".

  • Category: To show dynamic search ads for indexed pages with a specific Google content category.
  • URL: To show dynamic search ads for indexed pages with a specific URL, where the value may be included anywhere within the URL.
  • Page Title: To show dynamic search ads for indexed pages with specific text in the page title.
  • Page Content: To show dynamic search ads for indexed pages with specific content.

Example: url=shoes.example.com and page title=footwear
Example: All Web Pages

Location
A geographical location at which to place ads for the campaign or ad group; the values aren’t case-sensitive. If you don’t enter any values for the campaign or ad group, all locations are targeted. To target specific locations, enter the location using the Microsoft Advertising location code formats. To download a location list, log in to the Microsoft Advertising developer portal using your Microsoft Advertising advertising account credentials. Note: To exclude a location, precede the location code with a minus sign (-), such as -United States.
Location Type
The location type, such as City, Country, MetroArea, PostalCode, and State. To download a location list, log in to the Microsoft Advertising developer portal using your Microsoft Advertising advertising account credentials.
Match Type
(Campaigns on the search network only) The keyword matching option(s). This may include the keyword matching option for a dynamic search target or product group. Values include : Broad (the default for new keywords), Exact, Phrase, Content (set automatically for keywords when the ad group targets the content network), Negative (to exclude a keyword on the content network), Dynamic Ad Target (the default for new dynamic search targets), Product Group (the default for new product groups), or Negative Product Group (to exclude a product group). A value for either the match type or keyword ID is required to edit or delete a keyword with multiple match types.

For Broad Match Modifier, choose "Broad" and insert a + before any word within the keyword that’s required (such as "+red +shoes" to require both "red" and "shoes").

Changing the match type for a Microsoft Advertising keyword doesn’t delete the existing keyword.
Max CPC
(Campaigns on the search network) The maximum cost per click (CPC), which is the highest amount to pay for an ad click based on the keyword, product group, or dynamic search target, with or without monetary symbols and punctuation. For existing keywords and product groups records in optimized portfolios, updates are effective for only one day and are overwritten during the next optimization cycle. Note: You can’t set bids for negative keywords.
Max Content CPC
(Read-only for CPC campaigns created before the content network deprecated in 2017 only ) The maximum content cost per click (CPC), which is the highest amount to pay for an ad click from a display network site, with or without monetary symbols and punctuation.
Audience Target Method

(Audience ad groups) Whether to:

  • Target and Bid: To show ads only to users associated with target audiences who also satisfy any other targets for the ad group.
  • Bid Only: To show ads even to people who aren’t associated with target audiences as long as they satisfy other ad group-level targets.

You may increase the chances that ads are shown to specific audiences, however, by setting higher bids for those audiences.

Parent Product Groupings
The hierarchy of any parent product groups.

Example: All Products>>ProductTypeL1=a>>ProductTypeL2=b
Product Grouping

The product group (such as "brand=acme" or "All Products").

Notes:

  • When a specified product group doesn’t exist in the Parent Product Groupings hierarchy, Search, Social, & Commerce creates any parts of the hierarchy that are needed.
  • Search, Social, & Commerce automatically creates an "All Products" group whenever you create an ad group in a shopping campaign with a default bid set to the ad group default bid. Search, Social, & Commerce automatically creates an "Everything Else" group with the ad group default bid at each level of the product groups hierarchy. You can still explicitly create these default groups, and either exclude them or change their bids.
  • Each ad group can include up to eight tiers of product groups, including "All Products" and seven other tiers.
Partition Type
The partition type for the product group: subdivision (when it has child product groups) or unit (when it has no child product groups).
Ad Title, Ad Title 2-Ad Title 15
(Expanded text ads, multimedia ads, responsive ads, and responsive search ads only) The headlines of an ad. The maximum length for each ad title field is 30 characters or 15 double-byte characters, including any dynamic text (such as the values of keywords, {Param2} and {Param3} dynamic substitution variables, and ad customizers).

For responsive search ads, insert an ad customizer using the following format, where “Default text” is an optional value to insert when your feed file doesn’t include a valid value: {CUSTOMIZER.Attribute name:Default text}, such as {CUSTOMIZER.Discount:10%}

For expanded text ads, Ad Title and Ad Title 2 are required, and Ad Title 3 is optional. Microsoft Advertising deprecated expanded text ads in August 2022, and you can now only report on and delete them.

For multimedia ads, responsive ads, and responsive search ads, Ad Title, Ad Title 2, and Ad Title 3 are required, and all other ad title fields are optional.

To delete the existing value for a non-required field, use the value [delete] (including the brackets).

For all ad types except for expanded text ads, changing the ad copy deletes the existing ad and creates a new ad with the same properties.
Ad Title 1 Position-Ad Title 15 Position
(Responsive search ads only; optional) A position at which to pin the corresponding ad title: [null] (no value, which makes the ad title eligible for all positions), 1, 2, or 3. For example, if Ad Title Position has a value of 1, then Ad Title can appear only in Position 1. By default, all ad titles are null (have no values). To delete the existing value, use the value [delete] (including the brackets).

Note: You can pin multiple ad titles to the same position. The ad network uses one of the ad titles pinned to the position. Titles pinned to position 3 may not be shown with the ad.
Description Line 1-Description Line 4

(Text ads, dynamic search ads, multimedia ads, responsive ads, responsive search ads, and enhanced campaign-level sitelinks only) The body of an ad or a sitelink.

For sitelinks, optionally use both Description Line 1 and Description Line 2 to include extra text that the ad network may display under the link text. Each description field can include up to 35 single-byte or 17 double-byte characters.

For ads, the maximum length for each description field is 90 characters or 45 double-byte characters, including any dynamic text (such as the values of keywords and ad customizers).

For responsive search ads, insert an ad customizer using the following format, where Default text is an optional value to insert when your feed file doesn’t include a valid value: {CUSTOMIZER.Attribute name:Default text}, such as {CUSTOMIZER.Discount:10%}

For text ads and dynamic search ads, Description Line 1 is required and Description Line 2 is optional.

For multimedia ads, responsive ads, and responsive search ads, Description Line 1 and Description Line 2 are required, and Description Line 3 and Description Line 4 are optional.

To delete the existing value, use the value [delete] (including the brackets).

Notes:

  • (Standard text ads) The combined title and text must be at least three words.
  • (Expanded text ads) This field can optionally include the {Param2} and {Param3} dynamic substitution variables. If it does, the maximum length of the ad text is 300 single-byte or 150 double-byte characters. Microsoft Advertising deprecated expanded text ads in August 2022, and you can now only report on and delete them.
  • (Dynamic search ads) Dynamic substitution text isn’t allowed.
  • For all ad types except expanded text ads, changing ad copy deletes the existing ad and creates a new one.
Description Line 1 Position-Description Line 4 Position
(Responsive search ads only; optional) A position at which to pin the corresponding description: [null] (no value, which makes the description eligible for all positions), 1, 2, or 3. For example, if Description 1 Position has a value of 1, then Description 1 can appear only in Position 1. By default, no descriptions are pinned to a position.

To delete the existing value, use the value [delete] (including the brackets).

Note: You can pin multiple descriptions to the same position. The ad network uses one of the descriptions pinned to the position. Descriptions pinned to position 2 may not be shown with the ad.
Business Name
(Multimedia ads only) The business name, with a maximum of 25 characters.
Promotion Line
(Product Listing Ads only) A unique promotion line to be included with the product listing in search results (such as "Free shipping now!). The maximum length is 45 characters.

The promotion line may appear in different locations relative to the ad (such as below the ad) depending on where the ad appears on the page.
Display URL

The URL that’s included in the ad.

For expanded dynamic search ads, the ad network generates this value dynamically from the website domain, and you don’t need to enter a value.

For expanded text ads and responsive search ads, you don’t need to enter a value. The display URL is automatically extracted from the domain in the final URL. You optionally can customize the URL using the Path 1 and Path 2 fields.

Notes:

  • (Accounts with final URLs) The domain names in the display URL and final URL must match.
  • Microsoft Advertising deprecated expanded text ads in August 2022, and you can now only report on and delete them.
Display Path 1
(Expanded text ads, dynamic search ads, and responsive search ads only) Text that’s added to the display URL that’s automatically extracted from the final URL. Each path is preceded in the URL by a forward slash (/). A path can’t contain forward slash (/) or newline (\n) characters. The maximum length for each path is 15 characters or 7 double-byte characters.

To insert an ad customizer, use the following formats, where “Default text” is an optional value to insert when your feed file doesn’t include a valid value: {CUSTOMIZER.Attribute name:Default text}, such as {CUSTOMIZER.Discount:10%}

For example, if Display Path 1 is "deals," then the display URL would be <display URL>/deals, such as www.example.com/deals.

Microsoft Advertising deprecated expanded text ads in August 2022, and you can now only report on and delete them.
Display Path 1
(Expanded text ads, dynamic search ads, and responsive search ads only) An additional display path; see the entry for Display Path 1.

Example: If Display Path 1 is "deals" and Display Path 2 is "local," then the display URL would be <display URL>/deals/local, such as www.example.com/deals/local.
Start Date
(Enhanced sitelinks only) The first date on which bids may be placed for the sitelink, in the advertiser’s time zone and in one of the following formats: m/d/yyyy, m/d/yy, m-d-yyyy, or m-d-yy. The default for new enhanced sitelinks is the current day. Note: New enhanced sitelinks can be created only in campaigns with existing enhanced sitelinks or no sitelinks.
End Date
The last date on which the sitelink can appear with ads, in the advertiser’s time zone and in one of the following formats: m/d/yyyy, m/d/yy, m-d-yyyy, or m-d-yy. For a new sitelink, the default is [blank] (that is, no end date).
Call To Action
The call to action to include in the ad. See the , but enter multi-word calls to action as multiple words (such as "Bet Now" instead of "BetNow") in bulksheets.
Call To Action Language
The language for the call to action options. See the .
Base URL/Final URL
The landing page URL to which search engine users are taken when they click your ad, including any append parameters configured for the campaign or account. Base/final URLs at the keyword level override those at the ad level and higher.

To delete the existing value, use the value [delete] (including the brackets).
Destination URL
(Included in generated bulksheets for information purposes; not posted to the search engine) For accounts with destination URLs, this is the URL that links an ad to a base URL/landing page on the advertiser’s website (sometimes via another site that tracks the click and then redirects the user to the landing page). It includes any append parameters configured for the Search, Social, & Commerce campaign or account. If you generated tracking URLs, this is based on the tracking parameters in your account settings and campaign settings. If you appended search engine-specific parameters, they may be replaced with the equivalent parameters for Search, Social, & Commerce.

For accounts with final URLs, this column shows the same value as the Base URL/Final URL column.
Custom URL Param
Data to substitute for the {custom_code} dynamic variable when the variable is included in the tracking parameters for the search account or campaign settings. To insert the custom value in the tracking URL, you must upload the bulksheet file using the Generate Tracking URLs option.
Creative Type
The ad format: Dynamic Search Ad, Expanded Text Ad, Expanded Dynamic Search Ad, Multimedia Ad, Product Ad (shopping ads), or Responsive Search Ad, or Text ad. The default for new ads is Text ad.
Ad Group Start Date
The first date on which bids may be placed for the ad group, in the advertiser’s time zone and in one of the following formats: m/d/yyyy, m/d/yy, m-d-yyyy, or m-d-yy. For a new ad group, the default is the current date.
Ad Group End Date
The last date on which bids may be placed for the ad group, in the advertiser’s time zone and in one of the following formats: m/d/yyyy, m/d/yy, m-d-yyyy, or m-d-yy. For a new ad group, the default is [blank] (that is, no end date).
Tracking Template
(Optional) The tracking template, which specifies all off-landing domain redirects and tracking parameters and embeds the final URL in a parameter. The tracking template at the most granular level (with keyword as the most granular) overrides the values at all higher levels.

For Ă۶ąĘÓƵ Advertising conversion tracking, which is applied when the campaign settings include “EF Redirect” and “Auto Upload,” Search, Social, & Commerce automatically appends redirect and tracking code when you save the record.

For third-party redirects and tracking, enter a value.

For a list of parameters to indicate final URLs in tracking templates, see the Microsoft Advertising documentation.

To delete the existing value, use the value [delete] (including the brackets).
Landing Page Suffix
Any parameters to append to the end of final URLs to track information. Example: param2=value1&param3=value2

See “Click-tracking formats for Microsoft Advertising.”

Final URL suffixes at lower levels override the account-level suffix. For easier maintenance, use only the account-level suffix unless different tracking for individual account components is necessary. To configure a suffix at the ad group level or lower, use the Microsoft Advertising editor.
Search Network Status

Whether to place ads for the ad group on various elements of the Search Network:

  • All: To place ads on all Bing search networks and syndicated search partners.
  • OwnedAndOperatedOnly: To place ads only on Bing and Yahoo! websites.
  • SyndicatedSearchOnly: To place ads only on Bing and Yahoo! syndicated search partners.
  • Off: To place ads on the Content Network only (not the Search Network).

For new ad groups, the default is On.

Content Network Status
Deprecated
Languages
The target language for ads in the ad group: English, French, Finnish, German, Norwegian, Spanish, or Swedish. The default for new campaigns is English.

This setting determines the countries and regions in which your ad can be displayed. Make sure to choose a language compatible with the campaign’s location targets.
Budget Type
Whether the budget is Daily (the default) or Monthly.

Note: If you assign the campaign to an optimized portfolio, this value is automatically set to Daily.
Device
A device type for which bid adjustments are made at the campaign or ad group level: smartphone, tablet, or desktop.
Bid Adjustment

The bid adjustment for a specified target type. For example, if the keyword-level bid is 1 USD and the bid adjustment for smartphones is 50%, then the smartphone bid is 1.50 USD. By default, all targets are bid at the keyword-level bid. Valid percentages can include:

  • Smartphones and tablets: –100 (to not bid for the device type) and from –90 to 900
  • Desktop: from 0 to 900
Creative Preferred Devices
The device types on which you prefer to display the ad or sitelink: All (the default) or Mobile. When Mobile is specified, the network tries to display the ad or sitelink to mobile device users rather than desktop or tablet users. Otherwise, the network displays the ad or sitelink on any device type. Note: The network doesn’t guarantee that it will display the ad on the preferred device type.
Param2
The string to use as the substitution value if the keyword’s base URL or the ad’s title, description, or base URL contains the {Param2} dynamic substitution string. The maximum length is 70 characters, but be aware of the maximum length of the ad elements in which you use it (for example, Title 1 and Title 2 combined may be a maximum of 76 characters). To delete the existing value, use the value [delete] (including the brackets).
Param3
The string to use as the substitution value if the keyword’s base URL or the ad’s title, description, or base URL contains the {Param3} dynamic substitution string. The maximum length is 70 characters, but be aware of the maximum length of the ad elements in which you use it (for example, Title 1 and Title 2 combined may be a maximum of 76 characters). To delete the existing value, use the value [delete] (including the brackets).
Link Name
The sitelink text. It must be unique within the campaign. If you specify Description1 and Description2, then the sitelink text can include up to 25 single-byte or 12 double-byte characters; otherwise, the sitelink text can include up to 35 single-byte or 17 double-byte characters.

Microsoft Advertising may display two, four, or six enhanced sitelinks with descriptions, or four or six sitelinks in a single row without descriptions, with an ad.

You can create new enhanced sitelinks only in campaigns with existing enhanced sitelinks or no sitelinks.
Campaign Status
The display status of the campaign: Active, Paused, or Deleted (existing campaigns only). The default for new campaigns is Active. To delete an active or paused campaign, enter the value Deleted.
Ad Group Status
The display status of the ad group: Active, Paused, or Deleted (existing ad groups only). The default for new ad groups is Active. To delete an active or paused ad group, enter the value Deleted.
Keyword Status
The display status of the keyword: Active, Paused, or Deleted (existing keywords only). The default for new keywords is Active. To delete an active or paused keyword, enter the value Deleted. Note: If you create tracking URLs for a keyword with multiple match types, then the keyword status for each match type must be the same.
Placement Status
Deprecated
Ad Status
The display status of the ad: Active, Deleted (existing ads only), Disapproved (not editable), or Paused. The default for new ads is Active. To delete an active or paused ad, enter the value Deleted.
Target Status
The status of a dynamic search target: Active, Paused, or Deleted (existing targets only). The default for new targets is Active. To delete an active or paused target, enter the value Deleted.
Sitelink Status
The display status of the sitelink: Active or Deleted (existing sitelinks only). The default for new sitelinks is Active. To delete an active sitelink, enter the value Deleted.
Location Status
The status of the location target: Active or Deleted (existing locations only). The default for new locations is Active. To delete an active location, enter the value Deleted.
Product Group Status
The display status of the product group: Active or Deleted (existing product groups only). The default for new product groups is Active. To delete an active product group, enter the value Deleted.
Device Target Status
The status of the campaign- or ad group-level device target: Active or Deleted. For new campaigns and ad groups, the default is Active.
RLSA Target Status
The status of the campaign- or ad group-level RLSA target or (Google Ads only) exclusion: Active or Deleted (existing targets only). The default for new targets or exclusions is Active. To delete an active target or exclusion, enter the value Deleted.
[Advertiser-specific Label Classification]
(Named for an advertiser-specific label classification, such as "Color" for a label classification called Color) A value for the specified classification that is associated with the entity. You can include only one value per classification per entity (such as "red" for the "Color" label classification for Campaign A). The maximum length is 100 characters, and the value can include ASCII and non-ASCII characters.

Label classifications and their label values are applied to all child components; new components that are added later are automatically associated with the label. Label classifications for product groups are applied to the unit (most granular) level.

Neither the classification name nor the classification value is case-sensitive.
Constraints
A constraint that’s assigned to the entity. You can assign only one constraint per entity.
>Constraints are inherited by child entities, so you don’t need to enter values for child entities unless you want to override the inherited values.
Campaign ID
The unique ID that identifies an existing campaign. In CSV and TSV files, it must be preceded by a single quote (').[1] Required only when you change the campaign name, unless the row includes an "AMO ID" for the campaign.
Ad Group ID
The unique ID that identifies an existing ad group. In CSV and TSV files, it must be preceded by a single quote (').[1:1] Required only when you change the campaign name, unless the row includes an "AMO ID" for the ad group.
Placement ID
Deprecated
Keyword ID
The unique ID that identifies an existing keyword. In CSV and TSV files, it must be preceded by a single quote (').[1:2] Required only when you change the keyword, unless the row includes a) sufficient property columns to identify the keyword or b) an "AMO ID"."
Ad ID

The unique ID that identifies an existing ad. In CSV and TSV files, it must be preceded by a single quote (').[1:3] For responsive search ads, either the Ad ID or AMO ID is required to edit or delete ad data. For all other entity types, the AMO ID is required only when you change the ad status, unless the row includes a) sufficient ad property columns to identify the ad or b) an "AMO ID"." However, if you include neither the Ad ID nor AMO ID, and the ad property columns match multiple ads, then the status for only one of the ads changees.

Note: If you edit a) ad property columns except Status for an existing ad or b) any data for a responsive search ad, and you include neither the Ad ID nor AMO ID, then a new ad is created, and the existing ad isn’t changed.

Sitelink ID

The unique ID that identifies an existing sitelink. In CSV and TSV files, it must be preceded by a single quote (').[1:4] Required only when you change or delete the sitelink, unless the row includes a) sufficient property columns to identify the sitelink or b) an "AMO ID"." However, if you include neither Sitelink ID nor AMO ID, and the property columns match multiple sitelinks, then the status for only one of the sitelinks changes.

Note: If you edit sitelink property columns except Status for an existing sitelink, and you include neither the Sitelink ID nor AMO ID, then a new sitelink is created, and the existing sitelink isn’t changed.

Product Group ID
The unique ID that identifies an existing product group. In CSV and TSV files, it must be preceded by a single quote (').[1:5] Required only when you change or delete the product group, unless the row includes a) sufficient property columns to identify the product group or b) an "AMO ID"."
Location ID
The unique Microsoft Advertising identifier for the location target. To download a location list, log in to the Microsoft Advertising developer portal using your Microsoft Advertising advertising account credentials. Required only when you change or delete the location target, unless the row includes an "AMO ID" for the target.
Target ID
The unique ID that identifies an existing auto target. Required only when you change or delete the auto target, unless the row includes an "AMO ID" for the target.
RLSA Target ID
The unique ID that identifies an existing campaign- or ad group-level RLSA target. In CSV and TSV files, it must be preceded by a single quote (').[1:6] Required only when you change or delete the target or exclusion, unless the row includes an "AMO ID" for the target.
AMO ID
(In generated bulksheets) An Ă۶ąĘÓƵ-generated unique identifier for a synced entity. For responsive search ads, the AMO ID is required to edit or delete ads unless you include the Ad ID. To edit data for all other entity types with an AMO ID, the AMO ID is required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.
EF Error Message
(Included in generated bulksheets for information purposes) Placeholder for displaying error messages from the ad network regarding data in the row; error messages are included in EF Errors files. This value isn’t posted to the ad network.
SE Error Message
(Included in generated bulksheets for information purposes) Placeholder for displaying error messages from the ad network regarding data in the row; error messages are included in SE Errors files. This value isn’t posted to the ad network.
Exemption Request
(Included in generated bulksheets for information purposes) Placeholder for displaying the names and text of any Google advertising policies that an ad violates.
Retail Hash
(Included for information purposes in bulksheets generated using Advanced Campaign Management) An alphanumeric hash code (such as f9639f40cdf56524b541e5dacf55a991) that indicates the item was generated using the Advanced (ACM) view.

Fields required to create, edit, or delete each account component bulksheet-fields-per-component-microsoft

The following sections include the fields relevant to specific account entities.

NOTE
When a field isn’t applicable to an action, any value entered in the field is ignored.

Campaign fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Campaign Budget
Required to create a campaign.
Channel Type
Required to create a campaign.
Delivery Method
Optional
Campaign Priority
Required to create a shopping campaign.
Merchant ID
Required to create a shopping campaign.
Sales Country
Required to create a shopping campaign.
Product Scope Filter
(Shopping campaigns) Optional
DSA Domain Name
Required to create a campaign of type a) “DynamicSearchAds” or b) “Search” when the ExperimentId element isn’t set)
DSA Domain Language
Required to create a campaign of type a) “DynamicSearchAds” or b) “Search” when the ExperimentId element isn’t set)
Tracking Template
Optional
Landing Page Suffix
Optional
Budget Type
Required to create a campaign.
Device
Optional
Bid Adjustment
Optional
Campaign Status
Required only to delete a campaign.
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Campaign ID
Required only when you change the campaign name, unless the row includes an "AMO ID" for the campaign.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Ad group fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Ad Group Type
Required to create an ad group.
Audience Target Method
Required only to create audience ad groups.
Ad Group Start Date
Optional
Ad Group End Date
Optional
Tracking Template
Optional
Search Network Status
(Campaigns on the search network only) Optional
Languages
Optional
Device
Optional
Bid Adjustment
Optional
Ad Group Status
Required only to delete an ad group.
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Ad Group ID
Required only when you change the ad group name, unless the row includes an "AMO ID" for the ad group.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Keyword fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Keyword
Required
Match Type
A value for either the match type or keyword ID is required to edit or delete a keyword with multiple match types.
Max CPC
Optional
Base URL/Final URL
Optional
Custom URL Param
Optional
Tracking Template
Optional
Param1
Optional
Param2
Optional
Keyword Status
Required only to delete a keyword.
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Campaign ID
Optional
Ad Group ID
Optional
Keyword ID
Required only when you edit or delete the keyword, unless the row includes a) sufficient property columns to identify the keyword or b) an “AMO ID.”
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Dynamic search ad fields

NOTE
Create support isn’t available.

For this ad type, use the “Creative (except RSA)” row in the Download Bulksheet dialog.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Description Line 1-Description Line 2 Required to edit the description. Note: For this ad type, changing ad copy deletes the existing ad and creates a new one.
Display Path 1
Required to edit the field.
Display Path 2
Required to edit the field.
Creative Type
Required to create or edit the status of a product ad.
Creative Preferred Devices
Optional
Ad Status
Required to delete an ad.
[Advertiser-specific Label Classification]
Optional
Campaign ID
Optional
Ad Group ID
Optional
Ad ID
Required only when you change the ad status, unless the row includes a) sufficient ad property columns to identify the ad or b) an “AMO ID.” However, if you include neither the Ad ID nor AMO ID, and the ad property columns match multiple ads, then the status for only one of the ads changes.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Product (shopping) ad fields

For more information about creating shopping ads, see “Implement Microsoft Advertising shopping campaigns.”

For this ad type, use the “Creative (except RSA)” row in the Download Bulksheet dialog.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Promotion Line
Optional
Base URL/Final URL
Optional
Custom URL Param
Optional
Creative Type
Required to create or edit the status of a product ad.
Tracking Template
Optional
Ad Status
Required to delete an ad.
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Campaign ID
Optional
Ad Group ID
Optional
Ad ID
Required only when you change the ad status, unless the row includes a) sufficient ad property columns to identify the ad or b) an “AMO ID.” However, if you include neither the Ad ID nor AMO ID, and the ad property columns match multiple ads, then the status for only one of the ads changes.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Responsive (multimedia) ad fields

For this ad type, use the “Creative (except RSA)” row in the Download Bulksheet dialog.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Ad Title, Ad Title 2-Ad Title 15
For responsive ads, Ad Title, Ad Title 2, and Ad Title 3 are required to create ads, and all other ad title fields are optional. To delete the existing value for a non-required field, use the value [delete] (including the brackets). Note: For this ad type, changing ad copy deletes the existing ad and creates a new one.
Description Line 1-Description Line 4
Description Line 1 and Description Line 2 are required to create ads, and Description Line 3 and Description Line 4 are optional. Note: For this ad type, changing ad copy deletes the existing ad and creates a new one.
Business Name
Required to create or delete an ad.
Call To Action
Required to create an ad.
Call To Action Language
Required to create an ad.
Base URL/Final URL
Required to create an ad.
Creative Type
Optional.
Tracking Template
Optional
Ad Status
Required to delete an ad.
[Advertiser-specific Label Classification]
Optional
Campaign ID
Optional
Ad Group ID
Optional
Ad ID
Required only when you change the ad status, unless the row includes a) sufficient ad property columns to identify the ad or b) an “AMO ID.” However, if you include neither the Ad ID nor AMO ID, and the ad property columns match multiple ads, then the status for only one of the ads changes.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Responsive search ad fields

For this ad type, use the “Responsive Search Ad” row in the Download Bulksheet dialog.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Ad Title, Ad Title 2-Ad Title 15
For responsive search ads, Ad Title, Ad Title 2, and Ad Title 3 are required to create an ad, and all other ad title fields are optional. To delete the existing value for a non-required field, use the value [delete] (including the brackets).
Ad Title 1 Position-Ad Title 15 Position
Optional
Description Line 1-Description Line 4
For responsive search ads, Description Line 1 and Description Line 2 are required to create an ad, and Description Line 3 and Description Line 4 are optional. To delete the existing value, use the value [delete] (including the brackets).
Description Line 1 Position-Description Line 4 Position
Optional
Display Path 1
Optional
Display Path 2
Optional
Base URL/Final URL
Required to create an ad.
Custom URL Param
Optional
Creative Type
Optional
Tracking Template
Optional
Ad Status
Required to delete an ad.
[Advertiser-specific Label Classification]
Optional
Campaign ID
Optional
Ad Group ID
Optional
Ad ID
Required to edit or delete ads unless the row includes an “AMO ID.”
AMO ID
Required to edit or delete ads unless you include the Ad ID.

Text ad fields

For this ad type, use the “Creative (except RSA)” row in the Download Bulksheet dialog.

NOTE
Expanded text ads were deprecated. You can only delete existing text ads.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Ad Title, Ad Title 2-Ad Title 3
Read-only
Description Line 1-Description Line 2 Read-only
Display URL
Read-only
Display Path 1
Read-only
Display Path 2
Read-only
Base URL/Final URL
Read-only
Custom URL Param
Read-only
Creative Type
Optional
Tracking Template
Read-only
Creative Preferred Devices
Read-only
Ad Status
Required
[Advertiser-specific Label Classification]
Optional
Campaign ID
Optional
Ad Group ID
Optional
Ad ID
Required only when you change the ad status, unless the row includes an “AMO ID.”
AMO ID
Required to edit or delete the data unless you include the Ad ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Dynamic search target (auto target) fields

NOTE
Create support isn’t available.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Auto Target Expression
Required.
Match Type
Optional
Max CPC
Optional
Custom URL Param
Optional
Target Status
Required to delete a target
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Campaign ID
Optional
Ad Group ID
Optional
Target ID
Required only when you change or delete the auto target, unless the row includes an “AMO ID” for the target.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Shopping product group fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required
Match Type
Required to create a product group.
Max CPC
Required to create a product group.
Parent Product Groupings
Required
Product Grouping
Required
Partition Type
Required to create a product group.
Base URL/Final URL
Required
Tracking Template
Optional
Product Group Status
Required only to delete a product group.
[Advertiser-specific Label Classification]
Optional
Constraints
Optional
Campaign ID
Optional
Ad Group ID
Optional
Product Group ID
Required only when you change or delete the product group, unless the row includes a) sufficient property columns to identify the product group or b) an “AMO ID.”
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Description Line 1
Optional
Description Line 2
Optional
Start Date
Optional
End Date
Optional
Base URL/Final URL
Required
Custom URL Param
Optional
Tracking Template
Optional
Creative Preferred Devices
Optional
Link Name
Required
Sitelink Status
Required only to delete a sitelink.
Campaign ID
Optional
Sitelink ID
Required only when you change or delete the sitelink, unless the row includes a) sufficient property columns to identify the sitelink or b) an “AMO ID.” However, if you include neither Sitelink ID nor AMO ID and the property columns match multiple sitelinks, then the status for only one of the sitelinks changes.

Note: If you edit sitelink property columns except Status for an existing sitelink, and you don’t include either the Sitelink ID nor AMO ID, then a new sitelink is created, and the existing sitelink isn’t changed.
AMO ID
Required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Location target fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Location
Required
Location Type
Required to create a target
Bid Adjustment
Optional
Location Status
Required only to delete a location target.
Campaign ID
Optional
AMO ID
Required to edit or delete the data unless you include the campaign ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Campaign-level and ad group-level device target fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Device
Required to delete a device target.
Bid Adjustment
Optional
Ad Group Name
Required for ad group-level device targets. Not applicable for campaign-level device targets.
Device Target Status
Required only to delete a device target.
Campaign ID
Optional
Ad Group ID
Optional; applicable only for ad group-level device targets.
AMO ID
Required to edit or delete the data unless you include the Device Target ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.

Campaign-level and ad group-level RLSA target fields

For a description of each data field, see “All available data fields.”

Field
Required?
Acct Name
Required unless each row includes an "AMO ID" for the entity.
Campaign Name
Required
Ad Group Name
Required for ad group-level targets. Not applicable for campaign-level targets.
Audience
Required to create a new target.
Target Type
Optional
Bid Adjustment
Optional
RLSA Target Status
Required to delete a target.
Campaign ID
Optional
Ad Group ID
Optional; applicable only for ad group-level targets.
RLSA Target ID
Required only when you change or delete the target, unless the row includes an “AMO ID” for the target.
AMO ID
Required to edit or delete the data unless you include the RLSA Target ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.
  1. Excel converts large numbers to scientific notation (such as 2.12E+09 for 2115585666) when it opens the file. To view digits in the standard notation, select any cell in the column and click inside the formula bar. ↩︎ ↩︎ ↩︎ ↩︎ ↩︎ ↩︎ ↩︎
recommendation-more-help
bba95088-f653-468b-a1c0-bd1dbc81025c