TikTok Ads Setup Guide link

Updated November 16, 2023

Follow our setup guide to connect TikTok Ads to Fivetran.

Prerequisiteslink

To connect TikTok Ads to Fivetran, you need a TikTok Ads Business account with permission to access data from accounts you'd like to sync.

Setup instructionslink

Begin Fivetran configurationlink

In the connector setup form, enter the Destination schema name of your choice.
Click Authorize. You will be redirected to your TikTok Ads account to authorize Fivetran's access.

Authorize Fivetranlink

Log in to your TikTok Ads account.
Click Confirm to authorize Fivetran's access. You will be redirected back to Fivetran.

Complete Fivetran configurationlink

Choose your Sync Mode: Sync All Accounts or Sync Specific Accounts. If you select Sync Specific Accounts, then select the Accounts you want to sync using Fivetran.
Select how many months' worth of reporting data you'd like to include in your initial sync.
(Optional) To configure the attribution window to capture conversions, 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.
(Optional) If you want to sync custom reports, click Add custom report.
Enter your chosen Destination table. It must be unique within this connector and must comply with Fivetran's naming conventions.
NOTE: Give the table a name you will find easy to identify with the report in the future. If you want to enable or disable the sync for a particular report once it is set up, you can do so by selecting its table in the connector's schema tab.
Select the Report Level, Dimensions, Aggregate and Metrics you'd like to sync. See TikTok's Ads API Report Types documentation.
NOTE: An advertiser account can either be an Auction advertiser or a Reservation advertiser at a time.
NOTE: For any campaign that has been created in Tiktok Ads Manager (TTAM), select type AUCTION to get data, even if the advertiser is a Reservation Advertiser.
Click Save to save the report.
To add another custom report, repeat steps 4 — 7.
Click Save & Test. Fivetran will take it from here and sync your TikTok Ads data.

Documentation