Alesco Validate, Clean and Complete your CRM data in one secure place

Single Intelligent View

Enhance the power of your CRM by adding a Single Intelligent View of your data!

Data clean rooms and customer data platforms (CDP) have emerged in response to unreliable data and diminishing campaign results. While consumer privacy is still paramount, the need for performance insight has taken center stage. Companies taking part in clean rooms or CDP understand the importance of submitting accurate 1st-Party data. Our identity solutions support this objective by incorporating a consolidated process that delivers the ‘Single-Intelligent View’ of each CRM record – yielding higher match rates that produce more reliable media consumption and performance!

How data are validated, cleaned, and completed:

1) Create a table containing consumer records for the hygiene process. This table should contain fields like first name, last name, address, etc along with a timestamp to keep track of new records.
2) Use Snowflake Direct Share to send this table to Alesco.
3) Alesco will use a timestamp to recognize changes when you add new CRM data or update existing CRM data in a shared table. It will then automatically process, validate, complete, and clean the new CRM records and make the updated output data accessible in the shared output table.
4) Alesco will use Snowflake Direct Share to send the shared output table mentioned above.
5) After each append process, we will notify the user through email notifications.

Trigger Details:

For the hygiene process, we have two options:

1. For clients having fixed schedules:

-A task will be scheduled on our side to capture the upload of new records for enrichment in the share.

2. For clients wanting to process on an Ad-Hoc basis:

-Our offering consists of a script you can run to add the external function directly in your Snowflake account.

- After the creation of the external function, record the API_AWS_IAM_USER_ARN and API_AWS_EXTERNAL_ID of the function and share them with us to build a trust relationship between your Snowflake account and our API Gateway.

- From there, calls can be made directly to our service to enrich your data by running the function.

With a single process, we will:

-Provide Field Parsing and Standardization.
-Validation - to the degree to which the data conforms to defined business rules and constraints.
-Assess accuracy to ensure data is close to the true values.
-Determine completeness; the degree to which all required data is known.
-Unearth the consistency of each attribute across multiple datasets and offer attribute appends that fill-in mission-critical whitespace.
-Achieve uniformity; to the degree to which data is specified using the same unit of measure – making corrections prior to Clean Room submission.

Fields Included:

-FIRST_NAME
-LAST_NAME
-ADDRESS
-PHONE
-EMAIL
-TIMESTAMP
-ALESCO_PERM_INDIVIDUAL_ID
-ALESCO_ADDRESS
-ALESCO_CITY
-ALESCO_STATE
-ALESCO_ZIP
-ALESCO_PHONE
-LINE_TYPE
-PHONE_DATE
-ALESCO_EMAIL
-EMAIL_OPTIN_DATE
-BUSINESS_EMAIL
-BUSINESS_PHONE
-COMPANY_NAME
-BUSINESS_ADDRESS
-BUSINESS_SUITE
-BUSINESS_CITY
-BUSINESS_STATE
-BUSINESS_ZIP

### 单一智能视图（Single Intelligent View）
通过为您的客户关系管理（CRM，Customer Relationship Management）系统构建数据单一智能视图，全面提升其效能！

数据洁净室（data clean rooms）与客户数据平台（CDP，Customer Data Platform）正是为应对数据不可靠、营销活动效果下滑的痛点应运而生。尽管消费者隐私始终是核心要务，但对营销效果洞察的需求已成为焦点。参与数据洁净室或CDP项目的企业均深知提交精准第一方（1st-Party）数据的重要性。我们的身份识别解决方案通过整合统一流程，为每一条CRM记录打造「单一智能视图」，助力实现更高的匹配率，进而获得更可靠的媒体消费与营销效果数据。

#### 数据验证、清洗与补全流程：
1) 创建用于数据净化流程的消费者记录数据表，该表需包含姓名、地址等字段，并附带时间戳以追踪新增记录。
2) 通过Snowflake直接共享（Snowflake Direct Share）将该数据表发送至Alesco。
3) 当您在共享数据表中新增CRM数据或更新已有CRM数据时，Alesco将通过时间戳识别变更，随后自动对新增CRM记录进行处理、验证、补全与清洗，并将更新后的输出数据同步至共享输出数据表中以供访问。
4) Alesco将通过Snowflake直接共享将上述共享输出数据表回传至您的账户。
5) 每次追加处理完成后，我们将通过电子邮件向用户发送通知。

#### 触发方式详情：
针对数据净化流程，我们提供两种触发方案：
1. 固定周期触发场景：
- 我方将预设定时任务，捕获共享表中待丰富的新增记录上传操作。
2. 临时按需触发场景：
- 我方提供可直接在您的Snowflake账户中运行的脚本，用于部署外部函数。
- 外部函数部署完成后，请记录该函数的API_AWS_IAM_USER_ARN与API_AWS_EXTERNAL_ID，并将其提供给我方，以在您的Snowflake账户与我方API网关之间建立信任关系。
- 完成上述配置后，您可通过运行该函数直接调用我方服务，实现数据丰富。

通过统一流程，我们可提供以下能力：
- 字段解析与标准化
- 数据验证：验证数据是否符合预设业务规则与约束条件
- 准确性评估：确保数据贴近真实值
- 完整性判定：衡量所有必填字段的完备程度
- 一致性校验与属性补全：挖掘多数据集间各属性的一致性问题，并提供属性补全能力以填补关键数据空白
- 格式统一：确保数据采用统一的度量单位，在提交至数据洁净室前完成格式修正

#### 包含字段：
FIRST_NAME
LAST_NAME
ADDRESS
PHONE
EMAIL
TIMESTAMP
ALESCO_PERM_INDIVIDUAL_ID
ALESCO_ADDRESS
ALESCO_CITY
ALESCO_STATE
ALESCO_ZIP
ALESCO_PHONE
LINE_TYPE
PHONE_DATE
ALESCO_EMAIL
EMAIL_OPTIN_DATE
BUSINESS_EMAIL
BUSINESS_PHONE
COMPANY_NAME
BUSINESS_ADDRESS
BUSINESS_SUITE
BUSINESS_CITY
BUSINESS_STATE
BUSINESS_ZIP

搜集汇总

背景与挑战

背景概述

该数据集提供CRM数据的标准化验证、清理和补全服务，通过Snowflake平台实现自动化处理，支持定时和按需两种触发模式，涵盖姓名、地址、电话等核心字段的增强处理。