Tiktok Ads Connector
Start moving your Tiktok Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.
View more about the Tiktok Ads connector in the Weld documentation
Explore available Tiktok Ads data
Browse all the data tables available for the Tiktok Ads connector, in our interactive ERD data viewer.
View the Tiktok Ads Data SchemaTransform and model Tiktok Ads data
Get clean data models from your Tiktok Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.
Tiktok Ads
raw.tiktok_ads.table1
raw.tiktok_ads.table2
Get started with Tiktok Ads SQL Templates
Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Tiktok Ads.
Account Report
Generates an account report for the TikTok Ads integration. It retrieves data from the `ad_daily_report`, `advertiser`, and `ad` tables, and joins them based on specific conditions. The resulting report includes aggregated metrics such as impressions, clicks, spend, reach, conversion, likes, comments, shares, profile visits, follows, video watched durations, and video view percentages.
Ad Group Report
Generates an ad group report for the TikTok Ads integration. It retrieves data from various tables such as ad_group_daily_report, ad_group, advertiser, and campaign. The report includes metrics like impressions, clicks, spend, reach, conversion, and engagement metrics such as likes, comments, and shares. The data is grouped by date, account, campaign, and ad group.
Campaign Report
Generates a campaign report for the TikTok Ads integration. It retrieves data from the `campaign_daily_report`, `campaign`, and `advertiser` tables. The report includes metrics such as clicks, impressions, spend, reach, conversions, likes, comments, shares, profile visits, follows, video views, and various calculated metrics like CPC, CTR, and CPM. The data is grouped by date, account ID, account name, campaign ID, and campaign name.
Ad Report
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.
View all Tiktok Ads templatesTikTok Ads is an advertising platform that allows brands to connect with a younger, highly-engaged audience through short-form video content.
Here are four popular data analytics use cases with data derived from TikTok Ads:
- Engagement Analysis for Video Content:On a platform where content virality is king, understanding what resonates with viewers is crucial. By analyzing metrics like view duration, share count, and engagement rate, marketers can gauge which content themes or styles captivate their target audience, informing future creative decisions.
- Audience Segmentation and Targeting:TikTok Ads provides detailed demographic and behavioral data about the users engaging with ads. Marketers can segment their audience based on age, interests, location, and more. This data-driven approach ensures that ads are tailored to, and resonate with, the intended audience, maximizing engagement and conversions.
- Ad Format Performance Evaluation:TikTok offers various ad formats, from in-feed videos to branded effects. By analyzing performance data for each format, marketers can determine which one delivers the best ROI, allowing for more informed budget allocation in future campaigns.
- Conversion Tracking and Retargeting:TikTok's Pixel allows advertisers to track user actions after interacting with an ad, from website visits to purchases. This data helps marketers measure the direct impact of their campaigns on sales and other desired actions. Additionally, insights into users who engaged with an ad but didn't convert can inform retargeting strategies, aiming to nurture these potential customers further down the sales funnel.
By leveraging the insights provided by TikTok Ads, businesses have the opportunity to craft compelling, data-driven campaigns that resonate with the platform's unique audience, optimizing for both reach and conversion.
Start working with your Tiktok Ads data today
Get started building your data warehouse with Tiktok Ads and 150+ more apps and database connectors available.
