The tables below contain the mappings between the fields in the nine Marketo datasets and their corresponding Experience Data Model (XDM) fields.
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.
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.
Read the documentation on XDM Experience Event class for more information on the XDM Class and XDM Field Group(s).
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.
Source dataset | XDM target field | Notes |
---|---|---|
_id |
_id |
|
"Marketo" |
personKey.sourceType |
|
"${MUNCHKIN_ID}" |
personKey.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
personID |
personKey.sourceID |
|
concat(personID,"@${MUNCHKIN_ID}.Marketo") |
personKey.sourceKey |
Primary identity. The value for "${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 |
|
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) |
identityMap |
This is a calculated field. |
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.
Source dataset | XDM target field | Notes |
---|---|---|
"Marketo" |
campaignKey.sourceType |
|
"${MUNCHKIN_ID}" |
campaignKey.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
id |
campaignKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
campaignKey.sourceKey |
Primary identity. The value for "${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 |
The 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 |
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.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
id |
campaignMemberKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
campaignMemberKey.sourceKey |
Primary identity. The value for "${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 |
Relationship |
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) |
personKey |
Relationship |
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 |
The 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 |
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.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
concat(id, ".mkto_org") |
accountKey.sourceID |
|
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo") |
accountKey.sourceKey |
Primary identity. The value for "${MUNCHKIN_ID}" will be automatically replaced. |
|
extSourceSystemAudit.externalKey |
The 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 |
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.sourceInstanceID |
"${MUNCHKIN_ID}" will be replaced as part of Explore API. |
id |
marketingListKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
marketingListKey.sourceKey |
Primary identity. The value for "${MUNCHKIN_ID}" will be automatically replaced. |
name |
marketingListName |
|
description |
marketingListDescription |
|
createdAt |
extSourceSystemAudit.createdDate |
|
updatedAt |
extSourceSystemAudit.lastUpdatedDate |
|
marketoIsDeleted |
isDeleted |
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.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
staticListMemberID |
marketingListMemberKey.sourceID |
|
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo") |
marketingListMemberKey.sourceKey |
Primary identity. The value for "${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 |
Relation |
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null) |
personKey |
Relation |
createdAt |
extSourceSystemAudit.createdDate |
|
marketoIsDeleted |
isDeleted |
The named accounts dataset is only necessary with Marketo’s 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.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
concat(id, ".mkto_acct") |
accountKey.sourceID |
|
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo") |
accountKey.sourceKey |
Primary identity. The value for "${MUNCHKIN_ID}" will be automatically replaced. |
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 |
The 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 |
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.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
id |
opportunityKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
opportunityKey.sourceKey |
Primary identity. The value for "${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 |
Secondary identity. The values for {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 |
Relationship |
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 |
This source dataset is only available to users with the Salesforce integration. |
lastActivityDate |
lastActivityDate |
|
leadSource |
leadSource |
|
nextStep |
nextStep |
|
marketoIsDeleted |
isDeleted |
Read the XDM Business Opportunity Person Relation overview for more information on the XDM class.
Source dataset | XDM target field | Notes |
---|---|---|
"Marketo" |
opportunityPersonKey.sourceType |
|
"${MUNCHKIN_ID}" |
opportunityPersonKey.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
id |
opportunityPersonKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
opportunityPersonKey.sourceKey |
Primary identity. The value for "${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 |
The 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 |
Relationship |
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) |
personKey |
Relationship |
role |
personRole |
|
isPrimary |
isPrimary |
|
createdAt |
extSourceSystemAudit.createdDate |
|
updatedAt |
extSourceSystemAudit.lastUpdatedDate |
|
marketoIsDeleted |
isDeleted |
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 dataset | XDM target field | Notes |
---|---|---|
"Marketo" |
b2b.personKey.sourceType |
|
"${MUNCHKIN_ID}" |
b2b.personKey.sourceInstanceID |
The value for "${MUNCHKIN_ID}" will be automatically replaced. |
id |
b2b.personKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
b2b.personKey.sourceKey |
Primary identity. The value for "${MUNCHKIN_ID}" will be automatically replaced. |
iif(unsubscribed == 'true', 'n', 'y' )) |
consents.marketing.email.val |
If unsubscribed is 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 |
|
|
extSourceSystemAudit.externalKey |
The 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 |
|
|
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 |
This 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.sourceConvertedContactKey |
This is a calculated field. |
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.