Prebuilt Reports

NOTE: We include prebuilt reports by default. You can enable or disable prebuilt report tables on the Schema tab to avoid syncing data you don't need.

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