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 finden in 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.sourceInstanceIDleadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyactivityTypeIdeventTypeeventType- 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.sourceInstanceID"Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeycostactualCost.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 Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztintegrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.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.sourceInstanceIDidcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyiif(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 Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztsfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeletedFirmen companies
Weitere Informationen zur XDM-Klasse finden Sie in der Übersicht über XDM Business Account.
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDconcat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyiif(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.externalKeyextSourceSystemAudit.externalKey.sourceKey ist Sekundäre Identität. CRM_ORG_ID und CRM_TYPE werden als Teil der Explore-API ersetztcreatedAtextSourceSystemAudit.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.sourceInstanceIDidmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeynamemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.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.sourceInstanceIDstaticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyiif(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.sourceInstanceIDconcat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyiif(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 Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztcreatedAtextSourceSystemAudit.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.sourceInstanceIDidopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyiif(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 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)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.sourceInstanceID"Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeycreatedAtextSourceSystemAudit.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 Sekundäre Identität. CRM_TYPE und CRM_ORG_ID werden als Teil der Explore-API ersetztisPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.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.sourceInstanceID"Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeycountryworkAddress.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 sekundäre Identitätiif(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.valiif(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
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.