Marketo Engage-Feldzuordnungen marketo-engage-field-mappings
Die folgenden Tabellen enthalten die Zuordnungen zwischen den Feldern der neun Marketo-Datensätze und den zugehörigen Experience-Datenmodell (XDM)-Feldern.
Activities
unterstützen jetzt isDeleted
. Ihre vorhandenen Datenflüsse beinhalten automatisch isDeleted
, bei neu aufgenommenen Daten wird nur die Markierung aufgenommen. Wenn Sie die Markierung auf alle historischen Daten anwenden möchten, müssen Sie Ihre vorhandenen Datenflüsse stoppen und sie mit der neuen Zuordnung erneut erstellen. Beachten Sie Folgendes: Wenn Sie isDeleted
entfernen, haben Sie keinen Zugriff mehr auf die Funktion. Die Zuordnung muss beibehalten werden, nachdem sie automatisch ausgefüllt wurde.Aktivitäten activities
Die Marketo-Quelle unterstützt jetzt zusätzliche Standardaktivitäten. Um Standardaktivitäten zu verwenden, müssen Sie Ihr Schema mithilfe des Dienstprogramms zur automatischen Schemaerstellung aktualisieren, denn wenn Sie einen neuen activities
-Datenfluss erstellen, ohne Ihr Schema zu aktualisieren, schlagen die Zuordnungsvorlagen fehl, da die neuen Zielfelder nicht in Ihrem Schema vorhanden sind. Wenn Sie sich dafür entscheiden, Ihr Schema nicht zu aktualisieren, können Sie trotzdem einen neuen Datenfluss erstellen und etwaige Fehler ignorieren. Neue oder aktualisierte Felder werden jedoch nicht in Experience Platform aufgenommen.
Weitere Informationen zu den XDMKlassen und XDM-Feldergruppen findenin der Dokumentation zur XDM Experience Event-Klasse.
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)
Quellfeld ist ein berechnetes Feld, das mithilfe der Option Berechnetes Feld hinzufügen in der Experience Platform-Benutzeroberfläche hinzugefügt werden muss. Lesen Sie das Tutorial Hinzufügen berechneter Felder für weitere Informationen._id
_id
_id
"Marketo"
personKey.sourceType
"${MUNCHKIN_ID}"
personKey.sourceInstanceID
leadId
personID
personKey.sourceID
concat(personID,"@${MUNCHKIN_ID}.Marketo")
personKey.sourceKey
activityTypeId
eventType
eventType
- Wenn die
activityTypeId
ist 1, 2, 3, 9, 10 oder 11 → (hergestellt von
als Selbst. - Wenn die
activityTypeId
ist 6, 7, 8, 12, 21, 22, 24, 25, 27, 32, 34, 35, 36, 46, 101, 104, 110, 113, 114 oder 115 → MarkePRODUCEDby
as system. - Für alle anderen Werte → "
" markieren
als Selbst.
producedBy
producedBy
activityDate
timestamp
timestamp
attributes.Webpage URL
web.webPageDetails.URL
web.webPageDetails.URL
attributes.User Agent
environment.browserDetails.userAgent
environment.browserDetails.userAgent
attributes.Client IP Address
environment.ipV4
environment.ipV4
attributes.Search Query
search.keywords
search.keywords
attributes.Search Engine
search.searchEngine
search.searchEngine
primaryAttributeValue when activityTypeId = 1
web.webPageDetails.webPageID
web.webPageDetails.webPageID
primaryAttributeValue when activityTypeId = 1
web.webPageDetails.name
web.webPageDetails.name
attributes.Personalized URL
web.webPageDetails.isPersonalizedURL
web.webPageDetails.isPersonalizedURL
attributes.Query Parameters
web.webPageDetails.queryParameters
web.webPageDetails.queryParameters
attributes.Referrer URL
web.webReferrer.URL
web.webReferrer.URL
primaryAttributeValueId when activityTypeId in (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.listKey
attributes.Is Primary
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
attributes.Role
opportunityEvent.role
opportunityEvent.role
attributes.Created Date
leadOperation.newLead.createdDate
leadOperation.newLead.createdDate
attributes.Form Name
leadOperation.newLead.formName
leadOperation.newLead.formName
attributes.Lead Source
leadOperation.newLead.leadSource
leadOperation.newLead.leadSource
attributes.List Name
leadOperation.newLead.listName
leadOperation.newLead.listName
attributes.SFDC Type
leadOperation.newLead.sfdcType
leadOperation.newLead.sfdcType
attributes.Source Type
leadOperation.newLead.sourceType
leadOperation.newLead.sourceType
leadOperation.convertLead.assignTo
leadOperation.convertLead.assignTo
attributes.Converted Status
leadOperation.convertLead.convertedStatus
leadOperation.convertLead.convertedStatus
attributes.Send Notification Email
leadOperation.convertLead.isSentNotificationEmail
leadOperation.convertLead.isSentNotificationEmail
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.mailingKey
directMarketing.mailingName
directMarketing.mailingName
directMarketing.testVariantName
directMarketing.testVariantName
attributes.Test Variant
directMarketing.testVariantID
directMarketing.testVariantID
attributes.Subcategory
-
activityTypeId = 8
- 1099 → BLOCKIERT
- 1003 → SPAM AUF SOURCE GESPERRT
- 1004 → SPAM IN NACHRICHT GESPERRT
- E-MAIL-ADRESSE → 2003 UNGÜLTIG
- E-MAIL→ADRESSFEHLER 2001
- * → UNBEKANNTER GRUND FÜR EINEN BOUNCE
-
activityTypeId = 27
- 3999 → NICHT AKZEPTIERT
- 3001 → POSTFACH VOLL
- 3004 → TIMEOUT AUFGETRETEN
- 4003 → DNS-FEHLER
- 4002 → NACHRICHT ZU GROSS
- 4006 → RICHTLINIENVERLETZUNG
- 4999 → VORÜBERGEHENDER FEHLER
- 9999 → FEHLERHAFTE ANTWORT ERHALTEN
- * → UNBEKANNTER GRUND FÜR SOFTBOUNCE
directMarketing.emailBouncedCode
directMarketing.emailBouncedCode
attributes.Details
directMarketing.emailBouncedDetails
directMarketing.emailBouncedDetails
attributes.Email
directMarketing.email
directMarketing.email
attributes.Is Mobile Device
device.isMobileDevice
device.isMobileDevice
attributes.device
device.model
device.model
attributes.Platform
environment.operatingSystem
environment.operatingSystem
attributes.Link
directMarketing.linkURL
directMarketing.linkURL
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.webInteractionKey
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.webFormKey
web.fillOutForm.webFormName
web.fillOutForm.webFormName
web.webInteraction.linkURL
web.webInteraction.linkURL
attributes.Change Value
leadOperation.changeScore.changeValue
leadOperation.changeScore.changeValue
attributes.New Value
leadOperation.changeScore.newValue
leadOperation.changeScore.newValue
attributes.Old Value
leadOperation.changeScore.oldValue
leadOperation.changeScore.oldValue
attributes.Priority
leadOperation.changeScore.priority
leadOperation.changeScore.priority
attributes.Reason
leadOperation.changeScore.reason
leadOperation.changeScore.reason
attributes.Relative Score
leadOperation.changeScore.relativeScore
leadOperation.changeScore.relativeScore
attributes.Relative Urgency
leadOperation.changeScore.relativeUrgency
leadOperation.changeScore.relativeUrgency
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.scoreAttributeKey
leadOperation.changeScore.scoreAttributeName
leadOperation.changeScore.scoreAttributeName
attributes.Urgency
leadOperation.changeScore.urgency
leadOperation.changeScore.urgency
attributes.Data Value Changes
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
attributes.Acquired By
leadOperation.campaignProgression.isAcquiredBy
leadOperation.campaignProgression.isAcquiredBy
attributes.Success
leadOperation.campaignProgression.isSuccessful
leadOperation.campaignProgression.isSuccessful
attributes.New Status ID
leadOperation.campaignProgression.newStatusID
leadOperation.campaignProgression.newStatusID
attributes.New Status
leadOperation.campaignProgression.newStatusName
leadOperation.campaignProgression.newStatusName
attributes.Old Status ID
leadOperation.campaignProgression.oldStatusID
leadOperation.campaignProgression.oldStatusID
attributes.Old Status
leadOperation.campaignProgression.oldStatusName
leadOperation.campaignProgression.oldStatusName
attributes.Reason
leadOperation.campaignProgression.reason
leadOperation.campaignProgression.reason
attributes.Date
leadOperation.interestingMoment.date
leadOperation.interestingMoment.date
attributes.Description
leadOperation.interestingMoment.description
leadOperation.interestingMoment.description
attributes.Source
leadOperation.interestingMoment.source
leadOperation.interestingMoment.source
leadOperation.interestingMoment.type
leadOperation.interestingMoment.type
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.webhookKey
leadOperation.callWebhook.webhookName
leadOperation.callWebhook.webhookName
attributes.Error Type
leadOperation.callWebhook.responseCode
leadOperation.callWebhook.responseCode
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.campaignKey
attributes.New Nurture Cadence
leadOperation.changeCampaignCadence.newCadence
leadOperation.changeCampaignCadence.newCadence
attributes.Previous Nurture Cadence
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
attributes.Track ID
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
attributes.Stream Name
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
attributes.New Track ID
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
attributes.New Track Name
leadOperation.changeCampaignStream.newStreamName
leadOperation.changeCampaignStream.newStreamName
attributes.Previous Track ID
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
attributes.Previous Stream Name
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
attributes.New Stage ID
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
attributes.New Stage
leadOperation.changeRevenueStage.newStageName
leadOperation.changeRevenueStage.newStageName
attributes.Old Stage ID
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
attributes.Old Stage
leadOperation.changeRevenueStage.previousStageName
leadOperation.changeRevenueStage.previousStageName
attributes.Reason
leadOperation.changeRevenueStage.reason
leadOperation.changeRevenueStage.reason
attributes.Merge IDs
wenn activityTypeId = 32json_to_object(${leadOperation\.mergeLeads\.mergeIDs})
leadOperation.mergeLeads.sourceKeys
attributes.Master Updated
leadOperation.mergeLeads.targetUpdated
leadOperation.mergeLeads.targetUpdated
attributes.Merged in Sales
leadOperation.mergeLeads.mergedInCRM
leadOperation.mergeLeads.mergedInCRM
attributes.Merge Source
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
attributes.Test Variant
directMarketing.emailSent.testVariantID
directMarketing.emailSent.testVariantID
directMarketing.emailSent.testVariantName
directMarketing.emailSent.testVariantName
attributes.Campaign Run ID
directMarketing.emailSent.automationRunID
directMarketing.emailSent.automationRunID
directMarketing.automationRunID
directMarketing.automationRunID
Programme programs
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Campaign. Weitere Informationen zu den XDM-Feldergruppen finden Sie im Handbuch zur Schemafeldgruppe „Business Campaign Details“.
"${MUNCHKIN_ID}"
campaignKey.sourceInstanceID
"Marketo"
campaignKey.sourceType
channel
channelName
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignKey.sourceKey
cost
actualCost.amount
createdAt
extSourceSystemAudit.createdDate
description
campaignDescription
endDate
campaignEndDate
id
campaignKey.sourceID
iif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)
parentCampaignKey
iif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztintegrationPartner
integrationPartnerName
marketoIsDeleted
isDeleted
name
campaignName
startDate
campaignStartDate
status
campaignStatus
type
campaignType
updatedAt
extSourceSystemAudit.lastUpdatedDate
webinarHistorySyncDate
webinarHistorySyncDate
webinarHistorySyncStatus
webinarHistorySyncStatus
webinarSessionDescription
webinarSessionDescription
webinarSessionName
webinarSessionName
Programmmitgliedschaften program-memberships
Weitere Informationen zur XDM-Klasse finden Sie in der XDM Business Campaign Members-Übersicht. Weitere Informationen zu den XDM-Feldergruppen finden Sie im Handbuch zur Schemafeldgruppe „XDM Business Campaign Member Details“.
"Marketo"
campaignMemberKey.sourceType
"${MUNCHKIN_ID}"
campaignMemberKey.sourceInstanceID
id
campaignMemberKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
campaignMemberKey.sourceKey
iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
iif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)
acquiredByCampaignKey
reachedSuccess
hasReachedSuccess
isExhausted
isExhausted
statusName
memberStatus
statusReason
memberStatusReason
membershipDate
membershipDate
nurtureCadence
nurtureCadence
trackName
nurtureTrackName
webinarUrl
webinarConfirmationUrl
registrationCode
webinarRegistrationID
reachedSuccessDate
reachedSuccessDate
iif(sfdc.crmId != null && sfdc.crmId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdc.crmId, "sourceKey", concat(sfdc.crmId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztsfdc.lastStatus
lastStatus
sfdc.hasResponded
hasResponded
sfdc.firstRespondedDate
firstRespondedDate
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted
Firmen companies
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Account.
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
concat(id, ".mkto_org")
accountKey.sourceID
concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
iif(mktoCdpExternalId != null und& mktoCdpExternalId != "", to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}", „sourceID“, mktoCdpExternalId, „sourceKey“, concat(mktoCdpExternalId,“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
iif(msftCdpExternalId != null und& msftCdpExternalId != "", to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}", „sourceID“, msftCdpExternalId, „sourceKey“, concat(msftCdpExternalId,“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_ORG_ID und CRM_TYPE werden als Teil der Explore-API ersetztcreatedAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
billingCity
accountBillingAddress.city
billingCountry
accountBillingAddress.country
billingPostalCode
accountBillingAddress.postalCode
billingState
accountBillingAddress.state
billingStreet
accountBillingAddress.street1
annualRevenue
accountOrganization.annualRevenue.amount
sicCode
accountOrganization.SICCode
industry
accountOrganization.industry
numberOfEmployees
accountOrganization.numberOfEmployees
website
accountOrganization.website
mainPhone
accountPhone.number
company
accountName
companyNotes
accountDescription
site
accountSite
iif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
accountParentKey
marketoIsDeleted
isDeleted
Statische Listen static-lists
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht zu XDM Business Marketing List.
"Marketo"
marketingListKey.sourceType
"${MUNCHKIN_ID}"
marketingListKey.sourceInstanceID
id
marketingListKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
marketingListKey.sourceKey
name
marketingListName
description
marketingListDescription
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
marketoIsDeleted
isDeleted
Zugehörigkeiten zu statischen Listen static-list-memberships
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Marketing List Members.
"Marketo"
marketingListMemberKey.sourceType
"${MUNCHKIN_ID}"
marketingListMemberKey.sourceInstanceID
staticListMemberID
marketingListMemberKey.sourceID
concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")
marketingListMemberKey.sourceKey
iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)
marketingListKey
iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
createdAt
extSourceSystemAudit.createdDate
marketoIsDeleted
isDeleted
Benannte Konten named-accounts
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Account.
"Marketo"
accountKey.sourceType
"${MUNCHKIN_ID}"
accountKey.sourceInstanceID
concat(id, ".mkto_acct")
accountKey.sourceID
concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")
accountKey.sourceKey
iif(crmGuid != null && crmGuid != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", crmGuid, "sourceKey", concat(crmGuid,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztcreatedAt
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
Opportunitys opportunities
Weitere Informationen zur XDM-Klasse finden Sie in der XDM Business Opportunity-Übersicht.
"Marketo"
opportunityKey.sourceType
"${MUNCHKIN_ID}"
opportunityKey.sourceInstanceID
id
opportunityKey.sourceID
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityKey.sourceKey
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
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztiif(mktoCdpAccountOrgId != null && mktoCdpAccountOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpAccountOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpAccountOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
accountKey
description
opportunityDescription
name
opportunityName
stage
opportunityStage
type
opportunityType
createdAt
extSourceSystemAudit.createdDate
updatedAt
extSourceSystemAudit.lastUpdatedDate
expectedRevenue
expectedRevenue.amount
amount
opportunityAmount.amount
closeDate
expectedCloseDate
fiscalQuarter
fiscalQuarter
fiscalYear
fiscalYear
forecastCategory
forecastCategory
forecastCategoryName
forecastCategoryName
isClosed
isClosed
isWon
isWon
quantity
opportunityQuantity
probability
probabilityPercentage
iif(mktoCdpSourceCampaignId != null && mktoCdpSourceCampaignId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpSourceCampaignId, "sourceKey", concat(mktoCdpSourceCampaignId,"@${MUNCHKIN_ID}.Marketo")), null)
campaignKey
lastActivityDate
lastActivityDate
leadSource
leadSource
nextStep
nextStep
marketoIsDeleted
isDeleted
Rollen von Kontakten bei Opportunitys opportunity-contact-roles
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Opportunity Person Relation.
"${MUNCHKIN_ID}"
opportunityPersonKey.sourceInstanceID
"Marketo"
opportunityPersonKey.sourceType
concat(id,"@${MUNCHKIN_ID}.Marketo")
opportunityPersonKey.sourceKey
createdAt
extSourceSystemAudit.createdDate
id
opportunityPersonKey.sourceID
iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)
personKey
iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)
opportunityKey
iif(mktoCdpSfdcId != null && mktoCdpSfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", mktoCdpSfdcId, "sourceKey", concat(mktoCdpSfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztisPrimary
isPrimary
marketoIsDeleted
isDeleted
role
personRole
updatedAt
extSourceSystemAudit.lastUpdatedDate
Personen persons
Weitere Informationen zur XDM-Klasse finden Sie in der XDM Individual Profile-Übersicht. Mehr über XDM-Feldergruppen erfahren Sie im Handbuch zur Schemafeldgruppe „XDM-Geschäftspersonendetails“ und im Handbuch zur Schemafeldgruppe „XDM-Geschäftspersonenkomponenten“.
"${MUNCHKIN_ID}"
b2b.personKey.sourceInstanceID
"Marketo"
b2b.personKey.sourceType
address
workAddress.street1
city
workAddress.city
company
organizations
concat(id,"@${MUNCHKIN_ID}.Marketo")
b2b.personKey.sourceKey
country
workAddress.country
createdAt
extSourceSystemAudit.createdDate
dateOfBirth
person.birthDate
email
personComponents.workEmail.address
email
workEmail.address
fax
faxPhone.number
firstName
person.name.firstName
id
b2b.personKey.sourceID
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
iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourceAccountKey
iif(decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null) != null, to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}",„sourceID“, decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null), „sourceKey“, concat(decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null),“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
iif(decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null)!= null, to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}",„sourceID“, decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null), „sourceKey“, concat(decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null),“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
personComponents.sourceExternalKey
iif(decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null) != null, to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}",„sourceID“, decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null), „sourceKey“, concat(decode(sfdcType, „Contact“, sfdcContactId, „Lead“, sfdcLeadId , null),“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
iif(decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null)!= null, to_object(„sourceType“, "${CRM_TYPE}", „sourceInstanceID“, "${CRM_ORG_ID}",„sourceID“, decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null), „sourceKey“, concat(decode(msftType, „Contact“, msftContactId, „Lead“, msftLeadId , null),“@${CRM_ORG_ID}.${CRM_TYPE}„), null)
extSourceSystemAudit.externalKey
extSourceSystemAudit.externalKey.sourceKey
ist sekundäre Identitätiif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)
identityMap
iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourcePersonKey
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)
b2b.convertedContactKey
iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)
personComponents.sourceConvertedContactKey
iif(unsubscribed == 'true', 'n', 'y' )
consents.marketing.email.val
iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)
consents.marketing.email.reason
lastName
person.name.lastName
leadPartitionId
b2b.personGroupID
leadPartitionId
personComponents.personGroupID
leadScore
b2b.personScore
leadScore
personComponents.personScore
leadSource
b2b.personSource
leadSource
personComponents.personSource
leadStatus
b2b.personStatus
leadStatus
personComponents.personStatus
marketingSuspended
b2b.isMarketingSuspended
marketingSuspendedCause
b2b.marketingSuspendedCause
marketoIsDeleted
isDeleted
middleName
person.name.middleName
mktoCdpConvertedDate
b2b.convertedDate
mktoCdpIsConverted
b2b.isConverted
mobilePhone
mobilePhone.number
personType
b2b.personType
personType
personComponents.personType
phone
workPhone.number
postalCode
workAddress.postalCode
salutation
person.name.courtesyTitle
state
workAddress.state
title
extendedWorkDetails.jobTitle
updatedAt
extSourceSystemAudit.lastUpdatedDate
Nächste Schritte
Durch die Lektüre dieses Dokuments haben Sie Einblick in die Zuordnungsbeziehung zwischen Ihren Marketo-Datensätzen und den zugehörigen XDM-Feldern gewonnen. Lesen Sie das Tutorial zum Erstellen einer Marketo -Quellverbindung, um den Marketo-Datenfluss abzuschließen.