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 name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | True | Custom fields are only supported on invoices. |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
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 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to allow Weld to access your Tiktok Ads account using OAuth.
Step 2 - Approve and finalize
- Approve Weld to access your Tiktok Ads account.
- When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Tiktok Ads account.
📈 Data Modelling
- Access Data Post-Sync: Once the initial synchronization is complete, your Tiktok Ads data is available for querying in the SQL editor by clicking Transform.
- Find Tiktok Ad Tables: In Transform, expand the Tiktok Ad folder under data sources to see available tables.
- Explore Table Schema: Click on a table to view its schema and understand the structure and type of data.
- Create SQL Queries: Begin a new page in Transform to start crafting your SQL queries.
- Utilize AI Assistance: For help with queries, click the icon to talk to
Ed, our AI Assistant, and input details about your querying needs.
- Save and Organize Queries: Save your refined queries in a specific folder for future reference.
📂 Table Summary
Weld supports data replication of both object and report Tiktok Ads data.
-
Objects
- Description: Objects represent the structural and operational setup of an advertising entity. This includes configurations, targeting settings, and relationships with other entities in the advertising ecosystem.
- Example:
ad_group
-
Reports
- Description: Reports focus on the performance metrics and results of the entity. They provide detailed data about how well the entity is performing on a daily basis.
- Example:
ad_group_report
Objects Overview
- Core Entities: Essential to Tiktok Ads, representing foundational data. Provides information on what the entity is and how it is set up:
- Advertiser
- Campaign
- Ad Group
- Ad
Reports Overview
- Performance Metrics: Includes detailed metrics and statistics for reporting on Ads, Ad Groups, and Campaigns. Indicate how well the entity is performing, based on various performance metrics.
- Granularity: Data availability is detailed, offered on a daily and hourly basis.
- Additional Reporting Dimensions: Reports can also be created based on Country, Language, Age, Gender, and Platform.
📊 SQL Templates
View all →Generates an ad report by joining multiple tables from the TikTok Ads integration. It retrieves data such as impressions, clicks, spend, reach, conversions, likes, comments, shares, and various video metrics for each ad group. The report also includes information about the advertiser, campaign, account, currency, gender, audience type, and budget.