Create category mappings in bulk

You can manage multiple category mappings at once by uploading a .csv (comma-separated values) file of signals into Google Ad Manager.

Note
  • Category mapping works only for the first-party data; remove third-party Audience Segment data from your file before uploading.
  • Some sensitive categories aren't supported. If your .csv file includes a mapping with an unsupported category, an error message indicates the value is not valid.

Columns in the .csv file

The values for each column in the .csv file must follow these formatting rules.

Field name Data type Acceptable values
Entity type Enum

AUDIENCE_SEGMENT

CUSTOM_TARGETING_VALUE

CMS_METADATA

Entity ID Number The Ad Manager IDs of the entity
  • If your entity type is audience segment, use an audience segment ID.
  • If your entity type is custom targeting, use a value ID of the key-value pair.
  • If your entity type is CMS metadata, use the value ID of the CMS metadata pair.
Taxonomy type Enum

IAB_AUDIENCE_1_1

IAB_CONTENT_2_2

GOOGLE_STRUCTURED_VIDEO_1_0

Category ID Number

For IAB Content & Audience, use the external category ID defined by the IAB.

For Google structured video, the categoryIds are defined in the structured signals table.

Example data

Entity type Entity ID Taxonomy type Category ID
CUSTOM_TARGETING_VALUE 948160320555 IAB_CONTENT_2_2 27
CUSTOM_TARGETING_VALUE 948160320555 IAB_CONTENT_2_2 324
CMS_METADATA 1234567890 GOOGLE_STRUCTURED_VIDEO_1_0 af_1

Upload the file

Note that you must remove column headers from the .csv file before you upload it.

  1. Sign in to Google Ad Manager.

  2. Go to Inventory, then Publisher provided signals.

  1. Under "Tools & settings", in the "Bulk upload mappings" section, click Upload and then drag a .csv file into the indicated area, or click Browse to go to the file.

Tip: If you don't have an existing .csv file, click Download sample CSV file and then modify it as appropriate.

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
1872538968951386743
true
Search Help Center
true
true
true
true
true
148
false
false