(bêta) Marketo Engage mappages de champs

IMPORTANT

La source Marketo Engage est actuellement en version bêta. Ses fonctionnalités et la documentation peuvent être modifiées.

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

Activités

Jeu de données source Champ de cible XDM Notes
_id _id
personID personID Identité Principal
eventType eventType
timestamp timestamp
web.webPageDetails._marketo.URL web.webPageDetails._marketo.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
listOperations.listID listOperations.listID
opportunityEvent.isPrimary opportunityEvent.isPrimary
opportunityEvent.opportunityID opportunityEvent.opportunityID
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.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
opportunityEvent.dataValueChanges.attributeName opportunityEvent.dataValueChanges.attributeName
opportunityEvent.dataValueChanges.newValue opportunityEvent.dataValueChanges.newValue
opportunityEvent.dataValueChanges.oldValue opportunityEvent.dataValueChanges.oldValue
opportunityEvent.opportunityID opportunityEvent.opportunityID
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

Programmes

Jeu de données source Champ de cible XDM Notes
id campaignID Identité Principal
sfdcId extSourceSystemAudit.externalID Identité Secondaire
name campaignName
description campaignDescription
type campaignType
status campaignStatus
channel channelName
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate
cost actualCost.amount
parentProgramId parentCampaignID
integrationPartner integrationPartnerName
startDate campaignStartDate
endDate campaignEndDate

Membres de programme

Jeu de données source Champ de cible XDM Notes
id campaignMemberID Identité Principal
programId campaignID Relation
leadId personID Relation
acquiredByCampaignID acquiredByCampaignID
reachedSuccess hasReachedSuccess
isExhausted isExhausted
statusName memberStatus
statusReason memberStatusReason
membershipDate membershipDate
nurtureCadence nurtureCadence
trackName nurtureTrackName
webinarUrl webinarConfirmationUrl
registrationCode webinarRegistrationID
reachedSuccessDate reachedSuccessDate
sfdc.crmId extSourceSystemAudit.externalID
sfdc.lastStatus lastStatus
sfdc.hasResponded hasResponded
sfdc.firstRespondedDate firstRespondedDate
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

Sociétés

Jeu de données source Champ de cible XDM Notes
id accountID Identité Principal
mktoCdpExternalId extSourceSystemAudit.externalID Identité Secondaire
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
mktoCdpParentOrgId accountParentID

Listes statiques

Jeu de données source Champ de cible XDM Notes
id marketingListID Identité Principal
name marketingListName
description marketingListDescription
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

Abonnements à la liste statique

Jeu de données source Champ de cible XDM Notes
staticListMemberID marketingListMemberID Identité Principal
staticListID marketingListID Relation
personID personID Relation
createdAt extSourceSystemAudit.createdDate

Comptes nommés

IMPORTANT

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

Jeu de données source Champ de cible XDM Notes
id accountID Identité Principal
crmGuid extSourceSystemAudit.externalID Identité Secondaire
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
parentAccountId accountParentID
sourceType accountSourceType

Opportunités

Jeu de données source Champ de cible XDM Notes
id opportunityID Identité Principal
externalOpportunityId extSourceSystemAudit.externalID Identité Secondaire
mktoCdpAccountOrgId accountID 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
mktoCdpSourceCampaignId campaignID Recommandé uniquement si vous utilisez l’intégration Salesforce.
lastActivityDate lastActivityDate
leadSource leadSource
nextStep nextStep

Rôles de contact d'opportunité

Jeu de données source Champ de cible XDM Notes
id opportunityPersonID Identité Principal
mktoCdpSfdcId extSourceSystemAudit.externalID Identité Secondaire
mktoCdpOpptyId opportunityID Relation
leadId personID Relation
role personRole
isPrimary isPrimary
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

Personnes

Jeu de données source Champ de cible XDM Notes
id personID Identité Principal
contactCompany b2b.accountID
marketingSuspended b2b.isMarketingSuspended
marketingSuspendedCause b2b.marketingSuspendedCause
leadScore b2b.personScore
leadSource b2b.personSource
leadStatus b2b.personStatus
personType b2b.personType
leadPartitionId b2b.personGroupID
mktoCdpCnvContactPersonId b2b.convertedContactID
mktoCdpIsConverted b2b.isConverted
mktoCdpConvertedDate b2b.convertedDate
sfdcLeadId extSourceSystemAudit.externalID 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 organizations
leadScore personComponents.personScore
leadSource personComponents.personSource
leadStatus personComponents.personStatus
personType personComponents.personType
leadPartitionId personComponents.personGroupID
mktoCdpCnvContactPersonId personComponents.sourceConvertedContactID
contactCompany personComponents.sourceAccountID
sfdcContactId personComponents.sourceExternalID Recommandé uniquement si vous utilisez l’intégration Salesforce.
id personComponents.sourcePersonID
email personComponents.workEmail.address
email workEmail.address
to_object('ECID',arrays_to_objects('id',explode(ecids))) identityMap
REMARQUE

Le champ source to_object('ECID',arrays_to_objects('id',explode(ecids))) est un champ calculé qui doit être ajouté à l'aide de l'option Ajouter champ calculé dans l'interface utilisateur de la plate-forme. Pour plus d'informations, consultez le didacticiel sur l'ajout de champs calculés.

Étapes suivantes

En lisant ce document, vous obtenez des informations sur la relation de mappage entre vos jeux de données Marketo et leurs champs XDM correspondants. Consultez le didacticiel sur la création d'une Marketo connexion source pour terminer votre flux de données Marketo.

Sur cette page