This is the legacy documentation for Google Ads scripts. Go to the current docs.

Bulk upload - supported entities

For easy reference, we have listed the entities supported by bulk upload. To learn more about bulk uploads, see Bulk Upload.

Campaigns

Column Name Column type Required? Remarks
Campaign String Yes

You should specify either a campaign ID or name to uniquely identify the campaign to apply changes. If you provide both fields, then they should refer to the same campaign.

If you specify a campaign name that doesn't exist and no campaign ID, a new campaign is created.

Campaign ID Number Yes
Start Date Date Required to create new campaigns. Not supported for edits. Use yyyy-MM-dd format.
End Date Date Required to create new campaigns. Not supported for edits. Use yyyy-MM-dd format.
Campaign state String No

Allowed values are

  • enabled
  • paused
  • removed
Budget Number Required to create new campaigns.
Campaign type String Required to create new campaigns.

Allowed values are

  • search
  • display
  • video
Campaign subtype String No

Allowed values are

  • Non-skippable
  • Drive conversions
  • Sequence
  • Mobile app
  • App engagement
  • Smart
  • Gmail display campaign
  • Engagement
  • Manufacturer
  • Comparison Listing
  • Shopping - Partners
  • Standard
Bid Strategy Type String Required to create new campaigns. Valid values depend on campaign type:
Search
  • Manual CPC
  • CPC (enhanced)
  • Target CPA
  • Maximize clicks
  • Maximize conversions
Display
  • Manual CPC
  • CPC (enhanced)
  • Target CPA
  • Maximize clicks
  • Viewable CPM
Video
  • Viewable CPM
  • Manual CPV
  • Target CPM
Action String No

Allowed values are

  • add
  • set
  • remove

Ad groups

Column Name Column type Required? Remarks
Campaign ID Number Required to create new ad groups.

When creating a new ad group, you should specify either a campaign ID or name to uniquely identify the campaign in which to create the ad group. An ad group name is required and the ad group ID should be left empty.

When modifying an existing ad group, you must provide the ad group ID to uniquely identify the ad group being modified. Alternatively, you can also specify an ad group name to identify the ad group. In such cases, you should also specify either the campaign ID or name to uniquely identify the campaign to which the ad group belongs. If you specify both an ad group ID and a name, then both should refer to the same ad group.

Campaign String Required to create new ad groups.
Ad group ID Number Yes
Ad group String Yes
Ad group state String No

Allowed values are

  • enabled
  • paused
  • removed
Bid Strategy Type String Required to create new ad groups.

Allowed values are

  • cpc
  • cpa
  • cpm
Default max. CPC Number Required when creating new ad group if bidding strategy type is cpc.
Max. CPM Number Required when creating new ad group if bidding strategy type is cpm.
Max. CPA (converted clicks) Number Required when creating new ad group if bidding strategy type is cpa.
Action String No

Allowed values are

  • add
  • set
  • remove

Ads

  • Ad properties cannot be modified once they are created; you can update only its status and device preference properties.
  • Only text ads can be created using bulk uploads.
Column Name Column type Required? Remarks
Campaign ID Number Yes

You should specify either an ad group ID or both a campaign name and ad group name. This is used to identify the ad group that contains the ad being changed.

Campaign String Yes
Ad group String Yes
Ad group ID Number Yes
Ad ID Number Yes Ad IDs are required when editing or removing ads. When editing an ad, you should specify the Ad ID column to identify the ad being changed. Not supported when adding an ad.
Ad String Required when creating text ads. When editing text ads, the Ad ID column is optional. Instead, you can specify values for all these columns to uniquely identify the text ad being changed.
Description line 1 String
Description line 2 String
Display URL String
Final URL String
Headline 1 String Required when creating expanded text ads.
Headline 2 String
Description String
Path 1 String
Path 2 String
Device preference type String No

Allowed values are

  • All
  • Mobile
Ad state String No

Allowed values are

  • enabled
  • paused
  • removed
Ad type String Yes Required when creating ads.
Action String No

Allowed values are

  • add
  • set
  • remove

Keywords

Column Name Column type Required? Remarks
Campaign ID Number Yes

You should specify either an ad group ID or both an ad group name and either the parent campaign ID or campaign name. This is used to identify the ad group that contains the keyword being changed.

Campaign String Yes
Ad group String Yes
Ad group ID Number Yes
Keyword String Yes When editing the keywords, you must specify either the Keyword or Keyword ID column.This is used to identify the keyword being changed.
Keyword ID Number Yes
Keyword state String No

Allowed values are

  • enabled
  • paused
  • removed
Max. CPC Number No
Final URL String No
Match type String No

Allowed values are

  • Broad
  • Phrase
  • Exact

If you don't specify this column, then the match type is inferred from the Keyword column.

Action String No

Allowed values are

  • add
  • set
  • remove

Product groups

  • You cannot create or remove product groups. You can only update bids and final URLs of existing product groups.
Column Name Column type Required? Remarks
Campaign String Yes

You should specify either an ad group ID or both an ad group name and either the parent campaign ID or campaign name. This is used to identify the ad group that contains the product group being changed.

Campaign ID Number Yes
Ad group String Yes
Ad group ID Number Yes
Product group String Yes The full path of the product group in your product group hierarchy.
Partition type String No

Allowed values are

  • subdivision
  • unit
MaxCPC Number No
Tracking template String No
Custom parameter String No
Action String No

Allowed values are

  • add
  • set
  • remove

Offline Conversion

Column Name Column type Required? Remarks
Google Click Id String Yes The GCLID that led to the offline conversion. Refer to this article for details. You can also obtain GCLID values by running a Click Performance Report.
Conversion Name String Yes The name of the conversion type.
Conversion Time String Yes The date and time that the conversion occurred. Use MM/dd/yyyy HH:mm:ss format.
Conversion Value Number No The monetary value that you place on the conversion.
Conversion Currency String No

The currency code, if you are uploading conversions for multiple accounts, in different currencies. Do not use if you have set setmoneyInMicros as true.