Marketo Engage 필드 매핑

마지막 업데이트: 2023-05-26
  • 주제:
  • Sources
    이 항목에 대한 자세한 내용 보기
  • 작성 대상:
  • Developer
    User
    Admin
    Leader

아래 표에는 9개 필드 간의 매핑이 포함되어 있습니다 Marketo 데이터 세트 및 해당 XDM(경험 데이터 모델) 필드.

모두 Marketo 데이터 세트 제외 Activities 지금 지원 isDeleted. 기존 데이터 흐름에 자동으로 다음이 포함됩니다. isDeleted는 새로 수집된 데이터에 대한 플래그만 수집합니다. 모든 이전 데이터에 플래그를 적용하려면 기존 데이터 흐름을 중지하고 새 매핑을 사용하여 다시 만들어야 합니다. 다음을 제거할 경우 참고 isDeleted를 클릭하면 더 이상 기능에 액세스할 수 없습니다. 매핑은 자동으로 채워진 후에도 유지되어야 합니다.

활동

다음 Marketo 이제 source에서 추가 표준 활동을 지원합니다. 표준 활동을 사용하려면 를 사용하여 스키마를 업데이트해야 합니다. 스키마 자동 생성 유틸리티 새 항목을 만들면 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 기본 ID. 값 "${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 기본 ID. 값 "${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 는 보조 ID입니다. 값 {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 기본 ID. 값 "${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 는 보조 ID입니다. 값 {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 기본 ID. 값 "${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 는 보조 ID입니다. 값 {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}" 은 API 탐색의 일부로 대체됩니다.
id marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") marketingListKey.sourceKey 기본 ID. 값 "${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 기본 ID. 값 "${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 기본 ID. 값 "${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 는 보조 ID입니다. 값 {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 기본 ID. 값 "${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 보조 ID. 값 {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 기본 ID. 값 "${MUNCHKIN_ID}" 은 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 는 보조 ID입니다. 값 {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 기본 ID. 값 "${MUNCHKIN_ID}" 자동으로 교체됩니다.
iif(unsubscribed == 'true', 'n', 'y' )) consents.marketing.email.val 구독 취소한 경우: true (예: 값 = 1), 그런 다음 설정 consents.marketing.email.val as (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 는 보조 ID입니다.
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
title extendedWorkDetails.jobTitle
fax faxPhone.number
mobilePhone mobilePhone.number
firstName person.name.firstName
lastName person.name.lastName
middleName person.name.middleName
salutation person.name.courtesyTitle
dateOfBirth person.birthDate
city workAddress.city
country workAddress.country
postalCode workAddress.postalCode
state workAddress.state
address workAddress.street1
phone workPhone.number
company b2b.companyName
website b2b.companyWebsite
leadScore personComponents.personScore
leadSource personComponents.personSource
leadStatus personComponents.personStatus
personType personComponents.personType
leadPartitionId personComponents.personGroupID
iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null) personComponents.sourceAccountKey
  • iif(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null), "sourceKey", concat(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
  • iif(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
personComponents.sourceExternalKey
iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null) personComponents.sourcePersonKey
email personComponents.workEmail.address
email workEmail.address
iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null) identityMap 계산된 필드입니다.
marketoIsDeleted isDeleted
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) b2b.convertedContactKey 계산된 필드입니다.
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) personComponents.sourceConvertedContactKey 계산된 필드입니다.
노트

다음 to_object('ECID',arrays_to_objects('id',explode(ecids))) 소스 필드는 를 사용하여 추가해야 하는 계산된 필드입니다. 계산된 필드 추가 Platform UI의 옵션입니다. 다음 튜토리얼 참조: 계산된 필드 추가 추가 정보.

다음 단계

이 문서를 읽고 나면 사용자 간의 매핑 관계에 대한 통찰력을 얻을 수 있습니다 Marketo 데이터 세트 및 해당 XDM 필드. 다음 튜토리얼 참조: 만들기 Marketo 소스 연결 을(를) 완료하려면 Marketo 데이터 흐름.

이 페이지의