Marketo Measure Ultimate数据完整性要求

最近更新： 2025年2月27日

主题：
归因

Marketo Measure验证传入的AEP数据集，以确保数据充分且一致地用于归因。如果不满足数据完整性要求，则会导致Marketo Measure系统拒绝数据集。本文详细介绍了数据完整性要求，提供了数据检查的查询示例，并建议了具有空值的必填字段的解决方案。

实体对象

XDM类	XDM字段组	XDM路径	XDM类型	数据Source字段	必需？	注释
帐户 (Salesforce的帐户、公司帐户和/或Marketo的指定帐户)
XDM业务帐户		accountKey.sourceKey	字符串		是	例如 — 123@999-abc-888.Marketo
		accountKey.sourceID	字符串	ID	是	例如 — 123
		accountKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		accountKey.sourceType	字符串		是	例如 — Marketo
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
	XDM业务帐户详细信息	帐户名称	字符串	名称	是
营销活动(Salesforce的营销活动、Marketo的计划)
XDM商业营销活动		campaignKey.sourceKey	字符串		是	例如 — 55555@999-abc-888.Marketo
		campaignKey.sourceID	字符串	ID	是	例如 — 55555
		campaignKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		campaignKey.sourceType	字符串		是	例如 — Marketo
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
		campaignName	字符串	名称	是
		campaignType	字符串	营销活动类型	否	用于渠道映射
	XDM商业营销活动详细信息	channelname	字符串	频道名称	否	用于渠道映射
		campaignStartDate	日期时间	开始日期	否	对于促销活动成本
		campaignEndDate	日期时间	结束日期	否	对于促销活动成本
		actualCost.amount	数字	成本	否	对于促销活动成本
		actualCost.currencyCode	字符串 ^[A-Z]{3}$	CurrencyIsoCode	否	对于促销活动成本
营销活动成员(Salesforce的营销活动成员、Marketo的项目成员)
XDM商业营销活动成员		campaignMemberKey.sourceKey	字符串		是	例如 — 987654321@999-abc-888.Marketo
		campaignMemberKey.sourceID	字符串	ID	是	例如 — 987654321
		campaignMemberKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		campaignMemberKey.sourceType	字符串		是	例如 — Marketo
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
		personKey.sourceKey	字符串		是	例如 — 333@999-abc-888.Marketo
		personKey.sourceID	字符串	潜在客户ID或联系人ID	是	例如 — 333，根据数据源表，这或者是Lead ID，或者是Contact ID。要潜在客户或联系人的外键
		personKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		personKey.sourceType	字符串		是	例如 — Marketo
		campaignKey.sourceKey	字符串		是	例如 — 55555@999-abc-888.Marketo
		campaignKey.sourceID	字符串	营销活动ID	是	例如 — 55555。营销活动外键
		campaignKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		campaignKey.sourceType	字符串		是	例如 — Marketo
	XDM商业营销活动成员详细信息	b2b.personType	字符串	“潜在客户”或“联系人”	是	根据数据源表，这应该设置为“潜在客户”或“联系人”。对于大多数用例，我们建议将其设置为“联系”
		memberstatus	字符串	状态	是
		hasResponsed	布尔	HasResponsed	是
		firstRespondedDate	日期时间	FirstRespondedDate	否
人员(Salesforce的联系人或潜在客户、Marketo的人员)
XDM 个人轮廓	XDM业务人员详细信息	b2b.personKey.sourceKey	字符串		是	例如 — 333@999-abc-888.Marketo
		b2b.personKey.sourceID	字符串	ID	是	例如 — 333，根据数据源表，此值为商机ID或联系人ID
		b2b.personKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		b2b.personKey.sourceType	字符串		是	例如 — Marketo
		workEmail.address	字符串电子邮件	电子邮件	是
		b2b.personStatus	字符串	状态	*是，仅适用于Lead personType*	仅当b2b.personType为“潜在客户”时才需要
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
		b2b.isConverted	布尔	IsConverted	*是，仅适用于Lead personType*	仅当b2b.personType为“潜在客户”时才需要
		b2b.personType	字符串	“潜在客户”或“联系人”	是	根据数据源表，这应该设置为“潜在客户”或“联系人”。对于大多数用例，我们建议将其设置为“联系”
		extendedWorkDetails.jobTitle	字符串		否
	XDM业务人员组件	personComponents.sourceAccountKey.sourceKey	字符串		否	例如 — 123@999-abc-888.Marketo。 sourceAccountKey字段集仅对于真正的联系人记录“必填”，即定义为链接到帐户的人员记录。缺少它不会导致数据集被拒绝，但归因结果将关闭。 personComponents是一个数组，但Marketo Measure仅采用第一个元素personComponents[0]
		personComponents.sourceAccountKey.sourceID	字符串	帐户 ID	否	例如 — 123。帐户的外键
		personComponents.sourceAccountKey.sourceInstanceID	字符串		否	例如 — 999-abc-888
		personComponents.sourceAccountKey.sourceType	字符串		否	例如 — Marketo
Opportunity (Salesforce的Opportunity， Marketo的Opportunity)
XDM商业机会		opportunityKey.sourceKey	字符串		是	例如 — 77777@999-abc-888.Marketo
		opportunityKey.sourceID	字符串	ID	是	例如 — 77777
		opportunityKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		opportunityKey.sourceType	字符串		是	例如 — Marketo
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
		accountKey.sourceKey	字符串		是	例如 — 123@999-abc-888.Marketo
		accountKey.sourceID	字符串	帐户 ID	是	例如 — 123。帐户的外键
		accountKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		accountKey.sourceType	字符串		是	例如 — Marketo
		机会名称	字符串	名称	是
		opportunityStage	字符串	阶段	是
		opportunityType	字符串		否
	XDM业务机会详细信息	isWon	布尔	IsWon	是
		isClosed	布尔	IsClosed	是
		expectedCloseDate	日期	关闭日期	是
		opportunityAmount.amount	数字	数量	是
		opportunityAmount.currencyCode	字符串 ^[A-Z]{3}$	CurrencyIsoCode	是
机会联系人角色（仅当计划使用机会联系人角色作为购买组进行归因时才需要）
XDM业务机会人员关系		personKey.sourceKey	字符串		是	例如 — 333@999-abc-888.Marketo
		personKey.sourceID	字符串	联系人ID	是	例如 — 333。要联系的外键
		personKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		personKey.sourceType	字符串		是	例如 — Marketo
		isPrimary	布尔	IsPrimary	是
		opportunityKey.sourceKey	字符串		是	例如 — 77777@999-abc-888.Marketo
		opportunityKey.sourceID	字符串	机会 ID	是	例如 — 77777。机会的外键
		opportunityKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		opportunityKey.sourceType	字符串		是	例如 — Marketo
		opportunityPersonKey.sourceKey	字符串		是	例如 — 222222@999-abc-888.Marketo
		opportunityPersonKey.sourceID	字符串	ID	是	例如 — 222222
		opportunityPersonKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		opportunityPersonKey.sourceType	字符串		是	例如 — Marketo
		personRole	字符串	角色	否
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
转换率(仅当使用多种货币时需要；只能将一个转换率数据集激活到Marketo Measure)
转化		extSourceSystemAudit.externalKey.sourceKey	字符串		是	例如 — 8888@0x012345.Salesforce
		extSourceSystemAudit.externalKey.sourceId	字符串	ID	是	例如 — 8888
		extSourceSystemAudit.externalKey.sourceInstanceId	字符串		是	例如 — 0x012345
		extSourceSystemAudit.externalKey.sourceType	字符串		是	例如 — Salesforce
		extSourceSystemAudit.createdDate	日期时间	CreatedDate	是
		extSourceSystemAudit.lastUpdatedDate	日期时间	修改日期	是
		isDeleted	布尔		是
	货币兑换率详细信息	conversionRate	数字	ConversionRate	是
		endDate	日期	NextStartDate	是
		startDate	日期	开始日期	是
		sourceISOode	字符串	ISOCode	是	例如EUR
		targetisocode	字符串		是	Marketo Measure中设置的默认货币代码，例如USD

货币兑换数据要求

默认货币：在Marketo Measure中，所有收入和成本在报告时都转换为默认货币。对于目标货币本身，必须有一条记录具有相同的日期范围（例如，USD到USD），并且兑换率为1。

兑换率：每个（源货币、目标货币）对可以在不同的日期期间具有多个兑换率。根据Salesforce DatedConversionRate对象，费率必须涵盖0001-01-01到9999-12-31的整个时间范围。

日期范围：

在（源货币、目标货币）汇率集中没有重叠的日期范围（例如，2023-01-01到2023-02-01和2023-01-01到2024-01-01）。
日期范围之间没有间隔。起始日期不包括，结束日期不包括。

ExperienceEvent

XDM类	XDM字段组	XDM路径	XDM类型	数据Source字段	必需？	注释
活动
XDM ExperienceEvent		_id	字符串	ID	是	是
		事件类型	字符串	活动类型	是	是
		时间戳	日期时间	活动日期	是	是
	人员标识符	personKey.sourceKey	字符串		是	例如 — 333@999-abc-888.Marketo
		personKey.sourceID	字符串	潜在客户ID或联系人ID	是	例如 — 333，根据数据源表，这或者是Lead ID，或者是Contact ID。要潜在客户或联系人的外键
		personKey.sourceInstanceID	字符串		是	例如 — 999-abc-888
		personKey.sourceType	字符串		是	例如 — Marketo
	添加到营销活动	leadOperation.addToCampaign.campaignKey.sourceKey	字符串		仅对于leadOperation.addToCampaign类型为“是”	例如 — 55555@999-abc-888.Marketo
		leadOperation.addToCampaign.campaignKey.sourceId	字符串	营销活动ID	仅对于leadOperation.addToCampaign类型为“是”	例如 — 55555。营销活动外键
		leadOperation.addToCampaign.campaignKey.sourceInstanceId	字符串		仅对于leadOperation.addToCampaign类型为“是”	例如 — 999-abc-888
		leadOperation.addToCampaign.campaignKey.sourceType	字符串		仅对于leadOperation.addToCampaign类型为“是”	例如 — Marketo
	营销活动进程中的状态已更改	leadOperation.campaignProgression.campaignKey.sourceKey	字符串		仅对于leadOperation.campaignProgression类型为是	例如 — 55555@999-abc-888.Marketo
		leadOperation.campaignProgression.campaignKey.sourceId	字符串	营销活动ID	仅对于leadOperation.campaignProgression类型为是	例如 — 55555。营销活动外键
		leadOperation.campaignProgression.campaignKey.sourceInstanceId	字符串		仅对于leadOperation.campaignProgression类型为是	例如 — 999-abc-888
		leadOperation.campaignProgression.campaignKey.sourceType	字符串		仅对于leadOperation.campaignProgression类型为是	例如 — Marketo

支持的体验事件类型

事件类型	XDM事件类型	描述
新建潜在客户	leadOperation.newLead	用于记录新营销商机的创建和详细信息
转化商机	leadOperation.convertLead	当营销商机转化为分配给销售用户的符合销售条件的联系人时使用
有趣的时刻	leadOperation.interestingMoment	用于跟踪潜在客户的高价值活动
填写表单	web.formFilledOut	用于在人员填写网页上的表单时捕获详细信息
取消订阅电子邮件	directMarketing.emailUnsubscribed	用于在人员取消订阅电子邮件时捕获详细信息
打开电子邮件	directMarketing.emailOpened	用于在人员打开营销电子邮件时捕获详细信息
单击电子邮件	directMarketing.emailClicked	用于在人员单击营销电子邮件中的链接时捕获详细信息
进程中的更改状态	leadOperation.statusInCampaignProgressionChanged	用于在营销活动中的商机状态发生变化时捕获详细信息
添加到参与计划（添加到培养）	leadOperation.addToCampaign	用于将人员添加到特定营销活动。

对于上表中不支持的事件类型，请使用“有趣的时刻”事件类型。添加自定义字段以指示子类型“有趣的时刻”。

数据检查的查询示例

以下列出了用于检查AEP数据湖中摄取的数据集的查询示例。要对数据集使用这两个查询表名称，请将以下查询示例中的表名称替换为您实际的数据集表名称。

我们预计所有数量均为0。

对于personType字段，我们预计只有“潜在客户”或“联系人”值，并且没有空值。

对于所有“联系人”人员记录，我们希望有一个帐户外键。

对于“潜在客户”人员记录，帐户外键不存在并且不是必需的。如果选择将“潜在客户”人员记录摄取为“联系人”人员记录（建议使用），则不需要此类人员记录上的“帐户”外键。

XDM业务帐户

select 'account source id', count(*) from salesforce_account where accountKey.sourceId is null
union all
select 'account source type', count(*) from salesforce_account where accountKey.sourceType is null
union all
select 'account source instance id', count(*) from salesforce_account where accountKey.sourceInstanceId is null
union all
select 'account source key', count(*) from salesforce_account where accountKey.sourceKey is null
union all
select 'account name', count(*) from salesforce_account where accountName is null
union all
select 'created date', count(*) from salesforce_account where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from salesforce_account where extSourceSystemAudit.lastUpdatedDate is null;

XDM商业营销活动

select 'campaign source id', count(*) from salesforce_campaign where campaignKey.sourceId is null
union all
select 'campaign source type', count(*) from salesforce_campaign where campaignKey.sourceType is null
union all
select 'campaign source instance id', count(*) from salesforce_campaign where campaignKey.sourceInstanceId is null
union all
select 'campaign source key', count(*) from salesforce_campaign where campaignKey.sourceKey is null
union all
select 'campaign name', count(*) from salesforce_campaign where campaignName is null
union all
select 'created date', count(*) from salesforce_campaign where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from salesforce_campaign where extSourceSystemAudit.lastUpdatedDate is null;

XDM商业营销活动成员

select 'campaign member source id', count(*) from salesforce_campaign_member where campaignMemberKey.sourceId is null
union all
select 'campaign member source type', count(*) from salesforce_campaign_member where campaignMemberKey.sourceType is null
union all
select 'campaign member source instance id', count(*) from salesforce_campaign_member where campaignMemberKey.sourceInstanceId is null
union all
select 'campaign member source key', count(*) from salesforce_campaign_member where campaignMemberKey.sourceKey is null
union all
select 'campaign source id', count(*) from salesforce_campaign_member where campaignKey.sourceId is null
union all
select 'campaign source type', count(*) from salesforce_campaign_member where campaignKey.sourceType is null
union all
select 'campaign source instance id', count(*) from salesforce_campaign_member where campaignKey.sourceInstanceId is null
union all
select 'campaign source key', count(*) from salesforce_campaign_member where campaignKey.sourceKey is null
union all
select 'person source id', count(*) from salesforce_campaign_member where personKey.sourceId is null
union all
select 'person source type', count(*) from salesforce_campaign_member where personKey.sourceType is null
union all
select 'person source instance id', count(*) from salesforce_campaign_member where personKey.sourceInstanceId is null
union all
select 'person source key', count(*) from salesforce_campaign_member where personKey.sourceKey is null
union all
select distinct 'person type', b2b.personType from salesforce_campaign_member
union all
select 'member status', count(*) from salesforce_campaign_member where memberStatus is null
union all
select 'has responded', count(*) from salesforce_campaign_member where hasResponded is null
union all
select 'created date', count(*) from salesforce_campaign_member where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from salesforce_campaign_member where extSourceSystemAudit.lastUpdatedDate is null;

XDM业务人员

select 'person source id', count(*) from marketo_person where b2b.personKey.sourceId is null
union all
select 'person source type', count(*) from marketo_person where b2b.personKey.sourceType is null
union all
select 'person source instance id', count(*) from marketo_person where b2b.personKey.sourceInstanceId is null
union all
select 'person source key', count(*) from marketo_person where b2b.personKey.sourceKey is null
union all
select 'email', count(*) from marketo_person where workEmail.address is null
union all
select 'Lead - person status', count(*) from marketo_person where b2b.personType = 'Lead' and b2b.personStatus is null
union all
select 'Lead - is converted', count(*) from marketo_person where b2b.personType = 'Lead' and b2b.isConverted is null
union all
select distinct 'person type', b2b.personType from marketo_person
union all
select 'created date', count(*) from marketo_person where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from marketo_person where extSourceSystemAudit.lastUpdatedDate is null;

select 'person source id', count(*) from salesforce_contact where b2b.personKey.sourceId is null
union all
select 'person source type', count(*) from salesforce_contact where b2b.personKey.sourceType is null
union all
select 'person source instance id', count(*) from salesforce_contact where b2b.personKey.sourceInstanceId is null
union all
select 'person source key', count(*) from salesforce_contact where b2b.personKey.sourceKey is null
union all
select 'email', count(*) from salesforce_contact where workEmail.address is null
union all
select 'Lead - person status', count(*) from salesforce_contact where b2b.personType = 'Lead' and b2b.personStatus is null
union all
select 'Lead - is converted', count(*) from salesforce_contact where b2b.personType = 'Lead' and b2b.isConverted is null
union all
select distinct 'person type', b2b.personType from salesforce_contact
union all
select 'account source id', count(*) from salesforce_contact where b2b.personType = 'Contact' and personComponents[0].sourceAccountKey.sourceId is null
union all
select 'account source type', count(*) from salesforce_contact where b2b.personType = 'Contact' and personComponents[0].sourceAccountKey.sourceType is null
union all
select 'account source instance id', count(*) from salesforce_contact where b2b.personType = 'Contact' and personComponents[0].sourceAccountKey.sourceInstanceId is null
union all
select 'account source key', count(*) from salesforce_contact where b2b.personType = 'Contact' and personComponents[0].sourceAccountKey.sourceKey is null
union all
select 'created date', count(*) from salesforce_contact where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from salesforce_contact where extSourceSystemAudit.lastUpdatedDate is null;

XDM商业机会

select 'opportunity source id', count(*) from salesforce_opportunity where opportunityKey.sourceId is null
union all
select 'opportunity source type', count(*) from salesforce_opportunity where opportunityKey.sourceType is null
union all
select 'opportunity source instance id', count(*) from salesforce_opportunity where opportunityKey.sourceInstanceId is null
union all
select 'opportunity source key', count(*) from salesforce_opportunity where opportunityKey.sourceKey is null
union all
select 'account source id', count(*) from salesforce_opportunity where accountKey.sourceId is null
union all
select 'account source type', count(*) from salesforce_opportunity where accountKey.sourceType is null
union all
select 'account source instance id', count(*) from salesforce_opportunity where accountKey.sourceInstanceId is null
union all
select 'account source key', count(*) from salesforce_opportunity where accountKey.sourceKey is null
union all
select 'opportunity name', count(*) from salesforce_opportunity where opportunityName is null
union all
select 'opportunity stage', count(*) from salesforce_opportunity where opportunityStage is null
union all
select 'is won', count(*) from salesforce_opportunity where isWon is null
union all
select 'is closed', count(*) from salesforce_opportunity where isClosed is null
union all
select 'expected close date', count(*) from salesforce_opportunity where expectedCloseDate is null
union all
select 'opportunity amount', count(*) from salesforce_opportunity where opportunityAmount.amount is null
union all
select 'currency code', count(*) from salesforce_opportunity where opportunityAmount.currencyCode is null
union all
select 'created date', count(*) from salesforce_opportunity where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from salesforce_opportunity where extSourceSystemAudit.lastUpdatedDate is null;

XDM ExperienceEvent

select 'id', count(*) from marketo_activity where _id is null
union all
select 'event type', count(*) from marketo_activity where eventType is null
union all
select 'timestamp', count(*) from marketo_activity where timestamp is null
union all
select 'person source id', count(*) from marketo_activity where personKey.sourceId is null
union all
select 'person source type', count(*) from marketo_activity where personKey.sourceType is null
union all
select 'person source instance id', count(*) from marketo_activity where personKey.sourceInstanceId is null
union all
select 'person source key', count(*) from marketo_activity where personKey.sourceKey is null
union all
select 'addToCampaign campaign id', count(*) from marketo_activity where eventType = 'leadOperation.addToCampaign' and leadOperation.addToCampaign.campaignKey.sourceId is null
union all
select 'addToCampaign campaign type', count(*) from marketo_activity where eventType = 'leadOperation.addToCampaign' and leadOperation.addToCampaign.campaignKey.sourceType is null
union all
select 'addToCampaign campaign instance id', count(*) from marketo_activity where eventType = 'leadOperation.addToCampaign' and leadOperation.addToCampaign.campaignKey.sourceInstanceId is null
union all
select 'addToCampaign campaign key', count(*) from marketo_activity where eventType = 'leadOperation.addToCampaign' and leadOperation.addToCampaign.campaignKey.sourceKey is null
union all
select 'statusInCampaignProgressionChanged campaign id', count(*) from marketo_activity where eventType = 'leadOperation.statusInCampaignProgressionChanged' and leadOperation.campaignProgression.campaignKey.sourceId is null
union all
select 'statusInCampaignProgressionChanged campaign type', count(*) from marketo_activity where eventType = 'leadOperation.statusInCampaignProgressionChanged' and leadOperation.campaignProgression.campaignKey.sourceType is null
union all
select 'statusInCampaignProgressionChanged campaign instance id', count(*) from marketo_activity where eventType = 'leadOperation.statusInCampaignProgressionChanged' and leadOperation.campaignProgression.campaignKey.sourceInstanceId is null
union all
select 'statusInCampaignProgressionChanged campaign key', count(*) from marketo_activity where eventType = 'leadOperation.statusInCampaignProgressionChanged' and leadOperation.campaignProgression.campaignKey.sourceKey is null;

select 'id', count(*) from salesforce_task where _id is null
union all
select 'event type', count(*) from salesforce_task where eventType is null
union all
select 'timestamp', count(*) from salesforce_task where timestamp is null
union all
select 'person source id', count(*) from salesforce_task where personKey.sourceId is null
union all
select 'person source type', count(*) from salesforce_task where personKey.sourceType is null
union all
select 'person source instance id', count(*) from salesforce_task where personKey.sourceInstanceId is null
union all
select 'person source key', count(*) from salesforce_task where personKey.sourceKey is null;

转化

select 'conversion rate', count(*) from currency_conversion_rate where conversionRate is null
union all
select 'end date', count(*) from currency_conversion_rate where endDate is null
union all
select 'start date', count(*) from currency_conversion_rate where startDate is null
union all
select 'source ISO Code', count(*) from currency_conversion_rate where sourceISOCode is null
union all
select 'target ISO Code', count(*) from currency_conversion_rate where targetISOCode is null
union all
select 'source id', count(*) from currency_conversion_rate where extSourceSystemAudit.externalKey.sourceId is null
union all
select 'source type', count(*) from currency_conversion_rate where extSourceSystemAudit.externalKey.sourceType is null
union all
select 'source instance id', count(*) from currency_conversion_rate where extSourceSystemAudit.externalKey.sourceInstanceId is null
union all
select 'source key', count(*) from currency_conversion_rate where extSourceSystemAudit.externalKey.sourceKey is null
union all
select 'created date', count(*) from currency_conversion_rate where extSourceSystemAudit.createdDate is null
union all
select 'last updated date', count(*) from currency_conversion_rate where extSourceSystemAudit.lastUpdatedDate is null;

具有NULL值的必填字段的建议解决方案

我们建议在字段映射中使用计算字段将该字段默认为非NULL值。以下是两个示例：

如果某些opportunity记录的opportunityName为null ，请在字段映射中创建并使用以下计算字段
- iif(name != null && trim(name) != "", name, "Unknown")
如果某些experienceevent记录的leadOperation.campaignProgression.campaignID为空，请在字段映射中创建并使用以下计算字段
- iif(leadOperation.campaignProgression.campaignID != null && leadOperation.campaignProgression.campaignID != "" , to_object("sourceType", "Marketo", "sourceInstanceID", "123-abc-321", "sourceID", leadOperation.campaignProgression.campaignID, "sourceKey", concat(leadOperation.campaignProgression.campaignID,"@123-abc-321.Marketo")), iif(eventType == "leadOperation.statusInCampaignProgressionChanged", to_object("sourceType", "Marketo", "sourceInstanceID", "123-abc-321", "sourceID", "Unknown", "sourceKey", "Unknown@123-abc-321.Marketo"), null))

recommendation-more-help