Marketo Engage-Feldzuordnungen marketo-engage-field-mappings
Verwenden Sie die folgenden Tabellen, um zu sehen, wie die Felder in jedem Marketo Engage-Datensatz den entsprechenden Feldern des Experience-Datenmodells (XDM) zugeordnet werden.
Activities unterstützen isDeleted. Ihre vorhandenen Datenflüsse enthalten automatisch isDeleted, sie nehmen jedoch nur das Flag für neue Daten auf. Um das Flag auf Ihre historischen Daten anzuwenden, stoppen Sie Ihre vorhandenen Datenflüsse und erstellen Sie sie mit der neuen Zuordnung neu. Wenn Sie isDeleted entfernen, können Sie diese Funktion nicht mehr verwenden. isDeleted-Zuordnung nach dem automatischen Ausfüllen beibehalten.Aktivitäten activities
Die Marketo unterstützt zusätzliche Standardaktivitäten. Um Standardaktivitäten zu verwenden, aktualisieren Sie Ihr Schema mit Dienstprogramm zur automatischen Schemaerstellung . 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. Experience Platform nimmt jedoch keine neuen oder aktualisierten Felder auf.
Weitere Informationen zur XDM-Klasse und Feldergruppen finden Sie in der Übersicht über die XDM ExperienceEvent-Klasse .
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) ist ein berechnetes Feld. Fügen Sie sie mit der Option Berechnetes Feld hinzufügen in der Experience Platform-Benutzeroberfläche hinzu. Lesen Sie das Tutorial Hinzufügen berechneter Felder für weitere Informationen._id_id_id"Marketo"personKey.sourceType"${MUNCHKIN_ID}"personKey.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.leadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.activityTypeIdeventTypeeventType- Wenn die
activityTypeIdist 1, 2, 3, 9, 10 oder 11 → (hergestellt vonals Selbst. - Wenn die
activityTypeIdist 6, 7, 8, 12, 21, 22, 24, 25, 27, 32, 34, 35, 36, 46, 101, 104, 110, 113, 114 oder 115 → MarkePRODUCEDbyas system. - Für alle anderen Werte → “
” markierenals Selbst.
producedByproducedByactivityDatetimestamptimestampattributes.Webpage URLweb.webPageDetails.URLweb.webPageDetails.URLattributes.User Agentenvironment.browserDetails.userAgentenvironment.browserDetails.userAgentattributes.Client IP Addressenvironment.ipV4environment.ipV4attributes.Search Querysearch.keywordssearch.keywordsattributes.Search Enginesearch.searchEnginesearch.searchEngineprimaryAttributeValue when activityTypeId = 1web.webPageDetails.webPageIDweb.webPageDetails.webPageIDprimaryAttributeValue when activityTypeId = 1web.webPageDetails.nameweb.webPageDetails.nameattributes.Personalized URLweb.webPageDetails.isPersonalizedURLweb.webPageDetails.isPersonalizedURLattributes.Query Parametersweb.webPageDetails.queryParametersweb.webPageDetails.queryParametersattributes.Referrer URLweb.webReferrer.URLweb.webReferrer.URLprimaryAttributeValueId 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.listKeyattributes.Is PrimaryopportunityEvent.isPrimaryopportunityEvent.isPrimaryiif(${opportunityEvent\.opportunityID} != null && ${opportunityEvent\.opportunityID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${opportunityEvent\.opportunityID}, "sourceKey", concat(${opportunityEvent\.opportunityID},"@${MUNCHKIN_ID}.Marketo")), null)opportunityEvent.opportunityKeyattributes.RoleopportunityEvent.roleopportunityEvent.roleattributes.Created DateleadOperation.newLead.createdDateleadOperation.newLead.createdDateattributes.Form NameleadOperation.newLead.formNameleadOperation.newLead.formNameattributes.Lead SourceleadOperation.newLead.leadSourceleadOperation.newLead.leadSourceattributes.List NameleadOperation.newLead.listNameleadOperation.newLead.listNameattributes.SFDC TypeleadOperation.newLead.sfdcTypeleadOperation.newLead.sfdcTypeattributes.Source TypeleadOperation.newLead.sourceTypeleadOperation.newLead.sourceTypeleadOperation.convertLead.assignToleadOperation.convertLead.assignToattributes.Converted StatusleadOperation.convertLead.convertedStatusleadOperation.convertLead.convertedStatusattributes.Send Notification EmailleadOperation.convertLead.isSentNotificationEmailleadOperation.convertLead.isSentNotificationEmailiif(${directMarketing\\.mailingID} != null && ${directMarketing\\.mailingID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${directMarketing\\.mailingID}, \"sourceKey\", concat(${directMarketing\\.mailingID},\"@${MUNCHKIN_ID}.Marketo\")), null)directMarketing.mailingKeydirectMarketing.mailingNamedirectMarketing.mailingNamedirectMarketing.testVariantNamedirectMarketing.testVariantNameattributes.Test VariantdirectMarketing.testVariantIDdirectMarketing.testVariantIDattributes.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.emailBouncedCodedirectMarketing.emailBouncedCodeattributes.DetailsdirectMarketing.emailBouncedDetailsdirectMarketing.emailBouncedDetailsattributes.EmaildirectMarketing.emaildirectMarketing.emailattributes.Is Mobile Devicedevice.isMobileDevicedevice.isMobileDeviceattributes.devicedevice.modeldevice.modelattributes.Platformenvironment.operatingSystemenvironment.operatingSystemattributes.LinkdirectMarketing.linkURLdirectMarketing.linkURLiif(${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.webInteractionKeyiif(${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.webFormKeyweb.fillOutForm.webFormNameweb.fillOutForm.webFormNameweb.webInteraction.linkURLweb.webInteraction.linkURLattributes.Change ValueleadOperation.changeScore.changeValueleadOperation.changeScore.changeValueattributes.New ValueleadOperation.changeScore.newValueleadOperation.changeScore.newValueattributes.Old ValueleadOperation.changeScore.oldValueleadOperation.changeScore.oldValueattributes.PriorityleadOperation.changeScore.priorityleadOperation.changeScore.priorityattributes.ReasonleadOperation.changeScore.reasonleadOperation.changeScore.reasonattributes.Relative ScoreleadOperation.changeScore.relativeScoreleadOperation.changeScore.relativeScoreattributes.Relative UrgencyleadOperation.changeScore.relativeUrgencyleadOperation.changeScore.relativeUrgencyiif(${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.scoreAttributeKeyleadOperation.changeScore.scoreAttributeNameleadOperation.changeScore.scoreAttributeNameattributes.UrgencyleadOperation.changeScore.urgencyleadOperation.changeScore.urgencyattributes.Data Value Changesjson_to_object(${opportunityEvent\.dataValueChanges})opportunityEvent.dataValueChangesiif(${leadOperation\.campaignProgression\.campaignID} != null && ${leadOperation\.campaignProgression\.campaignID} != "" , to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", ${leadOperation\.campaignProgression\.campaignID}, "sourceKey", concat(${leadOperation\.campaignProgression\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.campaignProgression.campaignKeyattributes.Acquired ByleadOperation.campaignProgression.isAcquiredByleadOperation.campaignProgression.isAcquiredByattributes.SuccessleadOperation.campaignProgression.isSuccessfulleadOperation.campaignProgression.isSuccessfulattributes.New Status IDleadOperation.campaignProgression.newStatusIDleadOperation.campaignProgression.newStatusIDattributes.New StatusleadOperation.campaignProgression.newStatusNameleadOperation.campaignProgression.newStatusNameattributes.Old Status IDleadOperation.campaignProgression.oldStatusIDleadOperation.campaignProgression.oldStatusIDattributes.Old StatusleadOperation.campaignProgression.oldStatusNameleadOperation.campaignProgression.oldStatusNameattributes.ReasonleadOperation.campaignProgression.reasonleadOperation.campaignProgression.reasonattributes.DateleadOperation.interestingMoment.dateleadOperation.interestingMoment.dateattributes.DescriptionleadOperation.interestingMoment.descriptionleadOperation.interestingMoment.descriptionattributes.SourceleadOperation.interestingMoment.sourceleadOperation.interestingMoment.sourceleadOperation.interestingMoment.typeleadOperation.interestingMoment.typeiif(${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.webhookKeyleadOperation.callWebhook.webhookNameleadOperation.callWebhook.webhookNameattributes.Error TypeleadOperation.callWebhook.responseCodeleadOperation.callWebhook.responseCodeiif(${leadOperation\\.changeCampaignCadence\\.campaignID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.changeCampaignCadence.campaignKeyattributes.New Nurture CadenceleadOperation.changeCampaignCadence.newCadenceleadOperation.changeCampaignCadence.newCadenceattributes.Previous Nurture CadenceleadOperation.changeCampaignCadence.previousCadenceleadOperation.changeCampaignCadence.previousCadenceiif(${leadOperation\.addToCampaign\.campaignID} != null && ${leadOperation\.addToCampaign\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.campaignID}, "sourceKey", concat(${leadOperation\.addToCampaign\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.addToCampaign.campaignKeyattributes.Track IDiif(${leadOperation\.addToCampaign\.streamID} != null && ${leadOperation\.addToCampaign\.streamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.streamID}, "sourceKey", concat(${leadOperation\.addToCampaign\.streamID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.addToCampaign.streamKeyattributes.Stream NameleadOperation.addToCampaign.streamNameleadOperation.addToCampaign.streamNameiif(${leadOperation\.changeCampaignStream\.campaignID} != null && ${leadOperation\.changeCampaignStream\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.campaignID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeCampaignStream.campaignKeyattributes.New Track IDiif(${leadOperation\.changeCampaignStream\.newStreamID} != null && ${leadOperation\.changeCampaignStream\.newStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.newStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.newStreamID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeCampaignStream.newStreamKeyattributes.New Track NameleadOperation.changeCampaignStream.newStreamNameleadOperation.changeCampaignStream.newStreamNameattributes.Previous Track IDiif(${leadOperation\.changeCampaignStream\.previousStreamID} != null && ${leadOperation\.changeCampaignStream\.previousStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.previousStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.previousStreamID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeCampaignStream.previousStreamKeyattributes.Previous Stream NameleadOperation.changeCampaignStream.previousStreamNameleadOperation.changeCampaignStream.previousStreamNameiif(${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.modelKeyleadOperation.changeRevenueStage.modelNameleadOperation.changeRevenueStage.modelNameattributes.New Stage IDiif(${leadOperation\.changeRevenueStage\.newStageID} != null && ${leadOperation\.changeRevenueStage\.newStageID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeRevenueStage\.newStageID}, "sourceKey", concat(${leadOperation\.changeRevenueStage\.newStageID},"@${MUNCHKIN_ID}.Marketo")), null)leadOperation.changeRevenueStage.newStageKeyattributes.New StageleadOperation.changeRevenueStage.newStageNameleadOperation.changeRevenueStage.newStageNameattributes.Old Stage IDiif(${leadOperation\\.changeRevenueStage\\.previousStageID} != null && ${leadOperation\\.changeRevenueStage\\.previousStageID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${leadOperation\\.changeRevenueStage\\.previousStageID}, \"sourceKey\", concat(${leadOperation\\.changeRevenueStage\\.previousStageID},\"@${MUNCHKIN_ID}.Marketo\")), null)leadOperation.changeRevenueStage.previousStageKeyattributes.Old StageleadOperation.changeRevenueStage.previousStageNameleadOperation.changeRevenueStage.previousStageNameattributes.ReasonleadOperation.changeRevenueStage.reasonleadOperation.changeRevenueStage.reasonattributes.Merge IDs wenn activityTypeId = 32json_to_object(${leadOperation\.mergeLeads\.mergeIDs})leadOperation.mergeLeads.sourceKeysattributes.Master UpdatedleadOperation.mergeLeads.targetUpdatedleadOperation.mergeLeads.targetUpdatedattributes.Merged in SalesleadOperation.mergeLeads.mergedInCRMleadOperation.mergeLeads.mergedInCRMattributes.Merge SourceleadOperation.mergeLeads.mergeSourceleadOperation.mergeLeads.mergeSourceiif(${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.mailingKeydirectMarketing.emailSent.mailingNamedirectMarketing.emailSent.mailingNameattributes.Test VariantdirectMarketing.emailSent.testVariantIDdirectMarketing.emailSent.testVariantIDdirectMarketing.emailSent.testVariantNamedirectMarketing.emailSent.testVariantNameattributes.Campaign Run IDdirectMarketing.emailSent.automationRunIDdirectMarketing.emailSent.automationRunIDdirectMarketing.automationRunIDdirectMarketing.automationRunIDProgramme 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.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID."Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.costactualCost.amountcreatedAtextSourceSystemAudit.createdDatedescriptioncampaignDescriptionendDatecampaignEndDateidcampaignKey.sourceIDiif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)parentCampaignKeyiif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.integrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.lastUpdatedDatewebinarHistorySyncDatewebinarHistorySyncDatewebinarHistorySyncStatuswebinarHistorySyncStatuswebinarSessionDescriptionwebinarSessionDescriptionwebinarSessionNamewebinarSessionNameProgrammmitgliedschaften 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.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.idcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeyiif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyiif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)acquiredByCampaignKeyreachedSuccesshasReachedSuccessisExhaustedisExhaustedstatusNamememberStatusstatusReasonmemberStatusReasonmembershipDatemembershipDatenurtureCadencenurtureCadencetrackNamenurtureTrackNamewebinarUrlwebinarConfirmationUrlregistrationCodewebinarRegistrationIDreachedSuccessDatereachedSuccessDateiif(sfdc.crmId != null && sfdc.crmId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", sfdc.crmId, "sourceKey", concat(sfdc.crmId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.sfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeletedFirmen companies
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Account.
accountKey.sourceKey wird an jede Konto-ID ein .mkto_org angehängt. Dieses Format ist nicht mit dem Marketo Measure-Ziel kompatibel, das das .mkto_org Suffix nicht unterstützt. Wenn Sie beabsichtigen, diese Daten nach Marketo Measure zu exportieren, entfernen Sie das .mkto_org Suffix aus allen Kontoschlüsselfeldern, bevor Sie die Daten aufnehmen. Die Liste der zu aktualisierenden Felder 🔗 Sie in den Formatanforderungen für den Marketo Measure-Kontoschlüssel."Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.concat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.iif(mktoCdpExternalId != null && mktoCdpExternalId != “”, to_object(„sourceType“, “${CRM_TYPE}”, „sourceInstanceID“, “${CRM_ORG_ID}”, „sourceID“, mktoCdpExternalId, „sourceKey“, concat(mktoCdpExternalId,“@${CRM_ORG_ID}.${CRM_TYPE}„)), null)iif(msftCdpExternalId != null && msftCdpExternalId != “”, to_object(„sourceType“, “${CRM_TYPE}”, „sourceInstanceID“, “${CRM_ORG_ID}”, „sourceID“, msftCdpExternalId, „sourceKey“, concat(msftCdpExternalId,“@${CRM_ORG_ID}.${CRM_TYPE}„)), null)
extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.createdAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatebillingCityaccountBillingAddress.citybillingCountryaccountBillingAddress.countrybillingPostalCodeaccountBillingAddress.postalCodebillingStateaccountBillingAddress.statebillingStreetaccountBillingAddress.street1annualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrynumberOfEmployeesaccountOrganization.numberOfEmployeeswebsiteaccountOrganization.websitemainPhoneaccountPhone.numbercompanyaccountNamecompanyNotesaccountDescriptionsiteaccountSiteiif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)accountParentKeymarketoIsDeletedisDeletedStatische Listen static-lists
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht zu XDM Business Marketing List.
"Marketo"marketingListKey.sourceType"${MUNCHKIN_ID}"marketingListKey.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.idmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.namemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeletedZugehö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.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.staticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)marketingListKeyiif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)personKeycreatedAtextSourceSystemAudit.createdDatemarketoIsDeletedisDeletedBenannte Konten named-accounts
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Account.
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.concat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.iif(crmGuid != null && crmGuid != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", crmGuid, "sourceKey", concat(crmGuid,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.createdAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatecityaccountBillingAddress.citycountryaccountBillingAddress.countrystateaccountBillingAddress.stateannualRevenueaccountOrganization.annualRevenue.amountsicCodeaccountOrganization.SICCodeindustryaccountOrganization.industrylogoUrlaccountOrganization.logoUrlnumberOfEmployeesaccountOrganization.numberOfEmployeesnameaccountNameiif(parentAccountId != null && parentAccountId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(parentAccountId, ".mkto_acct"), "sourceKey", concat(parentAccountId, ".mkto_acct@${MUNCHKIN_ID}.Marketo")), null)accountParentKeysourceTypeaccountSourceTypemarketoIsDeletedisDeletedOpportunitys opportunities
Weitere Informationen zur XDM-Klasse finden Sie in der XDM Business Opportunity-Übersicht.
"Marketo"opportunityKey.sourceType"${MUNCHKIN_ID}"opportunityKey.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.idopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.iif(externalOpportunityId != null && externalOpportunityId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", externalOpportunityId, "sourceKey", concat(externalOpportunityId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.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)accountKeydescriptionopportunityDescriptionnameopportunityNamestageopportunityStagetypeopportunityTypecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDateexpectedRevenueexpectedRevenue.amountamountopportunityAmount.amountcloseDateexpectedCloseDatefiscalQuarterfiscalQuarterfiscalYearfiscalYearforecastCategoryforecastCategoryforecastCategoryNameforecastCategoryNameisClosedisClosedisWonisWonquantityopportunityQuantityprobabilityprobabilityPercentageiif(mktoCdpSourceCampaignId != null && mktoCdpSourceCampaignId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpSourceCampaignId, "sourceKey", concat(mktoCdpSourceCampaignId,"@${MUNCHKIN_ID}.Marketo")), null)campaignKeylastActivityDatelastActivityDateleadSourceleadSourcenextStepnextStepmarketoIsDeletedisDeletedRollen 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.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID."Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.createdAtextSourceSystemAudit.createdDateidopportunityPersonKey.sourceIDiif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)personKeyiif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)opportunityKeyiif(mktoCdpSfdcId != null && mktoCdpSfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", mktoCdpSfdcId, "sourceKey", concat(mktoCdpSfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität. Die Explore-API ersetzt CRM_TYPE und CRM_ORG_ID durch Ihren CRM-Typ und Ihre CRM-Organisations-ID.isPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.lastUpdatedDatePersonen 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.sourceInstanceIDMUNCHKIN_ID durch Ihre Marketo Munchkin-ID."Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeyMUNCHKIN_ID durch Ihre Marketo Munchkin-ID.countryworkAddress.countrycreatedAtextSourceSystemAudit.createdDatedateOfBirthperson.birthDateemailpersonComponents.workEmail.addressemailworkEmail.addressfaxfaxPhone.numberfirstNameperson.name.firstNameidb2b.personKey.sourceIDiif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)b2b.accountKeyiif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourceAccountKeyiif(decode(sfdcType, „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.sourceExternalKeyiif(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.externalKeyextSourceSystemAudit.externalKey.sourceKey ist eine sekundäre Identität.iif(ecids != null, to_object('ECID',arrays_to_objects('id',explode(ecids))), null)identityMapiif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourcePersonKeyiif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)b2b.convertedContactKeyiif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", mktoCdpCnvContactPersonId, "sourceKey", concat(mktoCdpCnvContactPersonId,"@${MUNCHKIN_ID}.Marketo")), null)personComponents.sourceConvertedContactKeyiif(unsubscribed == 'true', 'n', 'y' )consents.marketing.email.valunsubscribed „true“ ist (Wert 1), wird consents.marketing.email.val auf n gesetzt. Wenn unsubscribed den Wert „false“ (Wert "0„) hat, wird consents.marketing.email.val auf null gesetzt.iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)consents.marketing.email.reasonlastNameperson.name.lastNameleadPartitionIdb2b.personGroupIDleadPartitionIdpersonComponents.personGroupIDleadScoreb2b.personScoreleadScorepersonComponents.personScoreleadSourceb2b.personSourceleadSourcepersonComponents.personSourceleadStatusb2b.personStatusleadStatuspersonComponents.personStatusmarketingSuspendedb2b.isMarketingSuspendedmarketingSuspendedCauseb2b.marketingSuspendedCausemarketoIsDeletedisDeletedmiddleNameperson.name.middleNamemktoCdpConvertedDateb2b.convertedDatemktoCdpIsConvertedb2b.isConvertedmobilePhonemobilePhone.numberpersonTypeb2b.personTypepersonTypepersonComponents.personTypephoneworkPhone.numberpostalCodeworkAddress.postalCodesalutationperson.name.courtesyTitlestateworkAddress.statetitleextendedWorkDetails.jobTitleupdatedAtextSourceSystemAudit.lastUpdatedDateNächste Schritte next-steps
Sie wissen jetzt, wie die Felder in Ihren Marketo Datensätzen ihren entsprechenden XDM-Feldern zugeordnet sind. Um Ihren Marketo Datenfluss abzuschließen, lesen Sie das Tutorial zum Erstellen einer Marketo-Quellverbindung.