Marketo Engage 欄位對應

上次更新: 2023-11-14
  • 主題:
  • Sources
    檢視有關此主題的更多資訊
  • 建立對象:
  • Developer
    User
    Admin
    Leader

下表包含九個欄位之間的對應 Marketo 資料集與其對應的體驗資料模型(XDM)欄位。

秘訣

全部 Marketo 資料集除外 Activities 現在支援 isDeleted. 您現有的資料流會自動包含 isDeleted,但僅會擷取新擷取資料的標幟。 如果您想要將標幟套用至所有歷史資料,則必須停止現有資料流並使用新對應重新建立資料流。 請注意,如果您移除了 isDeleted,則您將無法再存取該功能。 自動填入對應後,請務必保留對應。

活動

此 Marketo 來源現在支援其他標準活動。 若要使用標準活動,您必須使用 架構自動產生公用程式 因為如果您建立 activities 資料流若未更新您的結構描述,對應範本將失敗,因為新的目標欄位將不會出現在您的結構描述中。 如果您選擇不更新您的結構描述,您仍然可以建立新的資料流並解除任何錯誤。 不過,任何新欄位或更新後的欄位都不會內嵌到Platform中。

請參閱以下檔案: XDM體驗事件類別 以取得有關XDM類別和XDM欄位群組的詳細資訊。

來源資料集 xdm目標欄位 附註
_id _id
"Marketo" personKey.sourceType
"${MUNCHKIN_ID}" personKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
personID personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo") personKey.sourceKey 主要身分識別. 的值 "${MUNCHKIN_ID}" 將會自動取代。
eventType eventType
producedBy producedBy
timestamp timestamp
web.webPageDetails.URL web.webPageDetails.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
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
opportunityEvent.isPrimary opportunityEvent.isPrimary
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
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.testVariantName directMarketing.testVariantName
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
json_to_object(${opportunityEvent\.dataValueChanges}) opportunityEvent.dataValueChanges
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
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
leadOperation.interestingMoment.date leadOperation.interestingMoment.date
leadOperation.interestingMoment.description leadOperation.interestingMoment.description
leadOperation.interestingMoment.source leadOperation.interestingMoment.source
leadOperation.interestingMoment.type leadOperation.interestingMoment.type
iif(${leadOperation\\.callWebhook\\.webhookKey\\.sourceID} != null && ${leadOperation\\.callWebhook\\.webhookKey\\.sourceID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.callWebhook\\.webhookKey\\.sourceID}, \"sourceKey\", concat(${leadOperation\\.callWebhook\\.webhookKey\\.sourceInstanceID},\"@${MUNCHKIN_ID}.Marketo\")), null)" leadOperation.callWebhook.webhookKey
leadOperation.callWebhook.webhookName leadOperation.callWebhook.webhookName
leadOperation.callWebhook.responseCode leadOperation.callWebhook.responseCode
iif(${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceInstanceID},\"@${MUNCHKIN_ID}.Marketo\")), null)" leadOperation.changeCampaignCadence.campaignKey
leadOperation.changeCampaignCadence.newCadence leadOperation.changeCampaignCadence.newCadence
leadOperation.changeCampaignCadence.previousCadence leadOperation.changeCampaignCadence.previousCadence
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
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
leadOperation.addToCampaign.streamName leadOperation.addToCampaign.streamName
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
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
leadOperation.changeCampaignStream.newStreamName leadOperation.changeCampaignStream.newStreamName
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
leadOperation.changeCampaignStream.previousStreamName leadOperation.changeCampaignStream.previousStreamName
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
leadOperation.changeRevenueStage.modelName leadOperation.changeRevenueStage.modelName
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
leadOperation.changeRevenueStage.newStageName leadOperation.changeRevenueStage.newStageName
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
leadOperation.changeRevenueStage.previousStageName leadOperation.changeRevenueStage.previousStageName
leadOperation.changeRevenueStage.reason leadOperation.changeRevenueStage.reason
iif(${leadOperation\.mergeLeads\.sourceIDs} != null && ${leadOperation\.mergeLeads\.sourceIDs} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.mergeLeads\.sourceIDs}, "sourceKey", concat(${leadOperation\.mergeLeads\.sourceIDs},"@${MUNCHKIN_ID}.Marketo")), null) leadOperation.mergeLeads.sourceKeys
leadOperation.mergeLeads.targetUpdated leadOperation.mergeLeads.targetUpdated
leadOperation.mergeLeads.mergedInCRM leadOperation.mergeLeads.mergedInCRM
leadOperation.mergeLeads.mergeSource leadOperation.mergeLeads.mergeSource
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
directMarketing.emailSent.mailingName directMarketing.emailSent.mailingName
directMarketing.emailSent.testVariantID directMarketing.emailSent.testVariantID
directMarketing.emailSent.testVariantName directMarketing.emailSent.testVariantName
directMarketing.emailSent.automationRunID directMarketing.emailSent.automationRunID

計畫

閱讀 XDM商業活動概覽 以取得有關XDM類別的詳細資訊。 如需XDM欄位群組的詳細資訊,請閱讀 「商業促銷活動詳細資料」結構欄位群組 指南。

來源資料集 xdm目標欄位 附註
"Marketo" campaignKey.sourceType
"${MUNCHKIN_ID}" campaignKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
id campaignKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") campaignKey.sourceKey 主要身分識別. 的值 "${MUNCHKIN_ID}" 將會自動取代。
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 是次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
name campaignName
description campaignDescription
type campaignType
status campaignStatus
channel channelName
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
cost actualCost.amount
iif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null) parentCampaignKey
integrationPartner integrationPartnerName
webinarSessionName webinarSessionName
webinarSessionDescription webinarSessionDescription
webinarHistorySyncStatus webinarHistorySyncStatus
webinarHistorySyncDate webinarHistorySyncDate
startDate campaignStartDate
endDate campaignEndDate
marketoIsDeleted isDeleted

計畫成員資格

閱讀 XDM商業活動會員總覽 以取得有關XDM類別的詳細資訊。 如需XDM欄位群組的詳細資訊,請閱讀 XDM商業活動會員詳細資料結構描述欄位群組 指南。

來源資料集 xdm目標欄位 附註
"Marketo" campaignMemberKey.sourceType
"${MUNCHKIN_ID}" campaignMemberKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
id campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") campaignMemberKey.sourceKey 主要身分識別. 的值 "${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 是次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
sfdc.lastStatus lastStatus
sfdc.hasResponded hasResponded
sfdc.firstRespondedDate firstRespondedDate
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

公司

閱讀 XDM商業帳戶總覽 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" accountKey.sourceType
"${MUNCHKIN_ID}" accountKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
concat(id, ".mkto_org") accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo") accountKey.sourceKey 主要身分識別. 的值 "${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}")), null)
  • iif(msftCdpExternalId != null && msftCdpExternalId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", msftCdpExternalId, "sourceKey", concat(msftCdpExternalId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey extSourceSystemAudit.externalKey 是次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
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

靜態清單

閱讀 XDM業務行銷清單總覽 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" marketingListKey.sourceType
"${MUNCHKIN_ID}" marketingListKey.sourceInstanceID "${MUNCHKIN_ID}" 將取代為Explore API的一部分。
id marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") marketingListKey.sourceKey 主要身分識別. 的值 "${MUNCHKIN_ID}" 將會自動取代。
name marketingListName
description marketingListDescription
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

靜態清單成員資格

閱讀 XDM業務行銷清單成員總覽 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" marketingListMemberKey.sourceType
"${MUNCHKIN_ID}" marketingListMemberKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
staticListMemberID marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo") marketingListMemberKey.sourceKey 主要身分識別. 的值 "${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

具名帳戶

重要

具名帳戶資料集僅適用於Marketo的帳戶型行銷(ABM)功能。 如果您未使用ABM,則不需要為已命名帳戶設定對應。

閱讀 XDM商業帳戶總覽 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" accountKey.sourceType
"${MUNCHKIN_ID}" accountKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
concat(id, ".mkto_acct") accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo") accountKey.sourceKey 主要身分識別. 的值 "${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 是次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
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

機會

閱讀 XDM商業機會概觀 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" opportunityKey.sourceType
"${MUNCHKIN_ID}" opportunityKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
id opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") opportunityKey.sourceKey 主要身分識別. 的值 "${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.sourceKey 次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
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(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 此來源資料集僅適用於具有下列特徵的使用者: Salesforce 整合。
lastActivityDate lastActivityDate
leadSource leadSource
nextStep nextStep
marketoIsDeleted isDeleted

機會聯絡人角色

閱讀 XDM商業機會個人關係概觀 以取得有關XDM類別的詳細資訊。

來源資料集 xdm目標欄位 附註
"Marketo" opportunityPersonKey.sourceType
"${MUNCHKIN_ID}" opportunityPersonKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
id opportunityPersonKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") opportunityPersonKey.sourceKey 主要身分識別. 的值 "${MUNCHKIN_ID}" 將取代為Explore API的一部分。
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 是次要身分。 以下專案的值: {CRM_ORG_ID}{CRM_TYPE} 將會自動取代。
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null) opportunityKey 關係
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) personKey 關係
role personRole
isPrimary isPrimary
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

人員

閱讀 XDM個別設定檔概述 以取得有關XDM類別的詳細資訊。 如需XDM欄位群組的詳細資訊,請閱讀 XDM商業人士詳細資料結構描述欄位群組 指南和 XDM商業人士元件結構描述欄位群組 指南。

來源資料集 xdm目標欄位 附註
"Marketo" b2b.personKey.sourceType
"${MUNCHKIN_ID}" b2b.personKey.sourceInstanceID 的值 "${MUNCHKIN_ID}" 將會自動取代。
id b2b.personKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") b2b.personKey.sourceKey 主要身分識別. 的值 "${MUNCHKIN_ID}" 將會自動取代。
iif(unsubscribed == 'true', 'n', 'y' )) consents.marketing.email.val 如果取消訂閱為 true (例如,值= 1),然後設定 consents.marketing.email.val 作為(n)。 如果取消訂閱為 false (例如,值= 0),然後設定 consents.marketing.email.val 作為 null.
iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null) consents.marketing.email.reason
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
marketingSuspended b2b.isMarketingSuspended
marketingSuspendedCause b2b.marketingSuspendedCause
leadScore b2b.personScore
leadSource b2b.personSource
leadStatus b2b.personStatus
personType b2b.personType
leadPartitionId b2b.personGroupID
mktoCdpIsConverted b2b.isConverted
mktoCdpConvertedDate b2b.convertedDate
  • 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, "Contact", 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, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey extSourceSystemAudit.externalKey 是次要身分。
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 b2b.companyName
website b2b.companyWebsite
leadScore personComponents.personScore
leadSource personComponents.personSource
leadStatus personComponents.personStatus
personType personComponents.personType
leadPartitionId personComponents.personGroupID
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, "Contact", 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, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
personComponents.sourceExternalKey
iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null) personComponents.sourcePersonKey
email personComponents.workEmail.address
email workEmail.address
iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null) identityMap 這是計算欄位。
marketoIsDeleted isDeleted
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 這是計算欄位。
注意

to_object('ECID',arrays_to_objects('id',explode(ecids))) 來源欄位是計算欄位,必須使用 新增計算欄位 Platform UI中的選項。 請參閱上的教學課程 新增計算欄位 以取得詳細資訊。

後續步驟

閱讀本檔案後,您對彼此之間的對應關係有了更深入的瞭解 Marketo 資料集及其對應的XDM欄位。 請參閱上的教學課程 建立 Marketo 來源連線 完成您的 Marketo 資料流。

此頁面上的