Marketo Engage 欄位對應 marketo-engage-field-mappings

Last update: Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

主題：

建立對象：

undefined

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

TIP

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

活動 activities

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

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

NOTE

此

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

來源欄位是計算欄位，必須使用 新增計算欄位 Experience PlatformUI中的選項。閱讀有關教學課程新增計算欄位以取得詳細資訊。

來源資料集

xdm目標欄位

附註

_id

"Marketo"

personKey.sourceType

"${MUNCHKIN_ID}"

personKey.sourceInstanceID

的值 "${MUNCHKIN_ID}" 將會自動取代。

personID

personKey.sourceID

concat(personID,"@${MUNCHKIN_ID}.Marketo")

personKey.sourceKey

主要身分。的值 "${MUNCHKIN_ID}" 將會自動取代。

eventType

producedBy

timestamp

web.webPageDetails.URL

environment.browserDetails.userAgent

environment.ipV4

search.keywords

search.searchEngine

web.webPageDetails.webPageID

web.webPageDetails.name

web.webPageDetails.isPersonalizedURL

web.webPageDetails.queryParameters

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

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

leadOperation.newLead.createdDate

leadOperation.newLead.formName

leadOperation.newLead.leadSource

leadOperation.newLead.listName

leadOperation.newLead.sfdcType

leadOperation.newLead.sourceType

leadOperation.convertLead.assignTo

leadOperation.convertLead.convertedStatus

leadOperation.convertLead.isSentNotificationEmail

directMarketing.mailingID

directMarketing.mailingName

directMarketing.testVariantName

directMarketing.testVariantID

directMarketing.emailBouncedCode

directMarketing.emailBouncedDetails

directMarketing.email

device.isMobileDevice

device.model

environment.operatingSystem

directMarketing.linkURL

web.webInteraction.linkID

web.fillOutForm.webFormID

web.fillOutForm.webFormName

web.webInteraction.linkURL

leadOperation.changeScore.changeValue

leadOperation.changeScore.newValue

leadOperation.changeScore.oldValue

leadOperation.changeScore.priority

leadOperation.changeScore.reason

leadOperation.changeScore.relativeScore

leadOperation.changeScore.relativeUrgency

leadOperation.changeScore.scoreAttributeID

leadOperation.changeScore.scoreAttributeName

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.isAcquiredBy

leadOperation.campaignProgression.isSuccessful

leadOperation.campaignProgression.newStatusID

leadOperation.campaignProgression.newStatusName

leadOperation.campaignProgression.oldStatusID

leadOperation.campaignProgression.oldStatusName

leadOperation.campaignProgression.reason

leadOperation.interestingMoment.date

leadOperation.interestingMoment.description

leadOperation.interestingMoment.source

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.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.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

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

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

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

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

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.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.mergedInCRM

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.testVariantID

directMarketing.emailSent.testVariantName

directMarketing.emailSent.automationRunID

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

identityMap

這是計算欄位。

計畫 programs

閱讀 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

webinarSessionDescription

webinarHistorySyncStatus

webinarHistorySyncDate

startDate

campaignStartDate

endDate

campaignEndDate

marketoIsDeleted

isDeleted

計畫成員資格 program-memberships

閱讀 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

statusName

memberStatus

statusReason

memberStatusReason

membershipDate

nurtureCadence

trackName

nurtureTrackName

webinarUrl

webinarConfirmationUrl

registrationCode

webinarRegistrationID

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

公司 companies

閱讀 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

靜態清單 static-lists

閱讀 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

靜態清單成員資格 static-list-memberships

閱讀 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

具名帳戶 named-accounts

IMPORTANT

具名帳戶資料集僅適用於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

機會 opportunities

閱讀 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

fiscalYear

forecastCategory

forecastCategoryName

isClosed

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

leadSource

nextStep

marketoIsDeleted

isDeleted

機會聯絡人角色 opportunity-contact-roles

閱讀 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

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

人員 persons

閱讀 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

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

這是計算欄位。

後續步驟

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

recommendation-more-help

337b99bb-92fb-42ae-b6b7-c7042161d089