FirstHive User Event Demo Dataset

This synthetically generated demo dataset simulates real user behavior across key events like sessions, purchases, and deliveries. **FirstHive** customers can explore these samples to see the rich event and engagement data our platform provides—perfect for testing personalization and activation strategies. No real customer data is included.

原始信息汇总

FirstHive User Event Demo Dataset

概述

• 提供方: FirstHive Tech Corp
• 试用信息: 30天免费试用
• 数据性质: 合成生成的演示数据集，模拟真实用户行为
• 数据内容: 包含会话、购买和交付等关键事件的用户行为数据
• 用途: 用于测试个性化和激活策略，不包含真实客户数据

业务需求

1. 360度客户视图

   • 数据统一: 整合和清理分散的数据，形成安全、统一的来源

2. 机器学习

   • AI驱动的洞察: 使用高级细分、身份解析和预测分析

3. 个性化客户体验

   • 超个性化: 跨渠道提供实时、AI驱动的体验

4. 受众激活

   • 实时激活: 利用AI编排和Snowflake的可扩展性

5. 监管报告

   • 隐私合规: 确保符合GDPR、CCPA等行业标准

数据字典

PRGM_EMAIL_CLICKS表

• 列名:
  • ECL_PK_ID (Number)
  • PRGM_FK_ID (Number)
  • USR_FK_ID (Number)
  • USR_UNIQUE_ID (Varchar)
  • USR_INTERACTION_ID (Varchar)
  • USR_REF_INTERACTION_ID (Varchar)
  • USR_UNIQUE_ID_NEW (Varchar)
  • USR_PERSONA_ID (Varchar)
  • CMP_FK_ID (Number)
  • PCE_FK_ID (Number)
  • MESSAGE_ID (Varchar)
  • CURL_FK_ID (Number)
  • ECL_URL (Varchar)
  • ECL_CREATED_ON (Timestamp_NTZ)
  • ECL_REFERERURL (Varchar)
  • ECL_IPADDR (Varchar)
  • ECL_COUNTRY (Varchar)
  • ECL_BROWSERNAME (Varchar)
  • ECL_BROWSERVERSION (Varchar)
  • ECL_CLIENTPLATFORM (Varchar)
  • FH_UPDATED_DATE (Timestamp_NTZ)
  • LAST_SYNC_DATE (Timestamp_NTZ)
  • DML_OPERATION_TYPE (Number)

使用示例

1. 电子邮件分析 sql SELECT SUM(IFF(pse.SEMAIL_STATUS=1,1,0)) AS Totalsent, COUNT(DISTINCT pec.usr_unique_id) AS Clickcount, COUNT(DISTINCT peo.usr_unique_id) AS Opencount, FROM FH_MARKET_DB.USER_MASTER UM JOIN FH_MARKET_DB.USER_DETAILS UD ON UM.USR_UNIQUE_ID =UD.USR_UNIQUE_ID JOIN FH_MARKET_DB.prgm_sent_email pse ON pse.usr_unique_id = UM.usr_unique_id LEFT JOIN FH_MARKET_DB.prgm_email_open peo ON peo.usr_unique_id = pse.usr_unique_id LEFT JOIN FH_MARKET_DB.prgm_email_clicks pec ON pec.usr_unique_id = pse.usr_unique_id WHERE USD_CITY = San Francisco;

2. 用户信息查询 sql SELECT UM.USR_EMAIL, UM.USR_MOBILE, UD.USD_FIRSTNAME, UD.USD_LASTNAME FROM FH_MARKET_DB.USER_DETAILS UD JOIN FH_MARKET_DB.USER_MASTER UM ON UD.USR_UNIQUE_ID =UM.USR_UNIQUE_ID WHERE UD.USD_CITY = San Francisco;

3. 短信分析 sql SELECT COUNT(PSS.SSMS_PK_ID) AS Totalsent, SUM(CASE WHEN PSS.SSMS_STATUS = 1 THEN 1 ELSE 0 END) AS TotalDelivered, SUM(CASE WHEN PSS.SSMS_STATUS != 1 THEN 1 ELSE 0 END) AS TotalFailed, COUNT(DISTINCT SUO.USR_UNIQUE_ID) AS TotalClicks FROM FH_MARKET_DB.USER_MASTER UM JOIN FH_MARKET_DB.USER_DETAILS UD ON UM.USR_UNIQUE_ID =UD.USR_UNIQUE_ID LEFT JOIN FH_MARKET_DB.PRGM_SENT_SMS PSS ON UM.USR_UNIQUE_ID = PSS.USR_UNIQUE_ID LEFT JOIN FH_MARKET_DB.PRGM_SMS_URL_OPEN SUO ON PSS.USR_UNIQUE_ID = SUO.USR_UNIQUE_ID WHERE UD.USD_CITY = San Francisco;

分类

• 360度客户视图
• 受众激活
• 机器学习
• 营销
• 个性化客户体验
• 监管报告

技术信息

• 刷新频率: 近实时
• 时间覆盖范围: 最近7天，基于事件
• 地理覆盖范围: 全球，按经纬度
• 云区域可用性: AWS多个区域

联系方式

• 销售: [e-mail]
• 支持: [e-mail]