DocumentatieExperience PlatformGids voor Source Connectors

Marketo Engage veldtoewijzingen marketo-engage-field-mappings

Last update: Mon May 05 2025 00:00:00 GMT+0000 (Coordinated Universal Time)
  • Onderwerpen:

Gemaakt voor:

  • Ontwikkelaar

De onderstaande tabellen bevatten de toewijzingen tussen de velden in de negen Marketo -gegevenssets en de bijbehorende XDM-velden (Experience Data Model).

TIP
Alle Marketo -gegevenssets behalve Activities nu ondersteunen isDeleted . De bestaande gegevensstromen zullen automatisch isDeleted omvatten, maar zullen slechts de vlag voor onlangs opgenomen gegevens opnemen. Als u de vlag op al uw historische gegevens wilt toepassen, dan moet u uw bestaande dataflows tegenhouden en hen met de nieuwe afbeelding ontspannen. Als u isDeleted verwijdert, hebt u geen toegang meer tot de functionaliteit. Het is van essentieel belang dat de toewijzing wordt behouden nadat deze automatisch wordt gevuld.

Activiteiten activities

De bron Marketo ondersteunt nu aanvullende standaardactiviteiten. Om standaardactiviteiten te gebruiken, moet u uw schema bijwerken gebruikend het schema auto-generatienutomdat als u nieuwe activities dataflow creeert zonder uw schema bij te werken, de afbeeldingsmalplaatjes zullen ontbreken aangezien de nieuwe doelgebieden niet in uw schema aanwezig zullen zijn. Als u ervoor kiest uw schema niet bij te werken, kunt u nog steeds een nieuwe gegevensstroom maken en eventuele fouten negeren. Nieuwe of bijgewerkte velden worden echter niet in Experience Platform opgenomen.

Lees de documentatie over de klasse van de Gebeurtenis van de Ervaring XDMvoor meer informatie over de Klasse XDM en de Groep(s) van het Gebied XDM.

NOTE
Het bronveld iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) is een berekend veld dat moet worden toegevoegd met de optie Add calculated field in de gebruikersinterface van Experience Platform. Lees het leerprogramma op toevoegend berekende gebiedenvoor meer informatie.
Source-gegevensset
XDM-doelveld
Notities
_id
_id
"Marketo"
personKey.sourceType
"${MUNCHKIN_ID}"
personKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
personID
personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo")
personKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
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
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)
identityMap
Dit is een berekend veld.

Programma's programs

Lees het XDM BedrijfsCampagne overzichtvoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van het het schemagebied van de Details van de BedrijfsCampagne .

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
campaignKey.sourceType
"${MUNCHKIN_ID}"
campaignKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
id
campaignKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
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
De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
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

Lidmaatschap van programma program-memberships

Lees het XDM overzicht van de Leden Bedrijfs van de Campagnevoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van het het schemagebied van de Details van het Lid van de BedrijfsCampagne van de 0} XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
campaignMemberKey.sourceType
"${MUNCHKIN_ID}"
campaignMemberKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
id
campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignMemberKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
Relatie
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
Relatie
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
De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
sfdc.lastStatus
lastStatus
sfdc.hasResponded
hasResponded
sfdc.firstRespondedDate
firstRespondedDate
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted

Bedrijven companies

Lees het XDM overzicht van de BedrijfsRekeningvoor meer informatie over de klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
concat(id, ".mkto_org")
accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
  • 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
De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
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

Statische lijsten static-lists

Lees het XDM overzicht van de Bedrijfs Marketing van de Lijstvoor meer informatie over de klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
marketingListKey.sourceType
"${MUNCHKIN_ID}"
marketingListKey.sourceInstanceID
"${MUNCHKIN_ID}" wordt vervangen als onderdeel van de API voor zoeken.
id
marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
marketingListKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
name
marketingListName
description
marketingListDescription
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted

Statische lijstlidmaatschappen static-list-memberships

Lees het XDM Bedrijfs van de Marketing Lijst Leden overzichtvoor meer informatie over de Klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
marketingListMemberKey.sourceType
"${MUNCHKIN_ID}"
marketingListMemberKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
staticListMemberID
marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")
marketingListMemberKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)
marketingListKey
Relatie
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
Relatie
createdAt
extSourceSystemAudit.createdDate
marketoIsDeleted
isDeleted

Benoemde accounts named-accounts

IMPORTANT
De genoemde rekeningen dataset is slechts noodzakelijk met de op rekening-gebaseerde marketing van Marketo (ABM) eigenschap. Als u ABM niet gebruikt, hoeft u geen toewijzingen in te stellen voor benoemde accounts.

Lees het XDM overzicht van de BedrijfsRekeningvoor meer informatie over de klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
concat(id, ".mkto_acct")
accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
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
De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
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

Kansen opportunities

Lees het XDM overzicht van de BedrijfsKansvoor meer informatie over de klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
opportunityKey.sourceType
"${MUNCHKIN_ID}"
opportunityKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
id
opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
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
Secundaire identiteit De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
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
Relatie
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
Deze brongegevensset is alleen beschikbaar voor gebruikers met de Salesforce -integratie.
lastActivityDate
lastActivityDate
leadSource
leadSource
nextStep
nextStep
marketoIsDeleted
isDeleted

Contactrollen opportunity opportunity-contact-roles

Lees het XDM overzicht van de Verhouding van de Person van de Bedrijfs van de Opportunityvoor meer informatie over de klasse XDM.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
opportunityPersonKey.sourceType
"${MUNCHKIN_ID}"
opportunityPersonKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
id
opportunityPersonKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityPersonKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt vervangen als onderdeel van de API voor zoeken.
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
De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)
opportunityKey
Relatie
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
Relatie
role
personRole
isPrimary
isPrimary
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted

Personen persons

Lees het XDM Individuele overzicht van het Profielvoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van de het schemagroep van de Details van de BedrijfsPersoon van 0} XDM {en XDM van de BedrijfsPersoon de het schemagroep van Componenten van de Componenten.

Source-gegevensset
XDM-doelveld
Notities
"Marketo"
b2b.personKey.sourceType
"${MUNCHKIN_ID}"
b2b.personKey.sourceInstanceID
De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
id
b2b.personKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
b2b.personKey.sourceKey
Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.
iif(unsubscribed == 'true', 'n', 'y' ))
consents.marketing.email.val
Als unsubscribed true is (bijvoorbeeld value = 1), dan plaats consents.marketing.email.val als (n). Als unsubscribed false is (bijvoorbeeld value = 0 ), stelt u consents.marketing.email.val in als 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
De extSourceSystemAudit.externalKey is de secundaire identiteit.
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
Dit is een berekend veld.
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)
personComponents.sourceConvertedContactKey
Dit is een berekend veld.

Volgende stappen

Door dit document te lezen, hebt u insight verworven op de toewijzingsverhouding tussen uw Marketo datasets en hun overeenkomstige gebieden XDM. Zie het leerprogramma op creërend a Marketo bronverbindingom uw Marketo dataflow te voltooien.

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089