Bulksheet schema changes in the new Search Ads 360

The new Search Ads 360 features an updated bulksheet schema. While most fields are unchanged, there are some differences. To migrate generated bulksheets to the new Search Ads 360, you'll need to update your bulksheets to match the schemas below and to use the new Search Ads 360 entity IDs.

Entity IDs from the previous Search Ads 360 have changed

When you migrate campaigns, ad groups, or other entities to the new Search Ads 360, they will be assigned new IDs. To migrate a bulksheet, you'll need to update the following fields to match the entity IDs in the new Search Ads 360:

Campaign ID
Campaign group ID
Customer ID
Ad group ID
Ad ID
Keyword ID
Advertiser conversion ID
Conversion ID
Conversion visit ID
Floodlight activity ID

Shared bulksheet columns

Supported platforms	Previous Search Ads 360	New Search Ads 360	Description
All	`Row type`	`Row Type`	(Updated) 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`	`Action`	Optional. The action to be taken. Supported values: `Add` `Edit` `Remove`
All	`Account`	`Customer ID`	(Updated) Required. The ID of the manager, sub-manager, or client account. Example: `123-456-7890`.
All	`Campaign`	`Campaign`	Required. The name of your campaign. Example: `Shoe sales`
All	`Campaign ID`	`Campaign ID`	(New) Optional. The ID of your campaign. Example: `19582311240`
All	`Ad group`	`Ad group`	Keywords, Negative Keywords: Required Ad groups: Required on Add The name of the ad group. Example: `Heels`
All	`Ad group ID`	`Ad group ID`	Optional. The ID of your ad group. Example: `137828207414`
All	`Keyword max CPC`	`Default max. CPC`	(Updated) Optional. The highest amount you're willing to pay for a click on your ad. Number with 2 decimals. Example: `12.34`
All	Not supported	`Max. CPV`	(New) Optional. The highest amount you're willing to pay for a view on your video. Number with 2 decimals. Example: `12.34`
All	Not supported	`Mobile final URL`	(New) Optional. The mobile URL (example: http://m.example.com) people reach when they click your ad.
All	Not supported	`Final URL suffix`	(New) Optional. The final URL suffix consists of parameters added to the end of your landing page URL for tracking purposes. Example: `x=y`
All	`URL template`	`Tracking template`	(Updated) Optional. The tracking template used. Path to a valid template (example: `http://abc.com/tracking?param1=create&url={lpurl}`

Keywords

Supported platforms	Previous Search Ads 360	New Search Ads 360	Description
All	Not supported	`Keyword status`	(New) Optional. The desired status of the keyword. Supported values:
All	`Keyword`	`Keyword`	Required on Add. A keyword to add to your campaign or ad group. Examples: `shoes`
All	Not supported	`Keyword ID`	(New) Optional. The ID of the keyword to edit or remove. Example: `10071290`
All	`Keyword match type`	`Type`	(Updated) Optional. The match type of your keyword. Supported values: `Exact match` `Phrase match` `Broad match`
All	`Keyword landing page`	`Final URL`	(Updated) Optional. The final URL people reach when they click your ad. Example: http://example.com
All	`Label`	`Label`	Optional. The label applied to your keyword. Examples: `label 1; label 2; label 3 [123-456-7890]`
Microsoft Advertising	`Keyword Param 2`	Not supported	Deprecated. Use `Custom parameter` instead.
Microsoft Advertising	`Keyword Param 3`	Not supported	Deprecated. Use `Custom parameter` instead.
Google Ads, Yahoo! JAPAN Ads only	Not supported	`Custom parameter`	(New) Optional. Custom URL parameters. Example: `{_color}=red ; {_bg}=blue`

Conversions

Previous Search Ads 360	New Search Ads 360	Description
`Conversion type`	`Conversion type`	Optional. Supported values: `Action`, `Transaction`
`Keyword ID`	`Keyword ID`	Optional. The ID of the keyword. Example: `10071290`
`Ad ID`	`Ad ID`	Optional. The ID of the ad. Example: `10071290`
`Click Id`	`Click Id`	Required on edit. Example: `CJjsqefUkAJSHDJ_gPdDiEAAA`
`Advertiser conversion ID`	`Advertiser conversion ID`	Optional. The ID of the conversion action. Example: `1234567`
`Device segment`	`Device segment`	Optional. The type of device to track. Supported values: `Desktop`, `Other device`, `Tablet`, `High end mobile`.
`Conversion ID`	`Conversion ID`	Optional. The ID of the conversion. Example: `123456678`
`Conversion quantity`	`Conversion quantity`	Optional. Example: `12345`
`Floodlight activity ID`	`Floodlight activity ID`	Optional. The ID of a Floodlight activity. Example: `12345`
`Floodlight activity name`	`Floodlight activity name`	Optional. The name of a Floodlight activity. Example: `Purchase`
`Conversion visit ID`	`Conversion visit ID`	Optional. The ID of a conversion visit. Example: `12345`
`Engine Account Currency`	`Client account currency`	(Updated) Optional. The currency used by the client account. Example: `USD`
`Conversion revenue`	`Conversion revenue`	Optional. The monetary amount of the conversion. Example: `12.34`
`Status`	`Status`	Optional. The status of the conversion. Supported values: `Active`, `Removed`
`Conversion visit timestamp`	`Conversion visit timestamp`	Optional. The timestamp of the conversion visit. Example: `2023-03-21 12:23:00.001`
`Conversion external click ID`	Not supported	Deprecated. Use `Click ID` instead.
`Feed ID`	Not supported	Deprecated
`Channel`	Not supported	Deprecated
`Product country`	Not supported	Deprecated
`Product Country`	Not supported	Deprecated
`Product ID`	Not supported	Deprecated
`Product language`	Not supported	Deprecated
`Store ID`	Not supported	Deprecated
`Product group ID`	Not supported	Deprecated

Ad group

Supported platforms	Previous Search Ads 360	New Search Ads 360	Description
All	Not supported	`Ad group status`	(New) Optional. The desired status of the ad group. Supported values:
Google Ads	Not supported	`Ad group type`	(New) Optional. Once 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	`Ad group language`	`Language`	(Updated) Optional. The language targeted by the ad group. Supported values: `Optimize` `Do not optimize`
Microsoft Advertising Yahoo! JAPAN Ads	Not supported	`Location`	(New) Optional. The location targeted by the ad group. Country name. Example: `France`
Microsoft Advertising	`Country`	Not supported	Deprecated. Use `Location` instead.
Microsoft Advertising	`Region`	Not supported	Deprecated. Use `Location` instead.
Microsoft Advertising	`Metro`	Not supported	Deprecated. Use `Location` instead.
Microsoft Advertising	`City`	Not supported	Deprecated. Use `Location` instead.
Google Ads Yahoo! JAPAN Ads	`Ad rotation`	`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	`Ad group search max CPC`	`Default max. CPC`	(Updated) 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	Not supported	`CPC%`	(New) Optional. The percentage by which to adjust manual CPC bids. Example: `12.3%`
Google Ads	Not supported	`Max. CPM`	(New) Optional. The maximum cost you're willing to pay per thousand impressions. Example: `12.34`
Google Ads	Not supported	`Max. CPV`	(New) Optional. The highest amount you're willing to pay for a click on your video. Number with 2 decimals. Example: 12.34
Google Ads	`Ad group target CPA`	`Target CPA`	(Updated) Optional. Cost-per-action - the average amount you'd like to pay for a conversion. Number with 2 decimals. Example: `12.34`
Google Ads	Not supported	`Target CPM`	(New) Optional. The average amount you want to pay per thousand impressions. Number with 2 decimals. Example: `12.34`
Google Ads	`Ad group target ROAS`	`Target ROAS`	(Updated) Optional. Target return on ad spend. Example: `12%`
Microsoft Advertising	`Ad group content max CPC`	Not supported	Deprecated. Use `Default max. CPC` instead.
Yahoo! Gemini ad groups	`Ad group native max CPC`	Not supported	Starting July 2023, Yahoo! Engine Track (formerly Yahoo! Gemini) within Search Ads 360 will no longer be supported. Support for Yahoo! JAPAN Ads is unchanged.
Microsoft Advertising	`Ad group start date (YYYY-MM-DD)`	Not supported
Microsoft Advertising	`Ad group end date (YYYY-MM-DD)`	Not supported
All	`Desktop bid adjustment %`	Not supported
All	`Mobile bid adjustment %`	Not supported
All	`Tablet bid adjustment %`	Not supported
All	`Label`	`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`	(New) Optional. Countries to exclude from targeting. Example: `France`

Negative keywords

Supported platforms	Previous Search Ads 360	New Search Ads 360	Description
All	Not supported	`Keyword status`	(New) Optional. The desired status of the negative keyword. Supported values:
All	`Keyword ID`	`Keyword ID`	Required on Edit or Delete. Example: `1235`
All	`Keyword`	`Negative keyword`	(Updated) Required on Add. The negative keyword to edit or remove. Example: `cat`
All	`Match Type`	`Type`	(Updated) Optional. The match type of your negative keyword. Supported values: `Exact match` `Phrase match` `Broad match`
All	Not supported	`Level`	(New) Optional. The entity to which the negative keyword should be applied. Supported values: `Ad group`, `Campaign`

Campaigns

Supported platforms	Previous Search Ads 360	New Search Ads 360	Description
Baidu Microsoft Advertising Yahoo! JAPAN Ads	Not supported	`Campaign group`	(New) Optional. The name of the campaign group. Example: `Summer`
Microsoft Advertising Baidu	Not supported	`Campaign group ID`	(New) Optional. The ID of the campaign group. Example: `1234`
Google Ads	Not supported	`Campaign type`	(New) 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	Not supported	`Campaign subtype`	(New) 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	Not supported	`Target CPA`	(New) Optional. Cost-per-action - the average amount you'd like to pay for a conversion. Number with 2 decimals. Example: `12.34`
Google Ads	Not supported	`Target ROAS`	(New) Optional. Target return on ad spend. Example: `15%`
Google Ads	Not supported	`Target Impression Share`	(New) Optional. Your target impression share. Example: `15%.`
Google Ads	Not supported	`Max CPC Bid Limit for Target IS`	(New) Optional. The maximum you're willing to pay per target impression share. Example: `10.00`
Google Ads	Not supported	`Location Goal for Target IS`	(New) Optional. Your target placement for impression shares. Supported values: `Anywhere on results page` `Top of results page` `Absolute top of results page`
All	`Advertiser bid strategy`	Not supported	Deprecated. Use `Bid strategy` or `Bid strategy type` instead (Google Ads only).
Google Ads	Not supported	`Bid strategy`	(New) Optional. Portfolio bid strategy name, if applicable. Example: `my bid strategy`
Google Ads	Not supported	`Bid strategy type`	(New) 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 (YYYY-MM-DD)`	`Campaign start date`	(Updated) Optional. The starting date of the campaign. Example: `2024-02-29`
Google Ads Yahoo! JAPAN Ads	`Campaign end date (YYYY-MM-DD)`	`Campaign end date`	(Updated) Optional. The end date of the campaign. Example: `2024-02-29`
All	`Campaign daily budget`	Not supported	Deprecated. Use `Budget` and `Budget type` instead.
All	Not supported	`Budget`	(New) Required on Add. The budget for the campaign. Example: `100` Enter `0` for Baidu unlimited budget.
Google Ads	Not supported	`Budget type`	(New) Required on Add. Supported values: `Daily` `Campaign total` `Monthly`
Microsoft Advertising	`Campaign monthly budget`	Not supported	Deprecated. Use `Budget` and `Budget type` instead.
Yahoo! Gemini	`Campaign lifetime budget`	Not supported	Starting July 2023, Yahoo! Engine Track (formerly Yahoo! Gemini) within Search Ads 360 will no longer be supported. Support for Yahoo! JAPAN Ads is unchanged.
Microsoft Advertising	`Campaign budget type`	Not supported	Deprecated. Use `Budget type` instead.
Google Ads Microsoft Advertising	`Campaign target network`	`Networks`	(Updated) Optional. Supported values (Google Ads): `Google search` `Search partners` `Display Network` `YouTube search` `YouTube videos` Microsoft Advertising `Display Network` `Bing Search`
Baidu	Not supported	`Bid adjustment setting`	(New) Required on Add. Supported values: `Based on desktop bids` `Based on mobile bids`
All	Not supported	`Devices`	Optional. Use to set device bid adjustments. Examples: `Computers:+10%` `Mobile devices with full browsers:-5%` `Tablets with full browsers:+15%`
`All`	`Desktop bid adjustment %`	Not supported	Deprecated. Use `Devices` instead.
All	`Mobile bid adjustment %`	Not supported	Deprecated. Use `Devices` instead.
All	`Tablet bid adjustment %`	Not supported	Deprecated. Use `Devices` instead.
All	Not supported	`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	`Campaign language target`	`Language`	(Updated) Optional. Use to include or exclude target language(s). Examples: `en` `zh_hk:excluded` Learn more about Bulksheet templates and language codes.
All	Not supported	`Exclusion`	(New) 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	Not supported	`Location`	(New) 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.
All	`Country`	Not supported	Deprecated. Use `Location` instead.
All	`Region`	Not supported	Deprecated. Use `Location` instead.
All	`Metro`	Not supported	Deprecated. Use `Location` instead.
All	`City`	Not supported	Deprecated. Use `Location` instead.
Baidu	`Ad rotation`	`Ad rotation`	Optional. Supported values: `Optimize (clicks)` `Rotate evenly` `Optimize (conversions)` `Rotate indefinitely`
All	`Ad delivery method`	`Delivery method`	(Updated) 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`	`Label`	Optional. Any label attached to your campaign. Examples: `label 1`; `label 2`; `label 3 [123-456-7890]`
Google Ads	Not supported	`Viewability vendor`	(New) Optional. Mobile app viewability provider. Supported values: `None` `MOAT` `Double Verify` `Integral Ad Science` `comScore` `Telemetry`

Was this helpful?

How can we improve it?