Les tableaux ci-dessous contiennent les mappages entre les champs des neuf jeux de données Marketo et leurs champs de modèle de données d’expérience (XDM) correspondants.
Tous les jeux de données Marketo, sauf Activities
, prennent désormais isDeleted
en charge. Vos flux de données existants incluront automatiquement isDeleted
, mais n’ingèreront que l’indicateur pour les données nouvellement ingérées. Si vous souhaitez appliquer l’indicateur à toutes vos données historiques, vous devez arrêter vos flux de données existants et les recréer avec le nouveau mappage. Notez que si vous supprimez isDeleted
, vous n’aurez plus accès à la fonctionnalité. Il est essentiel que le mappage soit conservé une fois qu’il est automatiquement renseigné.
La source Marketo prend désormais en charge les activités standards supplémentaires. Pour utiliser des activités standards, vous devez mettre à jour votre schéma à l’aide de l’utilitaire de génération automatique de schéma, car si vous créez de nouveaux flux de données activities
sans mettre à jour votre schéma, les modèles de mappage échouent, car les nouveaux champs cibles ne seront pas présents dans votre schéma. Si vous choisissez de ne pas mettre à jour votre schéma, vous pouvez toujours créer un nouveau flux de données et ignorer les erreurs. Toutefois, les champs nouveaux ou mis à jour ne seront pas ingérés dans Platform.
Consultez la documentation relative à la classe d’événement d’expérience XDM pour plus d’informations sur la classe XDM et le ou les groupes de champs XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
_id |
_id |
|
"Marketo" |
personKey.sourceType |
|
"${MUNCHKIN_ID}" |
personKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
personID |
personKey.sourceID |
|
concat(personID,"@${MUNCHKIN_ID}.Marketo") |
personKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
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 |
Lisez la présentation de XDM Business Campaign pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez le guide groupe de champs de schéma des détails Business Campaign.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
campaignKey.sourceType |
|
"${MUNCHKIN_ID}" |
campaignKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
id |
campaignKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
campaignKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
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 |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
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 |
Lisez la présentation des membres XDM Business Campaign pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez le guide Groupe de champs de schéma des détails des membres XDM Business Campaign.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
campaignMemberKey.sourceType |
|
"${MUNCHKIN_ID}" |
campaignMemberKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
id |
campaignMemberKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
campaignMemberKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null) |
campaignKey |
Relation |
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) |
personKey |
Relation |
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 |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
sfdc.lastStatus |
lastStatus |
|
sfdc.hasResponded |
hasResponded |
|
sfdc.firstRespondedDate |
firstRespondedDate |
|
createdAt |
extSourceSystemAudit.createdDate |
|
updatedAt |
extSourceSystemAudit.lastUpdatedDate |
|
marketoIsDeleted |
isDeleted |
Lisez la présentation des comptes professionnels XDM pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
accountKey.sourceType |
|
"${MUNCHKIN_ID}" |
accountKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
concat(id, ".mkto_org") |
accountKey.sourceID |
|
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo") |
accountKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
|
extSourceSystemAudit.externalKey |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
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 |
Lisez la présentation de la liste XDM Business Marketing pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
marketingListKey.sourceType |
|
"${MUNCHKIN_ID}" |
marketingListKey.sourceInstanceID |
"${MUNCHKIN_ID}" sera remplacé dans le cadre de l’API Explore. |
id |
marketingListKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
marketingListKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
name |
marketingListName |
|
description |
marketingListDescription |
|
createdAt |
extSourceSystemAudit.createdDate |
|
updatedAt |
extSourceSystemAudit.lastUpdatedDate |
|
marketoIsDeleted |
isDeleted |
Lisez la Présentation des membres de la liste XDM Business Marketing pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
marketingListMemberKey.sourceType |
|
"${MUNCHKIN_ID}" |
marketingListMemberKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
staticListMemberID |
marketingListMemberKey.sourceID |
|
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo") |
marketingListMemberKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
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 |
Le jeu de données de comptes désignés n’est nécessaire qu’avec la fonctionnalité Account-based marketing (ABM) de Marketo. Si vous n’utilisez pas ABM, vous n’avez pas besoin de configurer des mappages pour les comptes désignés.
Lisez la Présentation des comptes professionnels XDM pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
accountKey.sourceType |
|
"${MUNCHKIN_ID}" |
accountKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
concat(id, ".mkto_acct") |
accountKey.sourceID |
|
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo") |
accountKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
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 |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
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 |
Lisez la Présentation des opportunités commerciales XDM pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
opportunityKey.sourceType |
|
"${MUNCHKIN_ID}" |
opportunityKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
id |
opportunityKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
opportunityKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
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 |
Identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
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 |
Relation |
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 |
Ce jeu de données source n’est disponible que pour les utilisateurs disposant de l’intégration Salesforce. |
lastActivityDate |
lastActivityDate |
|
leadSource |
leadSource |
|
nextStep |
nextStep |
|
marketoIsDeleted |
isDeleted |
Lisez la Présentation de la relation Personne-opportunité commerciale XDM pour plus d’informations sur la classe XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
opportunityPersonKey.sourceType |
|
"${MUNCHKIN_ID}" |
opportunityPersonKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
id |
opportunityPersonKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
opportunityPersonKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera remplacée dans le cadre de l’API Explorer. |
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 |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. Les valeurs de {CRM_ORG_ID} et {CRM_TYPE} seront automatiquement remplacées. |
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null) |
opportunityKey |
Relation |
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null) |
personKey |
Relation |
role |
personRole |
|
isPrimary |
isPrimary |
|
createdAt |
extSourceSystemAudit.createdDate |
|
updatedAt |
extSourceSystemAudit.lastUpdatedDate |
|
marketoIsDeleted |
isDeleted |
Lisez la Présentation du Profil individuel XDM pour plus d’informations sur la classe XDM. Pour plus d’informations sur les groupes de champs XDM, consultez les guides Groupe de champs de schéma Détails professionnels XDM et Groupe de champs de schéma Composants professionnels XDM.
Jeu de données source | Champ cible XDM | Notes |
---|---|---|
"Marketo" |
b2b.personKey.sourceType |
|
"${MUNCHKIN_ID}" |
b2b.personKey.sourceInstanceID |
La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
id |
b2b.personKey.sourceID |
|
concat(id,"@${MUNCHKIN_ID}.Marketo") |
b2b.personKey.sourceKey |
Identité principale. La valeur de "${MUNCHKIN_ID}" sera automatiquement remplacée. |
iif(unsubscribed == 'true', 'n', 'y' )) |
consents.marketing.email.val |
Si le désabonnement est true (par exemple, valeur = 1 ), définissez consents.marketing.email.val en tant que (n ). Si le désabonnement est false (par exemple, valeur = 0 ), définissez consents.marketing.email.val en tant que 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 |
Le champ extSourceSystemAudit.externalKey est l’identité secondaire. |
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 |
|
iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null) |
identityMap |
Il s’agit d’un champ calculé. |
marketoIsDeleted |
isDeleted |
|
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) |
b2b.convertedContactKey |
Il s’agit d’un champ calculé. |
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null) |
personComponents.sourceConvertedContactKey |
Il s’agit d’un champ calculé. |
Le champ source to_object('ECID',arrays_to_objects('id',explode(ecids)))
est un champ calculé qui doit être ajouté à l’aide de l’option Ajouter un champ calculé dans l’interface utilisateur de Platform. Voir le tutoriel sur l’ajout de champs calculés pour plus d’informations.
En lisant ce document, vous avez obtenu des informations sur la relation de mappage entre vos jeux de données Marketo et leurs champs XDM correspondants. Voir le tutoriel sur la création d’une Marketo connexion source pour terminer vos flux de données Marketo.