Tiktok Ads

TikTok Ads is the advertising platform offered by TikTok, a popular short-form video social media platform. It allows businesses and advertisers to create and manage ad campaigns to reach TikTok's vast and engaged user base.

Features

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataTrueCustom fields are only supported on invoices.
HistoryFalse
ReSyncTrueTable level
TemplatesTrue

Data Schema

Open full-page schema explorer

In the table gmv_max_creatives_daily_detailed_report the creative_id can have a value of -1. This is because the product card doesn't have an item ID. When shop_content_type is PRODUCT_CARD, the value of this metric will be -1.

Setup Guide

Step 1 - Create the connection

  1. In Weld, click Data Sources in the sidebar, then Add Data Source, and choose TikTok Ads. If the account is already connected, choose Use existing connection and go to Step 2.
  2. Check the connection Name (1). It's filled in for you, and you can change it.
  3. Click Authorize (3) and sign in to TikTok. Approve Weld's access, and you're taken back to the setup.

If someone else owns the TikTok account, for example a client, click Share Authorization Link (2) instead and send them the link. They sign in and grant access without a Weld login. See Authorization links.

Step 2 - Connection Settings

Weld syncs every advertiser account the TikTok user you signed in with can access. On Connection Settings, set:

  • Fetch deleted ads: include deleted ads, ad groups and campaigns in the reports.
  • GMV Max report exclude inactive creatives: leave inactive creatives out of the GMV Max creatives report.
  • Start of the week for weekly reports: Sunday, the default, or Monday.
  • Limit historical data: sync only data after a date you choose. Leave it empty to sync all the history the API offers.

Click Next.

Step 3 - Data to sync

Tick the tables you want. Each table shows whether it syncs in full or incrementally, and you can expand it to remove or hash columns. See Tables below for what each kind holds.

Step 4 - Configure sync

Choose how often to sync, check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.

Query your data

When the first sync finishes, the tables are in your warehouse under the destination schema. In Transform, find them under Data Sources in the sidebar, then write a model on top of them or ask Ed to write one. See Data models.

Tables

Objects. How your account is set up:

  • advertiser, campaign, ad_group, ad
  • gmv_max_campaign

Performance reports. For campaigns, ad groups and ads, by hour, day, week and month, for example campaign_daily_report, ad_group_weekly_report or ad_hourly_report. Weekly reports start on the day set in Start of the week for weekly reports.

Audience reports:

  • By age and gender: campaign_age_gender_report, ad_age_gender_report
  • By country: campaign_country_report, ad_country_report, country_report_weekly, country_report_monthly
  • By language: campaign_language_report, ad_language_report
  • By platform: campaign_platform_report

GMV Max reports:

  • gmv_max_campaign_daily_detailed_report, gmv_max_creatives_daily_detailed_report

gmv_max_campaign_daily_report and gmv_max_campaign_advertiser_daily_report are being retired, because TikTok is retiring the report behind them and no longer returns net cost for it. Use gmv_max_campaign_daily_detailed_report instead. It has more metrics and a breakdown by store, but no country breakdown.

SQL Templates

View all →

Was this page helpful?