Kwai Ads data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
activation
Display name Activation (Conv.)
Description The number of activation events attributed to your ads
Field type metric
Data type int.number.value
add_to_cart
Display name Add to cart (Conv.)
Description The number of add to cart events attributed to your ads
Field type metric
Data type int.number.value
app_launch
Display name App launch (Conv.)
Description The number of app launch events attributed to your ads
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
clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
content_view
Display name Content view (Conv.)
Description The number of content view events attributed to your ads
Field type metric
Data type int.number.value
conversions
Display name Conversion (Conv.)
Description The total number of conversions attributed to your ads, based on the selected conversion goal
Field type metric
Data type int.number.value
cost
Display name Cost
Description The total amount of cost (in USD)
Field type metric
Data type float.currency.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
impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
in_app_ad_click
Display name In-app ad click (Conv.)
Description The number of in-app ad click events attributed to your ads
Field type metric
Data type int.number.value
in_app_ad_view
Display name In-app ad view (Conv.)
Description The number of in-app ad view events attributed to your ads
Field type metric
Data type int.number.value
key_in_app_event
Display name Key in-app event (Conv.)
Description The number of key in-app events attributed to your ads
Field type metric
Data type int.number.value
registration
Display name Registration (Conv.)
Description The total number of registration events attributed to your ads
Field type metric
Data type int.number.value
through_plays
Display name Through plays
Description For video 15 seconds or shorter, the number of times the video was played at 97%. For longer videos, the number of video plays to at least 15 unique seconds
Field type metric
Data type int.number.value
total_day_one_retention
Display name Total day 1 retention (Conv.)
Description The number of total day 1 retention attributed activations by your ads
Field type metric
Data type int.number.value
total_day_one_retention_platform_attribution
Display name Total day 1 retention (platform attribution) (Conv.)
Description The number of total day 1 retention (platform attribution) attributed activations by your ads
Field type metric
Data type int.number.value
total_purchase
Display name Total purchase (Conv.)
Description The number of total purchase events attributed to your ads
Field type metric
Data type int.number.value
video_completions
Display name Video completions
Description Number of video played to its completion
Field type metric
Data type int.number.value
video_plays_25
Display name Video plays at 25%
Description Number of video plays at 25%
Field type metric
Data type int.number.value
video_plays_3s
Display name 3-second video play
Description Number of video plays until 3 seconds
Field type metric
Data type int.number.value
video_plays_50
Display name Video plays at 50%
Description Number of video plays at 50%
Field type metric
Data type int.number.value
video_plays_5s
Display name 5-second video play
Description Number of video plays until 5 seconds
Field type metric
Data type int.number.value
video_plays_75
Display name Video plays at 75%
Description Number of video plays at 75%
Field type metric
Data type int.number.value

Table: AD_SET

account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
activation
Display name Activation (Conv.)
Description The number of activation events attributed to your ads
Field type metric
Data type int.number.value
ad_set_id
Display name Ad set ID
Description The ID of the ad set
Field type dimension
Data type string.text.value
ad_set_name
Display name Ad set name
Description The name of the ad set
Field type dimension
Data type string.text.value
add_to_cart
Display name Add to cart (Conv.)
Description The number of add to cart events attributed to your ads
Field type metric
Data type int.number.value
app_launch
Display name App launch (Conv.)
Description The number of app launch events attributed to your ads
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
clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
content_view
Display name Content view (Conv.)
Description The number of content view events attributed to your ads
Field type metric
Data type int.number.value
conversions
Display name Conversion (Conv.)
Description The total number of conversions attributed to your ads, based on the selected conversion goal
Field type metric
Data type int.number.value
cost
Display name Cost
Description The total amount of cost (in USD)
Field type metric
Data type float.currency.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
impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
in_app_ad_click
Display name In-app ad click (Conv.)
Description The number of in-app ad click events attributed to your ads
Field type metric
Data type int.number.value
in_app_ad_view
Display name In-app ad view (Conv.)
Description The number of in-app ad view events attributed to your ads
Field type metric
Data type int.number.value
key_in_app_event
Display name Key in-app event (Conv.)
Description The number of key in-app events attributed to your ads
Field type metric
Data type int.number.value
registration
Display name Registration (Conv.)
Description The total number of registration events attributed to your ads
Field type metric
Data type int.number.value
through_plays
Display name Through plays
Description For video 15 seconds or shorter, the number of times the video was played at 97%. For longer videos, the number of video plays to at least 15 unique seconds
Field type metric
Data type int.number.value
total_day_one_retention
Display name Total day 1 retention (Conv.)
Description The number of total day 1 retention attributed activations by your ads
Field type metric
Data type int.number.value
total_day_one_retention_platform_attribution
Display name Total day 1 retention (platform attribution) (Conv.)
Description The number of total day 1 retention (platform attribution) attributed activations by your ads
Field type metric
Data type int.number.value
total_purchase
Display name Total purchase (Conv.)
Description The number of total purchase events attributed to your ads
Field type metric
Data type int.number.value
video_completions
Display name Video completions
Description Number of video played to its completion
Field type metric
Data type int.number.value
video_plays_25
Display name Video plays at 25%
Description Number of video plays at 25%
Field type metric
Data type int.number.value
video_plays_3s
Display name 3-second video play
Description Number of video plays until 3 seconds
Field type metric
Data type int.number.value
video_plays_50
Display name Video plays at 50%
Description Number of video plays at 50%
Field type metric
Data type int.number.value
video_plays_5s
Display name 5-second video play
Description Number of video plays until 5 seconds
Field type metric
Data type int.number.value
video_plays_75
Display name Video plays at 75%
Description Number of video plays at 75%
Field type metric
Data type int.number.value

Table: AD

account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
activation
Display name Activation (Conv.)
Description The number of activation events attributed to your ads
Field type metric
Data type int.number.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_set_id
Display name Ad set ID
Description The ID of the ad set
Field type dimension
Data type string.text.value
ad_set_name
Display name Ad set name
Description The name of the ad set
Field type dimension
Data type string.text.value
add_to_cart
Display name Add to cart (Conv.)
Description The number of add to cart events attributed to your ads
Field type metric
Data type int.number.value
app_launch
Display name App launch (Conv.)
Description The number of app launch events attributed to your ads
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
clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
content_view
Display name Content view (Conv.)
Description The number of content view events attributed to your ads
Field type metric
Data type int.number.value
conversions
Display name Conversion (Conv.)
Description The total number of conversions attributed to your ads, based on the selected conversion goal
Field type metric
Data type int.number.value
cost
Display name Cost
Description The total amount of cost (in USD)
Field type metric
Data type float.currency.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
impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
in_app_ad_click
Display name In-app ad click (Conv.)
Description The number of in-app ad click events attributed to your ads
Field type metric
Data type int.number.value
in_app_ad_view
Display name In-app ad view (Conv.)
Description The number of in-app ad view events attributed to your ads
Field type metric
Data type int.number.value
key_in_app_event
Display name Key in-app event (Conv.)
Description The number of key in-app events attributed to your ads
Field type metric
Data type int.number.value
registration
Display name Registration (Conv.)
Description The total number of registration events attributed to your ads
Field type metric
Data type int.number.value
through_plays
Display name Through plays
Description For video 15 seconds or shorter, the number of times the video was played at 97%. For longer videos, the number of video plays to at least 15 unique seconds
Field type metric
Data type int.number.value
total_day_one_retention
Display name Total day 1 retention (Conv.)
Description The number of total day 1 retention attributed activations by your ads
Field type metric
Data type int.number.value
total_day_one_retention_platform_attribution
Display name Total day 1 retention (platform attribution) (Conv.)
Description The number of total day 1 retention (platform attribution) attributed activations by your ads
Field type metric
Data type int.number.value
total_purchase
Display name Total purchase (Conv.)
Description The number of total purchase events attributed to your ads
Field type metric
Data type int.number.value
video_completions
Display name Video completions
Description Number of video played to its completion
Field type metric
Data type int.number.value
video_plays_25
Display name Video plays at 25%
Description Number of video plays at 25%
Field type metric
Data type int.number.value
video_plays_3s
Display name 3-second video play
Description Number of video plays until 3 seconds
Field type metric
Data type int.number.value
video_plays_50
Display name Video plays at 50%
Description Number of video plays at 50%
Field type metric
Data type int.number.value
video_plays_5s
Display name 5-second video play
Description Number of video plays until 5 seconds
Field type metric
Data type int.number.value
video_plays_75
Display name Video plays at 75%
Description Number of video plays at 75%
Field type metric
Data type int.number.value