LINE Ads data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

ad_account_id
Display name Ad account ID
Description The ID of the ad account
Field type dimension
Data type string.text.value
ad_account_name
Display name Ad account name
Description The name of the ad account
Field type dimension
Data type string.text.value
ad_description
Display name Ad description
Description The description of the ad
Field type dimension
Data type string.text.value
ad_group_id
Display name Ad group ID
Description The ID of this ad group
Field type dimension
Data type string.text.value
ad_group_name
Display name Ad group name
Description The name of this ad group
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad
Field type dimension
Data type string.text.value
ad_title
Display name Ad title
Description The title of the ad
Field type dimension
Data type string.text.value
add_to_carts
Display name Add-to-carts
Description The number of add-to-carts in the app
Field type metric
Data type int.number.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_objective
Display name Campaign objective
Description The objective of the campaign
Field type dimension
Data type string.text.value
category_views
Display name Category views
Description The number of category views in the app
Field type metric
Data type int.number.value
clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
cost
Display name Cost
Description Total amount of cost
Field type metric
Data type float.currency.value
currency
Display name Ad account currency
Description The currency of the ad account
Field type dimension
Data type string.currency.code
cv
Display name CV (conversions)
Description Total number of conversions
Field type metric
Data type int.number.value
cv_api
Display name CV API
Description The number of API conversions
Field type metric
Data type int.number.value
cv_checkout_started
Display name CV (checkout started)
Description The number of checkout started conversions
Field type metric
Data type int.number.value
cv_item_added_to_cart
Display name CV (item added to cart)
Description The number of item added to cart conversions
Field type metric
Data type int.number.value
cv_lead_generated
Display name CV (lead generated)
Description The number of conversion Generate leads events
Field type metric
Data type int.number.value
cv_product_details_viewed
Display name CV (product details viewed)
Description The number of product details viewed conversions
Field type metric
Data type int.number.value
cv_purchased
Display name CV (purchased)
Description The number of purchased conversions
Field type metric
Data type int.number.value
cv_reservation_completed
Display name CV (reservation completed)
Description The number of reservation completed conversions
Field type metric
Data type int.number.value
cv_signup_completed
Display name CV (signup completed)
Description The number of signup completed conversions
Field type metric
Data type int.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
home_screen_views
Display name Home screen views
Description The number home screen views in the app
Field type metric
Data type int.number.value
impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
installs_clicks
Display name Installs (clicks)
Description Number of app installs, click through conversion
Field type metric
Data type int.number.value
installs_skan
Display name Installs (SKAN)
Description Number of app installs measured by SKAdNetwork
Field type metric
Data type int.number.value
installs_views
Display name Installs (views)
Description Number of app installs, view through conversion
Field type metric
Data type int.number.value
level_achieved
Display name Level achieved
Description The number of level achieved in the app
Field type metric
Data type int.number.value
opens
Display name Opens
Description The number of app opens
Field type metric
Data type int.number.value
product_views
Display name Product views
Description The number of product views in the app
Field type metric
Data type int.number.value
purchases
Display name Purchases
Description The number of purchases in the app
Field type metric
Data type int.number.value
searches
Display name Searches
Description The number of searches in the app
Field type metric
Data type int.number.value
total_installs
Display name Total installs
Description Total number of app installs (clicks and views)
Field type metric
Data type int.number.value
tutorial_completes
Display name Tutorial completes
Description The number of tutorial completes in the app
Field type metric
Data type int.number.value
video_100_watched
Display name Video (100% watched)
Description The number of video completes, i.e. views where 100% of the video was watched in the app
Field type metric
Data type int.number.value
video_25_watched
Display name Video (25% watched)
Description The number of views where at least 25% of the video was watched in the app
Field type metric
Data type int.number.value
video_50_watched
Display name Video (50% watched)
Description The number of views where at least 50% of the video was watched in the app
Field type metric
Data type int.number.value
video_75_watched
Display name Video (75% watched)
Description The number of views where at least 75% of the video was watched in the app
Field type metric
Data type int.number.value
video_95_watched
Display name Video (95% watched)
Description The number of views where at least 95% of the video was watched in the app
Field type metric
Data type int.number.value
video_views
Display name Video (viewed for at least 3s)
Description The number of times video was viewed for at least 3 seconds in the app
Field type metric
Data type int.number.value
viewable_impressions
Display name Viewable impressions
Description The number of viewable impressions
Field type metric
Data type int.number.value