Marketo Engage フィールドマッピング marketo-engage-field-mappings
次の表を使用して、各Marketo Engage データセットのフィールドが、対応するExperience Data Model (XDM)フィールドにどのようにマッピングされるかを確認します。
Activitiesを除くすべてのMarketo データセットがisDeletedをサポートしています。 既存のデータフローには自動的にisDeletedが含まれますが、新しいデータのフラグのみを取り込みます。 過去のデータにフラグを適用するには、既存のデータフローを停止し、新しいマッピングで再作成します。 isDeletedを削除すると、この機能を使用できなくなります。 自動入力された後は、isDeleted マッピングを保持します。アクティビティ activities
Marketo ソースは、追加の標準アクティビティをサポートしています。 標準アクティビティを使用するには、 スキーマ自動生成ユーティリティ を使用してスキーマを更新します。 スキーマを更新せずに新しいactivities データフローを作成した場合、新しいターゲットフィールドがスキーマに含まれていないため、マッピングテンプレートが失敗します。 スキーマの更新を選択しない場合でも、新しいデータフローを作成しエラーを解除できます。 ただし、Experience Platformは新しいフィールドや更新されたフィールドを取り込みません。
XDM クラスとそのフィールドグループについて詳しくは、XDM ExperienceEvent クラスの概要を参照してください。
iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null) ソースフィールドは計算フィールドです。 Experience Platform UIの「計算フィールドを追加」オプションで追加します。 詳しくは、計算フィールドの追加に関するチュートリアルを参照してください。_id_id_id"Marketo"personKey.sourceType"${MUNCHKIN_ID}"personKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。leadIdpersonIDpersonKey.sourceIDconcat(personID,"@${MUNCHKIN_ID}.Marketo")personKey.sourceKeyMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。activityTypeIdeventTypeeventTypeactivityTypeIdがは、1、2、3、9、10、または11 → markproducedByです自分として。activityTypeIdがは6、7、8、12、21、22、24、25、27、32、34、35、36、46、101、104、110、113、114、または115 →マークproducedBysystemとして。- その他すべての値に対し→
producedByとマークします自分として。
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 → メッセージがブロックされました
- Sourceで1003 →のスパムブロック
- メッセージで1004 →のスパムブロック
- 2003 → メールアドレスが無効です
- 2001年→電子メールアドレスのエラー
- バウンスの理由が
→不明です
-
activityTypeId = 27
- 3999 → メッセージが受け入れられませんでした
- 3001 → メールボックスがいっぱいです
- 3004 → タイムアウトが発生しました
- 4003 → DNS エラー
- 4002 → メッセージが大きすぎます
- 4006 → ポリシー違反
- 4999 →一時的な障害
- 9999 →受信した応答が正しくありません
- → ソフトバウンスの原因が不明
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 IDsjson_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.automationRunIDプログラム programs
XDM クラスについて詳しくは、XDM ビジネスキャンペーンの概要を参照してください。 XDM フィールドグループについて詳しくは、ビジネスキャンペーン詳細スキーマフィールドグループガイドを参照してください。
"${MUNCHKIN_ID}"campaignKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。"Marketo"campaignKey.sourceTypechannelchannelNameconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織IDに置き換えます。integrationPartnerintegrationPartnerNamemarketoIsDeletedisDeletednamecampaignNamestartDatecampaignStartDatestatuscampaignStatustypecampaignTypeupdatedAtextSourceSystemAudit.lastUpdatedDatewebinarHistorySyncDatewebinarHistorySyncDatewebinarHistorySyncStatuswebinarHistorySyncStatuswebinarSessionDescriptionwebinarSessionDescriptionwebinarSessionNamewebinarSessionNameプログラムのメンバーシップ program-memberships
XDM クラスについて詳しくは、XDM ビジネスキャンペーンメンバーの概要を参照してください。 XDM フィールドグループについて詳しくは、XDM ビジネスキャンペーンメンバー詳細スキーマフィールドグループガイドを参照してください。
"Marketo"campaignMemberKey.sourceType"${MUNCHKIN_ID}"campaignMemberKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。idcampaignMemberKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")campaignMemberKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織IDに置き換えます。sfdc.lastStatuslastStatussfdc.hasRespondedhasRespondedsfdc.firstRespondedDatefirstRespondedDatecreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted会社 companies
XDM クラスについて詳しくは、XDM ビジネスアカウントの概要を参照してください。
accountKey.sourceKeyのデフォルトマッピングでは、各アカウント IDに.mkto_org接尾辞が追加されます。 この形式は、.mkto_org接尾辞をサポートしていないMarketo Measure宛先と互換性がありません。 このデータをMarketo Measureにエクスポートする場合は、データを取り込む前に、すべてのアカウントキーフィールドから.mkto_org サフィックスを削除してください。 更新するフィールドのリストについては、Marketo Measure アカウントキーのフォーマット要件を参照してください。"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。concat(id, ".mkto_org")accountKey.sourceIDconcat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織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)accountParentKeymarketoIsDeletedisDeleted静的リスト static-lists
XDM クラスについて詳しくは、XDM ビジネスマーケティングリストの概要を参照してください。
"Marketo"marketingListKey.sourceType"${MUNCHKIN_ID}"marketingListKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。idmarketingListKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")marketingListKey.sourceKeyMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。namemarketingListNamedescriptionmarketingListDescriptioncreatedAtextSourceSystemAudit.createdDateupdatedAtextSourceSystemAudit.lastUpdatedDatemarketoIsDeletedisDeleted静的リストのメンバーシップ static-list-memberships
XDM クラスについて詳しくは、XDM ビジネスマーケティングリストメンバーの概要を参照してください。
"Marketo"marketingListMemberKey.sourceType"${MUNCHKIN_ID}"marketingListMemberKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。staticListMemberIDmarketingListMemberKey.sourceIDconcat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")marketingListMemberKey.sourceKeyMUNCHKIN_IDを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.createdDatemarketoIsDeletedisDeleted重点アカウント named-accounts
XDM クラスについて詳しくは、XDM ビジネスアカウントの概要を参照してください。
"Marketo"accountKey.sourceType"${MUNCHKIN_ID}"accountKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。concat(id, ".mkto_acct")accountKey.sourceIDconcat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")accountKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織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)accountParentKeysourceTypeaccountSourceTypemarketoIsDeletedisDeleted商談 opportunities
XDM クラスについて詳しくは、XDM ビジネス商談の概要を参照してください。
"Marketo"opportunityKey.sourceType"${MUNCHKIN_ID}"opportunityKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。idopportunityKey.sourceIDconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織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)campaignKeylastActivityDatelastActivityDateleadSourceleadSourcenextStepnextStepmarketoIsDeletedisDeleted商談連絡先の役割 opportunity-contact-roles
XDM クラスについて詳しくは、XDM ビジネス商談担当者関係の概要を参照してください。
"${MUNCHKIN_ID}"opportunityPersonKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。"Marketo"opportunityPersonKey.sourceTypeconcat(id,"@${MUNCHKIN_ID}.Marketo")opportunityPersonKey.sourceKeyMUNCHKIN_IDを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はセカンダリ IDです。 探索APIは、CRM_TYPEとCRM_ORG_IDをCRM タイプとCRM組織IDに置き換えます。isPrimaryisPrimarymarketoIsDeletedisDeletedrolepersonRoleupdatedAtextSourceSystemAudit.lastUpdatedDateユーザー persons
XDM クラスについて詳しくは、XDM 個人プロファイルの概要を参照してください。 XDM フィールドグループについて詳しくは、XDM ビジネスユーザー詳細スキーマフィールドグループガイドと XDM ビジネスユーザーコンポーネントスキーマフィールドグループガイドを参照してください。
"${MUNCHKIN_ID}"b2b.personKey.sourceInstanceIDMUNCHKIN_IDをMarketo Munchkin IDに置き換えます。"Marketo"b2b.personKey.sourceTypeaddressworkAddress.street1cityworkAddress.citycompanyorganizationsconcat(id,"@${MUNCHKIN_ID}.Marketo")b2b.personKey.sourceKeyMUNCHKIN_IDを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”, sfdcId, null “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, “LeadId, null), “sourceKey”, concat (decode (msftType, “Contact”, msftContactId, “LeadId, “msft” , 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”, sfdcId, null “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, “LeadId, null), “sourceKey”, concat (decode (msftType, “Contact”, msftContactId, “LeadId, “msft” , null),”@${CRM_ORG_ID}.${CRM_TYPE}”), null)
extSourceSystemAudit.externalKeyextSourceSystemAudit.externalKey.sourceKeyはセカンダリ IDです。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 (値1)の場合、consents.marketing.email.valはnに設定されます。 unsubscribedがfalse (値0)の場合、consents.marketing.email.valはnullに設定されます。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.lastUpdatedDate次の手順 next-steps
これで、Marketo データセットのフィールドが、対応するXDM フィールドにどのようにマッピングされるかがわかります。 Marketo データフローを完了するには、Marketo ソース接続の作成に関するチュートリアルを参照してください。