# Teads schema ERD

Table and field reference for the Fivetran Teads connector.

## Table & Field Reference

### report_budget

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| billable_event | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| budget_delivered | Unknown |  |
| budget_delivered_agency_fee | Unknown |  |
| budget_delivered_cost_per_result | Unknown |  |
| budget_delivered_cpc | Unknown |  |
| budget_delivered_cpm | Unknown |  |
| budget_delivered_fee | Unknown |  |
| budget_delivered_teads | Unknown |  |
| budget_delivered_teads_cost_per_result | Unknown |  |
| budget_delivered_teads_cpc | Unknown |  |
| budget_delivered_teads_cpm | Unknown |  |
| budget_delivered_total_ad_cost | Unknown |  |
| budget_delivered_total_ad_cost_cost_per_result | Unknown |  |
| budget_delivered_total_ad_cost_cpc | Unknown |  |
| budget_delivered_total_ad_cost_cpm | Unknown |  |
| budget_spent | Unknown |  |
| budget_spent_cost_per_result | Unknown |  |
| budget_spent_cpc | Unknown |  |
| budget_spent_cpm | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| cookieless_impression | Unknown |  |
| cookieless_impressions_rate | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| fee | Unknown |  |
| hour | Unknown |  |
| impressions | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| month | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| total_ad_cost | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_lumen

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| lumen_attention_per_1000_impression | Unknown |  |
| lumen_average_dwell_time | Unknown |  |
| lumen_average_view_rate | Unknown |  |
| month | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| uv_impression | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_scope

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| month | Unknown |  |
| scope_3_ad_selection_emission | Unknown |  |
| scope_3_creative_consumer_device_emission | Unknown |  |
| scope_3_creative_distribution_emission | Unknown |  |
| scope_3_measured_impression | Unknown |  |
| scope_3_media_consumer_device_emission | Unknown |  |
| scope_3_media_distribution_emission | Unknown |  |
| scope_3_total_emission | Unknown |  |
| scope_3_total_emissions_per_mille | Unknown |  |
| scope_3_total_emissions_without_device | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_video

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| click | Unknown |  |
| click_through_rate | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| month | Unknown |  |
| post_click_conversion | Unknown |  |
| post_view_conversion | Unknown |  |
| progress_1 | Unknown |  |
| progress_10 | Unknown |  |
| progress_11 | Unknown |  |
| progress_12 | Unknown |  |
| progress_13 | Unknown |  |
| progress_14 | Unknown |  |
| progress_15 | Unknown |  |
| progress_16 | Unknown |  |
| progress_17 | Unknown |  |
| progress_18 | Unknown |  |
| progress_19 | Unknown |  |
| progress_2 | Unknown |  |
| progress_20 | Unknown |  |
| progress_21 | Unknown |  |
| progress_22 | Unknown |  |
| progress_23 | Unknown |  |
| progress_24 | Unknown |  |
| progress_25 | Unknown |  |
| progress_26 | Unknown |  |
| progress_27 | Unknown |  |
| progress_28 | Unknown |  |
| progress_29 | Unknown |  |
| progress_3 | Unknown |  |
| progress_30 | Unknown |  |
| progress_4 | Unknown |  |
| progress_5 | Unknown |  |
| progress_6 | Unknown |  |
| progress_7 | Unknown |  |
| progress_8 | Unknown |  |
| progress_9 | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| video_completes | Unknown |  |
| video_completion_rate | Unknown |  |
| video_first_quartile | Unknown |  |
| video_midpoint | Unknown |  |
| video_starts | Unknown |  |
| video_third_quartile | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_moat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| moat_10_sec_in_view_impression | Unknown |  |
| moat_11_sec_in_view_impression | Unknown |  |
| moat_12_sec_in_view_impression | Unknown |  |
| moat_13_sec_in_view_impression | Unknown |  |
| moat_14_sec_in_view_impression | Unknown |  |
| moat_15_sec_in_view_impression | Unknown |  |
| moat_16_sec_in_view_impression | Unknown |  |
| moat_17_sec_in_view_impression | Unknown |  |
| moat_18_sec_in_view_impression | Unknown |  |
| moat_19_sec_in_view_impression | Unknown |  |
| moat_1_sec_in_view_impression | Unknown |  |
| moat_20_sec_in_view_impression | Unknown |  |
| moat_21_sec_in_view_impression | Unknown |  |
| moat_22_sec_in_view_impression | Unknown |  |
| moat_23_sec_in_view_impression | Unknown |  |
| moat_24_sec_in_view_impression | Unknown |  |
| moat_25_sec_in_view_impression | Unknown |  |
| moat_26_sec_in_view_impression | Unknown |  |
| moat_27_sec_in_view_impression | Unknown |  |
| moat_28_sec_in_view_impression | Unknown |  |
| moat_29_sec_in_view_impression | Unknown |  |
| moat_2_sec_in_view_impression | Unknown |  |
| moat_30_sec_in_view_impression | Unknown |  |
| moat_3_sec_in_view_impression | Unknown |  |
| moat_4_sec_in_view_impression | Unknown |  |
| moat_5_sec_in_view_impression | Unknown |  |
| moat_6_sec_in_view_impression | Unknown |  |
| moat_7_sec_in_view_impression | Unknown |  |
| moat_8_sec_in_view_impression | Unknown |  |
| moat_9_sec_in_view_impression | Unknown |  |
| moat_average_ad_length_ms | Unknown |  |
| moat_average_in_view_time_ms | Unknown |  |
| moat_complete_in_view_impression | Unknown |  |
| moat_impressions_analyzed_filtered_for_ivt | Unknown |  |
| moat_impressions_analyzed_unfiltered_for_ivt | Unknown |  |
| moat_in_view_measurable_impression | Unknown |  |
| moat_total_ad_length_ms | Unknown |  |
| moat_total_in_view_time_ms | Unknown |  |
| moat_valid_and_viewable_impression | Unknown |  |
| moat_valid_and_viewable_percentage | Unknown |  |
| month | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_video_progress

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| month | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| video_progress_10_second | Unknown |  |
| video_progress_11_second | Unknown |  |
| video_progress_12_second | Unknown |  |
| video_progress_13_second | Unknown |  |
| video_progress_14_second | Unknown |  |
| video_progress_15_second | Unknown |  |
| video_progress_16_second | Unknown |  |
| video_progress_17_second | Unknown |  |
| video_progress_18_second | Unknown |  |
| video_progress_19_second | Unknown |  |
| video_progress_1_second | Unknown |  |
| video_progress_20_second | Unknown |  |
| video_progress_21_second | Unknown |  |
| video_progress_22_second | Unknown |  |
| video_progress_23_second | Unknown |  |
| video_progress_24_second | Unknown |  |
| video_progress_25_second | Unknown |  |
| video_progress_26_second | Unknown |  |
| video_progress_27_second | Unknown |  |
| video_progress_28_second | Unknown |  |
| video_progress_29_second | Unknown |  |
| video_progress_2_second | Unknown |  |
| video_progress_30_second | Unknown |  |
| video_progress_3_second | Unknown |  |
| video_progress_4_second | Unknown |  |
| video_progress_5_second | Unknown |  |
| video_progress_6_second | Unknown |  |
| video_progress_7_second | Unknown |  |
| video_progress_8_second | Unknown |  |
| video_progress_9_second | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |

### report_display_progress

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_updated_at | Unknown |  |
| auction_has_billable | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_budget | Unknown |  |
| campaign_currency | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_updated_at | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| creative_external_integration_code | Unknown |  |
| creative_family | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_portfolio_item | Unknown |  |
| creative_size | Unknown |  |
| creative_type | Unknown |  |
| creative_updated_at | Unknown |  |
| day | Unknown |  |
| device | Unknown |  |
| display_10_second_view | Unknown |  |
| display_11_second_view | Unknown |  |
| display_12_second_view | Unknown |  |
| display_13_second_view | Unknown |  |
| display_14_second_view | Unknown |  |
| display_15_second_view | Unknown |  |
| display_16_second_view | Unknown |  |
| display_17_second_view | Unknown |  |
| display_18_second_view | Unknown |  |
| display_19_second_view | Unknown |  |
| display_1_second_view | Unknown |  |
| display_20_second_view | Unknown |  |
| display_21_second_view | Unknown |  |
| display_22_second_view | Unknown |  |
| display_23_second_view | Unknown |  |
| display_24_second_view | Unknown |  |
| display_25_second_view | Unknown |  |
| display_26_second_view | Unknown |  |
| display_27_second_view | Unknown |  |
| display_28_second_view | Unknown |  |
| display_29_second_view | Unknown |  |
| display_2_second_view | Unknown |  |
| display_30_second_view | Unknown |  |
| display_3_second_view | Unknown |  |
| display_4_second_view | Unknown |  |
| display_5_second_view | Unknown |  |
| display_6_second_view | Unknown |  |
| display_7_second_view | Unknown |  |
| display_8_second_view | Unknown |  |
| display_9_second_view | Unknown |  |
| hour | Unknown |  |
| line_group_updated_at | Unknown |  |
| line_id | Unknown |  |
| line_item_billable_event | Unknown |  |
| line_item_budget | Unknown |  |
| line_item_name | Unknown |  |
| line_item_updated_at | Unknown |  |
| month | Unknown |  |
| seat_id | Unknown |  |
| seat_name | Unknown |  |
| website_domain | Unknown |  |
| website_or_app | Unknown |  |
| year | Unknown |  |