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 the 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 .

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`

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

Under "Tools & settings", in the "Bulk upload mappings" section, click Uploadand then drag a .csv file into the indicated area, or click Browseto 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.

How can we improve it?