Marketo Engage mappages de champs

Les tableaux ci-dessous contiennent les mappages entre les champs des neuf Marketo jeux de données et leurs champs de modèle de données d’expérience (XDM) correspondants.

CONSEIL

Tous Marketo jeux de données, sauf Activities prise en charge désormais isDeleted. Vos flux de données existants incluront automatiquement isDeleted, mais n’ingère que l’indicateur pour les données nouvellement ingérées. Si vous souhaitez appliquer l’indicateur à toutes vos données historiques, vous devez arrêter vos flux de données existants et les recréer avec le nouveau mappage. Veuillez noter que si vous supprimez isDeleted, vous n’aurez plus accès à la fonctionnalité. Il est essentiel que le mappage soit conservé une fois qu’il est automatiquement renseigné.

Activités

Le Marketo source prend désormais en charge les activités standard supplémentaires. Pour utiliser des activités standard, vous devez mettre à jour votre schéma à l’aide du utilitaire de génération automatique de schéma car si vous créez des activities le flux de données sans mettre à jour votre schéma, les modèles de mappage échouent, car les nouveaux champs cibles ne seront pas présents dans votre schéma. Si vous choisissez de ne pas mettre à jour votre schéma, vous pouvez toujours créer un nouveau flux de données et ignorer les erreurs. Toutefois, les champs nouveaux ou mis à jour ne seront pas ingérés dans Platform.

Jeu de données source Champ cible XDM Notes
_id _id
"Marketo" personKey.sourceType
"${MUNCHKIN_ID}" personKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
personID personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo") personKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
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

Programmes

Jeu de données source Champ cible XDM Remarques
"Marketo" campaignKey.sourceType
"${MUNCHKIN_ID}" campaignKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
id campaignKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") campaignKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
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 Le extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
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

Abonnements au programme

Jeu de données source Champ cible XDM Remarques
"Marketo" campaignMemberKey.sourceType
"${MUNCHKIN_ID}" campaignMemberKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
id campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") campaignMemberKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null) campaignKey Relation
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) personKey Relation
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 Le extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
sfdc.lastStatus lastStatus
sfdc.hasResponded hasResponded
sfdc.firstRespondedDate firstRespondedDate
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

Sociétés

Jeu de données source Champ cible XDM Remarques
"Marketo" accountKey.sourceType
"${MUNCHKIN_ID}" accountKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
concat(id, ".mkto_org") accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo") accountKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
  • 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 Le extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
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

Listes statiques

Jeu de données source Champ cible XDM Remarques
"Marketo" marketingListKey.sourceType
"${MUNCHKIN_ID}" marketingListKey.sourceInstanceID "${MUNCHKIN_ID}" sera remplacé dans le cadre de l’API Explorer.
id marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") marketingListKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
name marketingListName
description marketingListDescription
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

Abonnements à des listes statiques

Jeu de données source Champ cible XDM Remarques
"Marketo" marketingListMemberKey.sourceType
"${MUNCHKIN_ID}" marketingListMemberKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
staticListMemberID marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo") marketingListMemberKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null) marketingListKey Relation
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null) personKey Relation
createdAt extSourceSystemAudit.createdDate
marketoIsDeleted isDeleted

Comptes nommés

IMPORTANT

Le jeu de données de comptes nommés n’est nécessaire qu’avec la fonctionnalité de marketing basé sur les comptes (ABM) de Marketo. Si vous n’utilisez pas ABM, vous n’avez pas besoin de configurer des mappages pour les comptes nommés.

Jeu de données source Champ cible XDM Remarques
"Marketo" accountKey.sourceType
"${MUNCHKIN_ID}" accountKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
concat(id, ".mkto_acct") accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo") accountKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
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 Le extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
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

Opportunités

Jeu de données source Champ cible XDM Remarques
"Marketo" opportunityKey.sourceType
"${MUNCHKIN_ID}" opportunityKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
id opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") opportunityKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
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 Identité Secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
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 Relation
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 Ce jeu de données source n’est disponible que pour les utilisateurs disposant de la variable Salesforce intégration.
lastActivityDate lastActivityDate
leadSource leadSource
nextStep nextStep
marketoIsDeleted isDeleted

Rôles de contact d’opportunité

Jeu de données source Champ cible XDM Remarques
"Marketo" opportunityPersonKey.sourceType
"${MUNCHKIN_ID}" opportunityPersonKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
id opportunityPersonKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") opportunityPersonKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera remplacé dans le cadre de l’API Explorer.
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 Le extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} sera automatiquement remplacé.
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null) opportunityKey Relation
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) personKey Relation
role personRole
isPrimary isPrimary
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted isDeleted

Personnes

Jeu de données source Champ cible XDM Remarques
"Marketo" b2b.personKey.sourceType
"${MUNCHKIN_ID}" b2b.personKey.sourceInstanceID La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
id b2b.personKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo") b2b.personKey.sourceKey Identité Principal. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacé.
iif(unsubscribed == 'true', 'n', 'y' )) consents.marketing.email.val Si le désabonnement est true (par exemple, valeur = 1), puis définissez consents.marketing.email.val as (n). Si le désabonnement est false (par exemple, valeur = 0), puis définissez consents.marketing.email.val as 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 Le extSourceSystemAudit.externalKey est l’identité secondaire.
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 Il s’agit d’un champ calculé.
marketoIsDeleted isDeleted
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) b2b.convertedContactKey Il s’agit d’un champ calculé.
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) personComponents.sourceConvertedContactKey Il s’agit d’un champ calculé.
REMARQUE

Le to_object('ECID',arrays_to_objects('id',explode(ecids))) Le champ source est un champ calculé qui doit être ajouté à l’aide de la variable Ajouter un champ calculé dans l’interface utilisateur de Platform. Voir le tutoriel sur ajout de champs calculés pour plus d’informations.

Étapes suivantes

En lisant ce document, vous avez obtenu des informations sur la relation de mappage entre vos Marketo jeux de données et leurs champs XDM correspondants. Voir le tutoriel sur création d’un Marketo connexion source pour terminer vos Marketo dataflow.

Sur cette page