TikTok Ads Setup Guide

Follow our setup guide to connect TikTok Ads to Fivetran.

Prerequisites

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 instructions

Begin Fivetran configuration

Enter your chosen Destination schema name in the connection setup form.
IMPORTANT: TikTok prohibits access to its API from some countries from the ASIA_SOUTH cloud region. Consider using other regions. Learn how to change the cloud provider region by following the instructions in the Error: Client IP Address Is In Banned Country List troubleshooting article.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.
Click Authorize. You will be redirected to your TikTok Ads account to authorize Fivetran's access.

Authorize Fivetran

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

Complete Fivetran configuration

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) Add Custom report

Click + Custom report.
Enter a Report name. The name must be unique within this connection 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 you'd like to sync.
Select the Dimensions you'd like to sync.
Select the Aggregate period.

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 Next.
Select the metrics you'd like to sync by doing either of the following:
- Start typing the metric's name in the search field to find it by name, and select it by checking the box.
- Select the category name on the left panel to see the relevant metrics for that category displayed on the right, and select them by checking the box.
Click Save to save the report.
To add another custom report, repeat step 4.

Finish Fivetran configuration

Click Save & Test. Fivetran will take it from here and sync your TikTok Ads data.

Connector Overview

Schema Information

Release Notes

API Connection Configuration

Documentation Home