Release Notes

October 2025

We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

September 2025

We have added two new tables, GMV_ADVERTISER_COUNTRY_REPORT_DAILY and GMV_CAMPAIGN_COUNTRY_REPORT_DAILY.

July 2025

We've added the following dimensions to basic reports:

AD_TYPE
COMPONENT_NAME
EVENT_SOURCE_ID
IMAGE_ID
PAGE_ID
POST_ID
ROOM_ID
SEARCH_TERMS
VIDEO_MATERIAL_ID

We added checks to the UI for dimension groupings, for more information visit: https://business-api.tiktok.com/gateway/docs/index?identify_key=c0138ffadd90a955c1f0670a56fe348d1d40680b3c89461e09f78ed26785164b&language=ENGLISH&doc_id=1751443956638721#item-link-Dimension%20grouping

June 2025

We have added a new Quickstart package for the Microsoft Dynamics 365 CRM connector.

We have updated the Quickstart packages for the following connectors:

Connectors supporting the Ad Reporting data model to version 1.15.0.
Connectors supporting the App Reporting data model to version 0.6.0.
Connectors supporting the Shopify Holistic Reporting data model to version 0.8.0.
Amazon Ads to version 0.5.0.
Amplitude to version 0.7.0.
Apple App Store to version 0.6.0.
Apple Search Ads to version 0.6.0.
Asana to version 0.9.0.
Facebook Ads to version 0.10.0.
Fivetran Platform to version 2.2.0.
GitHub to version 0.9.0.
Google Ads to version 0.14.0.
Google Play to version 0.5.0.
Greenhouse to version 0.9.0.
HubSpot to version 0.24.0.
Intercom to version 0.10.0.
Jira to version 0.21.0.
Klaviyo to version 0.9.0.
Lever to version 0.8.0.
LinkedIn Ad Analytics to version 0.12.0.
Mailchimp to version 0.12.0.
Microsoft Advertising to version 0.12.0.
Mixpanel to version 0.13.0.
NetSuite SuiteAnalytics to version 0.20.0.
Pendo to version 0.6.0.
Pinterest Ads to version 0.13.0.
QuickBooks to version 0.20.0.
Recurly to version 0.7.0.
Reddit Ads to version 0.5.0.
Sage Intacct to version 0.7.0.
Salesforce to version 1.3.0.
Snapchat Ads to version 0.10.0.
Stripe to version 0.19.0.
TikTok Ads to version 0.9.0.
Twilio to version 0.5.0.
Twitter Ads to version 0.10.0.
Workday HCM to version 0.4.0.
Zendesk Support to version 0.24.1.

May 2025

We have updated the Quickstart packages for the following connectors:

Connectors supporting the Ad Reporting data model to version 1.14.0.
Connectors supporting the Social Media Reporting data model to version 0.7.0.
Google Ads to version 0.13.0.
Instagram Business to version 0.3.0.
Intercom to version 0.9.2.
Mailchimp to version 0.10.1.
QuickBooks to version 0.18.1.
Recharge to version 0.4.0.
Recurly to version 0.6.0.
Shopify to version 0.19.0.
Stripe to version 0.18.0.
TikTok Ads to version 0.8.1.
Zendesk Support to version 0.22.0.
Zuora to version 0.5.0.

April 2025

We've added the following fields to the Prebuilt Audience reporting tables:

AD_AGE_GENDER_REPORT
AD_COUNTRY_REPORT
AD_LANGUAGE_REPORT
AD_PLATFORM_REPORT
CAMPAIGN_AGE_GENDER_REPORT
CAMPAIGN_COUNTRY_REPORT
CAMPAIGN_LANGUAGE_REPORT
CAMPAIGN_PLATFORM_REPORT

These add support for the following engagement metrics, which are now also available for selection in the Custom Audience reporting tables:

clicks_on_music_disc
comments
follows
likes
profile_visits_rate
profile_visits
shares

For more information, see TikTok's Documentation.

We've added the following fields to the Prebuilt Basic reporting tables:

AD_REPORT_DAILY
AD_REPORT_HOURLY
AD_REPORT_LIFETIME
ADGROUP_REPORT_DAILY
ADGROUP_REPORT_HOURLY
ADGROUP_REPORT_LIFETIME
CAMPAIGN_REPORT_DAILY
CAMPAIGN_REPORT_HOURLY
CAMPAIGN_REPORT_LIFETIME

These add support for the following engagement metrics, which are now also available for selection in the Custom Basic reporting tables:

anchor_click_rate
anchor_clicks
clicks_on_hashtag_challenge
clicks_on_music_disc
comments
duet_clicks
engagement_rate
engagements
follows
ix_average_video_play
ix_page_duration_avg
ix_page_viewrate_avg
ix_video_views
ix_video_views_p100
ix_video_views_p25
ix_video_views_p50
ix_video_views_p75
likes
profile_visits
profile_visits_rate
shares
sound_usage_clicks
stitch_clicks
tt_playlist_visit
tt_playlist_visit_rate

For more information, see TikTok's Documentation.

We have updated the Quickstart packages for the following connectors:

Facebook Ads to version 0.9.0
Google Ads to version 0.12.0
HubSpot to version 0.23.0
LinkedIn Ad Analytics to version 0.11.0
Microsoft Advertising to version 0.11.1
NetSuite SuiteAnalytics to version 0.19.0
Pinterest to version 0.12.0
Recharge to version 0.3.1
Reddit Ads to version 0.4.0
TikTok Ads to version 0.8.0
Twitter Ads to version 0.9.0
Xero to version 0.9.0
Zuora to version 0.4.0

February 2025

We've discontinued support for the following metrics in the ADGROUP_HISTORY table because they are no longer available in the TikTok Ads API:

impression_tracking_url
click_tracking_url

January 2025

The TikTok Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

November 2024

We added a buying_types filter to our calls to retrieve all possible buying_types entities {AUCTION, RESERVATION_RF, RESERVATION_TOP_VIEW} for the following tables:

AD_HISTORY
ADGROUP_HISTORY
CAMPAIGN_HISTORY

We added the buying_type field to all three tables (AD_HISTORY, ADGROUP_HISTORY, and CAMPAIGN_HISTORY) to reflect the buying_types filter value used in our data requests.

We added the following fields to the AD_HISTORY table (for details, see the TikTok documentation):

aigc_disclosure_type
avatar_icon_web_uri
brand_safety_postbid_partner
brand_safety_vast_url
branded_content_disabled
call_to_action_id
card_id
carousel_image_index
cpp_url
creative_type
dark_post_status
deeplink_type
dynamic_destination
dynamic_format
fallback_type
identity_authorized_bc_id
identity_id
identity_type
item_duet_status
item_stitch_status
music_id
optimization_event
page_id
phone_number
phone_region_calling_code
phone_region_code
product_set_id
product_specific_type
promotional_music_disabled
shopping_ads_deeplink_type
shopping_ads_fallback_type
shopping_ads_video_package_id
tiktok_page_category
tracking_app_id
tracking_pixel_id
vast_moat_enabled
vertical_video_strategy
viewability_postbid_partner
viewability_vast_url

We added the following fields to the ADGROUP_HISTORY table (for details, see the TikTok documentation):

adgroup_app_profile_page_state
attribution_event_count
bid_display_mode
brand_safety_partner
brand_safety_type
click_attribution_window
comment_disabled
cpm
delivery_mode
discount_amount
discount_percentage
discount_type
engaged_view_attribution_window
feed_type
identity_authorized_bc_id
identity_id
identity_type
ios14_quota_type
ios14_targeting
is_smart_performance_campaign
next_day_retention
pre_discount_budget
pre_discount_cpm
predict_impression
product_source
promotion_target_type
promotion_type
promotion_website_type
purchased_impression
purchased_reach
rf_estimated_cpr
rf_estimated_frequency
rf_purchased_type
roas_bid
saved_audience_id
scheduled_budget
search_result_enabled
share_disabled
shopping_ads_retargeting_actions_days
shopping_ads_retargeting_custom_audience_relation
shopping_ads_retargeting_type
shopping_ads_type
smart_audience_enabled
smart_interest_behavior_enabled
spending_power
split_test_group_id
split_test_status
store_authorized_bc_id
store_id
String> tiktok_subplacements
vbo_window
vertical_sensitivity_id
video_download_disabled
view_attribution_window

We added the following fields to the CAMPAIGN_HISTORY table (for details, see the TikTok documentation):

app_id
app_promotion_type
bid_type
budget_optimize_on
campaign_app_profile_page_state
campaign_product_source
deep_bid_type
is_advanced_dedicated_campaign
is_search_campaign
is_smart_performance_campaign
objective
optimization_goal
postback_window_mode
rf_campaign_type
roas_bid
rta_id
rta_product_selection_enabled

October 2024

We added a new table, IMAGE_HISTORY. For more information, see the TikTok API documentation.

September 2024

We added the ad_format field to the AD_HISTORY table.

We have also added a new table, UTM_PARAM. For more information, see the TikTok API documentation.

August 2024

We've added support for the custom_event_type dimension for custom reports.

We've also added a new page event metric to custom reports:

View Content Metrics:

cost_per_page_content_view_event
page_content_view_event_rate
page_content_view_events
total_page_view_content_events_value
value_per_page_content_view_event

Custom Page Event Metrics:

cost_per_custom_page_event
custom_page_event_rate
custom_page_events
custom_page_events_value
value_per_custom_page_event

For more information, see TikTok API documentation.

July 2024

We have added a new field, asset_ownership_status, to the PIXEL table.

We have added a new field, custom_event_type, to the PIXEL_EVENT table.

We have added new metrics to our basic prebuilt reports.

Reports:

AD_REPORT_DAILY
AD_REPORT_HOURLY
AD_REPORT_LIFETIME
ADGROUP_REPORT_DAILY
ADGROUP_REPORT_HOURLY
ADGROUP_REPORT_LIFETIME
CAMPAIGN_REPORT_DAILY
CAMPAIGN_REPORT_HOURLY
CAMPAIGN_REPORT_LIFETIME

Metrics:

Shop Event Metrics:

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

Page Event Metrics:

cost_per_on_web_subscribe
on_web_subscribe_per_click
on_web_subscribe
total_on_web_subscribe_value
value_per_on_web_subscribe

June 2024

We have added the total_landing_page_view, cost_per_landing_page_view, landing_page_view_rate, total_pageview, cost_per_pageview, pageview_rate, avg_value_per_pageview, and total_value_per_pageview fields to the following reports:

CAMPAIGN_REPORT_DAILY
CAMPAIGN_REPORT_HOURLY
CAMPAIGN_REPORT_LIFETIME
ADGROUP_REPORT_DAILY
ADGROUP_REPORT_HOURLY
ADGROUP_REPORT_LIFETIME
AD_REPORT_DAILY
AD_REPORT_HOURLY
AD_REPORT_LIFETIM

We have added the total_landing_page_view, cost_per_landing_page_view, and landing_page_view_rate fields to the following reports:

CAMPAIGN_AGE_GENDER_REPORT
CAMPAIGN_COUNTRY_REPORT
CAMPAIGN_LANGUAGE_REPORT
CAMPAIGN_PLATFORM_REPORT
AD_AGE_GENDER_REPORT
AD_COUNTRY_REPORT
AD_LANGUAGE_REPORT
AD_PLATFORM_REPORT

March 2024

We have added a new column, tiktok_item_id, to the AD_HISTORY table. For more information on this field, see TikTok ads' documentation.

We now use STATUS_ALL filtering option for basic reports which include all statuses. Previously, by default, we used the STATUS_NOT_DELETE filtering option for basic reports which includes all statuses except Deleted. All basic report aggregations will now also include the deleted entities.

August 2023

We have added a new table, VIDEO_HISTORY.

This change is applicable for all new connections, and we are gradually rolling out this change to all existing connections.

We have added new IN-APP METRICS, PAGE EVENT METRICS, and ATTRIBUTION METRICS fields to the following reports:

AD_REPORT_DAILY
AD_REPORT_HOURLY
AD_REPORT_LIFETIME
ADGROUP_REPORT_DAILY
ADGROUP_REPORT_HOURLY
ADGROUP_REPORT_LIFETIME
CAMPAIGN_REPORT_DAILY
CAMPAIGN_REPORT_HOURLY
CAMPAIGN_REPORT_LIFETIME

For more information about the fields, see our prebuilt reports documentation.

We are gradually rolling out these changes to all existing connections. If you want to sync the historical data for these fields, contact our support team.

July 2023

We have upgraded our TikTok Ads connector to TikTok Ads API v1.3. As part of the upgrade, we have renamed the following columns in the tables below:

Table name	Old column name	New column name
`ADGROUP_HISTORY`	`placement`	`placements`
	`enable_inventory_filter`	`inventory_filter_enabled`
	`external_action`	`optimization_event`
	`deep_external_action`	`secondary_optimization_event`
	`age`	`age_groups`
	`operation_system`	`operating_systems`
	`connection_type`	`network_types`
	`device_price`	`device_price_ranges`
	`android_osv`	`min_android_version`
	`ios_osv`	`min_ios_version`
	`optimize_goal`	`optimization_goal`
	`bid`	`bid_price`
	`conversion_bid`	`conversion_bid_price`
	`deep_cpabid`	`deep_cpa_bid`
	`opt_status`	`operation_status`
	`status`	`secondary_status`
`AD_HISTORY`	`profile_image`	`profile_image_url`
	`open_url`	`deeplink`
	`is_creative_authorized`	`creative_authorized`
	`opt_status`	`operation_status`
	`status`	`secondary_status`
`ADVERTISER`	`reason`	`rejected_reason`
	`phone_number`	`cellphone_number`
	`telephone`	`telephone_number`
`CAMPAIGN_HISTORY`	`opt_status`	`operation_status`
	`status`	`secondary_status`
`PIXEL`	`asset_ownership_owned_by`	`asset_ownership_owner_bc_id`
`PIXEL_EVENT`	`external_action`	`optimization_event`

We are gradually rolling out these changes to all existing connections.

June 2023

You can now opt to configure the attribution window to capture conversions. In the connector setup form, set the Show advanced options toggle to ON, and set the attribution window using the Rollback sync (optional) drop-down. By default, the window is 7 days. For more information, see our setup guide and REST API Config.

We have added a new option, Add custom report, to the setup form. This option enables you to configure and sync your custom reports using our TikTok Ads connector. For more information, see our setup guide. We are gradually rolling out this feature to all existing connections.

December 2022

We have added the following new tables:

PIXEL_HISTORY
PIXEL_EVENT_HISTORY
PIXEL_EVENT_RULE_HISTORY
PIXEL_STATISTICS

November 2022

We have added the following new tables:

AD_REPORT_LIFETIME
ADGROUP_REPORT_LIFETIME
CAMPAIGN_REPORT_LIFETIME

March 2022

We have added new IN-APP METRICS fields to the following reports:

CAMPAIGN_REPORT_DAILY
CAMPAIGN_REPORT_HOURLY
ADGROUP_REPORT_DAILY
ADGROUP_REPORT_HOURLY
AD_REPORT_DAILY
AD_REPORT_HOURLY

For more information about the fields, see our prebuilt reports documentation.

January 2022

Our Tiktok Ads connector is now generally available. Read our TikTok Ads connector documentation.

We have released pre-built, dbt Core-compatible data models for TikTok Ads. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

November 2021

We have added a new column, status, to the CAMPAIGN_HISTORY table.

August 2021

TikTok Ads is a video-sharing social networking platform.

Read our TikTok Ads connector documentation.