Fivetran supports the following TikTok Ads Prebuilt reports:
Report | Fields | Data level | Dimensions |
---|---|---|---|
CAMPAIGN_REPORT_DAILY | AUCTION_ADS_BASIC_DATA *, VIDEO_PLAY_DATA , ENGAGEMENT_DATA , IN-APP METRICS , skan_conversion , skan_cost_per_conversion , campaign_id, and stat_time_day` |
AUCTION_CAMPAIGN | campaign_id, stat_time_day |
CAMPAIGN_REPORT_HOURLY | AUCTION_ADS_BASIC_DATA , VIDEO_PLAY_DATA *, ENGAGEMENT_DATA , IN-APP METRICS , campaign_id , and stat_time_hour |
AUCTION_CAMPAIGN | campaign_id, stat_time_hour |
ADGROUP_REPORT_DAILY | AUCTION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA *, IN-APP METRICS , skan_conversion , skan_cost_per_conversion , adgroup_id , and stat_time_day |
AUCTION_ADGROUP | adgroup_id, stat_time_day |
ADGROUP_REPORT_HOURLY | AUCTION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , IN-APP METRICS *, adgroup_id , and stat_time_hour |
AUCTION_ADGROUP | adgroup_id, stat_time_hour |
AD_REPORT_DAILY | AUCTION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , IN-APP METRICS , ad_id , and stat_time_day |
AUCTION_AD | ad_id, stat_time_day |
AD_REPORT_HOURLY | AUCTION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , IN-APP METRICS , ad_id , and stat_time_day |
AUCTION_AD | ad_id, stat_time_hour |
CAMPAIGN_AGE_GENDER_REPORT | AUDIENCE_BASIC_DATA *, campaign_id , stat_time_day , age , and gender |
AUCTION_CAMPAIGN | campaign_id, stat_time_day, age, gender |
CAMPAIGN_COUNTRY_REPORT | AUDIENCE_BASIC_DATA , campaign_id , stat_time_day , and country_code |
AUCTION_CAMPAIGN | campaign_id, stat_time_day, country_code |
CAMPAIGN_LANGUAGE_REPORT | AUDIENCE_BASIC_DATA , campaign_id , stat_time_day , and language |
AUCTION_CAMPAIGN | campaign_id, stat_time_day, language |
CAMPAIGN_PLATFORM_REPORT | AUDIENCE_BASIC_DATA , campaign_id , stat_time_day , and platform |
AUCTION_CAMPAIGN | campaign_id, stat_time_day, platform |
AD_AGE_GENDER_REPORT | AUDIENCE_BASIC_DATA , ad_id , stat_time_day , age , and gender |
AUCTION_AD | ad_id, stat_time_day, age, gender |
AD_COUNTRY_REPORT | AUDIENCE_BASIC_DATA , ad_id , stat_time_day , and country_code |
AUCTION_AD | ad_id, stat_time_day, country_code |
AD_LANGUAGE_REPORT | AUDIENCE_BASIC_DATA , ad_id , stat_time_day , and language |
AUCTION_AD | ad_id, stat_time_day, language |
AD_PLATFORM_REPORT | AUDIENCE_BASIC_DATA , ad_id , stat_time_day , and platform |
AUCTION_AD | ad_id, stat_time_day, platform |
RESERVATION_CAMPAIGN_REPORT_DAILY | RESERVATION_ADS_BASIC_DATA *, VIDEO_PLAY_DATA , ENGAGEMENT_DATA , campaign_id , and stat_time_day |
RESERVATION_CAMPAIGN | campaign_id, stat_time_day |
RESERVATION_CAMPAIGN_REPORT_HOURLY | RESERVATION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , campaign_id , and stat_time_hour |
RESERVATION_CAMPAIGN | campaign_id, stat_time_hour |
RESERVATION_ADGROUP_REPORT_DAILY | RESERVATION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , adgroup_id , and stat_time_day |
RESERVATION_ADGROUP | adgroup_id, stat_time_day |
RESERVATION_ADGROUP_REPORT_HOURLY | RESERVATION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , adgroup_id , and stat_time_hour |
RESERVATION_ADGROUP | adgroup_id, stat_time_hour |
RESERVATION_AD_REPORT_DAILY | RESERVATION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , ad_id , and stat_time_day |
RESERVATION_AD | ad_id, stat_time_day |
RESERVATION_AD_REPORT_HOURLY | RESERVATION_ADS_BASIC_DATA , VIDEO_PLAY_DATA , ENGAGEMENT_DATA , ad_id , and stat_time_day |
RESERVATION_AD | ad_id, stat_time_hour |
*NOTE:
-
AUCTION_ADS_BASIC_DATA
refer to the following fields:spend
cash_spend
voucher_spend
cpc
cpm
impressions
clicks
ctr
reach
cost_per_1000_reached
conversion
cost_per_conversion
conversion_rate
real_time_conversion
real_time_cost_per_conversion
real_time_conversion_rate
result
cost_per_result
result_rate
real_time_result
real_time_cost_per_result
real_time_result_rate
secondary_goal_result
cost_per_secondary_goal_result
secondary_goal_result_rate
-
AUDIENCE_BASIC_DATA
refer to the following fields:spend
impressions
clicks
cpm
cpc
ctr
conversion
cost_per_conversion
conversion_rate
real_time_conversion
real_time_cost_per_conversion
real_time_conversion_rate
result
result_rate
cost_per_result
real_time_result
real_time_cost_per_result
real_time_result_rate
-
ENGAGEMENT_DATA
refer to the following fields:likes
comments
shares
profile_visits
follows
engagements
engagement_rate
skip_ad
-
RESERVATION_ADS_BASIC_DATA
refer to the following fields:spend
impressions
clicks
ctr
reach
cost_per_1000_reached
frequency
-
VIDEO_PLAY_DATA
refer to the following fields:video_play_actions
video_watched_2s
video_watched_6s
video_views_p25
video_views_p50
video_views_p75
video_views_p100
average_video_play
average_video_play_per_user
-
IN-APP METRICS
refer to the following fields:sales_lead
skan_sales_lead
skan_total_sales_lead
skan_total_sales_lead_value
total_purchase
total_purchase_value
total_sales_lead
total_sales_lead_value