LINE Ads

Explore the interactive ERD

Table & Field Reference

adaccount_available_campaign_objective

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`available_campaign_objective`	Unknown

adaccount_delivery_status_reason

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`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	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`code`	Unknown

adgroup_targeting_custom_audience

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`custom_audience_id`	Unknown

adgroup_targeting_excluded_custom_audience

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`excluded_custom_audience_id`	Unknown

adgroup_targeting_geo_area_include

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`area_type`	Unknown
`label`	Unknown
`radius`	Unknown
`value`	Unknown

adgroup_targeting_geo_area_exclude

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`area_type`	Unknown
`label`	Unknown
`radius`	Unknown
`value`	Unknown

adgroup_targeting_include_advanced_interest

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`interest`	Unknown

adgroup_targeting_include_advanced_behavior

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`behavior`	Unknown

adgroup_targeting_include_advanced_status

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`status`	Unknown

adgroup_targeting_include_advanced_purchase_intent

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`purchase_intent`	Unknown

adgroup_targeting_include_advanced_yj_interest

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_interest`	Unknown

adgroup_targeting_include_advanced_yj_purchase_intent

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_purchase_intent`	Unknown

adgroup_targeting_include_advanced_yj_lifestyle

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_lifestyle`	Unknown

adgroup_targeting_exclude_advanced_interest

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`interest`	Unknown

adgroup_targeting_exclude_advanced_behavior

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`behavior`	Unknown

adgroup_targeting_exclude_advanced_status

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`status`	Unknown

adgroup_targeting_exclude_advanced_purchase_intent

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`purchase_intent`	Unknown

adgroup_targeting_exclude_advanced_yj_interest

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_interest`	Unknown

adgroup_targeting_exclude_advanced_yj_purchase_intent

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_purchase_intent`	Unknown

adgroup_targeting_exclude_advanced_yj_lifestyle

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`yj_lifestyle`	Unknown

adgroup_targeting_placement

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`placement`	Unknown

adgroup_targeting_gender

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`gender_code`	Unknown

adgroup_targeting_ssps

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`ssps`	Unknown

adgroup_targeting_user_os

Column	Type	Keys
`index`	Unknown	PK
`adaccount_id`	Unknown	PKFK
`adgroup_id`	Unknown	PKFK
`group_id`	String	PKFK
`os`	Unknown
`ver_max`	Unknown
`ver_min`	Unknown

adgroup

Column	Type	Keys
`id`	Unknown	PK
`modified_date`	Instant	PK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`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	PKFK
`group_id`	String	PKFK
`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	PKFK
`campaign_id`	Unknown	PKFK
`group_id`	String	PKFK
`code`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`modified_date`	Instant	PK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`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	PKFK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`code`	Unknown

Column	Type	Keys
`id`	Unknown	PK
`modified_date`	Instant	PK
`adaccount_id`	Unknown	PKFK
`group_id`	String	PKFK
`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	PKFK
`group_id`	String	PKFK
`id`	Unknown	PKFK
`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_`