Bulksheet schema in Search Ads 360

Bulksheets in Search Ads 360 enable you to make changes to campaigns, ad groups, keywords, and other items. The bulksheet schemas below may be used to create these changes.

Bulksheet columns

Supported platforms	Columns	Description
All	`Row Type`	Required.Supported values `Campaign` `Ad group` `Ad` `Keyword` `Negative keyword` `Product group` `Conversion` Google Ads only: `Portfolio bid strategy` `Shared budget` `Campaign audience list` `Excluded campaign audience list` `Ad group audience list` `Excluded ad group audience list` `Callout` `Call asset` `Image asset` `Price asset` `Sitelink` `Structured snippet` `Negative Placement` `Negative Placement Association` `Targeted Location` `Excluded Location` `Ad customizer attribute` `Hotel group` `Hotel reconciliation`
All	`Action`	Optional. The action to be taken. Supported values: `Add` `Edit` `Remove`
All	`Customer ID`	Required. The ID of the manager, sub-manager, or client account. Example: `123-456-7890`
All	`Campaign`	Required. The name of your campaign. Example: `Shoe sales`
All	`Campaign ID`	Optional. The ID of your campaign. Example: `19582311240`
All	`Ad group`	Keywords, Negative Keywords: Required Ad groups: Required on Add The name of the ad group. Example: `Heels`
All	`Ad group ID`	Optional. The ID of your ad group. Example: `137828207414`
All	`Default max. CPC`	Optional. The highest amount you're willing to pay for a click on your ad. Number with 2 decimals. Example: `12.34`
All	`Max. CPV`	Optional. The highest amount you're willing to pay for a view on your video. Number with 2 decimals. Example: `12.34`
All	`Mobile final URL`	Optional. The mobile URL (example: http://m.example.com) people reach when they click your ad.
All	`Final URL suffix`	Optional. The final URL suffix consists of parameters added to the end of your landing page URL for tracking purposes. Example: `x=y`
All	`Tracking template`	Optional. The tracking template used. Path to a valid template (example: `http://abc.com/tracking?param1=create&url={lpurl}`

Keywords

Supported platforms	Keywords	Description
All	`Keyword status`	Optional. The desired status of the keyword. Supported values: `Enabled` `Paused` `Removed`
All	`Keyword`	Required on Add. A keyword to add to your campaign or ad group. Examples: `shoes`
All	`Keyword ID`	Optional. The ID of the keyword to edit or remove. Example: `10071290`
All	`Type`	Optional. The match type of your keyword. Supported values: `Exact match` `Phrase match` `Broad match`
All	`Final URL`	Optional. The final URL people reach when they click your ad. Example: http://example.com
All	`Label`	Optional. The label applied to your keyword. Examples: `label 1; label 2; label 3 [123-456-7890]`
Google Ads, Yahoo! JAPAN Ads only	`Custom parameter`	Optional. Custom URL parameters. Example: `{_color}=red ; {_bg}=blue`

Conversions

Conversions	Description
`Conversion type`	Optional. Supported values: `Action`, `Transaction`
`Keyword ID`	Optional. The ID of the keyword. Example: `10071290`
`Ad ID`	Optional. The ID of the ad. Example: `10071290`
`Click Id`	Required on edit. Example: `CJjsqefUkAJSHDJ_gPdDiEAAA`
`Advertiser conversion ID`	Optional. The ID of the conversion action. Example: `1234567`
`Device segment`	Optional. The type of device to track. Supported values: `Desktop`, `Other device`, `Tablet`, `High end mobile`.
`Conversion ID`	Optional. The ID of the conversion. Example: `123456678`
`Conversion quantity`	Optional. Example: `12345`
`Floodlight activity ID`	Optional. The ID of a Floodlight activity. Example: `12345`
`Floodlight activity name`	Optional. The name of a Floodlight activity. Example: `Purchase`
`Conversion visit ID`	Optional. The ID of a conversion visit. Example: `12345`
`Client account currency`	Optional. The currency used by the client account. Example: `USD`
`Conversion revenue`	Optional. The monetary amount of the conversion. Example: `12.34`
`Status`	Optional. The status of the conversion. Supported values: `Active`, `Removed`
`Conversion visit timestamp`	Optional. The timestamp of the conversion visit. Example: `2023-03-21 12:23:00.001`

Ad group

Supported platforms	Ad group	Description
All	`Ad group status`	Optional. The desired status of the ad group. Supported values: `Enabled` `Paused` `Removed`
Google Ads	`Ad group type`	Optional. After you've created an ad group type, it cannot be edited. Supported values: `Standard` `Dynamic` `Display` `Display engagement` `Shopping - Product` `Shopping - Showcase` `Shopping - Smart` `In-stream` `In-feed video` `Bumper` `Non-skippable` `Hotel` `Hotels - Property promotion` `Efficient reach` `Video action`
Google Ads Yahoo! JAPAN Ads	`Language`	Optional. The language targeted by the ad group. Supported values: `Optimize` `Do not optimize`
Microsoft Advertising Yahoo! JAPAN Ads	`Location`	Optional. The location targeted by the ad group. Country name. Example: `France`
Google Ads Yahoo! JAPAN Ads	`Ad rotation`	Optional. Specifies ad rotation settings: how often you'd like the ads in your ad group to be served relative to one another. Supported values: `Optimize`, `Do not optimize`
All	`Default max. CPC`	Optional. The highest amount you're willing to pay for a click on ads in your ad group. Number with 2 decimals. Example: `12.34`
Google Ads	`CPC%`	Optional. The percentage by which to adjust manual CPC bids. Example: `12.3%`
Google Ads	`Max. CPM`	Optional. The maximum cost you're willing to pay per thousand impressions. Example: `12.34`
Google Ads	`Max. CPV`	Optional. The highest amount you're willing to pay for a click on your video. Number with 2 decimals. Example: 12.34
Google Ads	`Target CPA`	Optional. Cost-per-action - the average amount you'd like to pay for a conversion. Number with 2 decimals. Example: `12.34`
Google Ads	`Target CPM`	Optional. The average amount you want to pay per thousand impressions. Number with 2 decimals. Example:`12.34`
Google Ads	`Target ROAS`	Optional. Target return on ad spend. Example: `12%`
All	`Label`	Optional. The label applied to your ad group. Examples: `label 1`; `label 2`; `label 3 [123-456-7890]`
Microsoft Advertising Yahoo! JAPAN Ads	`Exclusion`	Optional. Countries to exclude from targeting. Example: `France`

Negative keywords

Supported platforms	Negative keywords	Description
All	`Keyword status`	Optional. The desired status of the negative keyword. Supported values: `Enabled` `Paused` `Removed`
All	`Keyword ID`	Required on Edit or Delete. Example: `1235`
All	`Negative keyword`	Requiredon Add. The negative keyword to edit or remove. Example: `cat`
All	`Type`	Optional. The match type of your negative keyword. Supported values: `Exact match` `Phrase match` `Broad match`
All	`Level`	Optional. The entity to which the negative keyword should be applied. Supported values: `Ad group`, `Campaign`

Campaigns

Supported platforms	Campaigns	Description
Baidu Microsoft Advertising Yahoo! JAPAN Ads	`Campaign group`	Optional. The name of the campaign group. Example: `Summer`
Microsoft Advertising Baidu	`Campaign group ID`	Optional. The ID of the campaign group. Example: `1234`
Google Ads	`Campaign type`	Required on Add. The type of campaign. Supported values (Add): `Search` `Display` `Video` Supported values (Edit): `Unknown` `Search` `Display` `Shopping` `Video` `App` `Smart` `Hotel` `Discovery` `Performance Max`
Google Ads	`Campaign subtype`	Optional. Supported values: `Non-skippable` `Drive conversions` `Sequence` `Mobile app` `App engagement` `Smart` `Gmail display campaign` `Engagement` `Manufacturer` `Comparison Listing` `Shopping - Partners Standard`
Google Ads	`Target CPA`	Optional. Cost-per-action - the average amount you'd like to pay for a conversion. Number with 2 decimals. Example: `12.34`
Google Ads	`Target ROAS`	Optional. Target return on ad spend. Example: `15%`
Google Ads	`Target Impression Share`	Optional. Your target impression share. Example: `15%.`
Google Ads	`Max CPC Bid Limit for Target IS`	Optional. The maximum you're willing to pay per target impression share. Example: `10.00`
Google Ads	`Location Goal for Target IS`	Optional. Your target placement for impression shares. Supported values: `Anywhere on results page` `Top of results page` `Absolute top of results page`
Google Ads	`Bid strategy`	Optional. Portfolio bid strategy name, if applicable. Example: `my bid strategy`
Google Ads	`Bid strategy type`	Required on Add. Supported values `CPC (enhanced)` `Manual CPC` `cpc` `Viewable CPM` `cpm` `CPA (target)` `Maximize clicks` `Target ROAS` `Target CPA` `Maximize Conversions` `Maximize Conversion Value` `Manual CPV` `cpv` `Target CPM` `CPC%` `Target Impression Share` `Commission` `Invalid` `Target Position` `Target CPV`
Google Ads Yahoo! JAPAN Ads	`Campaign start date`	Optional. The starting date of the campaign. Example: `2024-02-29`
Google Ads Yahoo! JAPAN Ads	`Campaign end date`	Optional. The end date of the campaign. Example: `2024-02-29`
All	`Budget`	Required on Add. The budget for the campaign. Example: `100` Enter `0` for Baidu unlimited budget.
Google Ads	`Budget type`	Required on Add. Supported values: `Daily` `Campaign total` `Monthly`
Google Ads Microsoft Advertising	`Networks`	Optional. Supported values (Google Ads): `Google search` `Search partners` `Display Network` `YouTube search` `YouTube videos` Microsoft Advertising `Display Network` `Bing Search`
Baidu	`Bid adjustment setting`	Required on Add. Supported values: `Based on desktop bids` `Based on mobile bids`
All	`Devices`	Optional. Use to set device bid adjustments. Examples: `Computers:+10%` `Mobile devices with full browsers:-5%` `Tablets with full browsers:+15%`
All	`Devices`	Optional. Use to set device bid adjustments. Examples: `Computers:+10% Mobile devices with full browsers:-5% Tablets with full browsers:+15%`
Google Ads Microsoft Advertising	`Language`	Optional. Use to include or exclude target language(s). Examples: `en` `zh_hk:excluded` Learn more about Bulksheet templates and language codes.
All	`Exclusion`	Optional. Use to exclude targeted locations. Examples: `20 \| mi \| Seattle, Washington, United States : -5%` `Taipei City, Taiwan : +10%` `Montréal, Québec, Canada` `600 \| km \| Redmond, Washington, United States:removed`
All	`Location`	Optional. Use to set location targeting. Examples: `20 \| mi \| Seattle, Washington, United States : -5%` `Taipei City, Taiwan : +10%` `Montréal, Québec, Canada` `600 \| km \| Redmond, Washington, United States:removed` Learn more about Bulksheet templates and geo codes.
Baidu	`Ad rotation`	Optional. Supported values: `Optimize (clicks)` `Rotate evenly` `Optimize (conversions)` `Rotate indefinitely`
All	`Delivery method`	Optional. Engine-specific city codes. Supported values: Google Ads, Microsoft Advertising: Text for Google Ads and Bing Ads Baidu: Up to 7 digit codes: 2 digit country + 2 digit province + 3 digit city) To target multiple cities, separate with `\|`. Example: `Quebec, CA-QC, CA \| Toronto, CA-ON, CA` Microsoft Advertising: Use this setting at the ad group level to override the campaign level setting.
All	`Label`	Optional. Any label attached to your campaign. Examples: `label 1`; `label 2`; `label 3 [123-456-7890]`
Google Ads	`Viewability vendor`	Optional. Mobile app viewability provider. Supported values: `None` `MOAT` `Double Verify` `Integral Ad Science` `comScore` `Telemetry`

Was this helpful?

How can we improve it?