How can I export my campaign data to an external system like ClickHouse?

There are two primary methods for exporting data from Pushwoosh, each suited for different purposes: the Pushwoosh API and Event Streaming.

1. Pushwoosh API (Statistics API)

This method allows you to pull aggregated data and lists of previously sent messages from Pushwoosh. It is the best choice if your goal is to create a historical record or a directory of your campaigns in an external data warehouse.

• Use Case: Periodically fetching a list of all campaigns with their attributes (ID, name, content, send date) and performance statistics (sends, opens, clicks) to store and analyze in your own system.
• Recommended API Method: For getting a list of one-time messages and their details, the messages:list method is the most suitable. You can find its documentation here: Message Statistics API - messages:list.

2. Event Streaming

This feature pushes data about individual events (e.g., Push Sent, Push Opened) to your own endpoint in real-time via HTTP or gRPC. It provides a continuous stream of granular, user-level interactions as they happen.

• Use Case: Powering real-time analytics dashboards, tracking detailed user engagement funnels, or triggering actions in other systems based on user behavior.
• Data Structure: The data from Event Streaming is a flow of individual events, not a consolidated summary of a campaign. For more details, see our Event Streaming documentation.

Recommendation

To build a reference table of your campaigns in ClickHouse, we recommend using the Pushwoosh API, specifically the messages:list method. You can call this method on a schedule (e.g., daily) to retrieve information about newly sent campaigns and update your database.