Prebuilt Reports

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`,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION 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`,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION METRICS`, `campaign_id`, and `stat_time_hour`	AUCTION_CAMPAIGN	campaign_id, stat_time_hour
CAMPAIGN_REPORT_LIFETIME	`AUCTION_ADS_BASIC_DATA`, `VIDEO_PLAY_DATA`*, `ENGAGEMENT_DATA`, `IN-APP METRICS`,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION METRICS`, `campaign_id`, and `date`	AUCTION_CAMPAIGN	campaign_id
ADGROUP_REPORT_DAILY	`AUCTION_ADS_BASIC_DATA`, `VIDEO_PLAY_DATA`, `ENGAGEMENT_DATA`*, `IN-APP METRICS`,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION 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`*,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION METRICS`, `adgroup_id`, and `stat_time_hour`	AUCTION_ADGROUP	adgroup_id, stat_time_hour
ADGROUP_REPORT_LIFETIME	`AUCTION_ADS_BASIC_DATA`, `VIDEO_PLAY_DATA`, `ENGAGEMENT_DATA`, `IN-APP METRICS`*,`PAGE EVENT METRICS`, `SHOP EVENT METRICS`, `ATTRIBUTION METRICS`, `adgroup_id`, and `date`	AUCTION_ADGROUP	adgroup_id
AD_REPORT_DAILY	`AUCTION_ADS_BASIC_DATA`, `VIDEO_PLAY_DATA`, `ENGAGEMENT_DATA`, `IN-APP METRICS`,`PAGE EVENT METRICS`, `ATTRIBUTION METRICS`, `SHOP EVENT 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`,`PAGE EVENT METRICS`, `ATTRIBUTION METRICS`, `SHOP EVENT METRICS`, `ad_id`, and `stat_time_hour`	AUCTION_AD	ad_id, stat_time_hour
AD_REPORT_LIFETIME	`AUCTION_ADS_BASIC_DATA`, `VIDEO_PLAY_DATA`, `ENGAGEMENT_DATA`, `IN-APP METRICS`,`PAGE EVENT METRICS`, `ATTRIBUTION METRICS`, `SHOP EVENT METRICS`, `ad_id`, and `date`	AUCTION_AD	ad_id
CAMPAIGN_AGE_GENDER_REPORT	`AUDIENCE_BASIC_DATA`*, `PAGE_EVENT_AUDIENCE_METRICS`, `campaign_id`, `stat_time_day`, `age`, and `gender`	AUCTION_CAMPAIGN	campaign_id, stat_time_day, age, gender
CAMPAIGN_COUNTRY_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `campaign_id`, `stat_time_day`, and `country_code`	AUCTION_CAMPAIGN	campaign_id, stat_time_day, country_code
CAMPAIGN_LANGUAGE_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `campaign_id`, `stat_time_day`, and `language`	AUCTION_CAMPAIGN	campaign_id, stat_time_day, language
CAMPAIGN_PLATFORM_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `campaign_id`, `stat_time_day`, and `platform`	AUCTION_CAMPAIGN	campaign_id, stat_time_day, platform
AD_AGE_GENDER_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `aeo_type`, `ad_id`, `stat_time_day`, `age`, and `gender`	AUCTION_AD	ad_id, stat_time_day, age, gender
AD_COUNTRY_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `aeo_type`, `ad_id`, `stat_time_day`, and `country_code`	AUCTION_AD	ad_id, stat_time_day, country_code
AD_LANGUAGE_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `aeo_type`, `ad_id`, `stat_time_day`, and `language`	AUCTION_AD	ad_id, stat_time_day, language
AD_PLATFORM_REPORT	`AUDIENCE_BASIC_DATA`, `PAGE_EVENT_AUDIENCE_METRICS`, `aeo_type`, `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`, `skip_ad`, `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`, `skip_ad`, `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`, `skip_ad`, `engagement`, `engagement_rate`, `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`, `skip_ad`, `engagement`, `engagement_rate`, `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`, `skip_ad`, `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`, `skip_ad`, `ad_id`, and `stat_time_day`	RESERVATION_AD	ad_id, stat_time_hour

*NOTE:

We don't support SKAN metrics for hourly reports.
AUCTION_ADS_BASIC_DATA refer to the following fields:
- 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
PAGE_EVENT_AUDIENCE_METRICS refer to the following fields:
- total_landing_page_view
- cost_per_landing_page_view
- landing_page_view_rate
ENGAGEMENT_DATA refer to the following fields:
- likes
- comments
- shares
- profile_visits
- follows
RESERVATION_ADS_BASIC_DATA refer to the following fields:
- clicks
- cost_per_1000_reached
- ctr
- frequency
- impressions
- reach
- spend
VIDEO_PLAY_DATA refer to the following fields:
- average_video_play
- average_video_play_per_user
- video_play_actions
- video_watched_2s
- video_watched_6s
- video_views_p25
- video_views_p50
- video_views_p75
- video_views_p100
IN-APP METRICS refer to the following fields:
- add_to_wishlist
- add_to_wishlist_rate
- app_event_add_to_cart
- app_event_add_to_cart_rate
- checkout
- checkout_rate
- cost_per_checkout
- cost_per_purchase
- cost_per_add_to_wishlist
- cost_per_app_event_add_to_cart
- cost_per_registration
- cost_per_total_add_to_wishlist
- cost_per_total_app_event_add_to_cart
- cost_per_total_checkout
- cost_per_total_purchase
- cost_per_total_registration
- cost_per_total_view_content
- cost_per_view_content
- dpa_target_audience_type
- purchase
- purchase_rate
- registration
- registration_rate
- sales_lead
- skan_sales_lead
- skan_total_sales_lead
- skan_total_sales_lead_value
- total_active_pay_roas
- total_add_to_wishlist
- total_app_event_add_to_cart
- total_app_event_add_to_cart_value
- total_add_to_wishlist_value
- total_checkout
- total_checkout_value
- total_purchase
- total_purchase_value
- total_registration
- total_sales_lead
- total_sales_lead_value
- total_view_content
- total_view_content_value
- value_per_checkout
- value_per_total_purchase
- value_per_total_add_to_wishlist
- value_per_total_app_event_add_to_cart
- value_per_total_view_content
- view_content
- view_content_rate
ATTRIBUTION METRICS refer to the following fields:
- cta_app_install
- cta_conversion
- cta_purchase
- cta_registration
- cost_per_cta_purchase
- cost_per_cta_registration
- cost_per_vta_conversion
- cost_per_vta_purchase
- cost_per_vta_registration
- vta_app_install
- vta_conversion
- vta_purchase
- vta_registration
PAGE EVENT METRICS refer to the following fields:
- Complete Payment
  - complete_payment
  - complete_payment_rate
  - cost_per_complete_payment
  - total_complete_payment_rate
  - value_per_complete_payment
- Complete Registration
  - cost_per_user_registration
  - total_user_registration_value
  - user_registration
  - user_registration_rate
  - value_per_user_registration
- View Content
  - cost_per_product_details_page_browse
  - product_details_page_browse
  - product_details_page_browse_rate
  - total_product_details_page_browse_value
  - value_per_product_details_page_browse
- Add to Cart
  - cost_per_web_event_add_to_cart
  - total_web_event_add_to_cart_value
  - value_per_web_event_add_to_cart
  - web_event_add_to_cart
  - web_event_add_to_cart_rate
- Initiate Checkout
  - cost_per_initiate_checkout
  - initiate_checkout
  - initiate_checkout_rate
  - total_initiate_checkout_value
  - value_per_initiate_checkout
- Search
  - page_event_search
  - cost_per_page_event_search
  - page_event_search_rate
  - value_per_page_event_search
  - total_page_event_search_value
- Download
  - cost_per_download_start
  - download_start
  - download_start_rate
  - total_download_start_value
  - value_per_download_start
- Add to Wishlist
  - cost_per_on_web_add_to_wishlist
  - on_web_add_to_wishlist
  - on_web_add_to_wishlist_per_click
  - total_on_web_add_to_wishlist_value
  - value_per_on_web_add_to_wishlist
- Landing Page View
  - total_landing_page_view
  - cost_per_landing_page_view
  - landing_page_view_rate
- Page View
  - total_pageview
  - cost_per_pageview
  - pageview_rate
  - avg_value_per_pageview
  - total_value_per_pageview
- Subscribe
  - cost_per_on_web_subscribe
  - on_web_subscribe_per_click
  - on_web_subscribe
  - total_on_web_subscribe_value
  - value_per_on_web_subscribe
SHOP EVENT METRICS refer to the following fields::
- cost_per_onsite_initiate_checkout_count
- cost_per_onsite_on_web_cart
- cost_per_onsite_on_web_detail
- cost_per_onsite_shopping
- onsite_initiate_checkout_count_rate
- onsite_initiate_checkout_count
- onsite_on_web_cart_rate
- onsite_on_web_cart
- onsite_on_web_detail_rate
- onsite_on_web_detail
- onsite_shopping_rate
- onsite_shopping_roas
- onsite_shopping
- total_onsite_initiate_checkout_count_value
- total_onsite_on_web_cart_value
- total_onsite_on_web_detail_value
- total_onsite_shopping_value
- value_per_onsite_initiate_checkout_count
- value_per_onsite_on_web_cart
- value_per_onsite_on_web_detail
- value_per_onsite_shopping