Documentation Experience Platform Guide des connecteurs sources

Mappages de champs Marketo Engage marketo-engage-field-mappings

Last update: Fri Jul 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Rubriques :

Créé pour :

Développeur

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

TIP

Tous les jeux de données Marketo, sauf Activities, prennent désormais isDeleted en charge. Vos flux de données existants incluront automatiquement isDeleted, mais n’ingèreront 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. Notez 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 activities

La source Marketo prend désormais en charge les activités standards supplémentaires. Pour utiliser des activités standards, vous devez mettre à jour votre schéma à l’aide de l’utilitaire de génération automatique de schéma, car si vous créez de nouveaux flux de données activities 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.

Pour plus d’informations sur la classe XDM et le ou les groupes de champs XDM, consultez la documentation sur la classe XDM Experience Event .

NOTE

Le champ source

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

est un champ calculé qui doit être ajouté à l’aide de l’option Ajouter un champ calculé de l’interface utilisateur Experience Platform. Pour plus d’informations, lisez le tutoriel sur l’ ajout de champs calculés .

Jeu de données source

Champ cible XDM

Notes

_id

"Marketo"

personKey.sourceType

"${MUNCHKIN_ID}"

personKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

personID

personKey.sourceID

concat(personID,"@${MUNCHKIN_ID}.Marketo")

personKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

eventType

producedBy

timestamp

web.webPageDetails.URL

environment.browserDetails.userAgent

environment.ipV4

search.keywords

search.searchEngine

web.webPageDetails.webPageID

web.webPageDetails.name

web.webPageDetails.isPersonalizedURL

web.webPageDetails.queryParameters

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

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

leadOperation.newLead.createdDate

leadOperation.newLead.formName

leadOperation.newLead.leadSource

leadOperation.newLead.listName

leadOperation.newLead.sfdcType

leadOperation.newLead.sourceType

leadOperation.convertLead.assignTo

leadOperation.convertLead.convertedStatus

leadOperation.convertLead.isSentNotificationEmail

directMarketing.mailingID

directMarketing.mailingName

directMarketing.testVariantName

directMarketing.testVariantID

directMarketing.emailBouncedCode

directMarketing.emailBouncedDetails

directMarketing.email

device.isMobileDevice

device.model

environment.operatingSystem

directMarketing.linkURL

web.webInteraction.linkID

web.fillOutForm.webFormID

web.fillOutForm.webFormName

web.webInteraction.linkURL

leadOperation.changeScore.changeValue

leadOperation.changeScore.newValue

leadOperation.changeScore.oldValue

leadOperation.changeScore.priority

leadOperation.changeScore.reason

leadOperation.changeScore.relativeScore

leadOperation.changeScore.relativeUrgency

leadOperation.changeScore.scoreAttributeID

leadOperation.changeScore.scoreAttributeName

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.isAcquiredBy

leadOperation.campaignProgression.isSuccessful

leadOperation.campaignProgression.newStatusID

leadOperation.campaignProgression.newStatusName

leadOperation.campaignProgression.oldStatusID

leadOperation.campaignProgression.oldStatusName

leadOperation.campaignProgression.reason

leadOperation.interestingMoment.date

leadOperation.interestingMoment.description

leadOperation.interestingMoment.source

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.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.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

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

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

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

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

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.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.mergedInCRM

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.testVariantID

directMarketing.emailSent.testVariantName

directMarketing.emailSent.automationRunID

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

identityMap

Il s’agit d’un champ calculé.

Programmes programs

Lisez la présentation de XDM Business Campaign pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez le guide groupe de champs de schéma des détails Business Campaign.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

campaignKey.sourceType

"${MUNCHKIN_ID}"

campaignKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

id

campaignKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

campaignKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

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 champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées.

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

webinarSessionDescription

webinarHistorySyncStatus

webinarHistorySyncDate

startDate

campaignStartDate

endDate

campaignEndDate

marketoIsDeleted

isDeleted

Abonnements au programme program-memberships

Lisez la présentation des membres XDM Business Campaign pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez le guide Groupe de champs de schéma des détails des membres XDM Business Campaign.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

campaignMemberKey.sourceType

"${MUNCHKIN_ID}"

campaignMemberKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

id

campaignMemberKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

campaignMemberKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

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

statusName

memberStatus

statusReason

memberStatusReason

membershipDate

nurtureCadence

trackName

nurtureTrackName

webinarUrl

webinarConfirmationUrl

registrationCode

webinarRegistrationID

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 champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées.

sfdc.lastStatus

lastStatus

sfdc.hasResponded

hasResponded

sfdc.firstRespondedDate

firstRespondedDate

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Sociétés companies

Lisez la présentation des comptes professionnels XDM pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

concat(id, ".mkto_org")

accountKey.sourceID

concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")

accountKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

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 champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées.

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 static-lists

Lisez la présentation de la liste XDM Business Marketing pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

marketingListKey.sourceType

"${MUNCHKIN_ID}"

marketingListKey.sourceInstanceID

"${MUNCHKIN_ID}" sera remplacé dans le cadre de l’API Explore.

id

marketingListKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

marketingListKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

name

marketingListName

description

marketingListDescription

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Abonnements à des listes statiques static-list-memberships

Lisez la Présentation des membres de la liste XDM Business Marketing pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

marketingListMemberKey.sourceType

"${MUNCHKIN_ID}"

marketingListMemberKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

staticListMemberID

marketingListMemberKey.sourceID

concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")

marketingListMemberKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

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 désignés named-accounts

IMPORTANT

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

Lisez la Présentation des comptes professionnels XDM pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

concat(id, ".mkto_acct")

accountKey.sourceID

concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")

accountKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

iif(externalSourceId != null && externalSourceId != "", to_object("sourceType", externalSourceType, "sourceInstanceID", externalSourceInstanceId, "sourceID", externalSourceId, "sourceKey", externalSourceKey), 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 champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées.

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 opportunities

Lisez la Présentation des opportunités commerciales XDM pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

opportunityKey.sourceType

"${MUNCHKIN_ID}"

opportunityKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

id

opportunityKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

opportunityKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

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} seront automatiquement remplacées.

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

fiscalYear

forecastCategory

forecastCategoryName

isClosed

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 l’intégration Salesforce.

lastActivityDate

leadSource

nextStep

marketoIsDeleted

isDeleted

Rôles de contact d’opportunité opportunity-contact-roles

Lisez la Présentation de la relation Personne-opportunité commerciale XDM pour plus d’informations sur la classe XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

opportunityPersonKey.sourceType

"${MUNCHKIN_ID}"

opportunityPersonKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

id

opportunityPersonKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

opportunityPersonKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera remplacée 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 champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées.

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

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Personnes persons

Lisez la Présentation du Profil individuel XDM pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez les guides Groupe de champs de schéma Détails professionnels XDM et Groupe de champs de schéma Composants professionnels XDM.

Jeu de données source

Champ cible XDM

Notes

"Marketo"

b2b.personKey.sourceType

"${MUNCHKIN_ID}"

b2b.personKey.sourceInstanceID

La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

id

b2b.personKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

b2b.personKey.sourceKey

Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée.

iif(unsubscribed == 'true', 'n', 'y' ))

consents.marketing.email.val

Si le désabonnement est true (par exemple, valeur = 1), définissez consents.marketing.email.val en tant que (n). Si le désabonnement est false (par exemple, valeur = 0), définissez consents.marketing.email.val en tant que 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 champ 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

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é.

Étapes suivantes

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

recommendation-more-help

337b99bb-92fb-42ae-b6b7-c7042161d089