- 來源概觀
- 可用的來源聯結器
- Adobe應用程式
- Advertising
- Analytics
- 雲端儲存空間
- 同意與偏好設定
- CRM
- 客戶成功
- 資料庫
- Amazon Redshift聯結器
- Azure HDInsights聯結器上的Apache Hive
- Azure HDInsights聯結器上的Apache Spark
- AzureData Explorer聯結器
- azure synapse Analytics聯結器
- Azure資料表儲存體聯結器
- Couchbase聯結器
- Google BigQuery聯結器
- GreenPlum聯結器
- HP Vertica聯結器
- IBM DB2聯結器
- MariaDB聯結器
- Microsoft SQL Server聯結器
- MySQL聯結器
- oracle聯結器
- Phoenix聯結器
- PostgreSQL聯結器
- Snowflake串流聯結器
- Snowflake聯結器
- teradata Vantage聯結器
- 電子商務
- 本機系統
- 行銷自動化
- 付款
- 通訊協定
- 串流
- API教學課程
- UI教學課程
- 自助來源（批次SDK）
- 錯誤訊息
- 資料流執行通知
- IP位址允許清單
- 常見問答
- API 參考資料
- Platform發行說明
Marketo Engage 欄位對應
下表包含九個欄位之間的對應 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}" 將會自動取代。 |
|
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 |
|
|
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 |
|
|
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 資料流。
變更語言
