(测试版)Marketo Engage字段映射

重要

Marketo Engage源当前处于测试阶段。 其功能和文档可能会发生更改。

下表包含9个Marketo数据集中的字段与其相应的体验数据模型(XDM)字段之间的映射。

活动

源数据集 XDM目标字段 注释
_id _id
personID personID 主标识
eventType eventType
timestamp timestamp
web.webPageDetails._marketo.URL web.webPageDetails._marketo.URL
environment.browserDetails.userAgent environment.browserDetails.userAgent
environment.ipV4 environment.ipV4
search.keywords search.keywords
search.searchEngine search.searchEngine
web.webPageDetails.webPageID web.webPageDetails.webPageID
web.webPageDetails.name web.webPageDetails.name
web.webPageDetails.isPersonalizedURL web.webPageDetails.isPersonalizedURL
web.webPageDetails.queryParameters web.webPageDetails.queryParameters
web.webReferrer.URL web.webReferrer.URL
listOperations.listID listOperations.listID
opportunityEvent.isPrimary opportunityEvent.isPrimary
opportunityEvent.opportunityID opportunityEvent.opportunityID
opportunityEvent.role opportunityEvent.role
leadOperation.newLead.createdDate leadOperation.newLead.createdDate
leadOperation.newLead.formName leadOperation.newLead.formName
leadOperation.newLead.leadSource leadOperation.newLead.leadSource
leadOperation.newLead.listName leadOperation.newLead.listName
leadOperation.newLead.sfdcType leadOperation.newLead.sfdcType
leadOperation.newLead.sourceType leadOperation.newLead.sourceType
leadOperation.convertLead.assignTo leadOperation.convertLead.assignTo
leadOperation.convertLead.convertedStatus leadOperation.convertLead.convertedStatus
leadOperation.convertLead.isSentNotificationEmail leadOperation.convertLead.isSentNotificationEmail
directMarketing.mailingID directMarketing.mailingID
directMarketing.mailingName directMarketing.mailingName
directMarketing.testVariantID directMarketing.testVariantID
directMarketing.emailBouncedCode directMarketing.emailBouncedCode
directMarketing.emailBouncedDetails directMarketing.emailBouncedDetails
directMarketing.email directMarketing.email
device.isMobileDevice device.isMobileDevice
device.model device.model
environment.operatingSystem environment.operatingSystem
directMarketing.linkURL directMarketing.linkURL
web.webInteraction.linkID web.webInteraction.linkID
web.fillOutForm.webFormID web.fillOutForm.webFormID
web.fillOutForm.webFormName web.fillOutForm.webFormName
web.webInteraction.linkURL web.webInteraction.linkURL
leadOperation.changeScore.changeValue leadOperation.changeScore.changeValue
leadOperation.changeScore.newValue leadOperation.changeScore.newValue
leadOperation.changeScore.oldValue leadOperation.changeScore.oldValue
leadOperation.changeScore.priority leadOperation.changeScore.priority
leadOperation.changeScore.reason leadOperation.changeScore.reason
leadOperation.changeScore.relativeScore leadOperation.changeScore.relativeScore
leadOperation.changeScore.relativeUrgency leadOperation.changeScore.relativeUrgency
leadOperation.changeScore.scoreAttributeID leadOperation.changeScore.scoreAttributeID
leadOperation.changeScore.scoreAttributeName leadOperation.changeScore.scoreAttributeName
leadOperation.changeScore.urgency leadOperation.changeScore.urgency
opportunityEvent.dataValueChanges.attributeName opportunityEvent.dataValueChanges.attributeName
opportunityEvent.dataValueChanges.newValue opportunityEvent.dataValueChanges.newValue
opportunityEvent.dataValueChanges.oldValue opportunityEvent.dataValueChanges.oldValue
opportunityEvent.opportunityID opportunityEvent.opportunityID
leadOperation.campaignProgression.campaignID leadOperation.campaignProgression.campaignID
leadOperation.campaignProgression.isAcquiredBy leadOperation.campaignProgression.isAcquiredBy
leadOperation.campaignProgression.isSuccessful leadOperation.campaignProgression.isSuccessful
leadOperation.campaignProgression.newStatusID leadOperation.campaignProgression.newStatusID
leadOperation.campaignProgression.newStatusName leadOperation.campaignProgression.newStatusName
leadOperation.campaignProgression.oldStatusID leadOperation.campaignProgression.oldStatusID
leadOperation.campaignProgression.oldStatusName leadOperation.campaignProgression.oldStatusName
leadOperation.campaignProgression.reason leadOperation.campaignProgression.reason

程序

源数据集 XDM目标字段 注释
id campaignID 主标识
sfdcId extSourceSystemAudit.externalID 次标识
name campaignName
description campaignDescription
type campaignType
status campaignStatus
channel channelName
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
cost actualCost.amount
parentProgramId parentCampaignID
integrationPartner integrationPartnerName
startDate campaignStartDate
endDate campaignEndDate

方案成员资格

源数据集 XDM目标字段 注释
id campaignMemberID 主标识
programId campaignID 关系
leadId personID 关系
acquiredByCampaignID acquiredByCampaignID
reachedSuccess hasReachedSuccess
isExhausted isExhausted
statusName memberStatus
statusReason memberStatusReason
membershipDate membershipDate
nurtureCadence nurtureCadence
trackName nurtureTrackName
webinarUrl webinarConfirmationUrl
registrationCode webinarRegistrationID
reachedSuccessDate reachedSuccessDate
sfdc.crmId extSourceSystemAudit.externalID
sfdc.lastStatus lastStatus
sfdc.hasResponded hasResponded
sfdc.firstRespondedDate firstRespondedDate
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

公司

源数据集 XDM目标字段 注释
id accountID 主标识
mktoCdpExternalId extSourceSystemAudit.externalID 次标识
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
mktoCdpParentOrgId accountParentID

静态列表

源数据集 XDM目标字段 注释
id marketingListID 主标识
name marketingListName
description marketingListDescription
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

静态列表成员关系

源数据集 XDM目标字段 注释
staticListMemberID marketingListMemberID 主标识
staticListID marketingListID 关系
personID personID 关系
createdAt extSourceSystemAudit.createdDate

指定帐户

重要

只有在Marketo的基于帐户的营销(ABM)功能中,才需要命名帐户数据集。 如果您没有使用ABM,则无需为指定帐户设置映射。

源数据集 XDM目标字段 注释
id accountID 主标识
crmGuid extSourceSystemAudit.externalID 次标识
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
parentAccountId accountParentID
sourceType accountSourceType

机会

源数据集 XDM目标字段 注释
id opportunityID 主标识
externalOpportunityId extSourceSystemAudit.externalID 次标识
mktoCdpAccountOrgId accountID 关系
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
mktoCdpSourceCampaignId campaignID 仅当您使用Salesforce集成时,才建议使用。
lastActivityDate lastActivityDate
leadSource leadSource
nextStep nextStep

机会联系角色

源数据集 XDM目标字段 注释
id opportunityPersonID 主标识
mktoCdpSfdcId extSourceSystemAudit.externalID 次标识
mktoCdpOpptyId opportunityID 关系
leadId personID 关系
role personRole
isPrimary isPrimary
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

人员

源数据集 XDM目标字段 注释
id personID 主标识
contactCompany b2b.accountID
marketingSuspended b2b.isMarketingSuspended
marketingSuspendedCause b2b.marketingSuspendedCause
leadScore b2b.personScore
leadSource b2b.personSource
leadStatus b2b.personStatus
personType b2b.personType
leadPartitionId b2b.personGroupID
mktoCdpCnvContactPersonId b2b.convertedContactID
mktoCdpIsConverted b2b.isConverted
mktoCdpConvertedDate b2b.convertedDate
sfdcLeadId extSourceSystemAudit.externalID 次标识
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
title extendedWorkDetails.jobTitle
fax faxPhone.number
mobilePhone mobilePhone.number
firstName person.name.firstName
lastName person.name.lastName
middleName person.name.middleName
salutation person.name.courtesyTitle
dateOfBirth person.birthDate
city workAddress.city
country workAddress.country
postalCode workAddress.postalCode
state workAddress.state
address workAddress.street1
phone workPhone.number
company organizations
leadScore personComponents.personScore
leadSource personComponents.personSource
leadStatus personComponents.personStatus
personType personComponents.personType
leadPartitionId personComponents.personGroupID
mktoCdpCnvContactPersonId personComponents.sourceConvertedContactID
contactCompany personComponents.sourceAccountID
sfdcContactId personComponents.sourceExternalID 仅当您使用Salesforce集成时,才建议使用。
id personComponents.sourcePersonID
email personComponents.workEmail.address
email workEmail.address
to_object('ECID',arrays_to_objects('id',explode(ecids))) identityMap
注意

to_object('ECID',arrays_to_objects('id',explode(ecids)))源字段是一个计算字段,必须使用Platform UI中的Add calculated field选项添加该字段。 有关更多信息,请参阅有关添加计算字段的教程。

后续步骤

通过阅读本文档,您深入了解了Marketo数据集与其相应XDM字段之间的映射关系。 请参阅有关创建 Marketo 源连接🔗以完成Marketo数据流的教程。

在此页面上