CSV Header Files for Targeting Data Migration

Migrate your targeting data into Media Cloud by using two Data Processing Engine templates that handle the end-to-end setup of your targeting hierarchy. The first template, Create Media Targeting Categories, Segments And Values, imports your foundational targeting data by creating Ad Target Category, Ad Target Category Segment, and Ad Target Segment Value records from a single CSV file. When your targeting records exist in the org, the second template, Map Targeting With Product, Classification And Media Type, associates those records with your products, product classifications, and media types by creating Ad Available Target Segment, Ad Available Target Segment Value, and Ad Product Default Target Value records. Together, these templates eliminate the need for manual record creation and reduce the time required to set up complex targeting configurations for your media catalog.

Important To upload targeting data by using the Data Processing Engine template, match the expected CSV header format exactly. Deviations in spelling, casing, or order cause the upload to fail.

Use the Create Targeting Data template to import targeting categories, segments, and segment values in a single operation. Each row in the CSV file can create up to three records: one Ad Target Category, one Ad Target Category Segment, and one Ad Target Segment Value. The Data Processing Engine determines which records to create based on the presence of data in the name columns — if a name column is empty, no record is created for that entity in that row. Segment values are linked to their parent segments by using the Segment_Code column, so ensure that the segment is defined in an earlier row within the same CSV file.

Use the Assign Targeting Data template to associate existing targeting records with products, product classifications, and media types. This template creates records in Ad Available Target Segment, Ad Available Target Segment Value, and Ad Product Default Target Value. Two columns — ShouldAssociateDefaultTargeting and ShouldAssociateAvailableTargeting — control which association records are created for each row. Both can be set to TRUE in the same row to create all association types in a single pass. The template uses unique identifier fields such as codes and server identifiers to locate existing records in your org.