Blueshift
This source is currently in alpha. The interface and available tables may change.
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Blueshift to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync campaigns, daily campaign performance, templates, segments, subscription groups and tags from Blueshift.
Use a user API key from Account settings > API keys in Blueshift. Pick the region your account is hosted in.
Configuration
| Option | Type | Required |
|---|---|---|
User API key | password | Yes |
Region | select | Yes |
Linking Blueshift to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Blueshift
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
campaigns | Campaigns in the account. Without a start date filter Blueshift lists one-time campaigns from the last 30 days only; recurring, ongoing, transactional and onsite campaigns are listed in full. | Full refresh | — | — |
campaign_stats | Performance summary of each campaign per UTC day: sends, deliveries, opens, clicks, purchases and revenue attributed to that day. | Incremental, Full refresh | date | — |
email_templates | Email templates, including archived ones. | Full refresh | — | — |
push_templates | Mobile push notification templates, including archived ones. | Full refresh | — | — |
sms_templates | SMS and MMS templates, including archived ones. | Full refresh | — | — |
segments | Audience segments with their approximate user counts per channel. | Full refresh | — | — |
subscription_groups | Subscription groups users can opt in to or out of, active and archived. | Full refresh | — | — |
tags | Tag folders and the campaigns, segments and templates tagged with them. | Full refresh | — | — |