Documentação Experience Platform Guia dos conectores de origem

Marketo Engage mapeamentos de campos marketo-engage-field-mappings

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

Tópicos:

Criado para:

undefined

As tabelas abaixo contêm os mapeamentos entre os campos nos nove conjuntos de dados do Marketo e seus campos correspondentes do Experience Data Model (XDM).

TIP

Todos os conjuntos de dados Marketo, exceto Activities, agora oferecem suporte para isDeleted. Seus fluxos de dados existentes incluirão automaticamente isDeleted, mas apenas assimilarão o sinalizador de dados recém-assimilados. Se quiser aplicar o sinalizador a todos os dados históricos, interrompa os fluxos de dados existentes e recrie-os com o novo mapeamento. Observe que, se você remover isDeleted, não terá mais acesso à funcionalidade. É essencial que o mapeamento seja mantido após ser preenchido automaticamente.

Atividades activities

A origem Marketo agora dá suporte a atividades padrão adicionais. Para usar atividades padrão, você deve atualizar seu esquema usando o utilitário de geração automática de esquema, pois se você criar um novo fluxo de dados activities sem atualizar seu esquema, os modelos de mapeamento falharão, pois os novos campos de destino não estarão presentes em seu esquema. Se você optar por não atualizar o esquema, ainda será possível criar um novo fluxo de dados e descartar os erros. No entanto, campos novos ou atualizados não serão assimilados na Platform.

Leia a documentação da classe do Evento de experiência XDM para obter mais informações sobre a Classe XDM e o(s) Grupo(s) de Campos XDM.

NOTE

O campo de origem

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

é um campo calculado que deve ser adicionado usando a opção Adicionar campo calculado na interface de usuário do Experience Platform. Leia o tutorial em adição de campos calculados para obter mais informações.

Conjunto de dados do Source

Campo de destino XDM

Notas

_id

"Marketo"

personKey.sourceType

"${MUNCHKIN_ID}"

personKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

personID

personKey.sourceID

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

personKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

Este é um campo calculado.

Programas programs

Leia a Visão geral da Campanha Comercial XDM para obter mais informações sobre a classe XDM. Para obter mais informações sobre os grupos de campos XDM, leia o guia do campo de esquema Detalhes da campanha comercial.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

campaignKey.sourceType

"${MUNCHKIN_ID}"

campaignKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

id

campaignKey.sourceID

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

campaignKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

O extSourceSystemAudit.externalKey é a identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

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

Associações ao programa program-memberships

Leia a Visão geral dos membros da campanha de negócios XDM para obter mais informações sobre a classe XDM. Para obter mais informações sobre os grupos de campos XDM, leia o guia do campo de esquema Detalhes do membro da campanha de negócios XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

campaignMemberKey.sourceType

"${MUNCHKIN_ID}"

campaignMemberKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

id

campaignMemberKey.sourceID

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

campaignMemberKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)

campaignKey

Relação

iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relação

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

O extSourceSystemAudit.externalKey é a identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

sfdc.lastStatus

lastStatus

sfdc.hasResponded

hasResponded

sfdc.firstRespondedDate

firstRespondedDate

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Empresas companies

Leia a Visão geral da Conta Comercial XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

concat(id, ".mkto_org")

accountKey.sourceID

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

accountKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

O extSourceSystemAudit.externalKey é a identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

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

Listas estáticas static-lists

Leia a Visão geral da Lista de Marketing Comercial XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

marketingListKey.sourceType

"${MUNCHKIN_ID}"

marketingListKey.sourceInstanceID

"${MUNCHKIN_ID}" será substituído como parte da API Explorar.

id

marketingListKey.sourceID

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

marketingListKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

name

marketingListName

description

marketingListDescription

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Associações de lista estática static-list-memberships

Leia a Visão geral dos membros da Lista de marketing empresarial XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

marketingListMemberKey.sourceType

"${MUNCHKIN_ID}"

marketingListMemberKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

staticListMemberID

marketingListMemberKey.sourceID

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

marketingListMemberKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)

marketingListKey

Relação

iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relação

createdAt

extSourceSystemAudit.createdDate

marketoIsDeleted

isDeleted

Contas nomeadas named-accounts

IMPORTANT

O conjunto de dados de contas nomeadas só é necessário com o recurso de marketing baseado em conta (ABM) da Marketo. Se você não estiver usando o ABM, não será necessário configurar mapeamentos para contas nomeadas.

Leia a Visão geral da Conta Comercial XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

concat(id, ".mkto_acct")

accountKey.sourceID

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

accountKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

O extSourceSystemAudit.externalKey é a identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

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

Oportunidades opportunities

Leia a Visão geral da oportunidade de negócios XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

opportunityKey.sourceType

"${MUNCHKIN_ID}"

opportunityKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

id

opportunityKey.sourceID

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

opportunityKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

Identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

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

Relação

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

Este conjunto de dados de origem está disponível somente para usuários com a integração Salesforce.

lastActivityDate

leadSource

nextStep

marketoIsDeleted

isDeleted

Funções do contato da oportunidade opportunity-contact-roles

Leia a Visão geral da relação da pessoa com a oportunidade de negócios XDM para obter mais informações sobre a classe XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

opportunityPersonKey.sourceType

"${MUNCHKIN_ID}"

opportunityPersonKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

id

opportunityPersonKey.sourceID

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

opportunityPersonKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído como parte da API Explorar.

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

O extSourceSystemAudit.externalKey é a identidade secundária. Os valores de {CRM_ORG_ID} e {CRM_TYPE} serão substituídos automaticamente.

iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)

opportunityKey

Relação

iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relação

role

personRole

isPrimary

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Pessoas persons

Leia a Visão geral do Perfil Individual XDM para obter mais informações sobre a classe XDM. Para obter mais informações sobre os grupos de campos XDM, leia o guia do campo de esquema Detalhes da pessoa de negócios XDM e o guia do campo de esquema Componentes da pessoa de negócios XDM.

Conjunto de dados do Source

Campo de destino XDM

Notas

"Marketo"

b2b.personKey.sourceType

"${MUNCHKIN_ID}"

b2b.personKey.sourceInstanceID

O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

id

b2b.personKey.sourceID

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

b2b.personKey.sourceKey

Identidade principal. O valor de "${MUNCHKIN_ID}" será substituído automaticamente.

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

consents.marketing.email.val

Se a assinatura cancelada for true (por exemplo, valor = 1), defina consents.marketing.email.val como (n). Se a assinatura cancelada for false (por exemplo, valor = 0), defina consents.marketing.email.val como 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

O extSourceSystemAudit.externalKey é a identidade secundária.

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

Este é um campo calculado.

iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)

personComponents.sourceConvertedContactKey

Este é um campo calculado.

Próximas etapas

Ao ler este documento, você obtém informações sobre a relação de mapeamento entre seus conjuntos de dados do Marketo e seus campos XDM correspondentes. Consulte o tutorial sobre criação de uma Marketo conexão de origem para concluir seu fluxo de dados Marketo.

recommendation-more-help

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