Salesforce Marketing Cloud#
The table below gives information about all the data fields that you can import from Salesforce Marketing Cloud.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.
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 |
Use in Adverity |
|---|---|---|
ActionPeriodDeductedValue |
ActionPeriodDeductedValue |
dimension |
ActionPeriodNotes |
ActionPeriodNotes |
dimension |
ActionPeriodType |
ActionPeriodType |
dimension |
Additional |
Additional |
dimension |
BatchID |
BatchID |
metric |
BatchId |
BatchId |
metric |
CaptionName |
CaptionName |
dimension |
CardDesignType |
CardDesignType |
dimension |
CardType |
CardType |
dimension |
CarrierType |
CarrierType |
dimension |
Client.ID |
Client.ID |
metric |
Company |
Company |
dimension |
CompanyId |
CompanyId |
metric |
Contact |
Contact |
dimension |
CreatedDate |
CreatedDate |
dimension |
Delivery |
Delivery |
dimension |
DeliveryDate |
DeliveryDate |
dimension |
Duplicates |
Duplicates |
metric |
Email.ID |
Email.ID |
metric |
Email.ObjectID |
Email.ObjectID |
dimension |
Email.PartnerKey |
Email.PartnerKey |
dimension |
EmailAddress |
EmailAddress |
dimension |
EmailName |
EmailName |
dimension |
EmailSendDate |
EmailSendDate |
dimension |
EventDate |
EventDate |
dimension |
EventType |
EventType |
dimension |
ExistingUndeliverables |
ExistingUndeliverables |
metric |
ExistingUnsubscribes |
ExistingUnsubscribes |
metric |
FeedbackMessage |
FeedbackMessage |
dimension |
FinalOrderPrice |
FinalOrderPrice |
metric |
ForwardedEmails |
ForwardedEmails |
metric |
FromAddress |
FromAddress |
dimension |
FromName |
FromName |
dimension |
GiftCategory |
GiftCategory |
dimension |
GiftCode |
GiftCode |
dimension |
GiftInfoTitle |
GiftInfoTitle |
dimension |
HardBounces |
HardBounces |
metric |
ID |
ID |
dimension |
InvalidAddresses |
InvalidAddresses |
metric |
IsAlwaysOn |
IsAlwaysOn |
dimension |
IsMultipart |
IsMultipart |
dimension |
JobId |
JobId |
metric |
LastName |
LastName |
dimension |
List.ID |
List.ID |
metric |
List.ListName |
List.ListName |
dimension |
List.ObjectID |
List.ObjectID |
dimension |
List.PartnerKey |
List.PartnerKey |
dimension |
MissingAddresses |
MissingAddresses |
metric |
ModifiedDate |
ModifiedDate |
dimension |
NPS |
NPS |
metric |
NumberDelivered |
NumberDelivered |
metric |
NumberErrored |
NumberErrored |
metric |
NumberExcluded |
NumberExcluded |
metric |
NumberSent |
NumberSent |
metric |
NumberTargeted |
NumberTargeted |
metric |
ObjectID |
ObjectID |
dimension |
OrderCardId |
OrderCardId |
metric |
OrderDate |
OrderDate |
dimension |
OrderId |
OrderId |
metric |
OrderProcess |
OrderProcess |
dimension |
OrderStatus |
OrderStatus |
dimension |
OtherBounces |
OtherBounces |
metric |
PageSize |
PageSize |
dimension |
ParentCaptionName |
ParentCaptionName |
dimension |
PartnerKey |
PartnerKey |
dimension |
PartnerProperties.0.Name |
PartnerProperties.0.Name |
dimension |
PartnerProperties.0.Value |
PartnerProperties.0.Value |
dimension |
PaymentMethod |
PaymentMethod |
dimension |
PaymentStatus |
PaymentStatus |
dimension |
PhoneNumber |
PhoneNumber |
metric |
PreviewURL |
PreviewURL |
dimension |
Products |
Products |
dimension |
RecipientFirstName |
RecipientFirstName |
dimension |
RecipientId |
RecipientId |
metric |
RoyaltyHolder |
RoyaltyHolder |
dimension |
SendDate |
SendDate |
dimension |
SendID |
SendID |
metric |
SentDate |
SentDate |
dimension |
Service |
Service |
dimension |
SoftBounces |
SoftBounces |
metric |
Status |
Status |
dimension |
Subject |
Subject |
dimension |
SubscriberKey |
SubscriberKey |
metric |
SurveyDate |
SurveyDate |
dimension |
TotalOrderQuantityOfGiftsAndAssociatedCards |
TotalOrderQuantityOfGiftsAndAssociatedCards |
metric |
TotalOrderQuantityOfPaidCards |
TotalOrderQuantityOfPaidCards |
metric |
TriggeredSendDefinitionObjectID |
TriggeredSendDefinitionObjectID |
dimension |
URL |
URL |
dimension |
URLIDID |
URLIDID |
dimension |
UniqueClicks |
UniqueClicks |
metric |
UniqueOpens |
UniqueOpens |
metric |
Unsubscribes |
Unsubscribes |
metric |
VoucherCodeTypeName |
VoucherCodeTypeName |
dimension |
VoucherComments |
VoucherComments |
dimension |
VoucherReasonName |
VoucherReasonName |
dimension |
account_id |
account_id |
dimension |
assetType.displayName |
assetType.displayName |
dimension |
assetType.id |
assetType.id |
metric |
assetType.name |
assetType.name |
dimension |
category.id |
category.id |
metric |
category.name |
category.name |
dimension |
category.parentId |
category.parentId |
metric |
createdBy.email |
createdBy.email |
dimension |
createdBy.id |
createdBy.id |
metric |
createdBy.name |
createdBy.name |
dimension |
createdBy.userId |
createdBy.userId |
metric |
createdDate |
createdDate |
dimension |
customerKey |
customerKey |
dimension |
data.email.attributes.0.attributeType |
data.email.attributes.0.attributeType |
dimension |
data.email.attributes.0.channel |
data.email.attributes.0.channel |
dimension |
data.email.attributes.0.displayName |
data.email.attributes.0.displayName |
dimension |
data.email.attributes.0.name |
data.email.attributes.0.name |
dimension |
data.email.attributes.0.order |
data.email.attributes.0.order |
metric |
data.email.attributes.0.value |
data.email.attributes.0.value |
dimension |
data.email.legacy.legacyCategoryId |
data.email.legacy.legacyCategoryId |
metric |
data.email.legacy.legacyId |
data.email.legacy.legacyId |
metric |
data.email.legacy.legacyKey |
data.email.legacy.legacyKey |
dimension |
data.email.legacy.legacyType |
data.email.legacy.legacyType |
dimension |
data.email.options.characterEncoding |
data.email.options.characterEncoding |
dimension |
description |
description |
dimension |
enterpriseId |
enterpriseId |
dimension |
first_name |
first_name |
dimension |
id |
id |
dimension |
legacyData.legacyCategoryId |
legacyData.legacyCategoryId |
metric |
legacyData.legacyId |
legacyData.legacyId |
metric |
legacyData.legacyKey |
legacyData.legacyKey |
dimension |
legacyData.legacyType |
legacyData.legacyType |
dimension |
memberId |
memberId |
dimension |
modelVersion |
modelVersion |
metric |
modifiedBy.email |
modifiedBy.email |
dimension |
modifiedBy.id |
modifiedBy.id |
metric |
modifiedBy.name |
modifiedBy.name |
dimension |
modifiedBy.userId |
modifiedBy.userId |
metric |
modifiedDate |
modifiedDate |
dimension |
name |
name |
dimension |
objectID |
objectID |
dimension |
owner.email |
owner.email |
dimension |
owner.id |
owner.id |
metric |
owner.name |
owner.name |
dimension |
owner.userId |
owner.userId |
metric |
status.id |
status.id |
metric |
status.name |
status.name |
dimension |
thumbnail.thumbnailUrl |
thumbnail.thumbnailUrl |
dimension |