Collect TikTok Ads data in Google BigQuery
Load TikTok Ads campaigns, ad groups, ads and daily performance into your own BigQuery tables with OWOX Data Marts: one table per endpoint, a business-friendly schema, refreshed on a schedule. Join it with web analytics and CRM to see which videos lead to deals.
TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
Google BigQueryDateCostClicksDaily 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.
46 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 your web analytics and CRM
TikTok Ads Manager shows spend, video views and the conversions TikTok counted. A video watched on TikTok and a purchase made later on your site live in different systems. Spend, website touch points and CRM deals have to sit in one warehouse to connect them.
- Compare TikTok spend with Facebook, Google and Microsoft in one table
- Connect video views and clicks to the visits and deals that followed
- Keep video and engagement metrics beside cost in your own 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 pick the fields
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
Facebook AdsTikTok Ads
Google AdsAuthorizeConnectedEndpointAd PerformanceAd GroupsAd Performance by…AdsAd Performancestat_time_dayspendimpressionsclicksconversionvideo_viewsStep 2: Load TikTok Ads into a BigQuery table
The dataset and table in your storage are pre-filled, and you can change them. Run it and the first load, from the start of the previous month through today, lands in your own BigQuery project.
- Performance goes to a table such as tiktok_ads_ad_insights
- Several advertiser ids load into one table
DestinationDatasettiktok_adsTablead_insightsRunTabletiktok_ads.ad_insightsStep 3: Get a business-friendly output schema
After the first run you get the output schema: every field with 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
- Anyone on the team can read the table
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. Together 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: Schedule the refresh and backfill history
Set it once. A scheduled refresh keeps the tables current, and a manual backfill loads any past period.
- 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 same table everywhere
One table feeds your model, , , assistants like Claude and ChatGPT, and scheduled 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.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
- 0.41.0Dates from Google Sheets arrive as dates, not text
- 0.41.0Shared SQL logic stays in one place: build a Data Mart on top of another
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.40.0Connecting a plan from Google Sheets takes fewer guesses
Why OWOX for TikTok Ads in BigQuery
Hand-built API scripts, a generic ETL tool or manual exports each get TikTok data out. OWOX also keeps it yours, readable and ready to model.
- You own the data. It lands in your own BigQuery project, in tables you control.
- Your grain, your table. Choose ad, ad group, campaign or advertiser level, and add a country breakdown as its own table.
- Ready for a data model. Separate tables joined by campaign, ad group and ad ids, built to connect to web analytics and CRM.
- Maintained for you. No scripts to fix 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.