Exporting data
Learn how to export user, message, and outcome data from the OneSignal dashboard and API, including CSV delivery reports, subscription data, and per-user message event activity.
Overview
You can export data from OneSignal in several ways depending on your use case. This includes dashboard CSV exports, API endpoints, and real-time data streaming integrations. This guide covers how to export:
- Message and delivery data
- Audience activity per message
- Subscription and user profile data
- Email message delivery reports
- Alternative programmatic methods via API or Event Streams
Data retention
Messages sent via our dashboard Messages form are accessible for the lifetime of the app.
Messages sent via our API and Audience Activity are only accessible for around 30 days from when they were created.
Journeys-sent messages are downloadable from the dashboard. See Journey analytics for more details.
Export methods
Event Streams
Send message events like sents, opens, clicks, and more to your chosen destination.
View Messages API
Retrieve message reports in JSON format including delivery and performance stats.
Journey Analytics
Track performance for messages sent via Journeys and download reports.
Template Analytics
Export performance data for reusable templates.
Integrations
Export data into third-party tools like Segment, Mixpanel, or Google BigQuery.
Dashboard exports
Export data from the dashboard in CSV format.
Export message data
You can export individual push, in-app, email, SMS, and Live Activity message data when viewing the message within the dashboard.
You can bulk export push, email, SMS and Live Activity messages from the Delivery > Sent Messages page.
Available filters:
- Source: Dashboard, API, Automated, or Test Messages
- Device Type: Push, In-App, Email, SMS, or Live Activity
- Text Search: Search by message Content, Heading and name. Currently only available with Source: Dashboard Messages.
- Start Date & End Date: Select a start date and end date to filter messages by. Filters based on “Sent At” date based on your current timezone.
Messages table export
You can export individual push, in-app, email, SMS, and Live Activity message data when viewing the message within the dashboard.
You can bulk export push, email, SMS and Live Activity messages from the Delivery > Sent Messages page.
Available filters:
- Source: Dashboard, API, Automated, or Test Messages
- Device Type: Push, In-App, Email, SMS, or Live Activity
- Text Search: Search by message Content, Heading and name. Currently only available with Source: Dashboard Messages.
- Start Date & End Date: Select a start date and end date to filter messages by. Filters based on “Sent At” date based on your current timezone.
Messages table export
You can export message data via our REST API using the following endpoints:
- View message: Fetch data for a single message using its
id. - View messages: Retrieve a paginated list (up to 50 per page).
- Export audience activity CSV: Per-user event CSV including sent, open, click data.
- Message history: Limited to
sentandclickedevents within a 7-day window.
Export user and subscription data
- Go to Audience > Subscriptions.
- Optionally filter by Segment.
- Ensure all desired columns are visible.
- Click Export.
Subscriptions table export
- Go to Audience > Subscriptions.
- Optionally filter by Segment.
- Ensure all desired columns are visible.
- Click Export.
Subscriptions table export
You can export user and subscription data via our REST API using the following endpoints:
- CSV export: Provides a download link to a CSV file of all user data.
- View user: Retrieve the current state of a user, identified by the
alias_labelandalias_id.
Exporting data
Learn how to export user, message, and outcome data from the OneSignal dashboard and API, including CSV delivery reports, subscription data, and per-user message event activity.
Overview
You can export data from OneSignal in several ways depending on your use case. This includes dashboard CSV exports, API endpoints, and real-time data streaming integrations. This guide covers how to export:
- Message and delivery data
- Audience activity per message
- Subscription and user profile data
- Email message delivery reports
- Alternative programmatic methods via API or Event Streams
Data retention
Messages sent via our dashboard Messages form are accessible for the lifetime of the app.
Messages sent via our API and Audience Activity are only accessible for around 30 days from when they were created.
Journeys-sent messages are downloadable from the dashboard. See Journey analytics for more details.
Export methods
Event Streams
Send message events like sents, opens, clicks, and more to your chosen destination.
View Messages API
Retrieve message reports in JSON format including delivery and performance stats.
Journey Analytics
Track performance for messages sent via Journeys and download reports.
Template Analytics
Export performance data for reusable templates.
Integrations
Export data into third-party tools like Segment, Mixpanel, or Google BigQuery.
Dashboard exports
Export data from the dashboard in CSV format.
Export message data
You can export individual push, in-app, email, SMS, and Live Activity message data when viewing the message within the dashboard.
You can bulk export push, email, SMS and Live Activity messages from the Delivery > Sent Messages page.
Available filters:
- Source: Dashboard, API, Automated, or Test Messages
- Device Type: Push, In-App, Email, SMS, or Live Activity
- Text Search: Search by message Content, Heading and name. Currently only available with Source: Dashboard Messages.
- Start Date & End Date: Select a start date and end date to filter messages by. Filters based on “Sent At” date based on your current timezone.
Messages table export
You can export individual push, in-app, email, SMS, and Live Activity message data when viewing the message within the dashboard.
You can bulk export push, email, SMS and Live Activity messages from the Delivery > Sent Messages page.
Available filters:
- Source: Dashboard, API, Automated, or Test Messages
- Device Type: Push, In-App, Email, SMS, or Live Activity
- Text Search: Search by message Content, Heading and name. Currently only available with Source: Dashboard Messages.
- Start Date & End Date: Select a start date and end date to filter messages by. Filters based on “Sent At” date based on your current timezone.
Messages table export
You can export message data via our REST API using the following endpoints:
- View message: Fetch data for a single message using its
id. - View messages: Retrieve a paginated list (up to 50 per page).
- Export audience activity CSV: Per-user event CSV including sent, open, click data.
- Message history: Limited to
sentandclickedevents within a 7-day window.
Export user and subscription data
- Go to Audience > Subscriptions.
- Optionally filter by Segment.
- Ensure all desired columns are visible.
- Click Export.
Subscriptions table export
- Go to Audience > Subscriptions.
- Optionally filter by Segment.
- Ensure all desired columns are visible.
- Click Export.
Subscriptions table export
You can export user and subscription data via our REST API using the following endpoints:
- CSV export: Provides a download link to a CSV file of all user data.
- View user: Retrieve the current state of a user, identified by the
alias_labelandalias_id.