文档Experience Platform源连接器指南

Marketo Engage字段映射 marketo-engage-field-mappings

最近更新： 2026年10月16日

创建对象：

  • 开发人员

使用下表查看每个Marketo Engage数据集中的字段如何映射到其相应的体验数据模型(XDM)字段。

TIP
除Activities之外的所有Marketo数据集都支持isDeleted。 您的现有数据流自动包含isDeleted，但它们只摄取标记以添加新数据。 要将标记应用于历史数据，请停止现有数据流并使用新映射重新创建它们。 如果您删除isDeleted，则无法再使用此功能。 在自动填充isDeleted映射后将其保留。

活动 activities

Marketo源支持其他标准活动。 若要使用标准活动，请使用架构自动生成实用程序更新您的架构。 如果您在不更新架构的情况下创建新的activities数据流，则映射模板会失败，因为新的目标字段不在架构中。 如果选择不更新架构，您仍然可以创建新数据流并消除任何错误。 但是，Experience Platform不会摄取任何新的或更新后的字段。

有关XDM类及其字段组的详细信息，请阅读XDM ExperienceEvent类概述。

NOTE
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)源字段是计算字段。 在Experience Platform UI中使用​ 添加计算字段 ​选项添加它。 阅读有关添加计算字段的教程以了解更多信息。
Marketo源字段
活动类型标识
Source数据集
XDM目标字段
注释
_id
_id
_id
"Marketo"
personKey.sourceType
"${MUNCHKIN_ID}"
personKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
leadId
personID
personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo")
personKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
activityTypeId
eventType
eventType
  • 如果activityTypeId 为1、2、3、9、10或11，→标记productedBy 作为self。
  • 如果activityTypeId 为6、7、8、12、21、22、24、25、27、32、34、35、36、46、101、104、110、113、114或115，→标记产生者 作为系统。
  • 对于所有其他值，→标记productedBy 作为self。
producedBy
producedBy
activityDate
timestamp
timestamp
attributes.Webpage URL
web.webPageDetails.URL
web.webPageDetails.URL
attributes.User Agent
environment.browserDetails.userAgent
environment.browserDetails.userAgent
attributes.Client IP Address
environment.ipV4
environment.ipV4
attributes.Search Query
search.keywords
search.keywords
attributes.Search Engine
search.searchEngine
search.searchEngine
primaryAttributeValue when activityTypeId = 1
1
web.webPageDetails.webPageID
web.webPageDetails.webPageID
primaryAttributeValue when activityTypeId = 1
1
web.webPageDetails.name
web.webPageDetails.name
attributes.Personalized URL
1
web.webPageDetails.isPersonalizedURL
web.webPageDetails.isPersonalizedURL
attributes.Query Parameters
1
web.webPageDetails.queryParameters
web.webPageDetails.queryParameters
attributes.Referrer URL
web.webReferrer.URL
web.webReferrer.URL
primaryAttributeValueId when activityTypeId in (24, 25)
24, 25
iif(${listOperations\.listID} != null && ${listOperations\.listID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", ${listOperations\.listID}, "sourceKey", concat(${listOperations\.listID},"@${MUNCHKIN_ID}.Marketo")), null)
listOperations.listKey
attributes.Is Primary
34,35,36
opportunityEvent.isPrimary
opportunityEvent.isPrimary
在(34， 35， 36)中activityTypeId时为primaryAttributeValueId
34, 35, 36
iif(${opportunityEvent\.opportunityID} != null && ${opportunityEvent\.opportunityID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${opportunityEvent\.opportunityID}, "sourceKey", concat(${opportunityEvent\.opportunityID},"@${MUNCHKIN_ID}.Marketo")), null)
opportunityEvent.opportunityKey
attributes.Role
34, 35, 36
opportunityEvent.role
opportunityEvent.role
attributes.Created Date
leadOperation.newLead.createdDate
leadOperation.newLead.createdDate
attributes.Form Name
leadOperation.newLead.formName
leadOperation.newLead.formName
attributes.Lead Source
leadOperation.newLead.leadSource
leadOperation.newLead.leadSource
attributes.List Name
leadOperation.newLead.listName
leadOperation.newLead.listName
attributes.SFDC Type
leadOperation.newLead.sfdcType
leadOperation.newLead.sfdcType
attributes.Source Type
leadOperation.newLead.sourceType
leadOperation.newLead.sourceType
activityTypeId = 21时的primaryAttributeValue
21
leadOperation.convertLead.assignTo
leadOperation.convertLead.assignTo
attributes.Converted Status
21
leadOperation.convertLead.convertedStatus
leadOperation.convertLead.convertedStatus
attributes.Send Notification Email
21
leadOperation.convertLead.isSentNotificationEmail
leadOperation.convertLead.isSentNotificationEmail
在(7， 8， 9， 10， 11， 27)中的activityTypeId时primaryAttributeValueId
7, 8, 9, 10, 11, 27
iif(${directMarketing\\.mailingID} != null && ${directMarketing\\.mailingID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${directMarketing\\.mailingID}, \"sourceKey\", concat(${directMarketing\\.mailingID},\"@${MUNCHKIN_ID}.Marketo\")), null)
directMarketing.mailingKey
在(7， 8， 9， 10， 11， 27)中的activityTypeId时primaryAttributeValueId
7, 8, 9, 10, 11, 27
directMarketing.mailingName
directMarketing.mailingName
directMarketing.testVariantName
directMarketing.testVariantName
attributes.Test Variant
directMarketing.testVariantID
directMarketing.testVariantID

attributes.Subcategory

  • activityTypeId = 8

    • 1099 →消息被阻止
    • Source上阻止了1003 →垃圾邮件
    • 邮件已阻止1004 →垃圾邮件
    • 2003 →电子邮件地址无效
    • 2001 →电子邮件地址错误
    • →未知的退回原因

  • activityTypeId = 27

    • 3999 →消息未被接受
    • 3001 →邮箱已满
    • 3004 →发生超时
    • 4003 → DNS故障
    • 4002 →消息太大
    • 4006 →策略违规
    • 4999 →瞬时故障
    • 收到9999 →错误响应
    • →软退回的未知原因
8, 27
directMarketing.emailBouncedCode
directMarketing.emailBouncedCode
attributes.Details
directMarketing.emailBouncedDetails
directMarketing.emailBouncedDetails
attributes.Email
directMarketing.email
directMarketing.email
attributes.Is Mobile Device
device.isMobileDevice
device.isMobileDevice
attributes.device
device.model
device.model
attributes.Platform
environment.operatingSystem
environment.operatingSystem
attributes.Link
directMarketing.linkURL
directMarketing.linkURL
activityTypeId = 3个其他属性时的primaryAttributeValueId。链接Id
3
iif(${web\\.webInteraction\\.linkID} != null && ${web\\.webInteraction\\.linkID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.webInteraction\\.linkID}, \"sourceKey\", concat(${web\\.webInteraction\\.linkID},\"@${MUNCHKIN_ID}.Marketo\")), null)
web.webInteraction.webInteractionKey
当activityTypeId = 2 else属性时，为primaryAttributeValueId。Web窗体ID
2
iif(${web\\.fillOutForm\\.webFormID} != null && ${web\\.fillOutForm\\.webFormID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.fillOutForm\\.webFormID}, \"sourceKey\", concat(${web\\.fillOutForm\\.webFormID},\"@${MUNCHKIN_ID}.Marketo\")), null)
web.fillOutForm.webFormKey
activityTypeId = 2 else null时的primaryAttributeValueId
2
web.fillOutForm.webFormName
web.fillOutForm.webFormName
activityTypeId = 3 else attributes.Link时的primaryAttributeValueId
3
web.webInteraction.linkURL
web.webInteraction.linkURL
attributes.Change Value
22
leadOperation.changeScore.changeValue
leadOperation.changeScore.changeValue
attributes.New Value
22
leadOperation.changeScore.newValue
leadOperation.changeScore.newValue
attributes.Old Value
22
leadOperation.changeScore.oldValue
leadOperation.changeScore.oldValue
attributes.Priority
22
leadOperation.changeScore.priority
leadOperation.changeScore.priority
attributes.Reason
22
leadOperation.changeScore.reason
leadOperation.changeScore.reason
attributes.Relative Score
22
leadOperation.changeScore.relativeScore
leadOperation.changeScore.relativeScore
attributes.Relative Urgency
22
leadOperation.changeScore.relativeUrgency
leadOperation.changeScore.relativeUrgency
activityTypeId = 22时的primaryAttributeValueId
22
iif(${leadOperation\.changeScore\.scoreAttributeID} != null && ${leadOperation\.changeScore\.scoreAttributeID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeScore\.scoreAttributeID}, "sourceKey", concat(${leadOperation\.changeScore\.scoreAttributeID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeScore.scoreAttributeKey
activityTypeId = 22时的primaryAttributeValueId
22
leadOperation.changeScore.scoreAttributeName
leadOperation.changeScore.scoreAttributeName
attributes.Urgency
22
leadOperation.changeScore.urgency
leadOperation.changeScore.urgency
attributes.Data Value Changes
json_to_object(${opportunityEvent\.dataValueChanges})
opportunityEvent.dataValueChanges
activityTypeId = 104时的primaryAttributeValueId
104
iif(${leadOperation\.campaignProgression\.campaignID} != null && ${leadOperation\.campaignProgression\.campaignID} != "" , to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", ${leadOperation\.campaignProgression\.campaignID}, "sourceKey", concat(${leadOperation\.campaignProgression\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.campaignProgression.campaignKey
attributes.Acquired By
104
leadOperation.campaignProgression.isAcquiredBy
leadOperation.campaignProgression.isAcquiredBy
attributes.Success
104
leadOperation.campaignProgression.isSuccessful
leadOperation.campaignProgression.isSuccessful
attributes.New Status ID
104
leadOperation.campaignProgression.newStatusID
leadOperation.campaignProgression.newStatusID
attributes.New Status
104
leadOperation.campaignProgression.newStatusName
leadOperation.campaignProgression.newStatusName
attributes.Old Status ID
104
leadOperation.campaignProgression.oldStatusID
leadOperation.campaignProgression.oldStatusID
attributes.Old Status
104
leadOperation.campaignProgression.oldStatusName
leadOperation.campaignProgression.oldStatusName
attributes.Reason
104
leadOperation.campaignProgression.reason
leadOperation.campaignProgression.reason
attributes.Date
46
leadOperation.interestingMoment.date
leadOperation.interestingMoment.date
attributes.Description
46
leadOperation.interestingMoment.description
leadOperation.interestingMoment.description
attributes.Source
46
leadOperation.interestingMoment.source
leadOperation.interestingMoment.source
activityTypeId = 46时的primaryAttributeValue
46
leadOperation.interestingMoment.type
leadOperation.interestingMoment.type
activityTypeId = 110时的primaryAttributeValueId
110
iif(${leadOperation\\.callWebhook\\.webhookID} != null && ${leadOperation\\.callWebhook\\.webhookID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.callWebhook\\.webhookID}, \"sourceKey\", concat(${leadOperation\\.callWebhook\\.webhookID},\"@${MUNCHKIN_ID}.Marketo\")), null)
leadOperation.callWebhook.webhookKey
activityTypeId = 110时的primaryAttributeValueId
110
leadOperation.callWebhook.webhookName
leadOperation.callWebhook.webhookName
attributes.Error Type
110
leadOperation.callWebhook.responseCode
leadOperation.callWebhook.responseCode
activityTypeId = 115时的primaryAttributeValueId
115
iif(${leadOperation\\.changeCampaignCadence\\.campaignID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignID},\"@${MUNCHKIN_ID}.Marketo\")), null)
leadOperation.changeCampaignCadence.campaignKey
attributes.New Nurture Cadence
115
leadOperation.changeCampaignCadence.newCadence
leadOperation.changeCampaignCadence.newCadence
attributes.Previous Nurture Cadence
115
leadOperation.changeCampaignCadence.previousCadence
leadOperation.changeCampaignCadence.previousCadence
activityTypeId = 114时的primaryAttributeValueId
113
iif(${leadOperation\.addToCampaign\.campaignID} != null && ${leadOperation\.addToCampaign\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.campaignID}, "sourceKey", concat(${leadOperation\.addToCampaign\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.addToCampaign.campaignKey
attributes.Track ID
113
iif(${leadOperation\.addToCampaign\.streamID} != null && ${leadOperation\.addToCampaign\.streamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.streamID}, "sourceKey", concat(${leadOperation\.addToCampaign\.streamID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.addToCampaign.streamKey
attributes.Stream Name
113
leadOperation.addToCampaign.streamName
leadOperation.addToCampaign.streamName
activityTypeId = 115时的primaryAttributeValueId
115
iif(${leadOperation\.changeCampaignStream\.campaignID} != null && ${leadOperation\.changeCampaignStream\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.campaignID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeCampaignStream.campaignKey
attributes.New Track ID
115
iif(${leadOperation\.changeCampaignStream\.newStreamID} != null && ${leadOperation\.changeCampaignStream\.newStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.newStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.newStreamID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeCampaignStream.newStreamKey
attributes.New Track Name
115
leadOperation.changeCampaignStream.newStreamName
leadOperation.changeCampaignStream.newStreamName
attributes.Previous Track ID
115
iif(${leadOperation\.changeCampaignStream\.previousStreamID} != null && ${leadOperation\.changeCampaignStream\.previousStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.previousStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.previousStreamID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeCampaignStream.previousStreamKey
attributes.Previous Stream Name
115
leadOperation.changeCampaignStream.previousStreamName
leadOperation.changeCampaignStream.previousStreamName
activityTypeId = 101时的primaryAttributeValueId
101
iif(${leadOperation\.changeRevenueStage\.modelID} != null && ${leadOperation\.changeRevenueStage\.modelID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeRevenueStage\.modelID}, "sourceKey", concat(${leadOperation\.changeRevenueStage\.modelID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeRevenueStage.modelKey
activityTypeId = 101时的primaryAttributeValueId
101
leadOperation.changeRevenueStage.modelName
leadOperation.changeRevenueStage.modelName
attributes.New Stage ID
101
iif(${leadOperation\.changeRevenueStage\.newStageID} != null && ${leadOperation\.changeRevenueStage\.newStageID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeRevenueStage\.newStageID}, "sourceKey", concat(${leadOperation\.changeRevenueStage\.newStageID},"@${MUNCHKIN_ID}.Marketo")), null)
leadOperation.changeRevenueStage.newStageKey
attributes.New Stage
101
leadOperation.changeRevenueStage.newStageName
leadOperation.changeRevenueStage.newStageName
attributes.Old Stage ID
101
iif(${leadOperation\\.changeRevenueStage\\.previousStageID} != null && ${leadOperation\\.changeRevenueStage\\.previousStageID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${leadOperation\\.changeRevenueStage\\.previousStageID}, \"sourceKey\", concat(${leadOperation\\.changeRevenueStage\\.previousStageID},\"@${MUNCHKIN_ID}.Marketo\")), null)
leadOperation.changeRevenueStage.previousStageKey
attributes.Old Stage
101
leadOperation.changeRevenueStage.previousStageName
leadOperation.changeRevenueStage.previousStageName
attributes.Reason
101
leadOperation.changeRevenueStage.reason
leadOperation.changeRevenueStage.reason
activityTypeId = 32时的attributes.Merge IDs
32
json_to_object(${leadOperation\.mergeLeads\.mergeIDs})
leadOperation.mergeLeads.sourceKeys
attributes.Master Updated
32
leadOperation.mergeLeads.targetUpdated
leadOperation.mergeLeads.targetUpdated
attributes.Merged in Sales
32
leadOperation.mergeLeads.mergedInCRM
leadOperation.mergeLeads.mergedInCRM
attributes.Merge Source
32
leadOperation.mergeLeads.mergeSource
leadOperation.mergeLeads.mergeSource
activityTypeId = 6时的primaryAttributeValueId
6
iif(${directMarketing\.emailSent\.mailingID} != null && ${directMarketing\.emailSent\.mailingID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${directMarketing\.emailSent\.mailingID}, "sourceKey", concat(${directMarketing\.emailSent\.mailingID},"@${MUNCHKIN_ID}.Marketo")), null)
directMarketing.emailSent.mailingKey
activityTypeId = 6时的primaryAttributeValueId
6
directMarketing.emailSent.mailingName
directMarketing.emailSent.mailingName
attributes.Test Variant
6
directMarketing.emailSent.testVariantID
directMarketing.emailSent.testVariantID
注释 — 从辅助资产值派生
directMarketing.emailSent.testVariantName
directMarketing.emailSent.testVariantName
attributes.Campaign Run ID
6
directMarketing.emailSent.automationRunID
directMarketing.emailSent.automationRunID
directMarketing.automationRunID
directMarketing.automationRunID

项目 programs

有关XDM类的详细信息，请阅读XDM商业营销活动概述。 有关XDM字段组的详细信息，请阅读商业营销活动详细信息架构字段组指南。

NOTE
对于自定义标记类型，请在架构中创建新字段组。 然后，添加需要将源字段映射到目标XDM字段的字段名称。
Source数据集
XDM目标字段
注释
"${MUNCHKIN_ID}"
campaignKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
"Marketo"
campaignKey.sourceType
channel
channelName
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
cost
actualCost.amount
createdAt
extSourceSystemAudit.createdDate
description
campaignDescription
endDate
campaignEndDate
id
campaignKey.sourceID
iif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)
parentCampaignKey
iif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
integrationPartner
integrationPartnerName
marketoIsDeleted
isDeleted
name
campaignName
startDate
campaignStartDate
status
campaignStatus
type
campaignType
updatedAt
extSourceSystemAudit.lastUpdatedDate
webinarHistorySyncDate
webinarHistorySyncDate
webinarHistorySyncStatus
webinarHistorySyncStatus
webinarSessionDescription
webinarSessionDescription
webinarSessionName
webinarSessionName

计划成员资格 program-memberships

有关XDM类的详细信息，请阅读XDM商业营销活动成员概述。 有关XDM字段组的详细信息，请阅读XDM商业营销活动成员详细信息架构字段组指南。

Source数据集
XDM目标字段
注释
"Marketo"
campaignMemberKey.sourceType
"${MUNCHKIN_ID}"
campaignMemberKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
id
campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignMemberKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
关系
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
关系
iif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)
acquiredByCampaignKey
reachedSuccess
hasReachedSuccess
isExhausted
isExhausted
statusName
memberStatus
statusReason
memberStatusReason
membershipDate
membershipDate
nurtureCadence
nurtureCadence
trackName
nurtureTrackName
webinarUrl
webinarConfirmationUrl
registrationCode
webinarRegistrationID
reachedSuccessDate
reachedSuccessDate
iif(sfdc.crmId != null && sfdc.crmId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdc.crmId, "sourceKey", concat(sfdc.crmId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
sfdc.lastStatus
lastStatus
sfdc.hasResponded
hasResponded
sfdc.firstRespondedDate
firstRespondedDate
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted

公司 companies

有关XDM类的详细信息，请阅读XDM业务帐户概述。

IMPORTANT
accountKey.sourceKey的默认映射会将.mkto_org后缀附加到每个帐户ID。 此格式与Marketo Measure目标不兼容，后者不支持.mkto_org后缀。 如果您计划将此数据导出到Marketo Measure，请先从所有帐户密钥字段中删除.mkto_org后缀，然后再摄取数据。 有关要更新的字段列表，请阅读Marketo Measure帐户密钥格式要求。
Source数据集
XDM目标字段
注释
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
concat(id, ".mkto_org")
accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
  • iif(mktoCdpExternalId != null && mktoCdpExternalId != “”， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”， “sourceID”， mktoCdpExternalId， “sourceKey”， concat(mktoCdpExternalId，“@${CRM_ORG_ID}.${CRM_TYPE}”))，空)
  • iif(msftCdpExternalId != null && msftCdpExternalId != “”， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”， “sourceID”， msftCdpExternalId， “sourceKey”， concat(msftCdpExternalId，“@${CRM_ORG_ID}.${CRM_TYPE}”))，空)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
billingCity
accountBillingAddress.city
billingCountry
accountBillingAddress.country
billingPostalCode
accountBillingAddress.postalCode
billingState
accountBillingAddress.state
billingStreet
accountBillingAddress.street1
annualRevenue
accountOrganization.annualRevenue.amount
sicCode
accountOrganization.SICCode
industry
accountOrganization.industry
numberOfEmployees
accountOrganization.numberOfEmployees
website
accountOrganization.website
mainPhone
accountPhone.number
company
accountName
companyNotes
accountDescription
site
accountSite
iif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
accountParentKey
marketoIsDeleted
isDeleted

静态列表 static-lists

有关XDM类的详细信息，请阅读XDM商业营销列表概述。

Source数据集
XDM目标字段
注释
"Marketo"
marketingListKey.sourceType
"${MUNCHKIN_ID}"
marketingListKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
id
marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
marketingListKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
name
marketingListName
description
marketingListDescription
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted

静态列表成员资格 static-list-memberships

有关XDM类的详细信息，请阅读XDM商业营销列表成员概述。

Source数据集
XDM目标字段
注释
"Marketo"
marketingListMemberKey.sourceType
"${MUNCHKIN_ID}"
marketingListMemberKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
staticListMemberID
marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")
marketingListMemberKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)
marketingListKey
关系
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
关系
createdAt
extSourceSystemAudit.createdDate
marketoIsDeleted
isDeleted

指定帐户 named-accounts

有关XDM类的详细信息，请阅读XDM业务帐户概述。

IMPORTANT
如果您使用基于Marketo帐户的营销(ABM)功能，则只需要指定的帐户数据集。 如果不使用ABM，则不需要为指定帐户设置映射。
Source数据集
XDM目标字段
注释
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
concat(id, ".mkto_acct")
accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
iif(crmGuid != null && crmGuid != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", crmGuid, "sourceKey", concat(crmGuid,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
city
accountBillingAddress.city
country
accountBillingAddress.country
state
accountBillingAddress.state
annualRevenue
accountOrganization.annualRevenue.amount
sicCode
accountOrganization.SICCode
industry
accountOrganization.industry
logoUrl
accountOrganization.logoUrl
numberOfEmployees
accountOrganization.numberOfEmployees
name
accountName
iif(parentAccountId != null && parentAccountId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(parentAccountId, ".mkto_acct"), "sourceKey", concat(parentAccountId, ".mkto_acct@${MUNCHKIN_ID}.Marketo")), null)
accountParentKey
sourceType
accountSourceType
marketoIsDeleted
isDeleted

机会 opportunities

有关XDM类的详细信息，请阅读XDM业务机会概述。

Source数据集
XDM目标字段
注释
"Marketo"
opportunityKey.sourceType
"${MUNCHKIN_ID}"
opportunityKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
id
opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
iif(externalOpportunityId != null && externalOpportunityId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", externalOpportunityId, "sourceKey", concat(externalOpportunityId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
iif(mktoCdpAccountOrgId != null && mktoCdpAccountOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpAccountOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpAccountOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
accountKey
关系
description
opportunityDescription
name
opportunityName
stage
opportunityStage
type
opportunityType
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
expectedRevenue
expectedRevenue.amount
amount
opportunityAmount.amount
closeDate
expectedCloseDate
fiscalQuarter
fiscalQuarter
fiscalYear
fiscalYear
forecastCategory
forecastCategory
forecastCategoryName
forecastCategoryName
isClosed
isClosed
isWon
isWon
quantity
opportunityQuantity
probability
probabilityPercentage
iif(mktoCdpSourceCampaignId != null && mktoCdpSourceCampaignId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpSourceCampaignId, "sourceKey", concat(mktoCdpSourceCampaignId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
仅适用于使用Salesforce集成的情况。
lastActivityDate
lastActivityDate
leadSource
leadSource
nextStep
nextStep
marketoIsDeleted
isDeleted

机会联系人角色 opportunity-contact-roles

有关XDM类的详细信息，请阅读XDM业务机会人员关系概述。

Source数据集
XDM目标字段
注释
"${MUNCHKIN_ID}"
opportunityPersonKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
"Marketo"
opportunityPersonKey.sourceType
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityPersonKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
createdAt
extSourceSystemAudit.createdDate
id
opportunityPersonKey.sourceID
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
关系
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)
opportunityKey
关系
iif(mktoCdpSfdcId != null && mktoCdpSfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", mktoCdpSfdcId, "sourceKey", concat(mktoCdpSfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。 浏览API将CRM_TYPE和CRM_ORG_ID替换为您的CRM类型和CRM组织ID。
isPrimary
isPrimary
marketoIsDeleted
isDeleted
role
personRole
updatedAt
extSourceSystemAudit.lastUpdatedDate

人员 persons

有关XDM类的更多信息，请阅读XDM个人配置文件概述。 有关XDM字段组的详细信息，请阅读XDM业务人员详细信息架构字段组指南和XDM业务人员组件架构字段组指南。

源字段
目标XDM字段
注释
"${MUNCHKIN_ID}"
b2b.personKey.sourceInstanceID
浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
"Marketo"
b2b.personKey.sourceType
address
workAddress.street1
city
workAddress.city
company
organizations
concat(id,"@${MUNCHKIN_ID}.Marketo")
b2b.personKey.sourceKey
主要身份。 浏览API将MUNCHKIN_ID替换为您的Marketo Munchkin ID。
country
workAddress.country
createdAt
extSourceSystemAudit.createdDate
dateOfBirth
person.birthDate
email
personComponents.workEmail.address
email
workEmail.address
fax
faxPhone.number
firstName
person.name.firstName
id
b2b.personKey.sourceID
iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
b2b.accountKey
iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourceAccountKey
  • iif(decode(sfdcType， “Contact”， sfdcContactId， “Lead”， sfdcLeadId， null) != null， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”，“sourceID”， decode(sfdcType， “Contact”， sfdcContactId， “Lead”， sfdcLeadId， null)， “sourceKey”， concat(decode(sfdcType(sfigureType， sfdcContactId， “Lead”， sfdcLeadId ， null)，“@${CRM_ORG_ID}.${CRM_TYPE}”))， null)
  • iif(decode(msftType， “Contact”， msftContactId， “Lead”， msftLeadId， null) != null， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”，“sourceID”， decode(msftType， “Contact”， msftContactId， “LeadId， null)， “sourceKey”， concat(decode(decode(msftType， “Contact”， msftContactId， “Lead”， msftLeadId ， null)，”@${CRM_ORG_ID}.${CRM_TYPE}")， null)
personComponents.sourceExternalKey
  • iif(decode(sfdcType， “Contact”， sfdcContactId， “Lead”， sfdcLeadId， null) != null， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”，“sourceID”， decode(sfdcType， “Contact”， sfdcContactId， “Lead”， sfdcLeadId， null)， “sourceKey”， concat(decode(sfdcType(sfigureType， sfdcContactId， “Lead”， sfdcLeadId ， null)，“@${CRM_ORG_ID}.${CRM_TYPE}”))， null)
  • iif(decode(msftType， “Contact”， msftContactId， “Lead”， msftLeadId， null) != null， to_object(“sourceType”， “${CRM_TYPE}”， “sourceInstanceID”， “${CRM_ORG_ID}”，“sourceID”， decode(msftType， “Contact”， msftContactId， “LeadId， null)， “sourceKey”， concat(decode(decode(msftType， “Contact”， msftContactId， “Lead”， msftLeadId ， null)，”@${CRM_ORG_ID}.${CRM_TYPE}")， null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey是辅助标识。
iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)
identityMap
计算字段。
iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourcePersonKey
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)
b2b.convertedContactKey
计算字段。
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourceConvertedContactKey
计算字段。
iif(unsubscribed == 'true', 'n', 'y' )
consents.marketing.email.val
如果unsubscribed为true （值1），则consents.marketing.email.val设置为n。 如果unsubscribed为false（值0），则consents.marketing.email.val设置为null。
iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)
consents.marketing.email.reason
lastName
person.name.lastName
leadPartitionId
b2b.personGroupID
leadPartitionId
personComponents.personGroupID
leadScore
b2b.personScore
leadScore
personComponents.personScore
leadSource
b2b.personSource
leadSource
personComponents.personSource
leadStatus
b2b.personStatus
leadStatus
personComponents.personStatus
marketingSuspended
b2b.isMarketingSuspended
marketingSuspendedCause
b2b.marketingSuspendedCause
marketoIsDeleted
isDeleted
middleName
person.name.middleName
mktoCdpConvertedDate
b2b.convertedDate
mktoCdpIsConverted
b2b.isConverted
mobilePhone
mobilePhone.number
personType
b2b.personType
personType
personComponents.personType
phone
workPhone.number
postalCode
workAddress.postalCode
salutation
person.name.courtesyTitle
state
workAddress.state
title
extendedWorkDetails.jobTitle
updatedAt
extSourceSystemAudit.lastUpdatedDate

后续步骤 next-steps

您现在知道Marketo数据集中的字段如何映射到其对应的XDM字段。 要完成Marketo数据流，请阅读有关创建Marketo源连接的教程。

recommendation-more-help
experience-platform-help-sources