Release Notes
July 2024
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. You can find details about the tiktok_item_id
field in the TikTok ads documentation.
Previously, basic reports used STATUS_NOT_DELETE
filtering by default, which includes all statuses except Deleted
. Now, we added the STATUS_ALL
filtering option which incudes all statuses.
All basic report aggregations will now include deleted entities as well.
August 2023
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 connectors. 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 connectors.
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 connectors.
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.