TikTok Ads

TikTok Ads is a tool for TikTok business users designed for targeting, ad creation, insight reports, and ad management.

Data integration: Skyvia supports importing data to and from TikTok Ads, exporting TikTok Ads data to CSV files, replicating TikTok Ads data to relational databases, and synchronizing TikTok Ads data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support TikTok Ads.

Query: Skyvia Query supports TikTok Ads.

Establishing Connection

Skyvia supports both TikTok Ads Production and Sandbox environments. For the production environment, Skyvia uses OAuth authentication.

To establish a connection to TikTok Ads you must select the environment. Skyvia uses OAuth authentication for the TikTok Ads Production environment. To connect Skyvia to the Sandbox environment, you need the Token and AccountId.

Getting Credentials

To obtain the Token and AccountId for connecting to TikTok Ads Sandbox, you need create a new app in TikTok for Business UI. Perform the following steps:

  1. Log in to your TikTok account, go to My Apps and click Create New.
  2. Fill in the fields and click Confirm.
  3. After the app is approved, log in to TikTok again and go to MyApps.
  4. Click on your app name, go to the Sandbox Ad Account menu and create the sandbox there.
  5. After that, the AdvertiserId will be generated automatically. Generate the Access Token manually by clicking the Generate button.

    sandbox credentials

For the Production environment, you don’t need to obtain any additional parameters.

Creating Connection

Production environment


  1. Click Sign In with TikTok.


  2. In the opened window, enter your TikTok for Business credentials and click Log In.


  3. Grant Skyvia the requested permissions by clicking Confirm.

Sandbox environment

  1. In the Environment box, select Sandbox.


  1. Enter Token and Account Id.

Connector Specifics

Skyvia has the following TikTok Ads connector specifics:

Read-only Objects

The tables AdGroupActions, Identities, Locations, DeviceModels, InterestCategories and all the Reports (tables containing the -Report suffix in their names) are read-only in the TikTok Ads connector.

Sandbox Environment

The following objects are supported in the Sandbox environment: Ads, AdsDailyReport, AdsReport, AdsSKANDailyReport, AdsSKANReport, AdGroups, AdGroupsDailyReport, AdGroupsReport, AdGroupsSKANDailyReport, AdGroupsSKANReport, AdGroupActions, Audiences, Campaigns, CampaignsReport, CampaignsDailyReport, CampaignsSKANDailyReport, CampaignsSKANReport.

DML Operations Support

Operations Objects
INSERT, UPDATE, DELETE AdGroups, Ads, Campaigns
DELETE Audiences


The reports are present in the TikTok Ads connector as tables with the -Report suffix in their names. All reports are divided into separate tables according to the report levels: AdAccount, Campaign, AdGroup, or Ad with the corresponding suffix in the table names. There are several types of reports. Simple reports contain the regular reports, daily reports with the basic set of metrics, and the SKAN reports with additional metrics set. The full metrics set is available in the extended reports.

Simple Reports

The tables with the -Daily suffix in their names contain the metrics grouped by days. The data selection period is set by default if you do not set filters. The default report end date is equal to the current date. The default report start date is determined by the maximal allowed period (30 days).

The tables without the -Daily suffix contain the metrics for the whole period/ selected period. These tables contain the StartDate/EndDate fields. You can set the values for these fields if you set filters. The data selection period is set by default if you do not set filters. The default report end date is equal to the current date. The default report start date is determined by the maximal allowed period (365 days).

Simple reports are convenient when you need to query a small data volume. They may timeout when querying significant data volumes.

Extended Reports

The tables with the -ExtendedReport suffix in their names are read in the asynchronous API mode. The extended reports contain the full list of the fields available in the API.

Extended reports are not limited to the data selection period. The minimal possible start date for such reports is 01.01.2012.

Incremental Replication and Synchronization

The objects Campaigns, AdGroups, Ads, and Audiences contain the UpdatedDate or CreatedDate fields, thus, the Replication with Incremental Updates and Synchronization is supported for these objects.

The -Report objects may contain either the StartDate, EndDate, or Date (daily report) fields with data type DATE, not the DATETIME. It means that the Replication package with Incremental Updates enabled does not retrieve the data for the current date to avoid duplications. For example, running the replication package today will return the report with the data selection as of yesterday.

Supported Actions

Skyvia supports all the common actions for TikTok Ads.