Prebuilt Reports – Fivetran Support Portal

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`, `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`, `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`*, `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`, `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`, `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`, `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

Related articles

Didn’t find what you need?