Release Noteslink

August 2023link

We have added a new table, VIDEO_HISTORY.

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

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 customers. If you want to sync the historical data for these fields, contact our support team.

July 2023link

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 connectors.

June 2023link

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 customers.

December 2022link

We have added the following new tables:

PIXEL_HISTORY
PIXEL_EVENT_HISTORY
PIXEL_EVENT_RULE_HISTORY
PIXEL_STATISTICS

November 2022link

We have added the following new tables:

AD_REPORT_LIFETIME
ADGROUP_REPORT_LIFETIME
CAMPAIGN_REPORT_LIFETIME

March 2022link

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 2022link

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 2021link

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

August 2021link

TikTok Ads is a video-sharing social networking platform.

Read our TikTok Ads connector documentation.

Documentation