Message Event Data

OneSignal’s message events data contains data points from email, push notifications, in-app, and SMS messages sent through the platform. By integrating with OneSignal, you unlock the ability to automatically sync message event data to your Snowflake database. This allows you to run queries and generate reports based on user generated events.

Message Event Kinds
- Push Notification (Sent, Clicked, Received)
- In-App Message (Displayed, Clicked, Page Displayed)
- Email (Opened, Unsubscribed, Reported As Spam, Hard Bounced, Failed)
- SMS (Delivered, Failed, Undelivered)

Message Event Meta Data
- Subscription ID
- OneSignal ID
- External ID
- Subscription Language
- Subscription Timezone
- Subscription Type (SMS, Email, In-app-message, etc)
- Event Timestamps
- Message Name
- Message Title
- Message Body (Truncated)

Expected workflow:
1. Request access via this marketplace listing
2. OneSignal will reach out and confirm the details of the data share
3. Accept the data share from Onesignal, data will start syncing at this point
4. Start querying your OneSignal data in your own data warehouse 🎉

搜集汇总

背景与挑战

背景概述

该数据集包含通过OneSignal平台发送的电子邮件、推送通知、应用内消息和短信的事件数据，涵盖发送、点击、打开等多种事件类型及相关元数据。它支持自动同步到Snowflake数据库，便于用户查询和分析基于用户生成事件的报告。