TikTok Ads

TikTok Ads reports advertising statistics at the level of individual ads. You assemble the report yourself from dimensions and metrics: spend and cost metrics, impressions and clicks, conversions and results, video views by watch depth, paid engagement events, and Instant Experience statistics. Renta exports this report to your data warehouse.

A second report type, Account metadata, loads the profile of every connected ad account: name, status, balance, currency, timezone, and contact details.

Authentication

Renta uses OAuth to authenticate with TikTok Ads. You will be redirected to TikTok for Business to grant Renta limited access to your ad accounts.

Pipeline configuration

On the final step, choose which TikTok Ads data to export and how Renta loads it.

Report configuration

Point the pipeline at the ad accounts you need.

1. Ad accounts.
   Choose one or several TikTok Ads accounts to export data from. The list shows the ad accounts available to the authorized TikTok for Business user. Renta loads rows from every selected account into the same destination table.
2. Report Types.
   Choose what the pipeline exports.

Parameters

Select the TikTok Ads fields to include in the destination table. The parameters you choose here define the table schema.

On the Dimensions tab, check the fields that describe the ad behind each row: Date, advertiser id and name, campaign id, name, budget and objective, ad group id, name and budget, ad id, placement type, promotion type, and optimization goal.

On the Metrics tab, check the figures to export: spend, CPC, CPM and CPA, impressions and clicks, reach and frequency, conversions and results together with their real-time variants, video views by watch depth, paid followers, likes, comments and shares, profile visits, clicks on the music disc, Duet and Stitch buttons, Instant Experience statistics, and playlist visits.

Whichever dimensions you pick, the statistics stay at the level of individual ads. Fields such as campaign or ad group name describe the objects the ad belongs to.

For the Account metadata report the picker contains only dimensions: account name and status, balance and currency, timezone, country, company and contact details, and business license attributes. The destination table gets one row per selected ad account.

Table name

Name the pipeline and the destination table.

1. Integration name.
   The name of the pipeline. It is used exclusively in the Renta interface.
2. Table name.
   The destination table name. You can keep the auto-generated name or enter your own.

Date range

Set the historical period to load.

1. Date start.
   The first date of the extraction period.
2. Date end.
   The last date of the extraction period. Leave it as Today to keep collecting new data on every run.

TikTok Ads builds each report asynchronously. Renta creates a report task, waits until TikTok finishes it, and downloads the result. Requests are split into windows of up to 30 days per ad account, so a wide historical range takes longer to load than a few days.

Overwrite period

The overwrite period defines how many recent days Renta reloads on every run.

On each run, Renta re-fetches the report starting from the date of the last successful run minus the overwrite period. The affected days are deleted from the destination table and inserted again, while older data stays untouched. The options range from Without overwrite data to Overwrite all data. The default is Last 3 days.

Schedule

Choose how often the pipeline runs.

For Daily schedules, set the Update time, the exact time each run starts, then click Create pipeline.

The new pipeline appears in the Pipelines section under the ETL tab, where you can track its runs, progress, and the destination table name.

Sync strategy

The synchronization strategy depends on the report type and on whether the report includes the Date dimension.