Messaging Data: Personalized User Profiles & Events

Cordial provides real-time access to your customer’s profile updates, messaging engagements, and browsing/purchase behaviors. This helps you to analyze engagement trends, monitor customer behaviors, gauge performance, and unlock new insights to drive your business. Secure share tables & views can be customized to your desired specifications. Data is available retroactively in perpetuity, updated multiple times per day, and immediately queryable. Views included: - CONTACTACTIVITY - CONTACTS - ORDERS - MESSAGESENDS Fields for CONTACTACTIVITY view: - ACTION: the type of event (click, open, etc) - ACTION_DATE: The date the event took place - CREATED_DATE: The date the event was ingested - CID: The ID of the referenced contact record - MCID: The ID of the referenced messagecontacts record - MDTID: The ID of the referenced messagedeliverytemplate record - DEVICE The end user’s useragent device (browser, platform, type, etc). - GEO: Location data geo-coded from the end user’s ip address (latitude, longitude, country, state, postal code, etc). - SYSTEM_PROPERTIES: Operational data such as email domain, message tags, and referring link - PROPERTIES: Optional custom data specified by the customer for a given action type Fields for CONTACTS view: - ID: Unique contact identifier generated by Cordial - MODIFIED_DATE: The date the contact was last modified - CREATED_DATE: The date the contact was created - MDTLASTSENT: The MDTID and Datetime of the most recent messages sent to the contact - LIST_JOIN_DATE: The LIST_ID and join date of the lists to which the contact is subscribed - LIST: The LIST_ID of the lists to which the contact is subscribed - CHANNELS: The delivery channels to which the contact is (or has been) subscribed, including id (e.g. email) - ATTRIBUTES: The custom fields set for the contact - CART: The items in the user’s cart FIelds for ORDERS view: - ID: Unique order identifier generated by Cordial - ORDERID: Unique order identifier generated by the Client - MODIFIED_DATE: The date the order was last modified - CREATED_DATE: The date the order was created - CID: The ID of the referenced contact record - TOTALAMOUNT: total amount of the order - PURCHASEDATE: the purchase date of the order - ITEMS: the list of items in the order Expected workflow: - Request access to this listing and your Cordial CSM will reach out. - Work with the Cordial team to confirm details of the data share to your Snowflake instance. - Begin access to your secure data share!

搜集汇总

背景与挑战

背景概述

该数据集提供Cordial平台的实时客户档案、消息互动及浏览/购买行为数据，支持分析互动趋势、监控行为并评估绩效。数据以可自定义的安全共享表和视图形式呈现，支持历史追溯和每日多次更新，包含联系人活动、联系人信息、订单及消息发送四个核心视图。