Schema · Entity relationship diagram
Podscribe tables and relationships
Podscribe podcast, streaming audio and YouTube ad measurement: daily impressions, views, reach, spend, clicks, promo code uses, visitors, purchases and revenue (measured and modeled) by campaign, show and episode, using the same attribution settings as your Podscribe dashboard.
ConnectPaste an API key
Default schema
podscribeSource API docshelp.podscribe.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
- One row per day x campaign x show x episode, using your Podscribe dashboard's attribution defaults (multi-touch time decay, 30-day window, spend on publish date).
- The last 60 days are refreshed on every sync because attribution restates.
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
1 tables · click a table for its columnsdaily_performance47 columnsshow in diagram
DAY x CAMPAIGN x SHOW x EPISODE ("By Campaign & Day" report)
Primary key: day
| Column | Type | Key | Description |
|---|---|---|---|
| dayPrimary key. Upsert key: a re-pulled day replaces all of its rows. | date | PK | Primary key. Upsert key: a re-pulled day replaces all of its rows. |
| advertiser | varchar(256) | ||
| media_type | varchar(64) | ||
| type | varchar(64) | ||
| tags | varchar(1024) | ||
| publisher | varchar(512) | ||
| publisher_id | varchar(64) | ||
| campaign | varchar(1024) | ||
| campaign_id | varchar(256) | ||
| campaign_internal_id | varchar(256) | ||
| podscribe_campaign_id | varchar(64) | ||
| show_name | varchar(1024) | ||
| episode | varchar(2048) | ||
| episode_guid | varchar(512) | ||
| episode_id | varchar(64) | ||
| publish_date | date | ||
| spend | decimal(18,4) | ||
| podcast_streaming_impressions | decimal(18,2) | ||
| youtube_views | decimal(18,2) | ||
| rumble_impressions | decimal(18,2) | ||
| spotify_video_impressions | decimal(18,2) | ||
| reach | decimal(18,2) | ||
| clicks | decimal(18,2) | ||
| promo_codes | decimal(18,2) | ||
| visitors | decimal(18,4) | ||
| visits | decimal(18,4) | ||
| leads | decimal(18,4) | ||
| installs | decimal(18,4) | ||
| signups | decimal(18,4) | ||
| purchases | decimal(18,4) | ||
| revenue | decimal(18,4) | ||
| visitors_modeled | decimal(18,4) | ||
| visits_modeled | decimal(18,4) | ||
| leads_modeled | decimal(18,4) | ||
| installs_modeled | decimal(18,4) | ||
| signups_modeled | decimal(18,4) | ||
| purchases_modeled | decimal(18,4) | ||
| revenue_modeledPodscribe's modeled revenue (scaled for unmatched listeners). | decimal(18,4) | Podscribe's modeled revenue (scaled for unmatched listeners). | |
| product | varchar(512) | ||
| initiative | varchar(512) | ||
| business_line | varchar(512) | ||
| campaign_promo | varchar(512) | ||
| campaign_geo | varchar(256) | ||
| campaign_start_date | date | ||
| campaign_expected_date | date | ||
| campaign_end_date | date | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |