# LINE Ads schema ERD

Table and field reference for the Fivetran LINE Ads connector.

## Table & Field Reference

### adaccount_available_campaign_objective

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| available_campaign_objective | Unknown |  |

### adaccount_delivery_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| code | Unknown |  |

### adaccount

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK |
| id | Unknown | PK |
| modified_date | Instant | PK |
| configured_status | Unknown |  |
| country | Unknown |  |
| created_date | Unknown |  |
| currency | Unknown |  |
| delivery_status | Unknown |  |
| line_account_line_id | Unknown |  |
| line_account_name | Unknown |  |
| name | Unknown |  |
| product_type | Unknown |  |
| removed_date | Unknown |  |
| timezone | Unknown |  |

### adgroup_delivery_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| code | Unknown |  |

### adgroup_targeting_custom_audience

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| custom_audience_id | Unknown |  |

### adgroup_targeting_excluded_custom_audience

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| excluded_custom_audience_id | Unknown |  |

### adgroup_targeting_geo_area_include

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| area_type | Unknown |  |
| label | Unknown |  |
| radius | Unknown |  |
| value | Unknown |  |

### adgroup_targeting_geo_area_exclude

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| area_type | Unknown |  |
| label | Unknown |  |
| radius | Unknown |  |
| value | Unknown |  |

### adgroup_targeting_include_advanced_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| interest | Unknown |  |

### adgroup_targeting_include_advanced_behavior

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| behavior | Unknown |  |

### adgroup_targeting_include_advanced_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| status | Unknown |  |

### adgroup_targeting_include_advanced_purchase_intent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| purchase_intent | Unknown |  |

### adgroup_targeting_include_advanced_yj_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_interest | Unknown |  |

### adgroup_targeting_include_advanced_yj_purchase_intent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_purchase_intent | Unknown |  |

### adgroup_targeting_include_advanced_yj_lifestyle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_lifestyle | Unknown |  |

### adgroup_targeting_exclude_advanced_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| interest | Unknown |  |

### adgroup_targeting_exclude_advanced_behavior

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| behavior | Unknown |  |

### adgroup_targeting_exclude_advanced_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| status | Unknown |  |

### adgroup_targeting_exclude_advanced_purchase_intent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| purchase_intent | Unknown |  |

### adgroup_targeting_exclude_advanced_yj_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_interest | Unknown |  |

### adgroup_targeting_exclude_advanced_yj_purchase_intent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_purchase_intent | Unknown |  |

### adgroup_targeting_exclude_advanced_yj_lifestyle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| yj_lifestyle | Unknown |  |

### adgroup_targeting_placement

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| placement | Unknown |  |

### adgroup_targeting_gender

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| gender_code | Unknown |  |

### adgroup_targeting_ssps

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| ssps | Unknown |  |

### adgroup_targeting_user_os

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| adgroup_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| os | Unknown |  |
| ver_max | Unknown |  |
| ver_min | Unknown |  |

### adgroup

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_date | Instant | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| campaign_id | Unknown | FK |
| media_app_id | Unknown | FK |
| adgroup_learning_has_completion_history | Unknown |  |
| adgroup_learning_last_end_ts | Unknown |  |
| adgroup_learning_last_start_ts | Unknown |  |
| adgroup_learning_status | Unknown |  |
| adgroup_learning_status_code | Unknown |  |
| adgroup_learning_target_reach_ratio | Unknown |  |
| auto_bid_conversion_id | Unknown |  |
| auto_bid_type | Unknown |  |
| bid_amount_micro | Unknown |  |
| bid_strategy | Unknown |  |
| bid_type | Unknown |  |
| configured_status | Unknown |  |
| created_date | Unknown |  |
| daily_budget_micro | Unknown |  |
| delivery_status | Unknown |  |
| dpa_destination_type | Unknown |  |
| dpa_destination_url | Unknown |  |
| dpa_feed_type | Unknown |  |
| first_auto_bid_conversion_id | Unknown |  |
| in_stream_video_included | Unknown |  |
| name | Unknown |  |
| product_set_id | Unknown |  |
| removed_date | Unknown |  |
| rnf_end_date | Unknown |  |
| rnf_frequency | Unknown |  |
| rnf_frequency_interval | Unknown |  |
| rnf_start_date | Unknown |  |
| targeting_age_max | Unknown |  |
| targeting_age_min | Unknown |  |
| targeting_country | Unknown |  |
| targeting_geo_area_delivery_targeting_set_type | Unknown |  |
| targeting_mode | Unknown |  |

### media

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| affected_ad_count | Unknown |  |
| app_bundle | Unknown |  |
| appstore_url | Unknown |  |
| comment | Unknown |  |
| created_date | Unknown |  |
| duration | Unknown |  |
| file_size | Unknown |  |
| frames | Unknown |  |
| height | Unknown |  |
| last_lp_rejected_date | Unknown |  |
| loops | Unknown |  |
| media_type | Unknown |  |
| mime_type | Unknown |  |
| modified_date | Instant |  |
| name | Unknown |  |
| object_file_name | Unknown |  |
| object_obs_hash | Unknown |  |
| object_obs_o_id | Unknown |  |
| object_source_url | Unknown |  |
| os_code | Unknown |  |
| related_ads_count | Unknown |  |
| removed_date | Unknown |  |
| review_comment | Unknown |  |
| review_re_reviewable | Unknown |  |
| review_reason_code | Unknown |  |
| review_reject_reason | Unknown |  |
| review_status | Unknown |  |
| url | Unknown |  |
| width | Unknown |  |

### campaign_delivery_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| code | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_date | Instant | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| active_cbo | Unknown |  |
| bid_strategy | Unknown |  |
| campaign_objective | Unknown |  |
| configured_status | Unknown |  |
| created_date | Unknown |  |
| daily_budget_micro | Unknown |  |
| delivery_status | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| removed_date | Unknown |  |
| spending_limit_micro | Unknown |  |
| spending_limit_type | Unknown |  |
| start_date | Unknown |  |

### ad_delivery_status_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ad_id | Unknown | PK, FK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| code | Unknown |  |

### ad

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_date | Instant | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| adgroup_id | Unknown | FK |
| creative_animation_id | Unknown | FK |
| creative_image_id | Unknown | FK |
| creative_small_image_id | Unknown | FK |
| creative_video_id | Unknown | FK |
| configured_status | Unknown |  |
| created_date | Unknown |  |
| creative_animation_hash | Unknown |  |
| creative_call_to_action_app_store_url | Unknown |  |
| creative_call_to_action_click_url | Unknown |  |
| creative_call_to_action_deep_link_url | Unknown |  |
| creative_call_to_action_landing_page_url | Unknown |  |
| creative_call_to_action_type | Unknown |  |
| creative_description | Unknown |  |
| creative_format | Unknown |  |
| creative_id | Unknown |  |
| creative_image_hash | Unknown |  |
| creative_labels | Json |  |
| creative_long_title | Unknown |  |
| creative_review_comment | Unknown |  |
| creative_review_re_reviewable | Unknown |  |
| creative_review_reason_code | Unknown |  |
| creative_review_reject_reason | Unknown |  |
| creative_review_status | Unknown |  |
| creative_slots | Json |  |
| creative_small_image_hash | Unknown |  |
| creative_title | Unknown |  |
| creative_video_hash | Unknown |  |
| delivery_status | Unknown |  |
| imp_track_url | Unknown |  |
| name | Unknown |  |
| removed_date | Unknown |  |
| small_delivery | Unknown |  |
| view_track_url | Unknown |  |

### ad_report

| Column | Type | Keys |
| --- | --- | --- |
| day | Unknown | PK |
| adaccount_id | Unknown | PK, FK |
| group_id | String | PK, FK |
| id | Unknown | PK, FK |
| adgroup_id | Unknown | FK |
| campaign_id | Unknown | FK |
| add_to_cart | Unknown |  |
| add_to_cart_rate | Unknown |  |
| campaign_objective | Unknown |  |
| category_view | Unknown |  |
| category_view_rate | Unknown |  |
| clicks | Unknown |  |
| cpa_checkout_started | Unknown |  |
| cpa_item_added_to_cart | Unknown |  |
| cpa_lead_generated | Unknown |  |
| cpa_line_tag_and_cv_api | Unknown |  |
| cpa_product_details_viewed | Unknown |  |
| cpa_purchased | Unknown |  |
| cpa_reservation_completed | Unknown |  |
| cpa_signup_completed | Unknown |  |
| cpm_cost_per_thousand_impressions | Unknown |  |
| ctr_click_through_rate | Unknown |  |
| currency | Unknown |  |
| cv_api | Unknown |  |
| cv_checkout_started | Unknown |  |
| cv_conversions | Unknown |  |
| cv_item_added_to_cart | Unknown |  |
| cv_lead_generated | Unknown |  |
| cv_line_tag_and_cv_api | Unknown |  |
| cv_product_details_viewed | Unknown |  |
| cv_purchased | Unknown |  |
| cv_reservation_completed | Unknown |  |
| cv_signup_completed | Unknown |  |
| cvr_checkout_started | Unknown |  |
| cvr_conversion_rate | Unknown |  |
| cvr_item_added_to_cart | Unknown |  |
| cvr_lead_generated | Unknown |  |
| cvr_line_tag_and_cv_api | Unknown |  |
| cvr_product_details_viewed | Unknown |  |
| cvr_purchased | Unknown |  |
| cvr_reservation_completed | Unknown |  |
| cvr_signup_completed | Unknown |  |
| description | Unknown |  |
| home_screen_view_rate | Unknown |  |
| impressions | Unknown |  |
| install_rate_clicks | Unknown |  |
| installs_clicks | Unknown |  |
| installs_clicks_and_views | Unknown |  |
| installs_views | Unknown |  |
| level_achieved | Unknown |  |
| level_achieved_rate | Unknown |  |
| open_rate | Unknown |  |
| opens | Unknown |  |
| product_view_rate | Unknown |  |
| purchase | Unknown |  |
| purchase_rate | Unknown |  |
| search | Unknown |  |
| search_rate | Unknown |  |
| title | Unknown |  |
| tutorial_complete | Unknown |  |
| tutorial_percent_complete | Unknown |  |
| view_home_screen | Unknown |  |
| view_product | Unknown |  |
| custom_** |  |  |

## Relationships

- adaccount_available_campaign_objective(adaccount_id) → adaccount(id)
- adaccount_available_campaign_objective(group_id) → adaccount(group_id)
- adaccount_delivery_status_reason(adaccount_id) → adaccount(id)
- adaccount_delivery_status_reason(group_id) → adaccount(group_id)
- adgroup_delivery_status_reason(adgroup_id) → adgroup(id)
- adgroup_delivery_status_reason(adaccount_id) → adgroup(adaccount_id)
- adgroup_delivery_status_reason(group_id) → adgroup(group_id)
- adgroup_targeting_custom_audience(adgroup_id) → adgroup(id)
- adgroup_targeting_custom_audience(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_custom_audience(group_id) → adgroup(group_id)
- adgroup_targeting_excluded_custom_audience(adgroup_id) → adgroup(id)
- adgroup_targeting_excluded_custom_audience(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_excluded_custom_audience(group_id) → adgroup(group_id)
- adgroup_targeting_geo_area_include(adgroup_id) → adgroup(id)
- adgroup_targeting_geo_area_include(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_geo_area_include(group_id) → adgroup(group_id)
- adgroup_targeting_geo_area_exclude(adgroup_id) → adgroup(id)
- adgroup_targeting_geo_area_exclude(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_geo_area_exclude(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_interest(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_interest(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_interest(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_behavior(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_behavior(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_behavior(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_status(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_status(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_status(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_purchase_intent(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_purchase_intent(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_purchase_intent(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_yj_interest(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_yj_interest(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_yj_interest(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_yj_purchase_intent(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_yj_purchase_intent(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_yj_purchase_intent(group_id) → adgroup(group_id)
- adgroup_targeting_include_advanced_yj_lifestyle(adgroup_id) → adgroup(id)
- adgroup_targeting_include_advanced_yj_lifestyle(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_include_advanced_yj_lifestyle(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_interest(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_interest(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_interest(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_behavior(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_behavior(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_behavior(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_status(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_status(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_status(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_purchase_intent(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_purchase_intent(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_purchase_intent(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_yj_interest(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_yj_interest(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_yj_interest(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_yj_purchase_intent(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_yj_purchase_intent(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_yj_purchase_intent(group_id) → adgroup(group_id)
- adgroup_targeting_exclude_advanced_yj_lifestyle(adgroup_id) → adgroup(id)
- adgroup_targeting_exclude_advanced_yj_lifestyle(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_exclude_advanced_yj_lifestyle(group_id) → adgroup(group_id)
- adgroup_targeting_placement(adgroup_id) → adgroup(id)
- adgroup_targeting_placement(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_placement(group_id) → adgroup(group_id)
- adgroup_targeting_gender(adgroup_id) → adgroup(id)
- adgroup_targeting_gender(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_gender(group_id) → adgroup(group_id)
- adgroup_targeting_ssps(adgroup_id) → adgroup(id)
- adgroup_targeting_ssps(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_ssps(group_id) → adgroup(group_id)
- adgroup_targeting_user_os(adgroup_id) → adgroup(id)
- adgroup_targeting_user_os(adaccount_id) → adgroup(adaccount_id)
- adgroup_targeting_user_os(group_id) → adgroup(group_id)
- adgroup(campaign_id) → campaign(id)
- adgroup(media_app_id) → media(id)
- adgroup(adaccount_id) → adaccount(id)
- adgroup(group_id) → adaccount(group_id)
- media(adaccount_id) → adaccount(id)
- media(group_id) → adaccount(group_id)
- campaign_delivery_status_reason(campaign_id) → campaign(id)
- campaign_delivery_status_reason(adaccount_id) → campaign(adaccount_id)
- campaign_delivery_status_reason(group_id) → campaign(group_id)
- campaign(adaccount_id) → adaccount(id)
- campaign(group_id) → adaccount(group_id)
- ad_delivery_status_reason(ad_id) → ad(id)
- ad_delivery_status_reason(adaccount_id) → ad(adaccount_id)
- ad_delivery_status_reason(group_id) → ad(group_id)
- ad(adaccount_id) → adaccount(id)
- ad(adgroup_id) → adgroup(id)
- ad(creative_small_image_id) → media(id)
- ad(creative_image_id) → media(id)
- ad(creative_video_id) → media(id)
- ad(creative_animation_id) → media(id)
- ad(group_id) → adaccount(group_id)
- ad_report(adaccount_id) → adaccount(id)
- ad_report(campaign_id) → campaign(id)
- ad_report(adgroup_id) → adgroup(id)
- ad_report(id) → ad(id)
- ad_report(group_id) → adaccount(group_id)