Load TikTok Ads data into Databricks
Send TikTok Ads campaigns, ad groups, ads and daily performance to Databricks with OWOX Data Marts: one table per endpoint, readable descriptions, a scheduled refresh. Join them with web analytics and CRM to see which videos led to deals.
TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
DatabricksDateCostClicksDaily 09:00TikTok Ads Endpoints
7 TikTok Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Groups
Ad groups within your campaigns — bid strategy, optimization goal, placement, and targeting schedule.
45 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement.
39 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views.
40 fieldsTime seriesAds
Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups.
48 fieldsAdvertiser Account
Advertiser account — name, company, and currency.
4 fieldsCampaigns
Your campaigns — objective, type, status, budget, and schedule.
34 fieldsCustom Audiences
Custom audiences — type, size, validity status, and expiration.
9 fields
Why join TikTok Ads with web analytics and CRM in Databricks
TikTok Ads Manager shows spend, video views and the conversions TikTok counted. The purchase made later on your site lives elsewhere. Join spend, website touch points and CRM deals in one warehouse to connect the two.
- Put TikTok spend beside Facebook, Google and Microsoft Ads
- Follow video views and clicks to the visits and deals after them
- Keep video and engagement metrics next to cost in your tables
TikTok AdsVideo ad spendYour data warehouseAdTouch pointDealJoined by idVideo watched or clickedDeal laterOne query links the ad to the deal.Step 1: Connect TikTok Ads and choose what to load
Create a Data Mart, choose TikTok Ads as the source, continue with TikTok or add an access token, list your advertiser ids and tick only the fields you need.
- 7 endpoints and 217 fields to choose from
- Ad Performance alone has 39 fields: spend, clicks, conversions, video views, likes, shares
- Choose a data level for performance: ad, ad group, campaign or advertiser
Google AdsTikTok Ads
Reddit AdsAuthorizeConnectedEndpointAd PerformanceAd GroupsAd Performance by…AdsAd Performancestat_time_dayspendimpressionsclicksconversionvideo_viewsStep 2: Load TikTok Ads into Databricks tables
The catalog defaults to main, and the schema and table are pre-filled; change any of them. Run it and the first load, from the start of the previous month through today, lands in your own Databricks workspace.
- Performance goes to a table such as tiktok_ads_ad_insights
- Several advertiser ids load into one table
DestinationCatalogmainSchematiktok_adsTablead_insightsRunTablemain.tiktok_ads.ad_insightsStep 3: Open the output schema in plain words
The first run gives you the output schema: every field with an alias and a readable description, not an API identifier. Your quality checks can read it too.
- Video completion and engagement fields such as follows and profile visits are described in plain words
- Teammates can query the table without the API reference
main.tiktok_ads.ad_insightsOutput schemaFieldDescriptionstat_time_dayStatistics DatespendSpendimpressionsImpressionsclicksClicksconversionConversionsvideo_viewsVideo ViewsStep 4: Keep the TikTok Ads tables linked
Campaigns, ad groups, ads and performance stay separate tables, joined by ids. In SQL they become one TikTok Ads model.
- campaign_id, adgroup_id and ad_id repeat down the levels
- Pick the data level before the first load; to change it, start a new Data Mart or table
Campaignscampaign_idcampaign_nameobjectiveAd Groupsadgroup_idadgroup_nameoptimization_goalAdsad_idcampaign_idadgroup_idAd Performancead_idspendStep 5: Refresh on a schedule and backfill the history
Set it once. A scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice.
- A lookback window, 2 days by default, reloads recent days on each run
- Backfills longer than 31 days run in consecutive segments
Step 6: Reuse the Databricks tables in every tool
One set of tables feeds your model, , , assistants like Claude and ChatGPT and AI insights in Slack or email.
- Rank videos by cost and conversions in one view
- Every report reads the same table
TikTok AdsData MartPublished
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.43.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
- 0.41.0Dates from Google Sheets arrive as dates, not text
Why OWOX for TikTok Ads in Databricks
Databricks has connectors of its own, and plain API notebooks get TikTok data in too. OWOX adds control over the grain and how it reads.
- You own the data. It lands in your own Databricks workspace, in tables you control.
- Your grain, your table. Choose ad, ad group, campaign or advertiser level, and load a country breakdown as its own table.
- Described columns. Video completion and engagement fields such as follows and profile visits carry plain-word descriptions.
- Joined by campaign, ad group and ad ids. The tables arrive ready to meet web analytics and CRM in SQL.
- Maintained for you. No jobs to repair when TikTok changes its API.
- Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.