Marketo Engage 필드 매핑 marketo-engage-field-mappings

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

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

활동 activities

다음 Marketo 이제 source에서 추가 표준 활동을 지원합니다. 표준 활동을 사용하려면 를 사용하여 스키마를 업데이트해야 합니다. 스키마 자동 생성 유틸리티 새 항목을 만들면 activities 스키마를 업데이트하지 않으면 매핑 템플릿이 실패하고 스키마에 새 대상 필드가 없습니다. 스키마를 업데이트하지 않도록 선택하는 경우에도 새 데이터 흐름을 만들고 오류를 무시할 수 있습니다. 그러나 새 필드나 업데이트된 필드는 Platform에 수집되지 않습니다.

의 설명서를 읽어 보십시오. XDM 경험 이벤트 클래스 XDM 클래스 및 XDM 필드 그룹에 대한 자세한 정보입니다.

NOTE
다음 iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) 소스 필드는 를 사용하여 추가해야 하는 계산된 필드입니다. 계산된 필드 추가 Experience Platform UI의 옵션 다음에 대한 자습서 읽기: 계산된 필드 추가 추가 정보.
소스 데이터 세트
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
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)
identityMap
계산된 필드입니다.

프로그램 programs

읽기 XDM 비즈니스 캠페인 개요 XDM 클래스에 대한 자세한 내용. XDM 필드 그룹에 대한 자세한 내용은 비즈니스 캠페인 세부 정보 스키마 필드 그룹 가이드.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
campaignKey.sourceType
"${MUNCHKIN_ID}"
campaignKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
id
campaignKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignKey.sourceKey
기본 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

프로그램 멤버십 program-memberships

읽기 XDM 비즈니스 캠페인 멤버 개요 XDM 클래스에 대한 자세한 내용. XDM 필드 그룹에 대한 자세한 내용은 XDM 비즈니스 캠페인 멤버 세부 정보 스키마 필드 그룹 가이드.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
campaignMemberKey.sourceType
"${MUNCHKIN_ID}"
campaignMemberKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
id
campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignMemberKey.sourceKey
기본 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

회사 companies

읽기 XDM 비즈니스 계정 개요 XDM 클래스에 대한 자세한 내용.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
concat(id, ".mkto_org")
accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
기본 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

정적 목록 static-lists

읽기 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

정적 목록 멤버십 static-list-memberships

읽기 XDM 비즈니스 마케팅 목록 멤버 개요 XDM 클래스에 대해 자세히 알아보십시오.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
marketingListMemberKey.sourceType
"${MUNCHKIN_ID}"
marketingListMemberKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
staticListMemberID
marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")
marketingListMemberKey.sourceKey
기본 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

명명된 계정 named-accounts

IMPORTANT
명명된 계정 데이터 세트는 Marketo의 계정 기반 마케팅(ABM) 기능에만 필요합니다. ABM을 사용하지 않는 경우에는 명명된 계정에 대한 매핑을 설정할 필요가 없습니다.

읽기 XDM 비즈니스 계정 개요 XDM 클래스에 대한 자세한 내용.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
concat(id, ".mkto_acct")
accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
기본 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

기회 opportunities

읽기 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

영업 기회 연락처 역할 opportunity-contact-roles

읽기 XDM 비즈니스 영업 기회 사용자 관계 개요 XDM 클래스에 대한 자세한 내용.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
opportunityPersonKey.sourceType
"${MUNCHKIN_ID}"
opportunityPersonKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
id
opportunityPersonKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityPersonKey.sourceKey
기본 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

개인 persons

읽기 XDM 개별 프로필 개요 XDM 클래스에 대한 자세한 내용. XDM 필드 그룹에 대한 자세한 내용은 XDM 비즈니스 사용자 세부 정보 스키마 필드 그룹 안내서 및 XDM 비즈니스 사용자 구성 요소 스키마 필드 그룹 가이드.

소스 데이터 세트
XDM 타겟 필드
참고
"Marketo"
b2b.personKey.sourceType
"${MUNCHKIN_ID}"
b2b.personKey.sourceInstanceID
"${MUNCHKIN_ID}" 자동으로 교체됩니다.
id
b2b.personKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
b2b.personKey.sourceKey
기본 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
marketoIsDeleted
isDeleted
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)
b2b.convertedContactKey
계산된 필드입니다.
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)
personComponents.sourceConvertedContactKey
계산된 필드입니다.

다음 단계

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

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089