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.
TIP
All Marketo datasets except
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 Experience Platform.
Read the documentation on XDM Experience Event class for more information on the XDM Class and XDM Field Group(s).
NOTE
The
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) source field is a calculated field that must be added using the Add calculated field option in the Experience Platform UI. Read the tutorial on adding calculated fields for more information.Marketo source field
Activity type ID
Source dataset
XDM target field
Notes
_id_id_id"Marketo"personKey.sourceType"${MUNCHKIN_ID}"personKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
leadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyPrimary identity. MUNCHKIN_ID will be replaced as part of explore API
activityTypeIdeventTypeeventType- If the
activityTypeIdis 1, 2, 3, 9, 10, or 11 鈫 markproducedByas self. - If the
activityTypeIdis 6, 7, 8, 12, 21, 22, 24, 25, 27, 32, 34, 35, 36, 46, 101, 104, 110, 113, 114, or 115 鈫 markproducedByas system. - For all other values 鈫 mark
producedByas self.
producedByproducedByactivityDatetimestamptimestampattributes.Webpage URLweb.webPageDetails.URLweb.webPageDetails.URLattributes.User Agentenvironment.browserDetails.userAgentenvironment.browserDetails.userAgentattributes.Client IP Addressenvironment.ipV4environment.ipV4attributes.Search Querysearch.keywordssearch.keywordsattributes.Search Enginesearch.searchEnginesearch.searchEngineprimaryAttributeValue when activityTypeId = 11
web.webPageDetails.webPageIDweb.webPageDetails.webPageIDprimaryAttributeValue when activityTypeId = 11
web.webPageDetails.nameweb.webPageDetails.nameattributes.Personalized URL1
web.webPageDetails.isPersonalizedURLweb.webPageDetails.isPersonalizedURLattributes.Query Parameters1
web.webPageDetails.queryParametersweb.webPageDetails.queryParametersattributes.Referrer URLweb.webReferrer.URLweb.webReferrer.URLprimaryAttributeValueId when activityTypeId in (24, 25)24, 25
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.listKeyattributes.Is Primary34,35,36
opportunityEvent.isPrimaryopportunityEvent.isPrimaryprimaryAttributeValueId when activityTypeId in (34, 35, 36)
34, 35, 36
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.opportunityKeyattributes.Role34, 35, 36
opportunityEvent.roleopportunityEvent.roleattributes.Created DateleadOperation.newLead.createdDateleadOperation.newLead.createdDateattributes.Form NameleadOperation.newLead.formNameleadOperation.newLead.formNameattributes.Lead SourceleadOperation.newLead.leadSourceleadOperation.newLead.leadSourceattributes.List NameleadOperation.newLead.listNameleadOperation.newLead.listNameattributes.SFDC TypeleadOperation.newLead.sfdcTypeleadOperation.newLead.sfdcTypeattributes.Source TypeleadOperation.newLead.sourceTypeleadOperation.newLead.sourceTypeprimaryAttributeValue when activityTypeId = 21
21
leadOperation.convertLead.assignToleadOperation.convertLead.assignToattributes.Converted Status21
leadOperation.convertLead.convertedStatusleadOperation.convertLead.convertedStatusattributes.Send Notification Email21
leadOperation.convertLead.isSentNotificationEmailleadOperation.convertLead.isSentNotificationEmailprimaryAttributeValueId when activityTypeId in (7, 8, 9, 10, 11, 27)
7, 8, 9, 10, 11, 27
iif(${directMarketing\\.mailingID} != null && ${directMarketing\\.mailingID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${directMarketing\\.mailingID}, \"sourceKey\", concat(${directMarketing\\.mailingID},\"@${MUNCHKIN_ID}.Marketo\")), null)directMarketing.mailingKeyprimaryAttributeValueId when activityTypeId in (7, 8, 9, 10, 11, 27)
7, 8, 9, 10, 11, 27
directMarketing.mailingNamedirectMarketing.mailingNamedirectMarketing.testVariantNamedirectMarketing.testVariantNameattributes.Test VariantdirectMarketing.testVariantIDdirectMarketing.testVariantIDattributes.Subcategory
-
activityTypeId = 8
- 1099 鈫 MESSAGE BLOCKED
- 1003 鈫 SPAM BLOCKED ON SOURCE
- 1004 鈫 SPAM BLOCKED ON MESSAGE
- 2003 鈫 EMAIL ADDRESS INVALID
- 2001 鈫 EMAIL ADDRESS ERROR
- * 鈫 UNKNOWN REASON FOR BOUNCE
-
activityTypeId = 27
- 3999 鈫 MESSAGE NOT ACCEPTED
- 3001 鈫 MAILBOX FULL
- 3004 鈫 TIMEOUT OCCURRED
- 4003 鈫 DNS FAILURE
- 4002 鈫 MESSAGE TOO LARGE
- 4006 鈫 POLICY VIOLATION
- 4999 鈫 TRANSIENT FAILURE
- 9999 鈫 BAD RESPONSE RECEIVED
- * 鈫 UNKNOWN REASON FOR SOFT BOUNCE
8, 27
directMarketing.emailBouncedCodedirectMarketing.emailBouncedCodeattributes.DetailsdirectMarketing.emailBouncedDetailsdirectMarketing.emailBouncedDetailsattributes.EmaildirectMarketing.emaildirectMarketing.emailattributes.Is Mobile Devicedevice.isMobileDevicedevice.isMobileDeviceattributes.devicedevice.modeldevice.modelattributes.Platformenvironment.operatingSystemenvironment.operatingSystemattributes.LinkdirectMarketing.linkURLdirectMarketing.linkURLprimaryAttributeValueId when activityTypeId = 3 else attributes.Link ID
3
iif(${web\\.webInteraction\\.linkID} != null && ${web\\.webInteraction\\.linkID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.webInteraction\\.linkID}, \"sourceKey\", concat(${web\\.webInteraction\\.linkID},\"@${MUNCHKIN_ID}.Marketo\")), null)web.webInteraction.webInteractionKeyprimaryAttributeValueId when activityTypeId = 2 else attributes.Webform ID
2
iif(${web\\.fillOutForm\\.webFormID} != null && ${web\\.fillOutForm\\.webFormID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${web\\.fillOutForm\\.webFormID}, \"sourceKey\", concat(${web\\.fillOutForm\\.webFormID},\"@${MUNCHKIN_ID}.Marketo\")), null)web.fillOutForm.webFormKeyprimaryAttributeValueId when activityTypeId = 2 else null
2
web.fillOutForm.webFormNameweb.fillOutForm.webFormNameprimaryAttributeValueId when activityTypeId = 3 else attributes.Link
3
web.webInteraction.linkURLweb.webInteraction.linkURLattributes.Change Value22
leadOperation.changeScore.changeValueleadOperation.changeScore.changeValueattributes.New Value22
leadOperation.changeScore.newValueleadOperation.changeScore.newValueattributes.Old Value22
leadOperation.changeScore.oldValueleadOperation.changeScore.oldValueattributes.Priority22
leadOperation.changeScore.priorityleadOperation.changeScore.priorityattributes.Reason22
leadOperation.changeScore.reasonleadOperation.changeScore.reasonattributes.Relative Score22
leadOperation.changeScore.relativeScoreleadOperation.changeScore.relativeScoreattributes.Relative Urgency22
leadOperation.changeScore.relativeUrgencyleadOperation.changeScore.relativeUrgencyprimaryAttributeValueId when activityTypeId = 22
22
iif(${leadOperation\.changeScore\.scoreAttributeID} != null && ${leadOperation\.changeScore\.scoreAttributeID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeScore\.scoreAttributeID}, "sourceKey", concat(${leadOperation\.changeScore\.scoreAttributeID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeScore.scoreAttributeKeyprimaryAttributeValueId when activityTypeId = 22
22
leadOperation.changeScore.scoreAttributeNameleadOperation.changeScore.scoreAttributeNameattributes.Urgency22
leadOperation.changeScore.urgencyleadOperation.changeScore.urgencyattributes.Data Value Changesjson_to_object(${opportunityEvent\.dataValueChanges})opportunityEvent.dataValueChangesprimaryAttributeValueId when activityTypeId = 104
104
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.campaignKeyattributes.Acquired By104
leadOperation.campaignProgression.isAcquiredByleadOperation.campaignProgression.isAcquiredByattributes.Success104
leadOperation.campaignProgression.isSuccessfulleadOperation.campaignProgression.isSuccessfulattributes.New Status ID104
leadOperation.campaignProgression.newStatusIDleadOperation.campaignProgression.newStatusIDattributes.New Status104
leadOperation.campaignProgression.newStatusNameleadOperation.campaignProgression.newStatusNameattributes.Old Status ID104
leadOperation.campaignProgression.oldStatusIDleadOperation.campaignProgression.oldStatusIDattributes.Old Status104
leadOperation.campaignProgression.oldStatusNameleadOperation.campaignProgression.oldStatusNameattributes.Reason104
leadOperation.campaignProgression.reasonleadOperation.campaignProgression.reasonattributes.Date46
leadOperation.interestingMoment.dateleadOperation.interestingMoment.dateattributes.Description46
leadOperation.interestingMoment.descriptionleadOperation.interestingMoment.descriptionattributes.Source46
leadOperation.interestingMoment.sourceleadOperation.interestingMoment.sourceprimaryAttributeValue when activityTypeId = 46
46
leadOperation.interestingMoment.typeleadOperation.interestingMoment.typeprimaryAttributeValueId when activityTypeId = 110
110
iif(${leadOperation\\.callWebhook\\.webhookID} != null && ${leadOperation\\.callWebhook\\.webhookID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.callWebhook\\.webhookID}, \"sourceKey\", concat(${leadOperation\\.callWebhook\\.webhookID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.callWebhook.webhookKeyprimaryAttributeValueId when activityTypeId = 110
110
leadOperation.callWebhook.webhookNameleadOperation.callWebhook.webhookNameattributes.Error Type110
leadOperation.callWebhook.responseCodeleadOperation.callWebhook.responseCodeprimaryAttributeValueId when activityTypeId = 115
115
iif(${leadOperation\\.changeCampaignCadence\\.campaignID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.changeCampaignCadence.campaignKeyattributes.New Nurture Cadence115
leadOperation.changeCampaignCadence.newCadenceleadOperation.changeCampaignCadence.newCadenceattributes.Previous Nurture Cadence115
leadOperation.changeCampaignCadence.previousCadenceleadOperation.changeCampaignCadence.previousCadenceprimaryAttributeValueId when activityTypeId = 114
113
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.campaignKeyattributes.Track ID113
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.streamKeyattributes.Stream Name113
leadOperation.addToCampaign.streamNameleadOperation.addToCampaign.streamNameprimaryAttributeValueId when activityTypeId = 115
115
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.campaignKeyattributes.New Track ID115
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.newStreamKeyattributes.New Track Name115
leadOperation.changeCampaignStream.newStreamNameleadOperation.changeCampaignStream.newStreamNameattributes.Previous Track ID115
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.previousStreamKeyattributes.Previous Stream Name115
leadOperation.changeCampaignStream.previousStreamNameleadOperation.changeCampaignStream.previousStreamNameprimaryAttributeValueId when activityTypeId = 101
101
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.modelKeyprimaryAttributeValueId when activityTypeId = 101
101
leadOperation.changeRevenueStage.modelNameleadOperation.changeRevenueStage.modelNameattributes.New Stage ID101
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.newStageKeyattributes.New Stage101
leadOperation.changeRevenueStage.newStageNameleadOperation.changeRevenueStage.newStageNameattributes.Old Stage ID101
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.previousStageKeyattributes.Old Stage101
leadOperation.changeRevenueStage.previousStageNameleadOperation.changeRevenueStage.previousStageNameattributes.Reason101
leadOperation.changeRevenueStage.reasonleadOperation.changeRevenueStage.reasonattributes.Merge IDs when activityTypeId = 3232
json_to_object(${leadOperation\.mergeLeads\.mergeIDs})leadOperation.mergeLeads.sourceKeysattributes.Master Updated32
leadOperation.mergeLeads.targetUpdatedleadOperation.mergeLeads.targetUpdatedattributes.Merged in Sales32
leadOperation.mergeLeads.mergedInCRMleadOperation.mergeLeads.mergedInCRMattributes.Merge Source32
leadOperation.mergeLeads.mergeSourceleadOperation.mergeLeads.mergeSourceprimaryAttributeValueId when activityTypeId = 6
6
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.mailingKeyprimaryAttributeValueId when activityTypeId = 6
6
directMarketing.emailSent.mailingNamedirectMarketing.emailSent.mailingNameattributes.Test Variant6
directMarketing.emailSent.testVariantIDdirectMarketing.emailSent.testVariantIDNote - derived from secondary assets value
directMarketing.emailSent.testVariantNamedirectMarketing.emailSent.testVariantNameattributes.Campaign Run ID6
directMarketing.emailSent.automationRunIDdirectMarketing.emailSent.automationRunIDdirectMarketing.automationRunIDdirectMarketing.automationRunIDPrograms 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.
NOTE
For custom tag types, go to schemas and create new field groups. Then, add all the additional field names required to map the source fields with destination XDM fields.
Source dataset
XDM target field
Notes
"${MUNCHKIN_ID}"campaignKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
"Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
costactualCost.amountcreatedAtextSourceSystemAudit.createdDatedescriptioncampaignDescriptionendDatecampaignEndDateidcampaignKey.sourceIDiif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)parentCampaignKeyiif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_TYPE and CRM_ORG_ID will be replaced as part of explore APIintegrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.lastUpdatedDatewebinarHistorySyncDatewebinarHistorySyncDatewebinarHistorySyncStatuswebinarHistorySyncStatuswebinarSessionDescriptionwebinarSessionDescriptionwebinarSessionNamewebinarSessionNameProgram 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.
Source dataset
XDM target field
Notes
"Marketo"campaignMemberKey.sourceType"${MUNCHKIN_ID}"campaignMemberKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
idcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeyRelationship
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyRelationship
iif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)acquiredByCampaignKeyreachedSuccesshasReachedSuccessisExhaustedisExhaustedstatusNamememberStatusstatusReasonmemberStatusReasonmembershipDatemembershipDatenurtureCadencenurtureCadencetrackNamenurtureTrackNamewebinarUrlwebinarConfirmationUrlregistrationCodewebinarRegistrationIDreachedSuccessDatereachedSuccessDateiif(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.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_TYPE and CRM_ORG_ID will be replaced as part of explore APIsfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeletedCompanies companies
Read the XDM Business Account overview for more information on the XDM class.
Source dataset
XDM target field
Notes
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
concat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
iif(mktoCdpExternalId != null && mktoCdpExternalId != 鈥溾, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥, 鈥渟ourceID鈥, mktoCdpExternalId, 鈥渟ourceKey鈥, concat(mktoCdpExternalId,鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)iif(msftCdpExternalId != null && msftCdpExternalId != 鈥溾, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥, 鈥渟ourceID鈥, msftCdpExternalId, 鈥渟ourceKey鈥, concat(msftCdpExternalId,鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)
extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_ORG_ID and CRM_TYPE will be replaced as part of explore APIcreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatebillingCityaccountBillingAddress.citybillingCountryaccountBillingAddress.countrybillingPostalCodeaccountBillingAddress.postalCodebillingStateaccountBillingAddress.statebillingStreetaccountBillingAddress.street1annualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrynumberOfEmployeesaccountOrganization.numberOfEmployeeswebsiteaccountOrganization.websitemainPhoneaccountPhone.numbercompanyaccountNamecompanyNotesaccountDescriptionsiteaccountSiteiif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)accountParentKeymarketoIsDeletedisDeletedStatic lists static-lists
Read the XDM Business Marketing List overview for more information on the XDM class.
Source dataset
XDM target field
Notes
"Marketo"marketingListKey.sourceType"${MUNCHKIN_ID}"marketingListKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
idmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
namemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeletedStatic list memberships static-list-memberships
Read the XDM Business Marketing List Members overview for more information on the XDM Class.
Source dataset
XDM target field
Notes
"Marketo"marketingListMemberKey.sourceType"${MUNCHKIN_ID}"marketingListMemberKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
staticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)marketingListKeyRelationship
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)personKeyRelationship
createdAtextSourceSystemAudit.createdDatemarketoIsDeletedisDeletedNamed accounts named-accounts
IMPORTANT
The named accounts dataset is only necessary with Marketo鈥檚 account-based marketing (ABM) feature. If you are not using ABM, then you do not need to set up mappings for named accounts.
Read the XDM Business Account overview for more information on the XDM class.
Source dataset
XDM target field
Notes
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
concat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
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.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_TYPE and CRM_ORG_ID will be replaced as part of explore APIcreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatecityaccountBillingAddress.citycountryaccountBillingAddress.countrystateaccountBillingAddress.stateannualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrylogoUrlaccountOrganization.logoUrlnumberOfEmployeesaccountOrganization.numberOfEmployeesnameaccountNameiif(parentAccountId != null && parentAccountId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(parentAccountId, ".mkto_acct"), "sourceKey", concat(parentAccountId, ".mkto_acct@${MUNCHKIN_ID}.Marketo")), null)accountParentKeysourceTypeaccountSourceTypemarketoIsDeletedisDeletedOpportunities opportunities
Read the XDM Business Opportunity overview for more information on the XDM class.
Source dataset
XDM target field
Notes
"Marketo"opportunityKey.sourceType"${MUNCHKIN_ID}"opportunityKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
idopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
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.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_TYPE and CRM_ORG_ID will be replaced as part of explore APIiif(mktoCdpAccountOrgId != null && mktoCdpAccountOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpAccountOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpAccountOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)accountKeyRelationship
descriptionopportunityDescriptionnameopportunityNamestageopportunityStagetypeopportunityTypecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDateexpectedRevenueexpectedRevenue.amountamountopportunityAmount.amountcloseDateexpectedCloseDatefiscalQuarterfiscalQuarterfiscalYearfiscalYearforecastCategoryforecastCategoryforecastCategoryNameforecastCategoryNameisClosedisClosedisWonisWonquantityopportunityQuantityprobabilityprobabilityPercentageiif(mktoCdpSourceCampaignId != null && mktoCdpSourceCampaignId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpSourceCampaignId, "sourceKey", concat(mktoCdpSourceCampaignId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeyFor customers with Salesforce Integration only
lastActivityDatelastActivityDateleadSourceleadSourcenextStepnextStepmarketoIsDeletedisDeletedOpportunity contact roles opportunity-contact-roles
Read the XDM Business Opportunity Person Relation overview for more information on the XDM class.
Source dataset
XDM target field
Notes
"${MUNCHKIN_ID}"opportunityPersonKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
"Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
createdAtextSourceSystemAudit.createdDateidopportunityPersonKey.sourceIDiif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyRelationship
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)opportunityKeyRelationship
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.externalKeyextSourceSystemAudit.externalKey.sourceKey is Secondary Identity. CRM_TYPE and CRM_ORG_ID will be replaced as part of explore APIisPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.lastUpdatedDatePersons 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.
Source field
Target XDM field
Notes
"${MUNCHKIN_ID}"b2b.personKey.sourceInstanceIDMUNCHKIN_ID will be replaced as part of explore API
"Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeyPrimary Identity. MUNCHKIN_ID will be replaced as part of explore API
countryworkAddress.countrycreatedAtextSourceSystemAudit.createdDatedateOfBirthperson.birthDateemailpersonComponents.workEmail.addressemailworkEmail.addressfaxfaxPhone.numberfirstNameperson.name.firstNameidb2b.personKey.sourceIDiif(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.accountKeyiif(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.sourceAccountKeyiif(decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null) != null, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥,鈥渟ourceID鈥, decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null), 鈥渟ourceKey鈥, concat(decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null),鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)iif(decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null) != null, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥,鈥渟ourceID鈥, decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null), 鈥渟ourceKey鈥, concat(decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null),鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)
personComponents.sourceExternalKeyiif(decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null) != null, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥,鈥渟ourceID鈥, decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null), 鈥渟ourceKey鈥, concat(decode(sfdcType, 鈥淐ontact鈥, sfdcContactId, 鈥淟ead鈥, sfdcLeadId , null),鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)iif(decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null) != null, to_object(鈥渟ourceType鈥, 鈥${CRM_TYPE}鈥, 鈥渟ourceInstanceID鈥, 鈥${CRM_ORG_ID}鈥,鈥渟ourceID鈥, decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null), 鈥渟ourceKey鈥, concat(decode(msftType, 鈥淐ontact鈥, msftContactId, 鈥淟ead鈥, msftLeadId , null),鈥淍${CRM_ORG_ID}.${CRM_TYPE}鈥)), null)
extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey is secondary Identityiif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)identityMapThis is a calculated field
iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourcePersonKeyiif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)b2b.convertedContactKeyThis is a calculated field
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourceConvertedContactKeyThis is a calculated field
iif(unsubscribed == 'true', 'n', 'y' )consents.marketing.email.valIf unsubscribed is true (i.e. value = 1), then set consents.marketing.email.val as 鈥渘鈥. If unsubscribed is false (i.e. value = 0), then set consents.marketing.email.val as null
iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)consents.marketing.email.reasonlastNameperson.name.lastNameleadPartitionIdb2b.personGroupIDleadPartitionIdpersonComponents.personGroupIDleadScoreb2b.personScoreleadScorepersonComponents.personScoreleadSourceb2b.personSourceleadSourcepersonComponents.personSourceleadStatusb2b.personStatusleadStatuspersonComponents.personStatusmarketingSuspendedb2b.isMarketingSuspendedmarketingSuspendedCauseb2b.marketingSuspendedCausemarketoIsDeletedisDeletedmiddleNameperson.name.middleNamemktoCdpConvertedDateb2b.convertedDatemktoCdpIsConvertedb2b.isConvertedmobilePhonemobilePhone.numberpersonTypeb2b.personTypepersonTypepersonComponents.personTypephoneworkPhone.numberpostalCodeworkAddress.postalCodesalutationperson.name.courtesyTitlestateworkAddress.statetitleextendedWorkDetails.jobTitleupdatedAtextSourceSystemAudit.lastUpdatedDateNext 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.
recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089