Salesforce Marketing Cloud
The table below gives information about all the data fields that you can import from Salesforce Marketing Cloud.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
ActionPeriodDeductedValue |
ActionPeriodDeductedValue |
String |
|
dimension |
|
|
ActionPeriodNotes |
ActionPeriodNotes |
String |
|
dimension |
|
|
ActionPeriodType |
ActionPeriodType |
String |
|
dimension |
|
|
Additional |
Additional |
String |
|
dimension |
|
|
BatchID |
BatchID |
Long |
|
metric |
|
|
BatchId |
BatchId |
Long |
|
metric |
|
|
CaptionName |
CaptionName |
String |
|
dimension |
|
|
CardDesignType |
CardDesignType |
String |
|
dimension |
|
|
CardType |
CardType |
String |
|
dimension |
|
|
CarrierType |
CarrierType |
String |
|
dimension |
|
|
Client.ID |
Client.ID |
Long |
|
metric |
|
|
Company |
Company |
String |
|
dimension |
|
|
CompanyId |
CompanyId |
Long |
|
metric |
|
|
Contact |
Contact |
Boolean |
|
dimension |
|
|
CreatedDate |
CreatedDate |
DateTime |
|
dimension |
|
|
Delivery |
Delivery |
Boolean |
|
dimension |
|
|
DeliveryDate |
DeliveryDate |
String |
|
dimension |
|
|
Duplicates |
Duplicates |
Long |
|
metric |
|
|
Email.ID |
Email.ID |
Long |
|
metric |
|
|
Email.ObjectID |
Email.ObjectID |
String |
|
dimension |
|
|
Email.PartnerKey |
Email.PartnerKey |
String |
|
dimension |
|
|
EmailAddress |
EmailAddress |
String |
|
dimension |
|
|
EmailName |
EmailName |
String |
|
dimension |
|
|
EmailSendDate |
EmailSendDate |
String |
|
dimension |
|
|
EventDate |
EventDate |
String |
|
dimension |
|
|
EventType |
EventType |
String |
|
dimension |
|
|
ExistingUndeliverables |
ExistingUndeliverables |
Long |
|
metric |
|
|
ExistingUnsubscribes |
ExistingUnsubscribes |
Long |
|
metric |
|
|
FeedbackMessage |
FeedbackMessage |
String |
|
dimension |
|
|
FinalOrderPrice |
FinalOrderPrice |
Float |
|
metric |
|
|
ForwardedEmails |
ForwardedEmails |
Long |
|
metric |
|
|
FromAddress |
FromAddress |
String |
|
dimension |
|
|
FromName |
FromName |
String |
|
dimension |
|
|
GiftCategory |
GiftCategory |
String |
|
dimension |
|
|
GiftCode |
GiftCode |
String |
|
dimension |
|
|
GiftInfoTitle |
GiftInfoTitle |
String |
|
dimension |
|
|
HardBounces |
HardBounces |
Long |
|
metric |
|
|
ID |
ID |
Long |
|
dimension |
|
|
InvalidAddresses |
InvalidAddresses |
Long |
|
metric |
|
|
IsAlwaysOn |
IsAlwaysOn |
Boolean |
|
dimension |
|
|
IsMultipart |
IsMultipart |
Boolean |
|
dimension |
|
|
JobId |
JobId |
Long |
|
metric |
|
|
LastName |
LastName |
String |
|
dimension |
|
|
List.ID |
List.ID |
Long |
|
metric |
|
|
List.ListName |
List.ListName |
String |
|
dimension |
|
|
List.ObjectID |
List.ObjectID |
String |
|
dimension |
|
|
List.PartnerKey |
List.PartnerKey |
String |
|
dimension |
|
|
MissingAddresses |
MissingAddresses |
Long |
|
metric |
|
|
ModifiedDate |
ModifiedDate |
String |
|
dimension |
|
|
NPS |
NPS |
Long |
|
metric |
|
|
NumberDelivered |
NumberDelivered |
Long |
|
metric |
|
|
NumberErrored |
NumberErrored |
Long |
|
metric |
|
|
NumberExcluded |
NumberExcluded |
Long |
|
metric |
|
|
NumberSent |
NumberSent |
Long |
|
metric |
|
|
NumberTargeted |
NumberTargeted |
Long |
|
metric |
|
|
ObjectID |
ObjectID |
String |
|
dimension |
|
|
OrderCardId |
OrderCardId |
Long |
|
metric |
|
|
OrderDate |
OrderDate |
String |
|
dimension |
|
|
OrderId |
OrderId |
Long |
|
metric |
|
|
OrderProcess |
OrderProcess |
Boolean |
|
dimension |
|
|
OrderStatus |
OrderStatus |
String |
|
dimension |
|
|
OtherBounces |
OtherBounces |
Long |
|
metric |
|
|
PageSize |
PageSize |
String |
|
dimension |
|
|
ParentCaptionName |
ParentCaptionName |
String |
|
dimension |
|
|
PartnerKey |
PartnerKey |
String |
|
dimension |
|
|
PartnerProperties.0.Name |
PartnerProperties.0.Name |
String |
|
dimension |
|
|
PartnerProperties.0.Value |
PartnerProperties.0.Value |
String |
|
dimension |
|
|
PaymentMethod |
PaymentMethod |
String |
|
dimension |
|
|
PaymentStatus |
PaymentStatus |
String |
|
dimension |
|
|
PhoneNumber |
PhoneNumber |
Long |
|
metric |
|
|
PreviewURL |
PreviewURL |
String |
|
dimension |
|
|
Products |
Products |
Boolean |
|
dimension |
|
|
RecipientFirstName |
RecipientFirstName |
String |
|
dimension |
|
|
RecipientId |
RecipientId |
Long |
|
metric |
|
|
RoyaltyHolder |
RoyaltyHolder |
String |
|
dimension |
|
|
SendDate |
SendDate |
DateTime |
|
dimension |
|
|
SendID |
SendID |
Long |
|
metric |
|
|
SentDate |
SentDate |
DateTime |
|
dimension |
|
|
Service |
Service |
Boolean |
|
dimension |
|
|
SoftBounces |
SoftBounces |
Long |
|
metric |
|
|
Status |
Status |
String |
|
dimension |
|
|
Subject |
Subject |
String |
|
dimension |
|
|
SubscriberKey |
SubscriberKey |
String |
|
metric |
|
|
SurveyDate |
SurveyDate |
String |
|
dimension |
|
|
TotalOrderQuantityOfGiftsAndAssociatedCards |
TotalOrderQuantityOfGiftsAndAssociatedCards |
Long |
|
metric |
|
|
TotalOrderQuantityOfPaidCards |
TotalOrderQuantityOfPaidCards |
Long |
|
metric |
|
|
TriggeredSendDefinitionObjectID |
TriggeredSendDefinitionObjectID |
String |
|
dimension |
|
|
URL |
URL |
String |
|
dimension |
|
|
URLIDID |
URLIDID |
String |
|
dimension |
|
|
UniqueClicks |
UniqueClicks |
Long |
|
metric |
|
|
UniqueOpens |
UniqueOpens |
Long |
|
metric |
|
|
Unsubscribes |
Unsubscribes |
Long |
|
metric |
|
|
VoucherCodeTypeName |
VoucherCodeTypeName |
String |
|
dimension |
|
|
VoucherComments |
VoucherComments |
String |
|
dimension |
|
|
VoucherReasonName |
VoucherReasonName |
String |
|
dimension |
|
|
account_id |
account_id |
Long |
|
dimension |
|
|
assetType.displayName |
assetType.displayName |
String |
|
dimension |
|
|
assetType.id |
assetType.id |
Long |
|
metric |
|
|
assetType.name |
assetType.name |
String |
|
dimension |
|
|
category.id |
category.id |
Long |
|
metric |
|
|
category.name |
category.name |
String |
|
dimension |
|
|
category.parentId |
category.parentId |
Long |
|
metric |
|
|
createdBy.email |
createdBy.email |
String |
|
dimension |
|
|
createdBy.id |
createdBy.id |
Long |
|
metric |
|
|
createdBy.name |
createdBy.name |
String |
|
dimension |
|
|
createdBy.userId |
createdBy.userId |
Long |
|
metric |
|
|
createdDate |
createdDate |
String |
|
dimension |
|
|
customerKey |
customerKey |
String |
|
dimension |
|
|
data.email.attributes.0.attributeType |
data.email.attributes.0.attributeType |
String |
|
dimension |
|
|
data.email.attributes.0.channel |
data.email.attributes.0.channel |
String |
|
dimension |
|
|
data.email.attributes.0.displayName |
data.email.attributes.0.displayName |
String |
|
dimension |
|
|
data.email.attributes.0.name |
data.email.attributes.0.name |
String |
|
dimension |
|
|
data.email.attributes.0.order |
data.email.attributes.0.order |
Long |
|
metric |
|
|
data.email.attributes.0.value |
data.email.attributes.0.value |
String |
|
dimension |
|
|
data.email.legacy.legacyCategoryId |
data.email.legacy.legacyCategoryId |
Long |
|
metric |
|
|
data.email.legacy.legacyId |
data.email.legacy.legacyId |
Long |
|
metric |
|
|
data.email.legacy.legacyKey |
data.email.legacy.legacyKey |
String |
|
dimension |
|
|
data.email.legacy.legacyType |
data.email.legacy.legacyType |
String |
|
dimension |
|
|
data.email.options.characterEncoding |
data.email.options.characterEncoding |
String |
|
dimension |
|
|
description |
description |
String |
|
dimension |
|
|
enterpriseId |
enterpriseId |
String |
|
dimension |
|
|
first_name |
first_name |
String |
|
dimension |
|
|
id |
id |
Long |
|
dimension |
|
|
legacyData.legacyCategoryId |
legacyData.legacyCategoryId |
Long |
|
metric |
|
|
legacyData.legacyId |
legacyData.legacyId |
Long |
|
metric |
|
|
legacyData.legacyKey |
legacyData.legacyKey |
String |
|
dimension |
|
|
legacyData.legacyType |
legacyData.legacyType |
String |
|
dimension |
|
|
memberId |
memberId |
String |
|
dimension |
|
|
modelVersion |
modelVersion |
Long |
|
metric |
|
|
modifiedBy.email |
modifiedBy.email |
String |
|
dimension |
|
|
modifiedBy.id |
modifiedBy.id |
Long |
|
metric |
|
|
modifiedBy.name |
modifiedBy.name |
String |
|
dimension |
|
|
modifiedBy.userId |
modifiedBy.userId |
Long |
|
metric |
|
|
modifiedDate |
modifiedDate |
String |
|
dimension |
|
|
name |
name |
String |
|
dimension |
|
|
objectID |
objectID |
String |
|
dimension |
|
|
owner.email |
owner.email |
String |
|
dimension |
|
|
owner.id |
owner.id |
Long |
|
metric |
|
|
owner.name |
owner.name |
String |
|
dimension |
|
|
owner.userId |
owner.userId |
Long |
|
metric |
|
|
status.id |
status.id |
Long |
|
metric |
|
|
status.name |
status.name |
String |
|
dimension |
|
|
thumbnail.thumbnailUrl |
thumbnail.thumbnailUrl |
String |
|
dimension |
|