Appendix - Required bulksheet data for Microsoft Advertising accounts

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 API reference for a list of possible values, 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 API reference for a list of possible languages.

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 Adobe 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 Adobe-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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.