Export message data

How to download your message data from the dashboard and API

This guide explains how message data can be accessed and exported from OneSignal.

Data retention

Audience Activity and messages sent via our API are only accessible for around 30 days from when they were created.

Messages sent through the OneSignal dashboard Messages form are accessible for the lifetime of the app.

Journeys-sent messages are downloadable from the dashboard. See Journey analytics for more details.


API message exports

You can access push, email, and SMS message data from our API with the following options. In-app message data is only available in the dashboard when viewing the message.

View message(s) APIs

Allows you to pull the message data in JSON format including the payload, targeting parameters, delivery stats, and more.

The View message API provides the message data for a single message. This is common for use cases where you store the message "id" after sending it via the Create message API to access the data at some point in the future.

The View messages API provides a paginated view of up to 50 messages per request.

Audience activity CSV exports

Generate a compressed CSV report of events at a per-user bases for a message.

The Export audience activity CSV API will provide all message events at a per user basis.

The Message history API only provides the "sent" and "clicked" data over a 7 day period.

Event streams

Event Streams allow you to get real-time message event data at a per-user basis.


Dashboard message exports

For push, email, and SMS messages sent via our dashboard Messages form or API, you can export this within Delivery > Sent messages > Export. You can also export the Audience Activity on a per-message basis.

In-app message data is only available in the dashboard when viewing the message.

For Journey-sent message reports, see Journey analytics for more details.


Exported data attributes

PropertyDescription
idThe OneSignal message ID.
nameThe name you gave the message.
completed_atWhen the Notification finished sending in UTC format.
total_queuedHow many subscriptions were in the targeting parameters at the time of sending.
successfulHow many messages were delivered to Google and Apple's servers.
failedHow many messages were sent to unsubscribed devices. See What are Failed Notifications for details.
erroredHow many error users were reported, check your OneSignal dashboard settings for more details.
remainingHow many messages are left to be sent.
receivedHow many devices received the message. See Confirmed Deliveries.
convertedHow many messages were clicked.
contentsThe Notification Message body.
headingsThe Notification Title.
queued_atWhen the message was created in UTC format.
send_afterWhen the Notification was set to start sending to subscribers.
urlThe Launch URL set.
dataAny custom data set in the notification.
contents_en, headings_en, etcContents and headings based on language translations provided.
delayed_optionIf timezone or intelligent delivery was used.
delivery_time_of_dayIf timezone was used, the timezone to deliver.
global_imageGlobal Image URL used.
included_segments, excluded_segments, filtersSegments included or excluded if provided. Otherwise, filters used.
isIos, isAndroid, isHuawei, isSMS, isWeb, isEmailPlatforms enabled (t) or disabled (f).
throttle_rate_per_minuteThrottle rate set.
frequency_capped, frequency_capped_statusNumber capped and if capping was enabled.

Channel specific attributes

ChannelAttributeDescription
Emailemail_subjectThe subject of the email.
email_from_nameThe senders name.
email_from_addressThe senders email.
isEmailBoolean - indicates if message was an Email message.
SMSsms_fromSender of the SMS.
sms_media_urls
isSMSBoolean - indicates if message was an SMS message.
Huwaeihuawei_sound
huawei_led_color
huawei_accent_color
huawei_channel_color
huawei_visibility
huawei_channel_id
huawei_small_icon
huawei_large_icon
huawei_big_picture
huawei_msg_type
Specific Attributes for message sends to Huawei devices.
iOSios_attachmentsAn object of the iOS attachment.
Androidandroid
Live Activitieslive_activity_activity_idThese identifiers should be unique to each Live Activity.
live_activity_ios_event_updatesData payload for Live Activity updates.
live_activity_ios_event_kindSpecifies if an event is an update or end of a Live Activity.
live_activity_ios_dismiss_atThe time that the Live Activity will disappear from the lock screen.
live_activity_ios_stale_dateThe time that the system considers the Live Activity outdated and changes Activity State to ActivityState.stale.
Amazon Fireamazon_fire
Chrome Browser Extensionschrome_extension
Windows Phone 8.0windows_phone_legacy

Platform statistics

Platform statistics enable you to see how a platform is performing.

ChannelData AttributeDetails
Web Pushedge_web_pushHow well users have interacted with web push on Edge Browsers.
chrome_web_pushHow well users have interacted with web push on Chrome Browsers.
firefox_web_pushHow well users have interacted with web push on Firefox Browsers.
safari_web_pushHow well users have interacted with web push on Safari Browsers.
Mobile PushiosHow well users have interacted on iOS devices.
androidHow well users have interacted on Android devices.
Emailsuccessful
email_successful
How many emails were accepted by the Email Service Provider.
email_deliveredThe email was received by the Inbox Service Provider and should show in the user's inbox.
failed
errored
converted
receivedHow many were accepted by the recipient email server.
frequency_capped
openedThe number of times an email has been opened. This can include the recipient opening the email multiple times.
unique_opensThe number of unique recipients who have opened your email.
clicksThe total number of clicked links from your email. This can include the recipient clicking email links multiple times.
unique_clicksThe number of unique clicks that your recipients have made on your email.
bouncedThe number of hard or soft bounces for this email. Emails that soft bounce will be retried several times before they are either successfully delivered or registered as a hard bounce.
reported_spamThe number of recipients who reported this email as spam.
unsubscribedThe number of recipients who opted out of your emails using the unsubscribe link in this email.