Targeting Data Import Field Mapping

When the Data Processing Engine processes your CSV file, each column header maps to a specific field on a Salesforce object — either to create records with the specified values or to locate existing records by using lookup keys for establishing associations between targeting data, products, and classifications.

Available in: Lightning Experience

Available in: Enterprise, Performance, and Unlimited editions with Media Cloud- Advanced

This table shows how each CSV column maps to a specific field and object in Salesforce when the Data Processing Engine processes the import.

CSV Header	Maps to Object	Maps to Field
RowNumber	—	Row identifier (not mapped to a Salesforce field)
Category_Name	Ad Target Category	Name
Category_Code	Ad Target Category	Code
Category_IsActive	Ad Target Category	IsActive
Category_DisplaySequence	Ad Target Category	DisplaySequence
Category_Description	Ad Target Category	Description
Segment_Name	Ad Target Category Segment	Name
Segment_Code	Ad Target Category Segment	Code
Segment_IsActive	Ad Target Category Segment	IsActive
Segment_DataType	Ad Target Category Segment	DataType
Segment_DisplayType	Ad Target Category Segment	DisplayType
Segment_DisplaySequence	Ad Target Category Segment	DisplaySequence
Segment_Description	Ad Target Category Segment	Description
SegmentValue_Name	Ad Target Segment Value	Name
SegmentValue_ServerIdentifier	Ad Target Segment Value	ServerIdentifier
SegmentValue_PriceAdjustmentType	Ad Target Segment Value	PriceAdjustmentType
SegmentValue_PriceAdjustmentValue	Ad Target Segment Value	PriceAdjustmentValue
SegmentValue_Rank	Ad Target Segment Value	Rank

The following table shows how each CSV column is used during import — either as a lookup key to locate existing records or as a field value written to newly created association records.

CSV Header	Maps to oBJECT	Maps to Field	Purpose
RowNumber	—	—	Row identifier (not mapped to a Salesforce field)
AdTargetCategory_Code	Ad Target Category	Code	Lookup key to find an existing record.
AdTargetCategorySegment_Code	Ad Target Category Segment	Code	Lookup key to find an existing record.
AdTargetSegmentValue_ServerIdentifier	Ad Target Segment Value	ServerIdentifier	Lookup key to find an existing record.
Product2_ProductCode	-	-	Lookup key to find an existing record.
ProductClassification_Code	Product Classification	Code	Lookup key to find an existing record.
MediaType	Ad Available Target Segment Ad Product Default Target Value	Media Type	Filter criteria for matching records
ShouldAssociateDefaultTargeting	—	—	Controls whether the Ad Product Default Target Value record is created.
AdProductDefaultTargetValue_IsIncluded	Ad Product Default Target Value	IsIncluded	Field value on created record
AdProductDefaultTargetValue_IsEditable	Ad Product Default Target Value	IsEditable	Field value on created record
ShouldAssociateAvailableTargeting	—	—	Controls whether Ad Available Target Segment and Ad Available Target Segment Value records are created.
AdAvailableTargetSegment_ExternalId	Ad Available Target Segment	External_Identifier	Unique key for upsert
AdAvailableTargetSegmentValue_IsIncluded	Ad Available Target Segment Value	IsIncluded	Field value on created record