Marketo Engage欄位對應 marketo-engage-field-mappings
下表包含九個Marketo資料集中的欄位與其對應的體驗資料模型(XDM)欄位之間的對應。
Activities資料集現在都支援isDeleted。 您現有的資料流會自動包含isDeleted,但僅會針對新擷取的資料擷取標幟。 如果您想要將標幟套用至所有歷史資料,則必須停止現有資料流並使用新對應重新建立資料流。 請注意,如果您移除isDeleted,則您將無法再存取該功能。 自動填入對應後,請務必保留對應。活動 activities
Marketo來源現在支援其他標準活動。 若要使用標準活動,您必須使用結構描述自動產生公用程式來更新結構描述,因為如果您建立新的activities資料流而不更新結構描述,對應範本將會失敗,因為新的目標欄位將不會出現在結構描述中。 如果您選擇不更新您的結構描述,您仍然可以建立新的資料流並解除任何錯誤。 不過,任何新欄位或更新後的欄位都不會內嵌到Experience Platform中。
閱讀XDM體驗事件類別的檔案,以瞭解XDM類別和XDM欄位群組的詳細資訊。
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)來源欄位是必須使用Experience Platform UI中的 新增計算欄位 選項新增的計算欄位。 閱讀有關新增計算欄位的教學課程,以瞭解詳細資訊。_id_id_id"Marketo"personKey.sourceType"${MUNCHKIN_ID}"personKey.sourceInstanceIDleadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyactivityTypeIdeventTypeeventType- 如果
activityTypeId是1、2、3、9、10或11 →標籤productedBy做為 self。 - 如果
activityTypeId是6、7、8、12、21、22、24、25、27、32、34、35、36、46、101、104、110、113、114或115→記號productedBy作為 系統。 - 對於所有其他值,→標籤
productedBy做為 self。
producedByproducedByactivityDatetimestamptimestampattributes.Webpage URLweb.webPageDetails.URLweb.webPageDetails.URLattributes.User Agentenvironment.browserDetails.userAgentenvironment.browserDetails.userAgentattributes.Client IP Addressenvironment.ipV4environment.ipV4attributes.Search Querysearch.keywordssearch.keywordsattributes.Search Enginesearch.searchEnginesearch.searchEngineprimaryAttributeValue when activityTypeId = 1web.webPageDetails.webPageIDweb.webPageDetails.webPageIDprimaryAttributeValue when activityTypeId = 1web.webPageDetails.nameweb.webPageDetails.nameattributes.Personalized URLweb.webPageDetails.isPersonalizedURLweb.webPageDetails.isPersonalizedURLattributes.Query Parametersweb.webPageDetails.queryParametersweb.webPageDetails.queryParametersattributes.Referrer URLweb.webReferrer.URLweb.webReferrer.URLprimaryAttributeValueId when activityTypeId in (24, 25)iif(${listOperations\.listID} != null && ${listOperations\.listID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", ${listOperations\.listID}, "sourceKey", concat(${listOperations\.listID},"@${MUNCHKIN_ID}.Marketo")), null)listOperations.listKeyattributes.Is PrimaryopportunityEvent.isPrimaryopportunityEvent.isPrimaryiif(${opportunityEvent\.opportunityID} != null && ${opportunityEvent\.opportunityID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${opportunityEvent\.opportunityID}, "sourceKey", concat(${opportunityEvent\.opportunityID},"@${MUNCHKIN_ID}.Marketo")), null)opportunityEvent.opportunityKeyattributes.RoleopportunityEvent.roleopportunityEvent.roleattributes.Created DateleadOperation.newLead.createdDateleadOperation.newLead.createdDateattributes.Form NameleadOperation.newLead.formNameleadOperation.newLead.formNameattributes.Lead SourceleadOperation.newLead.leadSourceleadOperation.newLead.leadSourceattributes.List NameleadOperation.newLead.listNameleadOperation.newLead.listNameattributes.SFDC TypeleadOperation.newLead.sfdcTypeleadOperation.newLead.sfdcTypeattributes.Source TypeleadOperation.newLead.sourceTypeleadOperation.newLead.sourceTypeleadOperation.convertLead.assignToleadOperation.convertLead.assignToattributes.Converted StatusleadOperation.convertLead.convertedStatusleadOperation.convertLead.convertedStatusattributes.Send Notification EmailleadOperation.convertLead.isSentNotificationEmailleadOperation.convertLead.isSentNotificationEmailiif(${directMarketing\\.mailingID} != null && ${directMarketing\\.mailingID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${directMarketing\\.mailingID}, \"sourceKey\", concat(${directMarketing\\.mailingID},\"@${MUNCHKIN_ID}.Marketo\")), null)directMarketing.mailingKeydirectMarketing.mailingNamedirectMarketing.mailingNamedirectMarketing.testVariantNamedirectMarketing.testVariantNameattributes.Test VariantdirectMarketing.testVariantIDdirectMarketing.testVariantIDattributes.Subcategory
-
activityTypeId = 8
- 1099 →訊息已封鎖
- Source上已封鎖1003 →垃圾訊息
- 1004 →封郵件上的垃圾訊息
- 2003 →電子郵件地址無效
- 2001 →電子郵件地址錯誤
- * →未知的跳出原因
-
activityTypeId = 27
- 3999 →訊息未接受
- 3001 →信箱已滿
- 3004 →發生逾時
- 4003 → DNS失敗
- 4002 →訊息太大
- 4006 →原則違規
- 4999 →暫時性失敗
- 收到9999 →錯誤回應
- * →軟退信的未知原因
directMarketing.emailBouncedCodedirectMarketing.emailBouncedCodeattributes.DetailsdirectMarketing.emailBouncedDetailsdirectMarketing.emailBouncedDetailsattributes.EmaildirectMarketing.emaildirectMarketing.emailattributes.Is Mobile Devicedevice.isMobileDevicedevice.isMobileDeviceattributes.devicedevice.modeldevice.modelattributes.Platformenvironment.operatingSystemenvironment.operatingSystemattributes.LinkdirectMarketing.linkURLdirectMarketing.linkURLiif(${web\\.webInteraction\\.linkID} != null && ${web\\.webInteraction\\.linkID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.webInteraction\\.linkID}, \"sourceKey\", concat(${web\\.webInteraction\\.linkID},\"@${MUNCHKIN_ID}.Marketo\")), null)web.webInteraction.webInteractionKeyiif(${web\\.fillOutForm\\.webFormID} != null && ${web\\.fillOutForm\\.webFormID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.fillOutForm\\.webFormID}, \"sourceKey\", concat(${web\\.fillOutForm\\.webFormID},\"@${MUNCHKIN_ID}.Marketo\")), null)web.fillOutForm.webFormKeyweb.fillOutForm.webFormNameweb.fillOutForm.webFormNameweb.webInteraction.linkURLweb.webInteraction.linkURLattributes.Change ValueleadOperation.changeScore.changeValueleadOperation.changeScore.changeValueattributes.New ValueleadOperation.changeScore.newValueleadOperation.changeScore.newValueattributes.Old ValueleadOperation.changeScore.oldValueleadOperation.changeScore.oldValueattributes.PriorityleadOperation.changeScore.priorityleadOperation.changeScore.priorityattributes.ReasonleadOperation.changeScore.reasonleadOperation.changeScore.reasonattributes.Relative ScoreleadOperation.changeScore.relativeScoreleadOperation.changeScore.relativeScoreattributes.Relative UrgencyleadOperation.changeScore.relativeUrgencyleadOperation.changeScore.relativeUrgencyiif(${leadOperation\.changeScore\.scoreAttributeID} != null && ${leadOperation\.changeScore\.scoreAttributeID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeScore\.scoreAttributeID}, "sourceKey", concat(${leadOperation\.changeScore\.scoreAttributeID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeScore.scoreAttributeKeyleadOperation.changeScore.scoreAttributeNameleadOperation.changeScore.scoreAttributeNameattributes.UrgencyleadOperation.changeScore.urgencyleadOperation.changeScore.urgencyattributes.Data Value Changesjson_to_object(${opportunityEvent\.dataValueChanges})opportunityEvent.dataValueChangesiif(${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.campaignKeyattributes.Acquired ByleadOperation.campaignProgression.isAcquiredByleadOperation.campaignProgression.isAcquiredByattributes.SuccessleadOperation.campaignProgression.isSuccessfulleadOperation.campaignProgression.isSuccessfulattributes.New Status IDleadOperation.campaignProgression.newStatusIDleadOperation.campaignProgression.newStatusIDattributes.New StatusleadOperation.campaignProgression.newStatusNameleadOperation.campaignProgression.newStatusNameattributes.Old Status IDleadOperation.campaignProgression.oldStatusIDleadOperation.campaignProgression.oldStatusIDattributes.Old StatusleadOperation.campaignProgression.oldStatusNameleadOperation.campaignProgression.oldStatusNameattributes.ReasonleadOperation.campaignProgression.reasonleadOperation.campaignProgression.reasonattributes.DateleadOperation.interestingMoment.dateleadOperation.interestingMoment.dateattributes.DescriptionleadOperation.interestingMoment.descriptionleadOperation.interestingMoment.descriptionattributes.SourceleadOperation.interestingMoment.sourceleadOperation.interestingMoment.sourceleadOperation.interestingMoment.typeleadOperation.interestingMoment.typeiif(${leadOperation\\.callWebhook\\.webhookID} != null && ${leadOperation\\.callWebhook\\.webhookID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.callWebhook\\.webhookID}, \"sourceKey\", concat(${leadOperation\\.callWebhook\\.webhookID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.callWebhook.webhookKeyleadOperation.callWebhook.webhookNameleadOperation.callWebhook.webhookNameattributes.Error TypeleadOperation.callWebhook.responseCodeleadOperation.callWebhook.responseCodeiif(${leadOperation\\.changeCampaignCadence\\.campaignID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.changeCampaignCadence.campaignKeyattributes.New Nurture CadenceleadOperation.changeCampaignCadence.newCadenceleadOperation.changeCampaignCadence.newCadenceattributes.Previous Nurture CadenceleadOperation.changeCampaignCadence.previousCadenceleadOperation.changeCampaignCadence.previousCadenceiif(${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.campaignKeyattributes.Track IDiif(${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.streamKeyattributes.Stream NameleadOperation.addToCampaign.streamNameleadOperation.addToCampaign.streamNameiif(${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.campaignKeyattributes.New Track IDiif(${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.newStreamKeyattributes.New Track NameleadOperation.changeCampaignStream.newStreamNameleadOperation.changeCampaignStream.newStreamNameattributes.Previous Track IDiif(${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.previousStreamKeyattributes.Previous Stream NameleadOperation.changeCampaignStream.previousStreamNameleadOperation.changeCampaignStream.previousStreamNameiif(${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.modelKeyleadOperation.changeRevenueStage.modelNameleadOperation.changeRevenueStage.modelNameattributes.New Stage IDiif(${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.newStageKeyattributes.New StageleadOperation.changeRevenueStage.newStageNameleadOperation.changeRevenueStage.newStageNameattributes.Old Stage IDiif(${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.previousStageKeyattributes.Old StageleadOperation.changeRevenueStage.previousStageNameleadOperation.changeRevenueStage.previousStageNameattributes.ReasonleadOperation.changeRevenueStage.reasonleadOperation.changeRevenueStage.reasonattributes.Merge IDs (當activityTypeId = 32)json_to_object(${leadOperation\.mergeLeads\.mergeIDs})leadOperation.mergeLeads.sourceKeysattributes.Master UpdatedleadOperation.mergeLeads.targetUpdatedleadOperation.mergeLeads.targetUpdatedattributes.Merged in SalesleadOperation.mergeLeads.mergedInCRMleadOperation.mergeLeads.mergedInCRMattributes.Merge SourceleadOperation.mergeLeads.mergeSourceleadOperation.mergeLeads.mergeSourceiif(${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.mailingKeydirectMarketing.emailSent.mailingNamedirectMarketing.emailSent.mailingNameattributes.Test VariantdirectMarketing.emailSent.testVariantIDdirectMarketing.emailSent.testVariantIDdirectMarketing.emailSent.testVariantNamedirectMarketing.emailSent.testVariantNameattributes.Campaign Run IDdirectMarketing.emailSent.automationRunIDdirectMarketing.emailSent.automationRunIDdirectMarketing.automationRunIDdirectMarketing.automationRunID方案 programs
閱讀XDM商業活動概覽,瞭解有關XDM類別的更多資訊。 如需XDM欄位群組的詳細資訊,請閱讀商業促銷活動詳細資料結構描述欄位群組指南。
"${MUNCHKIN_ID}"campaignKey.sourceInstanceID"Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeycostactualCost.amountcreatedAtextSourceSystemAudit.createdDatedescriptioncampaignDescriptionendDatecampaignEndDateidcampaignKey.sourceIDiif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)parentCampaignKeyiif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_TYPE和CRM_ORG_ID將會取代為探索API的一部分integrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.lastUpdatedDatewebinarHistorySyncDatewebinarHistorySyncDatewebinarHistorySyncStatuswebinarHistorySyncStatuswebinarSessionDescriptionwebinarSessionDescriptionwebinarSessionNamewebinarSessionName計畫成員資格 program-memberships
閱讀XDM商業活動會員總覽,瞭解有關XDM類別的更多資訊。 如需XDM欄位群組的詳細資訊,請閱讀XDM商業促銷活動成員詳細資料結構描述欄位群組指南。
"Marketo"campaignMemberKey.sourceType"${MUNCHKIN_ID}"campaignMemberKey.sourceInstanceIDidcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyiif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeyiif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyiif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)acquiredByCampaignKeyreachedSuccesshasReachedSuccessisExhaustedisExhaustedstatusNamememberStatusstatusReasonmemberStatusReasonmembershipDatemembershipDatenurtureCadencenurtureCadencetrackNamenurtureTrackNamewebinarUrlwebinarConfirmationUrlregistrationCodewebinarRegistrationIDreachedSuccessDatereachedSuccessDateiif(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.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_TYPE和CRM_ORG_ID將會取代為探索API的一部分sfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted公司 companies
如需有關XDM類別的詳細資訊,請閱讀XDM商業帳戶總覽。
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDconcat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyiif(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.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_ORG_ID和CRM_TYPE將會取代為探索API的一部分createdAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatebillingCityaccountBillingAddress.citybillingCountryaccountBillingAddress.countrybillingPostalCodeaccountBillingAddress.postalCodebillingStateaccountBillingAddress.statebillingStreetaccountBillingAddress.street1annualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrynumberOfEmployeesaccountOrganization.numberOfEmployeeswebsiteaccountOrganization.websitemainPhoneaccountPhone.numbercompanyaccountNamecompanyNotesaccountDescriptionsiteaccountSiteiif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)accountParentKeymarketoIsDeletedisDeleted靜態清單 static-lists
閱讀XDM業務行銷清單總覽,瞭解有關XDM類別的更多資訊。
"Marketo"marketingListKey.sourceType"${MUNCHKIN_ID}"marketingListKey.sourceInstanceIDidmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeynamemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted靜態清單成員資格 static-list-memberships
閱讀XDM業務行銷清單成員總覽,瞭解有關XDM類別的更多資訊。
"Marketo"marketingListMemberKey.sourceType"${MUNCHKIN_ID}"marketingListMemberKey.sourceInstanceIDstaticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyiif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)marketingListKeyiif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)personKeycreatedAtextSourceSystemAudit.createdDatemarketoIsDeletedisDeleted具名帳戶 named-accounts
如需有關XDM類別的詳細資訊,請閱讀XDM商業帳戶總覽。
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDconcat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyiif(crmGuid != null && crmGuid != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", crmGuid, "sourceKey", concat(crmGuid,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_TYPE和CRM_ORG_ID將會取代為探索API的一部分createdAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatecityaccountBillingAddress.citycountryaccountBillingAddress.countrystateaccountBillingAddress.stateannualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrylogoUrlaccountOrganization.logoUrlnumberOfEmployeesaccountOrganization.numberOfEmployeesnameaccountNameiif(parentAccountId != null && parentAccountId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(parentAccountId, ".mkto_acct"), "sourceKey", concat(parentAccountId, ".mkto_acct@${MUNCHKIN_ID}.Marketo")), null)accountParentKeysourceTypeaccountSourceTypemarketoIsDeletedisDeleted機會 opportunities
閱讀XDM商業機會總覽以瞭解有關XDM類別的詳細資訊。
"Marketo"opportunityKey.sourceType"${MUNCHKIN_ID}"opportunityKey.sourceInstanceIDidopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyiif(externalOpportunityId != null && externalOpportunityId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", externalOpportunityId, "sourceKey", concat(externalOpportunityId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_TYPE和CRM_ORG_ID將會取代為探索API的一部分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)accountKeydescriptionopportunityDescriptionnameopportunityNamestageopportunityStagetypeopportunityTypecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDateexpectedRevenueexpectedRevenue.amountamountopportunityAmount.amountcloseDateexpectedCloseDatefiscalQuarterfiscalQuarterfiscalYearfiscalYearforecastCategoryforecastCategoryforecastCategoryNameforecastCategoryNameisClosedisClosedisWonisWonquantityopportunityQuantityprobabilityprobabilityPercentageiif(mktoCdpSourceCampaignId != null && mktoCdpSourceCampaignId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpSourceCampaignId, "sourceKey", concat(mktoCdpSourceCampaignId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeylastActivityDatelastActivityDateleadSourceleadSourcenextStepnextStepmarketoIsDeletedisDeleted機會聯絡人角色 opportunity-contact-roles
閱讀XDM商業機會個人關係總覽,以瞭解有關XDM類別的詳細資訊。
"${MUNCHKIN_ID}"opportunityPersonKey.sourceInstanceID"Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeycreatedAtextSourceSystemAudit.createdDateidopportunityPersonKey.sourceIDiif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyiif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)opportunityKeyiif(mktoCdpSfdcId != null && mktoCdpSfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", mktoCdpSfdcId, "sourceKey", concat(mktoCdpSfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分。 CRM_TYPE和CRM_ORG_ID將會取代為探索API的一部分isPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.lastUpdatedDate人員 persons
閱讀XDM個人設定檔總覽,瞭解有關XDM類別的詳細資訊。 如需有關XDM欄位群組的詳細資訊,請閱讀XDM商業人士詳細資料結構描述欄位群組指南和XDM商業人士元件結構描述欄位群組指南。
"${MUNCHKIN_ID}"b2b.personKey.sourceInstanceID"Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeycountryworkAddress.countrycreatedAtextSourceSystemAudit.createdDatedateOfBirthperson.birthDateemailpersonComponents.workEmail.addressemailworkEmail.addressfaxfaxPhone.numberfirstNameperson.name.firstNameidb2b.personKey.sourceIDiif(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.accountKeyiif(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.sourceAccountKeyiif(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId, null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID",解碼(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null), "sourceKey", concat(decode(sfdcType, "Contact", sfdcContactId, 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",解碼(msftType, "Contact", msftContactId, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "LeadId, null),"@${CRM_ORG_ID}。${CRM_TYPE}"), null)
personComponents.sourceExternalKeyiif(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId, null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID",解碼(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null), "sourceKey", concat(decode(sfdcType, "Contact", sfdcContactId, 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",解碼(msftType, "Contact", msftContactId, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "LeadId, null),"@${CRM_ORG_ID}。${CRM_TYPE}"), null)
extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey是次要身分iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)identityMapiif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourcePersonKeyiif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)b2b.convertedContactKeyiif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourceConvertedContactKeyiif(unsubscribed == 'true', 'n', 'y' )consents.marketing.email.valiif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)consents.marketing.email.reasonlastNameperson.name.lastNameleadPartitionIdb2b.personGroupIDleadPartitionIdpersonComponents.personGroupIDleadScoreb2b.personScoreleadScorepersonComponents.personScoreleadSourceb2b.personSourceleadSourcepersonComponents.personSourceleadStatusb2b.personStatusleadStatuspersonComponents.personStatusmarketingSuspendedb2b.isMarketingSuspendedmarketingSuspendedCauseb2b.marketingSuspendedCausemarketoIsDeletedisDeletedmiddleNameperson.name.middleNamemktoCdpConvertedDateb2b.convertedDatemktoCdpIsConvertedb2b.isConvertedmobilePhonemobilePhone.numberpersonTypeb2b.personTypepersonTypepersonComponents.personTypephoneworkPhone.numberpostalCodeworkAddress.postalCodesalutationperson.name.courtesyTitlestateworkAddress.statetitleextendedWorkDetails.jobTitleupdatedAtextSourceSystemAudit.lastUpdatedDate後續步驟
閱讀本檔案後,您已經取得Marketo資料集與其對應XDM欄位之間對應關係的insight。 請參閱有關建立 Marketo 來源連線的教學課程,以完成您的Marketo資料流。