Marketo Engage field mappings marketo-engage-field-mappings
The tables below contain the mappings between the fields in the nine Marketo datasets and their corresponding Experience Data Model (XDM) fields.
Activities
now support isDeleted
. Your existing dataflows will automatically include isDeleted
, but will only ingest the flag for newly ingested data. If you want to apply the flag to all of your historical data, then you must stop your existing dataflows and recreate them with the new mapping. Please note that if you remove isDeleted
, then you will no longer have access to the functionality. It is critical that the mapping is kept after it is auto-populated.Activities activities
The Marketo source now supports additional standard activities. To use standard activities, you must update your schema using the schema auto-generation utility because if you create new activities
dataflow without updating your schema, the mapping templates will fail as the new target fields will not be present in your schema. If you choose not to update your schema, you can still create a new dataflow and dismiss any errors. However, any new or updated fields will not be ingested into Platform.
See the documentation on XDM Experience Event class for more information on the XDM Class and XDM Field Group(s).
_id
_id
"Marketo"
personKey.sourceType
"${MUNCHKIN_ID}"
personKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.personID
personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo")
personKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.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
Programs programs
Read the XDM Business Campaign overview for more information on the XDM class. For more information on the XDM field groups, read the Business Campaign Details schema field group guide.
"Marketo"
campaignKey.sourceType
"${MUNCHKIN_ID}"
campaignKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.id
campaignKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.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
extSourceSystemAudit.externalKey
is the secondary identity. The values for {CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.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
Program memberships program-memberships
Read the XDM Business Campaign Members overview for more information on the XDM class. For more information on the XDM field groups, read the XDM Business Campaign Member Details schema field group guide.
"Marketo"
campaignMemberKey.sourceType
"${MUNCHKIN_ID}"
campaignMemberKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.id
campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignMemberKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
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
extSourceSystemAudit.externalKey
is the secondary identity. The values for {CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.sfdc.lastStatus
lastStatus
sfdc.hasResponded
hasResponded
sfdc.firstRespondedDate
firstRespondedDate
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted
Companies companies
Read the XDM Business Account overview for more information on the XDM class.
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.concat(id, ".mkto_org")
accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.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
extSourceSystemAudit.externalKey
is the secondary identity. The values for {CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.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
Static lists static-lists
Read the XDM Business Marketing List overview for more information on the XDM class.
"Marketo"
marketingListKey.sourceType
"${MUNCHKIN_ID}"
marketingListKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be replaced as part of Explore API.id
marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
marketingListKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.name
marketingListName
description
marketingListDescription
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted
Static list memberships static-list-memberships
Read the XDM Business Marketing List Members overview for more information on the XDM Class.
"Marketo"
marketingListMemberKey.sourceType
"${MUNCHKIN_ID}"
marketingListMemberKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.staticListMemberID
marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")
marketingListMemberKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)
marketingListKey
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
createdAt
extSourceSystemAudit.createdDate
marketoIsDeleted
isDeleted
Named accounts named-accounts
Read the XDM Business Account overview for more information on the XDM class.
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.concat(id, ".mkto_acct")
accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.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
extSourceSystemAudit.externalKey
is the secondary identity. The values for {CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.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
Opportunities opportunities
Read the XDM Business Opportunity overview for more information on the XDM class.
"Marketo"
opportunityKey.sourceType
"${MUNCHKIN_ID}"
opportunityKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.id
opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.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
{CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.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
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
lastActivityDate
lastActivityDate
leadSource
leadSource
nextStep
nextStep
marketoIsDeleted
isDeleted
Opportunity contact roles opportunity-contact-roles
Read the XDM Business Opportunity Person Relation overview for more information on the XDM class.
"Marketo"
opportunityPersonKey.sourceType
"${MUNCHKIN_ID}"
opportunityPersonKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.id
opportunityPersonKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityPersonKey.sourceKey
"${MUNCHKIN_ID}"
will be replaced as part of Explore API.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
extSourceSystemAudit.externalKey
is the secondary identity. The values for {CRM_ORG_ID}
and {CRM_TYPE}
will be automatically replaced.iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)
opportunityKey
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
role
personRole
isPrimary
isPrimary
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted
Persons persons
Read the XDM Individual Profile overview for more information on the XDM class. For more information on the XDM field groups, read the XDM Business Person Details schema field group guide and XDM Business Person Components schema field group guide.
"Marketo"
b2b.personKey.sourceType
"${MUNCHKIN_ID}"
b2b.personKey.sourceInstanceID
"${MUNCHKIN_ID}"
will be automatically replaced.id
b2b.personKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
b2b.personKey.sourceKey
"${MUNCHKIN_ID}"
will be automatically replaced.iif(unsubscribed == 'true', 'n', 'y' ))
consents.marketing.email.val
true
(for example, value = 1
), then set consents.marketing.email.val
as (n
). If unsubscribed is false
(for example, value = 0
), then set consents.marketing.email.val
as 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
extSourceSystemAudit.externalKey
is the secondary identity.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
iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)
identityMap
marketoIsDeleted
isDeleted
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)
b2b.convertedContactKey
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)
personComponents.sourceConvertedContactKey
to_object('ECID',arrays_to_objects('id',explode(ecids)))
source field is a calculated field that must be added using the Add calculated field option in the Platform UI. See the tutorial on adding calculated fields for more information.Next steps
By reading this document, you have gained insight on the mapping relationship between your Marketo datasets and their corresponding XDM fields. See the tutorial on creating a Marketo source connection to complete your Marketo dataflow.