You can manage multiple category mappings at once by uploading a .csv (comma-separated values) file of signals into Google Ad Manager.
- 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 |
|
Entity ID |
Number | The Ad Manager IDs of the entity
|
Taxonomy type |
Enum |
|
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.
-
Sign in to Google Ad Manager.
-
Go to Inventory, then Publisher provided signals.
-
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.