# StackAdapt schema ERD

Table and field reference for the Fivetran StackAdapt connector.

## Table & Field Reference

### insight_campaign_category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| code | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| display_text | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### ad_delivery

| Column | Type | Keys |
| --- | --- | --- |
| granularity_time | Unknown | PK |
| ad_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| ad_serving | Unknown |  |
| app_install | Unknown |  |
| atos | Unknown |  |
| atos_units | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions_bigint | Unknown |  |
| audio_q_1_playbacks_bigint | Unknown |  |
| audio_q_2_playbacks_bigint | Unknown |  |
| audio_q_3_playbacks_bigint | Unknown |  |
| audio_starts_bigint | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions_bigint | Unknown |  |
| click_secondary_conversions_bigint | Unknown |  |
| clicks_bigint | Unknown |  |
| companion_banner_viewed | Unknown |  |
| conversion_revenue | Unknown |  |
| conversions_bigint | Unknown |  |
| cookie_conversions_bigint | Unknown |  |
| cost | Unknown |  |
| cpd_media_cost | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpe | Unknown |  |
| ecpi | Unknown |  |
| ecpm | Unknown |  |
| ecpv | Unknown |  |
| engagement_rate | Unknown |  |
| engagements_bigint | Unknown |  |
| enterprise_features | Unknown |  |
| frequency | Unknown |  |
| ga_4_average_session_duration | Unknown |  |
| ga_4_bounce_rate | Unknown |  |
| ga_4_engaged_sessions | Unknown |  |
| ga_4_sessions | Unknown |  |
| ga_4_total_users | Unknown |  |
| granularity_end_time | Unknown |  |
| granularity_start_time | Unknown |  |
| granularity_type | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions_bigint | Unknown |  |
| impression_secondary_conversions_bigint | Unknown |  |
| impressions_bigint | Unknown |  |
| ip_conversions_bigint | Unknown |  |
| margins | Unknown |  |
| measured_impressions_bigint | Unknown |  |
| mmp_conversions | Unknown |  |
| mmp_conversions_bigint | Unknown |  |
| mmp_cpi | Unknown |  |
| mmp_install | Unknown |  |
| page_starts_bigint | Unknown |  |
| page_time_units | Unknown |  |
| profit | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpcv | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| secondary_conversions_bigint | Unknown |  |
| skan_conversions_bigint | Unknown |  |
| skan_cpi | Unknown |  |
| skan_install | Unknown |  |
| ssp_revenue | Unknown |  |
| targeting | Unknown |  |
| total_time | Unknown |  |
| tp_cpc_cost | Unknown |  |
| tp_cpm_cost | Unknown |  |
| unique_conversions_bigint | Unknown |  |
| unique_ecpa | Unknown |  |
| unique_impressions_bigint | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions_bigint | Unknown |  |
| video_q_1_playbacks_bigint | Unknown |  |
| video_q_2_playbacks_bigint | Unknown |  |
| video_q_3_playbacks_bigint | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| viewability_fee | Unknown |  |
| viewed_measured_impressions_bigint | Unknown |  |

### advertiser_delivery

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | FK |
| ad_serving | Unknown |  |
| app_install | Unknown |  |
| atos | Unknown |  |
| atos_units | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions_bigint | Unknown |  |
| audio_q_1_playbacks_bigint | Unknown |  |
| audio_q_2_playbacks_bigint | Unknown |  |
| audio_q_3_playbacks_bigint | Unknown |  |
| audio_starts_bigint | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions_bigint | Unknown |  |
| click_secondary_conversions_bigint | Unknown |  |
| clicks_bigint | Unknown |  |
| companion_banner_viewed | Unknown |  |
| conversion_revenue | Unknown |  |
| conversions_bigint | Unknown |  |
| cookie_conversions_bigint | Unknown |  |
| cost | Unknown |  |
| cpd_media_cost | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpe | Unknown |  |
| ecpi | Unknown |  |
| ecpm | Unknown |  |
| ecpv | Unknown |  |
| engagement_rate | Unknown |  |
| engagements_bigint | Unknown |  |
| enterprise_features | Unknown |  |
| frequency | Unknown |  |
| ga_4_average_session_duration | Unknown |  |
| ga_4_bounce_rate | Unknown |  |
| ga_4_engaged_sessions | Unknown |  |
| ga_4_sessions | Unknown |  |
| ga_4_total_users | Unknown |  |
| granularity_end_time | Unknown |  |
| granularity_start_time | Unknown |  |
| granularity_time | Unknown |  |
| granularity_type | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions_bigint | Unknown |  |
| impression_secondary_conversions_bigint | Unknown |  |
| impressions_bigint | Unknown |  |
| ip_conversions_bigint | Unknown |  |
| margins | Unknown |  |
| measured_impressions_bigint | Unknown |  |
| mmp_conversions | Unknown |  |
| mmp_conversions_bigint | Unknown |  |
| mmp_cpi | Unknown |  |
| mmp_install | Unknown |  |
| page_starts_bigint | Unknown |  |
| page_time_units | Unknown |  |
| profit | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpcv | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| secondary_conversions_bigint | Unknown |  |
| skan_conversions_bigint | Unknown |  |
| skan_cpi | Unknown |  |
| skan_install | Unknown |  |
| ssp_revenue | Unknown |  |
| targeting | Unknown |  |
| total_time | Unknown |  |
| tp_cpc_cost | Unknown |  |
| tp_cpm_cost | Unknown |  |
| unique_conversions_bigint | Unknown |  |
| unique_ecpa | Unknown |  |
| unique_impressions_bigint | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions_bigint | Unknown |  |
| video_q_1_playbacks_bigint | Unknown |  |
| video_q_2_playbacks_bigint | Unknown |  |
| video_q_3_playbacks_bigint | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| viewability_fee | Unknown |  |
| viewed_measured_impressions_bigint | Unknown |  |

### insight_campaign_demographic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| display_name | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| id | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_bid_factor

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| factor_percent | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| paused | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_deal

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| description | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_city

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| city | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_city

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| city | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_retargeting_segment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| advertiser_ids | Unknown |  |
| advertiser_restricted | Unknown |  |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| description | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| is_legacy_pixel | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| post_time | Unknown |  |
| post_time_period | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| required_frequency | Unknown |  |
| retargeting_category | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| standalone | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| unique_key | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| code | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| display_text | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### campaign_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_rollover | Unknown |  |
| budget_type | Unknown |  |
| created_at | Unknown |  |
| domain_exclusions | Unknown |  |
| domains | Json |  |
| freq_cap_expiry | Unknown |  |
| freq_cap_limit | Unknown |  |
| is_archived | Unknown |  |
| is_inventory_packages_strict | Unknown |  |
| name | Unknown |  |
| revenue_pricing | Unknown |  |
| revenue_type | Unknown |  |
| timezone | Unknown |  |
| user_metadata | Json |  |

### insight_campaign_deal

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| description | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| id | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_creative_tactic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| created_at | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| paused | Unknown |  |
| priority | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_supply_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| supply_source_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_supply_source

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_device

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| device_type | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### conversion_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribution_type | Unknown |  |
| click_count | Unknown |  |
| click_to_conversion_time | Unknown |  |
| conversion_extra | Unknown |  |
| domain | Unknown |  |
| first_click_time | Unknown |  |
| first_impression_time | Unknown |  |
| impression_count | Unknown |  |
| impression_to_conversion_time | Unknown |  |
| last_click_time | Unknown |  |
| last_domain | Unknown |  |
| last_impression_time | Unknown |  |

### campaign_group_delivery

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | FK |
| campaign_group_id | Unknown | FK |
| campaign_id | Unknown | FK |
| ad_serving | Unknown |  |
| app_install | Unknown |  |
| atos | Unknown |  |
| atos_units | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions_bigint | Unknown |  |
| audio_q_1_playbacks_bigint | Unknown |  |
| audio_q_2_playbacks_bigint | Unknown |  |
| audio_q_3_playbacks_bigint | Unknown |  |
| audio_starts_bigint | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions_bigint | Unknown |  |
| click_secondary_conversions_bigint | Unknown |  |
| clicks_bigint | Unknown |  |
| companion_banner_viewed | Unknown |  |
| conversion_revenue | Unknown |  |
| conversions_bigint | Unknown |  |
| cookie_conversions_bigint | Unknown |  |
| cost | Unknown |  |
| cpd_media_cost | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpe | Unknown |  |
| ecpi | Unknown |  |
| ecpm | Unknown |  |
| ecpv | Unknown |  |
| engagement_rate | Unknown |  |
| engagements_bigint | Unknown |  |
| enterprise_features | Unknown |  |
| frequency | Unknown |  |
| ga_4_average_session_duration | Unknown |  |
| ga_4_bounce_rate | Unknown |  |
| ga_4_engaged_sessions | Unknown |  |
| ga_4_sessions | Unknown |  |
| ga_4_total_users | Unknown |  |
| granularity_end_time | Unknown |  |
| granularity_start_time | Unknown |  |
| granularity_time | Unknown |  |
| granularity_type | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions_bigint | Unknown |  |
| impression_secondary_conversions_bigint | Unknown |  |
| impressions_bigint | Unknown |  |
| ip_conversions_bigint | Unknown |  |
| margins | Unknown |  |
| measured_impressions_bigint | Unknown |  |
| mmp_conversions | Unknown |  |
| mmp_conversions_bigint | Unknown |  |
| mmp_cpi | Unknown |  |
| mmp_install | Unknown |  |
| page_starts_bigint | Unknown |  |
| page_time_units | Unknown |  |
| profit | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpcv | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| secondary_conversions_bigint | Unknown |  |
| skan_conversions_bigint | Unknown |  |
| skan_cpi | Unknown |  |
| skan_install | Unknown |  |
| ssp_revenue | Unknown |  |
| targeting | Unknown |  |
| total_time | Unknown |  |
| tp_cpc_cost | Unknown |  |
| tp_cpm_cost | Unknown |  |
| unique_conversions_bigint | Unknown |  |
| unique_ecpa | Unknown |  |
| unique_impressions_bigint | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions_bigint | Unknown |  |
| video_q_1_playbacks_bigint | Unknown |  |
| video_q_2_playbacks_bigint | Unknown |  |
| video_q_3_playbacks_bigint | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| viewability_fee | Unknown |  |
| viewed_measured_impressions_bigint | Unknown |  |

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_ids | Json |  |
| description | Unknown |  |
| is_archived | Unknown |  |
| is_inventory_packages_strict | Unknown |  |
| name | Unknown |  |

### custom_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| duid_size | Unknown |  |
| expandable | Unknown |  |
| name | Unknown |  |
| phrases | Unknown |  |
| size | Unknown |  |

### insight_campaign_bid_factor

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| factor_percent | Unknown |  |
| frequency | Unknown |  |
| id | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| paused | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### audience_demographic_segment_children

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| audience_demographic_segment_index | Unknown | PK, FK |
| children | Json |  |
| display_name | Unknown |  |

### audience_demographic_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| display_name | Unknown |  |
| id | Unknown |  |

### audience_interest_segment_children

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| audience_interest_segment_index | Unknown | PK, FK |
| children | Json |  |
| display_name | Unknown |  |

### audience_interest_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| display_name | Unknown |  |
| id | Unknown |  |

### supply_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### ad_impression_tracker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ad_id | Unknown | PK, FK |
| impression_trackers | Unknown |  |

### ad

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| campaign_id | Unknown | FK |
| brand_name | Unknown |  |
| channel_type | Unknown |  |
| click_url | Unknown |  |
| creative_size | Unknown |  |
| is_archived | Unknown |  |
| is_draft | Unknown |  |
| is_rejected | Unknown |  |
| name | Unknown |  |
| paused | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| user_metadata | Json |  |

### insight_campaign_creative_tactic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| created_at | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| id | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| paused | Unknown |  |
| priority | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_group_device

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| device_type | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### insight_campaign_retargeting_pixel

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| advertiser_ids | Unknown |  |
| advertiser_restricted | Unknown |  |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| description | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| id | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| is_legacy_pixel | Unknown |  |
| name | Unknown |  |
| page_starts | Unknown |  |
| post_time | Unknown |  |
| post_time_period | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| required_frequency | Unknown |  |
| retargeting_category | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| standalone | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| unique_key | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| campaign_group_id | Unknown | FK |
| budget_rollover | Unknown |  |
| channel_type | Unknown |  |
| created_at | Instant |  |
| creative_tactic_fallback | Unknown |  |
| creative_tactic_fallbackids | Json |  |
| freq_cap_expiry | Unknown |  |
| freq_cap_limit | Unknown |  |
| freq_min_expiry | Unknown |  |
| is_archived | Unknown |  |
| is_draft | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| tactic_type | Unknown |  |
| timezone | Unknown |  |
| updated_at | Instant |  |
| user_metadata | Json |  |

### campaign_delivery

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | FK |
| id | Unknown | FK |
| ad_serving | Unknown |  |
| app_install | Unknown |  |
| atos | Unknown |  |
| atos_units | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions_bigint | Unknown |  |
| audio_q_1_playbacks_bigint | Unknown |  |
| audio_q_2_playbacks_bigint | Unknown |  |
| audio_q_3_playbacks_bigint | Unknown |  |
| audio_starts_bigint | Unknown |  |
| campaign_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions_bigint | Unknown |  |
| click_secondary_conversions_bigint | Unknown |  |
| clicks_bigint | Unknown |  |
| companion_banner_viewed | Unknown |  |
| conversion_revenue | Unknown |  |
| conversions_bigint | Unknown |  |
| cookie_conversions_bigint | Unknown |  |
| cost | Unknown |  |
| cpd_media_cost | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpe | Unknown |  |
| ecpi | Unknown |  |
| ecpm | Unknown |  |
| ecpv | Unknown |  |
| engagement_rate | Unknown |  |
| engagements_bigint | Unknown |  |
| enterprise_features | Unknown |  |
| frequency | Unknown |  |
| ga_4_average_session_duration | Unknown |  |
| ga_4_bounce_rate | Unknown |  |
| ga_4_engaged_sessions | Unknown |  |
| ga_4_sessions | Unknown |  |
| ga_4_total_users | Unknown |  |
| granularity_end_time | Unknown |  |
| granularity_start_time | Unknown |  |
| granularity_time | Unknown |  |
| granularity_type | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions_bigint | Unknown |  |
| impression_secondary_conversions_bigint | Unknown |  |
| impressions_bigint | Unknown |  |
| ip_conversions_bigint | Unknown |  |
| margins | Unknown |  |
| measured_impressions_bigint | Unknown |  |
| mmp_conversions | Unknown |  |
| mmp_conversions_bigint | Unknown |  |
| mmp_cpi | Unknown |  |
| mmp_install | Unknown |  |
| page_starts_bigint | Unknown |  |
| page_time_units | Unknown |  |
| profit | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpcv | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| roas | Unknown |  |
| secondary_conversions_bigint | Unknown |  |
| skan_conversions_bigint | Unknown |  |
| skan_cpi | Unknown |  |
| skan_install | Unknown |  |
| ssp_revenue | Unknown |  |
| targeting | Unknown |  |
| total_time | Unknown |  |
| tp_cpc_cost | Unknown |  |
| tp_cpm_cost | Unknown |  |
| unique_conversions_bigint | Unknown |  |
| unique_ecpa | Unknown |  |
| unique_impressions_bigint | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions_bigint | Unknown |  |
| video_q_1_playbacks_bigint | Unknown |  |
| video_q_2_playbacks_bigint | Unknown |  |
| video_q_3_playbacks_bigint | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| viewability_fee | Unknown |  |
| viewed_measured_impressions_bigint | Unknown |  |

### insight_campaign_group_demographic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| atos | Unknown |  |
| audio_completion_rate | Unknown |  |
| audio_completions | Unknown |  |
| audio_q_1_playbacks | Unknown |  |
| audio_q_2_playbacks | Unknown |  |
| audio_q_3_playbacks | Unknown |  |
| audio_starts | Unknown |  |
| average_impression_time | Unknown |  |
| campaign_group_id | Unknown |  |
| click_conversion_rate | Unknown |  |
| click_conversions | Unknown |  |
| click_secondary_conversions | Unknown |  |
| clicks | Unknown |  |
| conversion_revenue | Unknown |  |
| conversion_revenue_percentage | Unknown |  |
| conversions | Unknown |  |
| cookie_conversions | Unknown |  |
| cost | Unknown |  |
| cost_percentage | Unknown |  |
| ctr | Unknown |  |
| cvr | Unknown |  |
| display_name | Unknown |  |
| dooh_plays | Unknown |  |
| ecpa | Unknown |  |
| ecpc | Unknown |  |
| ecpcl | Unknown |  |
| ecpcv | Unknown |  |
| ecpe | Unknown |  |
| ecpm | Unknown |  |
| engagement_rate | Unknown |  |
| engagements | Unknown |  |
| frequency | Unknown |  |
| impression_conversion_rate | Unknown |  |
| impression_conversions | Unknown |  |
| impression_secondary_conversions | Unknown |  |
| impressions | Unknown |  |
| impressions_percentage | Unknown |  |
| page_starts | Unknown |  |
| profit | Unknown |  |
| profit_percentage | Unknown |  |
| rcpa | Unknown |  |
| rcpc | Unknown |  |
| rcpcl | Unknown |  |
| rcpe | Unknown |  |
| rcpm | Unknown |  |
| revenue | Unknown |  |
| revenue_percentage | Unknown |  |
| roas | Unknown |  |
| secondary_conversions | Unknown |  |
| total_time | Unknown |  |
| unique_conversions | Unknown |  |
| unique_impressions | Unknown |  |
| video_completion_rate | Unknown |  |
| video_completions | Unknown |  |
| video_q_1_playbacks | Unknown |  |
| video_q_2_playbacks | Unknown |  |
| video_q_3_playbacks | Unknown |  |
| video_starts | Unknown |  |
| view_rate | Unknown |  |
| views | Unknown |  |

## Relationships

- insight_campaign_category(campaign_id) → campaign(id)
- ad_delivery(campaign_id) → campaign(id)
- ad_delivery(ad_id) → ad(id)
- advertiser_delivery(advertiser_id) → advertiser(id)
- insight_campaign_demographic(campaign_id) → campaign(id)
- insight_campaign_group_bid_factor(id) → campaign_group(id)
- insight_campaign_group_deal(id) → campaign_group(id)
- insight_campaign_group_city(id) → campaign_group(id)
- insight_campaign_city(campaign_id) → campaign(id)
- insight_campaign_group_retargeting_segment(id) → campaign_group(id)
- insight_campaign_group_category(id) → campaign_group(id)
- insight_campaign_deal(campaign_id) → campaign(id)
- insight_campaign_group_creative_tactic(id) → campaign_group(id)
- insight_campaign_supply_source(supply_source_id) → supply_source(id)
- insight_campaign_supply_source(campaign_id) → campaign(id)
- insight_campaign_group_supply_source(id) → campaign_group(id)
- insight_campaign_device(campaign_id) → campaign(id)
- campaign_group_delivery(advertiser_id) → advertiser(id)
- campaign_group_delivery(campaign_id) → campaign(id)
- campaign_group_delivery(campaign_group_id) → campaign_group(id)
- insight_campaign_bid_factor(campaign_id) → campaign(id)
- audience_demographic_segment_children(audience_demographic_segment_index) → audience_demographic_segment(index)
- audience_interest_segment_children(audience_interest_segment_index) → audience_interest_segment(index)
- ad_impression_tracker(ad_id) → ad(id)
- ad(advertiser_id) → advertiser(id)
- ad(campaign_id) → campaign(id)
- insight_campaign_creative_tactic(campaign_id) → campaign(id)
- insight_campaign_group_device(id) → campaign_group(id)
- insight_campaign_retargeting_pixel(campaign_id) → campaign(id)
- campaign(advertiser_id) → advertiser(id)
- campaign(campaign_group_id) → campaign_group(id)
- campaign_delivery(advertiser_id) → advertiser(id)
- campaign_delivery(id) → campaign(id)
- insight_campaign_group_demographic(id) → campaign_group(id)