Marketo Engage 필드 매핑 marketo-engage-field-mappings
다음 표를 사용하여 각 Marketo Engage 데이터 세트의 필드가 해당 XDM(Experience Data Model) 필드에 매핑되는 방법을 확인하십시오.
Activities을(를) 제외한 모든 Marketo 데이터 세트가 isDeleted을(를) 지원합니다. 기존 데이터 흐름에는 isDeleted이(가) 자동으로 포함되지만 새 데이터에 대한 플래그만 수집됩니다. 이전 데이터에 플래그를 적용하려면 기존 데이터 흐름을 중지하고 새 매핑을 사용하여 다시 만드십시오. isDeleted을(를) 제거하면 더 이상 이 기능을 사용할 수 없습니다. isDeleted 매핑을 자동으로 채운 후 유지합니다.활동 activities
Marketo 원본은 추가 표준 활동을 지원합니다. 표준 활동을 사용하려면 스키마 자동 생성 유틸리티로 스키마를 업데이트하세요. 스키마를 업데이트하지 않고 새 activities 데이터 흐름을 만들면 새 대상 필드가 스키마에 없으므로 매핑 템플릿이 실패합니다. 스키마를 업데이트하지 않도록 선택하는 경우에도 새 데이터 흐름을 만들고 오류를 무시할 수 있습니다. 그러나 Experience Platform은 새 필드나 업데이트된 필드를 수집하지 않습니다.
XDM 클래스와 해당 필드 그룹에 대한 자세한 내용은 XDM ExperienceEvent 클래스 개요를 참조하십시오.
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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.leadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.activityTypeIdeventTypeeventTypeactivityTypeId가is 1, 2, 3, 9, 10 또는 11 → 표시producedByself(으)로.activityTypeId가is 6, 7, 8, 12, 21, 22, 24, 25, 27, 32, 34, 35, 36, 46, 101, 104, 110, 113, 114 또는 115 → 표시producedBysystem.- 다른 모든 값→
producedBy로 표시합니다.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 → 실패
- 4002 → 메시지가 너무 큼
- → 정책 위반
- 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 IDsjson_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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다."Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.costactualCost.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은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.integrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.lastUpdatedDatewebinarHistorySyncDatewebinarHistorySyncDatewebinarHistorySyncStatuswebinarHistorySyncStatuswebinarSessionDescriptionwebinarSessionDescriptionwebinarSessionNamewebinarSessionName프로그램 멤버십 program-memberships
XDM 클래스에 대한 자세한 내용은 XDM 비즈니스 캠페인 멤버 개요를 참조하십시오. XDM 필드 그룹에 대한 자세한 내용은 XDM 비즈니스 캠페인 멤버 세부 정보 스키마 필드 그룹 안내서를 참조하십시오.
"Marketo"campaignMemberKey.sourceType"${MUNCHKIN_ID}"campaignMemberKey.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.idcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.iif(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은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.sfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted회사 companies
XDM 클래스에 대한 자세한 내용은 XDM 비즈니스 계정 개요를 참조하십시오.
accountKey.sourceKey에 대한 기본 매핑은 각 계정 ID에 .mkto_org 접미사를 추가합니다. 이 형식은 .mkto_org 접미사를 지원하지 않는 Marketo Measure 대상과 호환되지 않습니다. 이 데이터를 Marketo Measure(으)로 내보내려면 데이터를 수집하기 전에 모든 계정 키 필드에서 .mkto_org 접미사를 제거하십시오. 업데이트할 필드 목록에 대한 Marketo Measure 계정 키 형식 요구 사항을 읽어 보십시오."Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.concat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_ID을(를) Marketo 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.externalKeyextSourceSystemAudit.externalKey.sourceKey은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.idmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.namemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted정적 목록 멤버십 static-list-memberships
XDM 클래스에 대한 자세한 내용은 XDM 비즈니스 마케팅 목록 멤버 개요를 참조하십시오.
"Marketo"marketingListMemberKey.sourceType"${MUNCHKIN_ID}"marketingListMemberKey.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.staticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.iif(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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.concat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_ID을(를) Marketo 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.externalKeyextSourceSystemAudit.externalKey.sourceKey은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.idopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyMUNCHKIN_ID을(를) Marketo 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.externalKeyextSourceSystemAudit.externalKey.sourceKey은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.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.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다."Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.createdAtextSourceSystemAudit.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은(는) 보조 ID입니다. Explore API는 CRM_TYPE 및 CRM_ORG_ID을(를) CRM 유형 및 CRM 조직 ID로 바꿉니다.isPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.lastUpdatedDate개인 persons
XDM 클래스에 대한 자세한 내용은 XDM 개별 프로필 개요를 참조하십시오. XDM 필드 그룹에 대한 자세한 내용은 XDM 비즈니스 사용자 세부 정보 스키마 필드 그룹 안내서 및 XDM 비즈니스 사용자 구성 요소 스키마 필드 그룹 안내서를 참조하십시오.
"${MUNCHKIN_ID}"b2b.personKey.sourceInstanceIDMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다."Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeyMUNCHKIN_ID을(를) Marketo Munchkin ID로 대체합니다.countryworkAddress.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”, decode(sfdcType, “Contact”, sfdcContactId, “Lead”, sfdcLeadId , null), “sourceKey”, concat(decode(sfdcType, “Contact”, sfdcContactId, “Lead”, sfdcLeadId , null), @${CRM_ORG_ID}.${CRM_TYPE}“))), null))), 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.sourceExternalKeyiif(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))), 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.externalKeyextSourceSystemAudit.externalKey.sourceKey은(는) 보조 ID입니다.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.valunsubscribed이(가) true(값 1)이면 consents.marketing.email.val이(가) n(으)로 설정됩니다. unsubscribed이(가) false(값 0)이면 consents.marketing.email.val이(가) null로 설정됩니다.iif(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다음 단계 next-steps
이제 Marketo 데이터 세트의 필드가 해당 XDM 필드에 매핑되는 방법을 알 수 있습니다. Marketo 데이터 흐름을 완료하려면 Marketo 소스 연결 만들기에 대한 자습서를 읽어 보십시오.