(Beta) Marketo Engage asignaciones de campos

IMPORTANTE

El origen Marketo Engage está actualmente en versión beta. Sus características y la documentación están sujetas a cambios.

Las tablas siguientes contienen las asignaciones entre los campos de los nueve conjuntos de datos Marketo y los campos correspondientes del Modelo de datos de experiencia (XDM).

Actividades

Conjunto de datos de origen Campo de destino XDM Notas
_id _id
personID personID Identidad primaria
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

Programas

Conjunto de datos de origen Campo de destino XDM Notas
id campaignID Identidad principal
sfdcId extSourceSystemAudit.externalID Identidad secundaria
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

Pertenencia a programas

Conjunto de datos de origen Campo de destino XDM Notas
id campaignMemberID Identidad principal
programId campaignID Relación
leadId personID Relación
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

Compañías

Conjunto de datos de origen Campo de destino XDM Notas
id accountID Identidad principal
mktoCdpExternalId extSourceSystemAudit.externalID Identidad secundaria
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

Listas estáticas

Conjunto de datos de origen Campo de destino XDM Notas
id marketingListID Identidad principal
name marketingListName
description marketingListDescription
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

Membresías de lista estáticas

Conjunto de datos de origen Campo de destino XDM Notas
staticListMemberID marketingListMemberID Identidad principal
staticListID marketingListID Relación
personID personID Relación
createdAt extSourceSystemAudit.createdDate

Cuentas con nombre

IMPORTANTE

El conjunto de datos de cuentas con nombre solo es necesario con la función de marketing basado en cuentas (ABM) de Marketo. Si no utiliza ABM, no es necesario configurar asignaciones para cuentas con nombre.

Conjunto de datos de origen Campo de destino XDM Notas
id accountID Identidad principal
crmGuid extSourceSystemAudit.externalID Identidad secundaria
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

Oportunidades

Conjunto de datos de origen Campo de destino XDM Notas
id opportunityID Identidad principal
externalOpportunityId extSourceSystemAudit.externalID Identidad secundaria
mktoCdpAccountOrgId accountID Relación
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 Solo se recomienda si utiliza la integración de Salesforce.
lastActivityDate lastActivityDate
leadSource leadSource
nextStep nextStep

Funciones de contacto de oportunidad

Conjunto de datos de origen Campo de destino XDM Notas
id opportunityPersonID Identidad principal
mktoCdpSfdcId extSourceSystemAudit.externalID Identidad secundaria
mktoCdpOpptyId opportunityID Relación
leadId personID Relación
role personRole
isPrimary isPrimary
createdAt extSourceSystemAudit.createdDate
updatedAt extSourceSystemAudit.lastUpdatedDate

Personas

Conjunto de datos de origen Campo de destino XDM Notas
id personID Identidad primaria
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 Identidad secundaria
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 Solo se recomienda si utiliza la integración de Salesforce.
id personComponents.sourcePersonID
email personComponents.workEmail.address
email workEmail.address
to_object('ECID',arrays_to_objects('id',explode(ecids))) identityMap
NOTA

El campo de origen to_object('ECID',arrays_to_objects('id',explode(ecids))) es un campo calculado que debe añadirse utilizando la opción Add calculated field en la interfaz de usuario de Platform. Consulte el tutorial sobre adición de campos calculados para obtener más información.

Pasos siguientes

Al leer este documento, ha obtenido información sobre la relación de asignación entre sus Marketo conjuntos de datos y sus campos XDM correspondientes. Consulte el tutorial sobre la creación de una Marketo conexión de origen para completar el flujo de datos Marketo.

En esta página