Linking Simplecast as a source

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.

Learn more
PostHog Wizard hedgehog

Sync your Simplecast podcast data into the PostHog data warehouse.

Adding a data source

  1. Go to the sources tab of the data pipeline section in PostHog.
  2. Click + New source and then click Link next to Simplecast.
  3. Create an API token on the Private Apps page in Simplecast. The token grants read access to the podcasts your account can see.
  4. Back in PostHog, enter your API token, then click Next.
  5. Select the tables you want to sync, set the sync method and frequency, then click Import.

Once the syncs are complete, you can start using Simplecast data in PostHog.

Available tables

TableDescriptionSync method
podcastsPodcasts (shows) hosted on Simplecast that your token can accessFull refresh
episodesEpisodes of a podcast, in any statusFull refresh
downloadsDaily download counts per podcastFull refresh
listenersDaily unique listener counts per podcastFull refresh
episode_downloadsAll-time download totals per episodeFull refresh
episode_listenersAll-time unique listener totals per episodeFull refresh

Full refresh tables reload all data on each sync.

Configuration

OptionTypeRequired
API tokenpasswordYes

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
podcasts

A podcast (show) hosted on Simplecast that the account's token can access.

Full refresh——
episodes

An episode created on a Simplecast podcast, in any status (draft, scheduled, published or private).

Full refresh——
downloads

Daily downloads of a Simplecast podcast, one row per podcast and day since the podcast was published.

Full refresh——
listeners

Daily unique listeners of a Simplecast podcast, one row per podcast and day since the podcast was published.

Full refresh——
episode_downloads

All-time downloads of each episode of a Simplecast podcast.

Full refresh——
episode_listeners

All-time unique listeners of each episode of a Simplecast podcast.

Full refresh——
seasons

A season of a Simplecast podcast. Join it to episodes on the podcast ID and the season number.

Full refresh——
locations

All-time downloads of a Simplecast podcast by listener country, one row per podcast and country.

Full refresh——
distribution_channels

A platform that Simplecast can distribute podcasts to, such as Apple Podcasts or Spotify.

Full refresh——
podcast_distribution_channels

A distribution channel that was added to a Simplecast podcast, with the podcast's URL on that platform.

Full refresh——
technology_applications

All-time downloads of a Simplecast podcast by listening application, one row per podcast and value.

Full refresh——
technology_browsers

All-time downloads of a Simplecast podcast by web browser, one row per podcast and value.

Full refresh——
technology_devices

All-time downloads of a Simplecast podcast by device model, one row per podcast and value.

Full refresh——
technology_device_class

All-time downloads of a Simplecast podcast by device type (for example phone, desktop or smart speaker), one row per podcast and value.

Full refresh——
technology_listening_methods

All-time downloads of a Simplecast podcast by listening method, one row per podcast and value.

Full refresh——
technology_network_types

All-time downloads of a Simplecast podcast by network type, one row per podcast and value.

Full refresh——
technology_operating_systems

All-time downloads of a Simplecast podcast by operating system, one row per podcast and value.

Full refresh——
technology_providers

All-time downloads of a Simplecast podcast by network provider, one row per podcast and value.

Full refresh——
technology_web_players

All-time downloads of a Simplecast podcast by web player, one row per podcast and value.

Full refresh——

Still have questions?

Was this page useful?