BigQuery Connector

Sync TikTok Ads Data to BigQuery

Detrics loads TikTok Ads into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  campaign_name,
  SUM(spend) AS spend,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks
FROM `your_project.marketing_data.tiktok_ads_ad_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY spend DESC
LIMIT 10

Why send TikTok Ads data to BigQuery?

Ad creatives that never expire

Creative URLs expire. Detrics archives your campaign images and videos permanently.

History without limits

Platform APIs cap how far back you can query. In BigQuery every TikTok Ads sync is stored across its 15 tables, so you accumulate years of your own history.

One warehouse for everything

Join TikTok Ads with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about TikTok Ads in plain language.

TikTok Ads tables in BigQuery

This is what Detrics creates for TikTok Ads: 15 preset tables with scheduled syncs, plus any custom one you define.

Campaign Performance

ad_performance_daily

Daily ad performance with creative insights

advertiser namecampaign namead namespendimpressionsclicks+11

campaign_performance_daily

Campaign-level performance with objectives

advertiser namecampaign namecampaign objective typespendimpressionsclicks+6

account_overview_daily

Account-level performance overview

advertiser namespendimpressionsclicksCTRCPC+2

+4 more tables in this group

Conversions & E-commerce

mobile_app_install_performance_daily

Mobile app install and retention tracking

advertiser namecampaign namespendapp installcost per app installregistration+7

conversion_tracking_daily

Conversion funnel and ROI tracking

advertiser namecampaign namespendconversioncost per conversionconversion rate v2+5

e_commerce_performance_daily

E-commerce funnel and revenue tracking

advertiser namecampaign namespendpurchasecost per purchasetotal purchase+5

Creative & Audience

video_engagement_analysis_daily

Video engagement and retention metrics

campaign namead namevideo play actionsvideo views p25video views p50video views p75+6

country_analysis

Performance by geographic location

campaign namecountry codespendimpressionsclicksCTR+2

gender_analysis

Performance segmented by gender

campaign namegenderspendimpressionsclicksCTR+2

+2 more tables in this group

HOW IT WORKS

From TikTok Ads to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With TikTok Ads in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

My TikTok Ads CPA jumped last week. Find out where.

Build a weekly TikTok Ads report for my client meeting

Detect anomalies in my TikTok Ads spend over the past 14 days

Explore the TikTok Ads MCP server

Every TikTok Ads field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

711 metrics

80 dimensions

View TikTok Ads Fields

Get TikTok Ads into your warehouse this week