Skip to content
Book a demoStart free
Connectors

OneSignal connector

Set up the OneSignal connector in Kaivo: authentication, configuration, the 4 BigQuery tables it syncs, and answers to common questions.

OneSignal connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your OneSignal data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your survey and email data instead of moving it.

Sync your OneSignal messaging data into BigQuery with Kaivo to analyse notifications and audience reach.

CategorySurveys & Email
AuthenticationAPI key
SetupSelf-service

Getting started with the OneSignal connector

Section titled “Getting started with the OneSignal connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your OneSignal account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your User Auth Key.

Field Description
User Auth Key
Your OneSignal User Auth Key. Find it in your profile under Account & API Keys.

|

When you set up the connector, you provide:

Field Description
Applications
Start Date
Any data before this date will not be fetched.

| | Outcome Names |

Comma-separated list of outcome names and aggregation types (sum/count) to retrieve, e.g. os__session_duration.count,os__click.count,CustomOutcomeName.sum.

|

Kaivo syncs 4 tables from OneSignal into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

apps (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
players INT64
messageable_players INT64
updated_at TIMESTAMP
created_at TIMESTAMP
gcm_key STRING
chrome_key STRING
chrome_web_key STRING
chrome_web_origin STRING
chrome_web_gcm_sender_id STRING
chrome_web_default_notification_icon STRING
chrome_web_sub_domain STRING
apns_env STRING
apns_certificates STRING
safari_apns_certificate STRING
safari_site_origin STRING
safari_push_id STRING
safari_icon_16_16 STRING
safari_icon_32_32 STRING
safari_icon_64_64 STRING
safari_icon_128_128 STRING
safari_icon_256_256 STRING
site_name STRING
basic_auth_key STRING
additional_data_is_root_payload BOOL
apns_key_id INT64
fcm_v1_service_account_json STRING
apns_p8 STRING
apns_bundle_id INT64
apns_team_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
devices (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
identifier STRING
session_count INT64
language STRING
timezone INT64
game_version STRING
device_os STRING
device_type INT64
device_model STRING
ad_id STRING
last_active INT64
amount_spent FLOAT64
created_at INT64
invalid_identifier BOOL
badge_count INT64
playtime INT64
sdk STRING
test_type STRING
ip STRING
external_user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
notifications (109 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
adm_big_picture STRING
adm_group STRING
adm_group_message__en STRING
adm_large_icon STRING
adm_small_icon STRING
adm_sound STRING
alexa_ssml STRING
alexa_display_title STRING
amazon_background_data BOOL
android_accent_color STRING
android_group STRING
android_group_message__en STRING
android_led_color STRING
android_sound STRING
android_visibility INT64
app_id STRING
big_picture STRING
buttons STRING
canceled BOOL
chrome_big_picture STRING
chrome_icon STRING
chrome_web_icon STRING
chrome_web_image STRING
chrome_web_badge STRING
content_available BOOL
name STRING
contents__en STRING
converted INT64
delayed_option STRING
delivery_time_of_day STRING
errored INT64
failed INT64
firefox_icon STRING
global_image STRING
headings__en STRING
huawei_accent_color STRING
huawei_big_picture STRING
huawei_channel_id STRING
huawei_existing_channel_id STRING
huawei_group STRING
huawei_group_message STRING
huawei_large_icon STRING
huawei_led_color STRING
huawei_msg_type STRING
huawei_small_icon STRING
huawei_sound STRING
huawei_visibility STRING
id STRING
include_player_ids STRING
include_external_user_ids STRING
thread_id STRING
ios_badge_count INT64
ios_badge_type STRING
ios_category STRING
ios_interruption_level STRING
ios_relevance_score FLOAT64
ios_sound STRING
target_content_identifier STRING
is_adm BOOL
is_android BOOL
is_chrome BOOL
is_chrome_web BOOL
is_alexa BOOL
is_firefox BOOL
is_ios BOOL
is_safari BOOL
is_wp BOOL
is_wp_wns BOOL
is_edge BOOL
is_huawei BOOL
is_sms BOOL
large_icon STRING
priority INT64
queued_at INT64
remaining INT64
send_after INT64
completed_at INT64
small_icon STRING
successful INT64
received INT64
filters STRING
template_id STRING
ttl INT64
url STRING
web_url STRING
app_url STRING
web_buttons STRING
web_push_topic STRING
wp_sound STRING
wp_wns_sound STRING
platform_delivery_stats__android__successful INT64
platform_delivery_stats__android__errored INT64
platform_delivery_stats__android__failed INT64
platform_delivery_stats__android__converted INT64
platform_delivery_stats__android__received INT64
platform_delivery_stats__ios__successful INT64
platform_delivery_stats__ios__errored INT64
platform_delivery_stats__ios__failed INT64
platform_delivery_stats__ios__converted INT64
platform_delivery_stats__ios__received INT64
ios_attachments__id STRING
throttle_rate_per_minute INT64
sms_from STRING
sms_media_urls STRING
email_click_tracking_disabled BOOL
fcap_group_ids STRING
fcap_status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: notifications__excluded_segments

Section titled “Subtable: notifications__excluded_segments”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: notifications__included_segments

Section titled “Subtable: notifications__included_segments”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
outcomes (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
value INT64
aggregation STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where OneSignal supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for OneSignal?

Section titled “How long does the initial sync take for OneSignal?”

It depends on how much history is in your OneSignal account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when OneSignal’s schema changes?

Section titled “What happens when OneSignal’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in OneSignal, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in OneSignal instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the OneSignal connector in Kaivo and all of its synced data is deleted with it.

Use notifications and outcomes to track sends and engagement over time.

Join apps with devices to see how many users you can reach.

Bring messaging data into BigQuery to connect notifications to user actions.

Use OneSignal data in your AI and BI tools

Section titled “Use OneSignal data in your AI and BI tools”

Once OneSignal data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with OneSignal data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for OneSignal connector pricing and plan details.