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
|
Budget | Number | Required to create new campaigns. | |
Campaign type | String | Required to create new campaigns. |
Allowed values are
|
Campaign subtype | String | No |
Allowed values are
|
Bid Strategy Type | String | Required to create new campaigns. | Valid values depend on campaign type:
|
Action | String | No |
Allowed values are
|
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
|
Bid Strategy Type | String | Required to create new ad groups. |
Allowed values are
|
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
|
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
|
Ad state | String | No |
Allowed values are
|
Ad type | String | Yes | Required when creating ads. |
Action | String | No |
Allowed values are
|
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
|
Max. CPC | Number | No | |
Final URL | String | No | |
Match type | String | No |
Allowed values are
If you don't specify this column, then the match type is inferred from the Keyword column. |
Action | String | No |
Allowed values are
|
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
|
MaxCPC | Number | No | |
Tracking template | String | No | |
Custom parameter | String | No | |
Action | String | No |
Allowed values are
|
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
|