Assign classification values to account components using bulksheets

Last update: 2023-09-29
  • Created for:
  • User

You can associate label classifications with values for the following search entities using bulksheets: campaign, ad group, keyword, ad, placement, unit-level product group, and dynamic search target. Each label classification can have up to 2000 values.

Each entity can have one label value per classification. For example, Shoes_Campaign can have a Color value of “red” and a Geo value of “Los Angeles,” but it can’t have multiple values for Color or Geo.

Label values are inherited by child entities, so don’t enter values for child entities unless you want to override the inherited values.


Your keywords and ad copy for some ad networks and campaign types are non-mutable, which means that editing them deletes the existing entity and creates a new one. When an existing entity is deleted in this way, the label classification isn’t assigned to the new entity.

  1. Download a bulksheet that includes the entities to which you want to assign label classification values:

    • On the Rows and Columns tab, expand the Campaign list in the Bulksheet Columns pane.

    • Expand the Label Classification list.

    • Select each classification for which you want to include a column in the bulksheet file.

      For example, if you include the label classifications “Color” and “Geo,” then the bulksheet includes “Color” and “Geo” columns.

  2. Open the file in an editor, and add label values to the label classification columns for the entities with which to associate them. The maximum length for each value is 100 characters, and it can include ASCII and non-ASCII characters.

    See the example values in the next section.

    Besides adding values, you can also delete existing values by removing them from the relevant rows. To remove values from both a parent entity and its child entities, either a) include only the parent entity row and remove the existing classification value or b) include both the parent entity and its child entities, and remove the existing classification value from all of the parent and child rows.

  3. Upload the file to create the associations.

The uploaded label values are visible in the relevant entity views.

Example of label classification values to upload in bulksheets

This example includes columns for label classifications “Color” and “Geo.” For your own bulksheets, substitute columns for your own label classification names.

Account Campaign Ad Group Keyword Ad Placement Labels Color Geo
Acct1 C1 Green
Acct1 C1 AG1
Acct1 C1 AG1 K1 UK
Acct1 C1 AG1 K2 Red AU
Acct1 C1 AG1 K3 Blue DE
Acct1 C1 AG1 A1
Acct1 C1 AG1 A1 Red
Acct1 C1 AG1 P1 Red AU
Acct1 C1 AG1 P2 Blue DE

On this page