Connect TikTok Ads to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Everything TikTok Ads exposes, modeled and queryable.
Extracts TikTok Ads account entities (advertisers, campaigns, ad groups, and ads) and rich daily performance metrics at the ad and campaign levels. Enables analysis of spend, delivery, clicks, CTR, reach, conversions, attribution (VTA/CTA), video performance (views and quartiles), engagement (likes, comments, shares), web page events (add to cart, checkout, purchase), and in‑app events, supporting time-series reporting and optimization across campaigns and creatives.
Tables & streams
Represents a TikTok Ads account with business identity, timezone/currency, billing balance, and status; used for account-level rollups, pacing, and cross-account comparisons.
Top-level marketing objective and budget container for ad groups and ads; enables analysis of spend, delivery, ROI, budget pacing, and lifecycle performance by objective or status.
Targeting and delivery configuration layer (audience, placement, schedule, bid/optimization) that organizes ads; supports analysis of targeting strategy effectiveness and delivery constraints.
Individual creative units and settings (names, media assets, landing pages, identities) that serve impressions; enables creative performance analysis such as CTR, engagement, views, and conversions.
Time-series fact table of ad and campaign results by day (spend, impressions, clicks, CTR, reach, conversions, video views, engagement, and attribution events) used for KPI tracking, ROAS, and optimization.
Uses a TikTok Ads API access token from your TikTok Marketing API app to authenticate
Requires a TikTok Ads account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate TikTok Ads in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your TikTok Ads data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
