Documentatie Experience Platform Gids voor Source Connectors

Marketo Engage veldtoewijzingen marketo-engage-field-mappings

Last update: Fri Jul 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Onderwerpen:

Gemaakt voor:

Ontwikkelaar

De onderstaande tabellen bevatten de toewijzingen tussen de velden in de negen Marketo -gegevenssets en de bijbehorende XDM-velden (Experience Data Model).

TIP

Alle Marketo -gegevenssets behalve Activities nu ondersteunen isDeleted . De bestaande gegevensstromen zullen automatisch isDeleted omvatten, maar zullen slechts de vlag voor onlangs opgenomen gegevens opnemen. Als u de vlag op al uw historische gegevens wilt toepassen, dan moet u uw bestaande dataflows tegenhouden en hen met de nieuwe afbeelding ontspannen. Als u isDeleted verwijdert, hebt u geen toegang meer tot de functionaliteit. Het is van essentieel belang dat de toewijzing wordt behouden nadat deze automatisch wordt gevuld.

Activiteiten activities

De bron Marketo ondersteunt nu aanvullende standaardactiviteiten. Om standaardactiviteiten te gebruiken, moet u uw schema bijwerken gebruikend het schema auto-generatienutomdat als u nieuwe activities dataflow creeert zonder uw schema bij te werken, de afbeeldingsmalplaatjes zullen ontbreken aangezien de nieuwe doelgebieden niet in uw schema aanwezig zullen zijn. Als u ervoor kiest uw schema niet bij te werken, kunt u nog steeds een nieuwe gegevensstroom maken en eventuele fouten negeren. Nochtans, zullen om het even welke nieuwe of bijgewerkte gebieden niet in Platform worden opgenomen.

Lees de documentatie over de klasse van de Gebeurtenis van de Ervaring XDMvoor meer informatie over de Klasse XDM en de Groep(s) van het Gebied XDM.

NOTE

Het bronveld

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

is een berekend veld dat moet worden toegevoegd met de optie Add calculated field in de gebruikersinterface van het Experience Platform. Lees het leerprogramma op toevoegend berekende gebiedenvoor meer informatie.

Source-gegevensset

XDM-doelveld

Notities

_id

"Marketo"

personKey.sourceType

"${MUNCHKIN_ID}"

personKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

personID

personKey.sourceID

concat(personID,"@${MUNCHKIN_ID}.Marketo")

personKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

eventType

producedBy

timestamp

web.webPageDetails.URL

environment.browserDetails.userAgent

environment.ipV4

search.keywords

search.searchEngine

web.webPageDetails.webPageID

web.webPageDetails.name

web.webPageDetails.isPersonalizedURL

web.webPageDetails.queryParameters

web.webReferrer.URL

iif(${listOperations\.listID} != null && ${listOperations\.listID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", ${listOperations\.listID}, "sourceKey", concat(${listOperations\.listID},"@${MUNCHKIN_ID}.Marketo")), null)

listOperations.listKey

opportunityEvent.isPrimary

iif(${opportunityEvent\.opportunityID} != null && ${opportunityEvent\.opportunityID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${opportunityEvent\.opportunityID}, "sourceKey", concat(${opportunityEvent\.opportunityID},"@${MUNCHKIN_ID}.Marketo")), null)

opportunityEvent.opportunityKey

opportunityEvent.role

leadOperation.newLead.createdDate

leadOperation.newLead.formName

leadOperation.newLead.leadSource

leadOperation.newLead.listName

leadOperation.newLead.sfdcType

leadOperation.newLead.sourceType

leadOperation.convertLead.assignTo

leadOperation.convertLead.convertedStatus

leadOperation.convertLead.isSentNotificationEmail

directMarketing.mailingID

directMarketing.mailingName

directMarketing.testVariantName

directMarketing.testVariantID

directMarketing.emailBouncedCode

directMarketing.emailBouncedDetails

directMarketing.email

device.isMobileDevice

device.model

environment.operatingSystem

directMarketing.linkURL

web.webInteraction.linkID

web.fillOutForm.webFormID

web.fillOutForm.webFormName

web.webInteraction.linkURL

leadOperation.changeScore.changeValue

leadOperation.changeScore.newValue

leadOperation.changeScore.oldValue

leadOperation.changeScore.priority

leadOperation.changeScore.reason

leadOperation.changeScore.relativeScore

leadOperation.changeScore.relativeUrgency

leadOperation.changeScore.scoreAttributeID

leadOperation.changeScore.scoreAttributeName

leadOperation.changeScore.urgency

json_to_object(${opportunityEvent\.dataValueChanges})

opportunityEvent.dataValueChanges

iif(${leadOperation\.campaignProgression\.campaignID} != null && ${leadOperation\.campaignProgression\.campaignID} != "" , to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", ${leadOperation\.campaignProgression\.campaignID}, "sourceKey", concat(${leadOperation\.campaignProgression\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.campaignProgression.campaignKey

leadOperation.campaignProgression.campaignID

leadOperation.campaignProgression.isAcquiredBy

leadOperation.campaignProgression.isSuccessful

leadOperation.campaignProgression.newStatusID

leadOperation.campaignProgression.newStatusName

leadOperation.campaignProgression.oldStatusID

leadOperation.campaignProgression.oldStatusName

leadOperation.campaignProgression.reason

leadOperation.interestingMoment.date

leadOperation.interestingMoment.description

leadOperation.interestingMoment.source

leadOperation.interestingMoment.type

iif(${leadOperation\\.callWebhook\\.webhookKey\\.sourceID} != null && ${leadOperation\\.callWebhook\\.webhookKey\\.sourceID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.callWebhook\\.webhookKey\\.sourceID}, \"sourceKey\", concat(${leadOperation\\.callWebhook\\.webhookKey\\.sourceInstanceID},\"@${MUNCHKIN_ID}.Marketo\")), null)"

leadOperation.callWebhook.webhookKey

leadOperation.callWebhook.webhookName

leadOperation.callWebhook.responseCode

iif(${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID} != null && ${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", ${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceID}, \"sourceKey\", concat(${leadOperation\\.changeCampaignCadence\\.campaignKey\\.sourceInstanceID},\"@${MUNCHKIN_ID}.Marketo\")), null)"

leadOperation.changeCampaignCadence.campaignKey

leadOperation.changeCampaignCadence.newCadence

leadOperation.changeCampaignCadence.previousCadence

iif(${leadOperation\.addToCampaign\.campaignID} != null && ${leadOperation\.addToCampaign\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.campaignID}, "sourceKey", concat(${leadOperation\.addToCampaign\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.addToCampaign.campaignKey

iif(${leadOperation\.addToCampaign\.streamID} != null && ${leadOperation\.addToCampaign\.streamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.addToCampaign\.streamID}, "sourceKey", concat(${leadOperation\.addToCampaign\.streamID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.addToCampaign.streamKey

leadOperation.addToCampaign.streamName

iif(${leadOperation\.changeCampaignStream\.campaignID} != null && ${leadOperation\.changeCampaignStream\.campaignID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.campaignID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.campaignID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.changeCampaignStream.campaignKey

iif(${leadOperation\.changeCampaignStream\.newStreamID} != null && ${leadOperation\.changeCampaignStream\.newStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.newStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.newStreamID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.changeCampaignStream.newStreamKey

leadOperation.changeCampaignStream.newStreamName

iif(${leadOperation\.changeCampaignStream\.previousStreamID} != null && ${leadOperation\.changeCampaignStream\.previousStreamID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeCampaignStream\.previousStreamID}, "sourceKey", concat(${leadOperation\.changeCampaignStream\.previousStreamID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.changeCampaignStream.previousStreamKey

leadOperation.changeCampaignStream.previousStreamName

iif(${leadOperation\.changeRevenueStage\.modelID} != null && ${leadOperation\.changeRevenueStage\.modelID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeRevenueStage\.modelID}, "sourceKey", concat(${leadOperation\.changeRevenueStage\.modelID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.changeRevenueStage.modelKey

leadOperation.changeRevenueStage.modelName

iif(${leadOperation\.changeRevenueStage\.newStageID} != null && ${leadOperation\.changeRevenueStage\.newStageID} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.changeRevenueStage\.newStageID}, "sourceKey", concat(${leadOperation\.changeRevenueStage\.newStageID},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.changeRevenueStage.newStageKey

leadOperation.changeRevenueStage.newStageName

iif(${leadOperation\\.changeRevenueStage\\.previousStageID} != null && ${leadOperation\\.changeRevenueStage\\.previousStageID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${leadOperation\\.changeRevenueStage\\.previousStageID}, \"sourceKey\", concat(${leadOperation\\.changeRevenueStage\\.previousStageID},\"@${MUNCHKIN_ID}.Marketo\")), null)

leadOperation.changeRevenueStage.previousStageKey

leadOperation.changeRevenueStage.previousStageName

leadOperation.changeRevenueStage.reason

iif(${leadOperation\.mergeLeads\.sourceIDs} != null && ${leadOperation\.mergeLeads\.sourceIDs} != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID",${leadOperation\.mergeLeads\.sourceIDs}, "sourceKey", concat(${leadOperation\.mergeLeads\.sourceIDs},"@${MUNCHKIN_ID}.Marketo")), null)

leadOperation.mergeLeads.sourceKeys

leadOperation.mergeLeads.targetUpdated

leadOperation.mergeLeads.mergedInCRM

leadOperation.mergeLeads.mergeSource

iif(${directMarketing\\.emailSent\\.mailingID} != null && ${directMarketing\\.emailSent\\.mailingID} != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\",\"sourceID\",${directMarketing\\.emailSent\\.mailingID}, \"sourceKey\", concat(${directMarketing\\.emailSent\\.mailingID},\"@${MUNCHKIN_ID}.Marketo\")), null)"

directMarketing.emailSent.mailingKey

directMarketing.emailSent.mailingName

directMarketing.emailSent.testVariantID

directMarketing.emailSent.testVariantName

directMarketing.emailSent.automationRunID

iif(${web\.ecid} != null, to_object('ECID', arrays_to_objects('id', explode(last(split(${web\.ecid}, ":")), " "))), null)

identityMap

Dit is een berekend veld.

Programma's programs

Lees het XDM BedrijfsCampagne overzichtvoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van het het schemagebied van de Details van de BedrijfsCampagne .

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

campaignKey.sourceType

"${MUNCHKIN_ID}"

campaignKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

id

campaignKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

campaignKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(sfdcId != null && sfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", sfdcId, "sourceKey", concat(sfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

extSourceSystemAudit.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

name

campaignName

description

campaignDescription

type

campaignType

status

campaignStatus

channel

channelName

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

cost

actualCost.amount

iif(parentProgramId != null && parentProgramId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", parentProgramId, "sourceKey", concat(parentProgramId,"@${MUNCHKIN_ID}.Marketo")), null)

parentCampaignKey

integrationPartner

integrationPartnerName

webinarSessionName

webinarSessionDescription

webinarHistorySyncStatus

webinarHistorySyncDate

startDate

campaignStartDate

endDate

campaignEndDate

marketoIsDeleted

isDeleted

Lidmaatschap van programma program-memberships

Lees het XDM overzicht van de Leden Bedrijfs van de Campagnevoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van het het schemagebied van de Details van het Lid van de BedrijfsCampagne van de 0} XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

campaignMemberKey.sourceType

"${MUNCHKIN_ID}"

campaignMemberKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

id

campaignMemberKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

campaignMemberKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(programId != null && programId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", programId, "sourceKey", concat(programId,"@${MUNCHKIN_ID}.Marketo")), null)

campaignKey

Relatie

iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relatie

iif(acquiredByCampaignID != null && acquiredByCampaignID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", acquiredByCampaignID, "sourceKey", concat(acquiredByCampaignID,"@${MUNCHKIN_ID}.Marketo")), null)

acquiredByCampaignKey

reachedSuccess

hasReachedSuccess

isExhausted

statusName

memberStatus

statusReason

memberStatusReason

membershipDate

nurtureCadence

trackName

nurtureTrackName

webinarUrl

webinarConfirmationUrl

registrationCode

webinarRegistrationID

reachedSuccessDate

iif(sfdc.crmId != null && sfdc.crmId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", sfdc.crmId, "sourceKey", concat(sfdc.crmId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

extSourceSystemAudit.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

sfdc.lastStatus

lastStatus

sfdc.hasResponded

hasResponded

sfdc.firstRespondedDate

firstRespondedDate

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Bedrijven companies

Lees het XDM overzicht van de BedrijfsRekeningvoor meer informatie over de klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

concat(id, ".mkto_org")

accountKey.sourceID

concat(id, ".mkto_org@${MUNCHKIN_ID}.Marketo")

accountKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

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.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

billingCity

accountBillingAddress.city

billingCountry

accountBillingAddress.country

billingPostalCode

accountBillingAddress.postalCode

billingState

accountBillingAddress.state

billingStreet

accountBillingAddress.street1

annualRevenue

accountOrganization.annualRevenue.amount

sicCode

accountOrganization.SICCode

industry

accountOrganization.industry

numberOfEmployees

accountOrganization.numberOfEmployees

website

accountOrganization.website

mainPhone

accountPhone.number

company

accountName

companyNotes

accountDescription

site

accountSite

iif(mktoCdpParentOrgId != null && mktoCdpParentOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", concat(mktoCdpParentOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpParentOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)

accountParentKey

marketoIsDeleted

isDeleted

Statische lijsten static-lists

Lees het XDM overzicht van de Bedrijfs Marketing van de Lijstvoor meer informatie over de klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

marketingListKey.sourceType

"${MUNCHKIN_ID}"

marketingListKey.sourceInstanceID

"${MUNCHKIN_ID}" wordt vervangen als onderdeel van de API voor zoeken.

id

marketingListKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

marketingListKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

name

marketingListName

description

marketingListDescription

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Statische lijstlidmaatschappen static-list-memberships

Lees het XDM Bedrijfs van de Marketing Lijst Leden overzichtvoor meer informatie over de Klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

marketingListMemberKey.sourceType

"${MUNCHKIN_ID}"

marketingListMemberKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

staticListMemberID

marketingListMemberKey.sourceID

concat(staticListMemberID,"@${MUNCHKIN_ID}.Marketo")

marketingListMemberKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(staticListID != null && staticListID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", staticListID, "sourceKey", concat(staticListID,"@${MUNCHKIN_ID}.Marketo")), null)

marketingListKey

Relatie

iif(personID != null && personID != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", personID, "sourceKey", concat(personID,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relatie

createdAt

extSourceSystemAudit.createdDate

marketoIsDeleted

isDeleted

Benoemde accounts named-accounts

IMPORTANT

De genoemde rekeningen dataset is slechts noodzakelijk met de op rekening-gebaseerde marketing van Marketo (ABM) eigenschap. Als u ABM niet gebruikt, hoeft u geen toewijzingen in te stellen voor benoemde accounts.

Lees het XDM overzicht van de BedrijfsRekeningvoor meer informatie over de klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

accountKey.sourceType

"${MUNCHKIN_ID}"

accountKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

concat(id, ".mkto_acct")

accountKey.sourceID

concat(id, ".mkto_acct@${MUNCHKIN_ID}.Marketo")

accountKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(externalSourceId != null && externalSourceId != "", to_object("sourceType", externalSourceType, "sourceInstanceID", externalSourceInstanceId, "sourceID", externalSourceId, "sourceKey", externalSourceKey), iif(crmGuid != null && crmGuid != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", crmGuid, "sourceKey", concat(crmGuid,"@${CRM_ORG_ID}.${CRM_TYPE}")), null))

extSourceSystemAudit.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

city

accountBillingAddress.city

country

accountBillingAddress.country

state

accountBillingAddress.state

annualRevenue

accountOrganization.annualRevenue.amount

sicCode

accountOrganization.SICCode

industry

accountOrganization.industry

logoUrl

accountOrganization.logoUrl

numberOfEmployees

accountOrganization.numberOfEmployees

name

accountName

iif(parentAccountId != null && parentAccountId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(parentAccountId, ".mkto_acct"), "sourceKey", concat(parentAccountId, ".mkto_acct@${MUNCHKIN_ID}.Marketo")), null)

accountParentKey

sourceType

accountSourceType

marketoIsDeleted

isDeleted

Kansen opportunities

Lees het XDM overzicht van de BedrijfsKansvoor meer informatie over de klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

opportunityKey.sourceType

"${MUNCHKIN_ID}"

opportunityKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

id

opportunityKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

opportunityKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(externalOpportunityId != null && externalOpportunityId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", externalOpportunityId, "sourceKey", concat(externalOpportunityId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

extSourceSystemAudit.externalKey.sourceKey

Secundaire identiteit De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

iif(mktoCdpAccountOrgId != null && mktoCdpAccountOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", concat(mktoCdpAccountOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpAccountOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)

accountKey

Relatie

description

opportunityDescription

name

opportunityName

stage

opportunityStage

type

opportunityType

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

expectedRevenue

expectedRevenue.amount

amount

opportunityAmount.amount

closeDate

expectedCloseDate

fiscalQuarter

fiscalYear

forecastCategory

forecastCategoryName

isClosed

isWon

quantity

opportunityQuantity

probability

probabilityPercentage

iif(mktoCdpAccountOrgId != null && mktoCdpAccountOrgId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", concat(mktoCdpAccountOrgId, ".mkto_org"), "sourceKey", concat(mktoCdpAccountOrgId, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)

accountKey

Deze brongegevensset is alleen beschikbaar voor gebruikers met de Salesforce -integratie.

lastActivityDate

leadSource

nextStep

marketoIsDeleted

isDeleted

Contactrollen opportunity opportunity-contact-roles

Lees het XDM overzicht van de Verhouding van de Person van de Bedrijfs van de Opportunityvoor meer informatie over de klasse XDM.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

opportunityPersonKey.sourceType

"${MUNCHKIN_ID}"

opportunityPersonKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

id

opportunityPersonKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

opportunityPersonKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt vervangen als onderdeel van de API voor zoeken.

iif(mktoCdpSfdcId != null && mktoCdpSfdcId != "", to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", mktoCdpSfdcId, "sourceKey", concat(mktoCdpSfdcId,"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

extSourceSystemAudit.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit. De waarden voor {CRM_ORG_ID} en {CRM_TYPE} worden automatisch vervangen.

iif(mktoCdpOpptyId != null && mktoCdpOpptyId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", mktoCdpOpptyId, "sourceKey", concat(mktoCdpOpptyId,"@${MUNCHKIN_ID}.Marketo")), null)

opportunityKey

Relatie

iif(leadId != null && leadId != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", leadId, "sourceKey", concat(leadId,"@${MUNCHKIN_ID}.Marketo")), null)

personKey

Relatie

role

personRole

isPrimary

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

marketoIsDeleted

isDeleted

Personen persons

Lees het XDM Individuele overzicht van het Profielvoor meer informatie over de klasse XDM. Voor meer informatie over de XDM gebiedsgroepen, lees de 🔗 gids van de het schemagroep van de Details van de BedrijfsPersoon van 0} XDM {en XDM van de BedrijfsPersoon de het schemagroep van Componenten van de Componenten.

Source-gegevensset

XDM-doelveld

Notities

"Marketo"

b2b.personKey.sourceType

"${MUNCHKIN_ID}"

b2b.personKey.sourceInstanceID

De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

id

b2b.personKey.sourceID

concat(id,"@${MUNCHKIN_ID}.Marketo")

b2b.personKey.sourceKey

Primaire identiteit. De waarde voor "${MUNCHKIN_ID}" wordt automatisch vervangen.

iif(unsubscribed == 'true', 'n', 'y' ))

consents.marketing.email.val

Als unsubscribed true is (bijvoorbeeld value = 1), dan plaats consents.marketing.email.val als (n). Als unsubscribed false is (bijvoorbeeld value = 0 ), stelt u consents.marketing.email.val in als null .

iif(unsubscribedReason != null && unsubscribedReason != "", substr(unsubscribedReason, 0, 100), null)

consents.marketing.email.reason

iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)

b2b.accountKey

marketingSuspended

b2b.isMarketingSuspended

marketingSuspendedCause

b2b.marketingSuspendedCause

leadScore

b2b.personScore

leadSource

b2b.personSource

leadStatus

b2b.personStatus

personType

b2b.personType

leadPartitionId

b2b.personGroupID

mktoCdpIsConverted

b2b.isConverted

mktoCdpConvertedDate

b2b.convertedDate

iif(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null), "sourceKey", concat(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
iif(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

extSourceSystemAudit.externalKey

De extSourceSystemAudit.externalKey is de secundaire identiteit.

createdAt

extSourceSystemAudit.createdDate

updatedAt

extSourceSystemAudit.lastUpdatedDate

title

extendedWorkDetails.jobTitle

fax

faxPhone.number

mobilePhone

mobilePhone.number

firstName

person.name.firstName

lastName

person.name.lastName

middleName

person.name.middleName

salutation

person.name.courtesyTitle

dateOfBirth

person.birthDate

city

workAddress.city

country

workAddress.country

postalCode

workAddress.postalCode

state

workAddress.state

address

workAddress.street1

phone

workPhone.number

company

b2b.companyName

website

b2b.companyWebsite

leadScore

personComponents.personScore

leadSource

personComponents.personSource

leadStatus

personComponents.personStatus

personType

personComponents.personType

leadPartitionId

personComponents.personGroupID

iif(contactCompany != null && contactCompany != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}", "sourceID", concat(contactCompany, ".mkto_org"), "sourceKey", concat(contactCompany, ".mkto_org@${MUNCHKIN_ID}.Marketo")), null)

personComponents.sourceAccountKey

iif(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}", "sourceID", decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null), "sourceKey", concat(decode(sfdcType, "Contact", sfdcContactId, "Lead", sfdcLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)
iif(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null) != null, to_object("sourceType", "${CRM_TYPE}", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null), "sourceKey", concat(decode(msftType, "Contact", msftContactId, "Lead", msftLeadId , null),"@${CRM_ORG_ID}.${CRM_TYPE}")), null)

personComponents.sourceExternalKey

iif(id != null && id != "", to_object("sourceType", "Marketo", "sourceInstanceID", "${MUNCHKIN_ID}","sourceID", id, "sourceKey", concat(id,"@${MUNCHKIN_ID}.Marketo")), null)

personComponents.sourcePersonKey

email

personComponents.workEmail.address

email

workEmail.address

marketoIsDeleted

isDeleted

iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)

b2b.convertedContactKey

Dit is een berekend veld.

iif(mktoCdpCnvContactPersonId != null && mktoCdpCnvContactPersonId != \"\", to_object(\"sourceType\", \"Marketo\", \"sourceInstanceID\", \"${MUNCHKIN_ID}\", \"sourceID\", mktoCdpCnvContactPersonId, \"sourceKey\", concat(mktoCdpCnvContactPersonId,\"@${MUNCHKIN_ID}.Marketo\")), null)

personComponents.sourceConvertedContactKey

Dit is een berekend veld.

Volgende stappen

Door dit document te lezen, hebt u inzicht gekregen in de toewijzingsverhouding tussen uw Marketo datasets en hun overeenkomstige gebieden XDM. Zie het leerprogramma op creërend a Marketo bronverbindingom uw Marketo dataflow te voltooien.

recommendation-more-help

337b99bb-92fb-42ae-b6b7-c7042161d089