Pushwoosh

Creating the data source

By adding the Pushwoosh data source to Kondado, you can access your notification and campaign data in your Data Warehouse or Data Lake - a process also known as ETL or ELT

Adding the data source

Requirements

Your Pushwoosh account must be of the Private Offering type
Preferably, follow the instructions below with a user who has a higher access level in the application

Instructions

1) Access the API Access section of your control panel

2) Click on Generate new access token

3) Configure the token as you prefer and click Save

4) Copy the value of your new Token

5) Log in to Kondado, go to the add data sources page and select the Pushwoosh data source

6) In the data source, under "Name" give your data source a name and, under Token, paste the value obtained in step (4)

Now just click on SAVE to start receiving data from Pushwoosh in your Data Warehouse or Data Lake

Pipelines

Relationship chart

Click to expand

App Stats

Replication type: Incremental with update window

Parameters:

Update window after send (days): How many days after the send date (savepoint) the messages can still be updated
Read start date (Savepoint): The date for the initial data replication

Relationships:

app_code → Apps > app_code

Aggregated per-application statistics over time, one row per action, app, platform, datetime, granularity and detail level. Carries the event count. Relates to pushwoosh_apps through the app_code column.

Campo	Tipo
action	text
app_code	text	Apps > > app_code
stat_datetime	timestamp
platformid	float	[en] 1 - ios, 2 - blackberry, 3 - android, 5 - windows phone, 7 - osx, 8 - windows, 9 - amazon, 10 - safari
stats_granularity	text
stats_level	text
app_name	text
count	float

Apps

Replication type: Full

Applications (apps) registered in the Pushwoosh account, one per row. Each row holds the app identifier code (app_code) and the application name.

Campo	Tipo
app_code	text	[pt] id do cliente
app_name	text

Push History

Replication type: Full

Relationships:

stats__app_code > stats → Apps > app_code

Main object

History of push messages sent by the Pushwoosh account, one per row. Includes message code, campaign identifiers and name, per-platform content and titles (iOS/Android), targeting conditions, destination URL and the creation and send timestamps.

Campo	Tipo
id	text
android_header	text
android_root_params	text
campaignid	text
campaignname	text
code	text
conditions	text
conditions_operator	text
createdate	timestamp
data	text
filter_code	text
filter_conditions	text
filter_name	text
geozone	text
ios_root_params	text
ios_subtitle	text
ios_title	text
richpageid	text
senddate	timestamp
subscription_segments	text
trackingcode	text
url	text

pushwoosh_push_history__stats

Child table of pushwoosh_push_history holding the delivery statistics of each push message, broken down by app and platform, one row per combination. Carries the statistic type (sent, opened, errors) and its value. Linked to the parent message through the push_history_id column.

Campo	Tipo
push_history_id	text
stats__app_code	text	Apps > > app_code
stats__platform	text
stat	text
stats__val	float

pushwoosh_push_history__content_translations

Child table of pushwoosh_push_history holding the content translations of each push message, one row per language. Carries the language (lang) and the message text in that language. Linked to the parent message through the push_history_id column.

Campo	Tipo
push_history_id	text
content_translations__content	text
content_translations__lang	text

Push Stats

Replication type: Incremental with update window

Parameters:

Update window after send (days): How many days after the send date (savepoint) the messages can still be updated
Read start date (Savepoint): The date for the initial data replication

Relationships:

push_history_id → Push History > id
push_code → Push History > code

Time-series statistics of each push message, one row per action (e.g. sent, opened), datetime and granularity. Carries the event count per message. Relates to pushwoosh_push_history through the push_history_id and push_code fields.

Campo	Tipo
action	text
stat_datetime	timestamp
push_history_id	text	Push History > > id
stats_granularity	text
push_code	text	Push History > > code
count	float

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Pushwoosh as a data source on Kondado

Connect your Pushwoosh Private Offering account to Kondado by generating an API access token and configuring the data source.

1

Verify your Pushwoosh account type

Ensure your Pushwoosh account is of the Private Offering type, and use a user with higher access level for best results.

2

Generate an API access token in Pushwoosh

In your Pushwoosh control panel, go to API Access, click Generate new access token, configure it as preferred, then Save and copy the token value.

3

Add Pushwoosh on Kondado

Log in to Kondado, navigate to add data sources, and select the Pushwoosh connector.

4

Configure and save the data source

Enter a Name for your data source, paste the Token from step 2, then click SAVE to start receiving Pushwoosh data in your Data Warehouse or Data Lake.

5

Explore available Pushwoosh data pipelines

Once connected, you can access pipelines including Apps, Push history, Push stats, and App stats with their respective fields and data types.

Frequently asked questions

What type of Pushwoosh account do I need to connect to Kondado?▼

You need a Private Offering type Pushwoosh account. This is a strict requirement — other account types will not work with the Kondado connector.

Where do I find the API token needed for the Kondado integration?▼

In your Pushwoosh control panel, go to the API Access section, click Generate new access token, configure it as you prefer, save it, and then copy the token value to paste into Kondado.

What Pushwoosh data can I access through Kondado?▼

You can access several pipelines including Apps (app_code, app_name), Push history (with campaign details, send dates, and content), Push stats (action counts by push), App stats (platform-level metrics), and related data like stats and content_translations.

Can I send Pushwoosh data to BI tools and dashboards?▼

Yes, after connecting Pushwoosh to Kondado, you can route the data to various destinations including BI tools and dashboards for visualization and analysis.

What should I do if I don't have sufficient access level in Pushwoosh?▼

The article recommends using a user with a higher access level in the Pushwoosh application. If you encounter permission issues, contact your Pushwoosh account administrator to either elevate your access or have them generate the API token for you.

Written by

Thassyo Pereira·Published 2023-07-05·Updated 2026-06-01