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

In this article:

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://www.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 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

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

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?

Need more help?

Try these next steps:

Contact us Tell us more and we’ll help you get there
true
Search
Clear search
Close search
Main menu
6029753889425742334
true
Search Help Center
true
true
true
true
true
5055977
false
false