Transistor.fm
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 Transistor.fm to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync your shows, episodes, private podcast subscribers, and daily download analytics from Transistor into the PostHog Data warehouse.
Create an API key in your Transistor account settings, then paste it below. The key has access to every show your Transistor user can see.
Download analytics sync incrementally by day. The other tables sync as a full refresh.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Linking Transistor.fm to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Transistor.fm
- 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 |
|---|---|---|---|---|
shows | Podcasts on the account, one row per show, with title, description, category, feed URL, and privacy settings. | Full refresh | — | id |
episodes | Episodes across every show on the account, including drafts and scheduled episodes, with audio, artwork, and publishing metadata. | Full refresh | — | id |
subscribers | Private podcast subscribers, one row per subscriber per show. Only shows marked private have subscribers. | Full refresh | — | show_id, id |
webhooks | Webhook subscriptions registered on each show, with the subscribed event name and delivery URL. | Full refresh | — | show_id, id |
show_analytics | Daily download counts per show, one row per show per day. | Incremental, Full refresh | date | show_id, date |
episode_analytics | Daily download counts per episode, one row per episode per day. | Incremental, Full refresh | date | show_id, episode_id, date |