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: 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
entityType	Enum	AUDIENCE_SEGMENT CUSTOM_TARGETING_VALUE CMS_METADATA
entityId	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.
taxonomyType	Enum	IAB_AUDIENCE_1_1 IAB_CONTENT_2_2 GOOGLE_STRUCTURED_VIDEO_1_0
categoryId	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

entityType	entityId	taxonomyType	categoryId
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

 

1. Sign in to Google Ad Manager.

2. Go to Inventory, then Publisher provided signals.

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