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
- 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 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. 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 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.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration