BigQuery Connector

Sync TikTok Organic Data to BigQuery

Detrics loads TikTok Organic 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
  video_title,
  SUM(video_views) AS video_views,
  SUM(video_likes) AS video_likes,
  SUM(video_comments) AS video_comments
FROM `your_project.marketing_data.tiktok_organic_monthly_video_summary_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY video_title
ORDER BY video_views DESC
LIMIT 10

Why send TikTok Organic data to BigQuery?

Audience evolution

Store daily snapshots of followers and engagement to measure real long-term growth.

History without limits

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

One warehouse for everything

Join TikTok Organic 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 Organic in plain language.

TikTok Organic tables in BigQuery

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

Profile Analytics

profile_snapshot

Account followers and video stats

usernamedisplay namefollower countfollowing counttotal likes receivedtotal video count

profile_overview

Account-level profile stats snapshot

usernamedisplay namefollower countfollowing counttotal likes receivedtotal video count

monthly_video_summary_daily

Video engagement aggregated by month

video titlevideo viewsvideo likesvideo commentsvideo shares

Video Performance

video_engagement

Recent video performance with engagement

video titlecreate dateshare URLvideo viewsvideo likesvideo comments+1

video_performance

All videos with engagement metrics

video titlecreate dateshare URLvideo viewsvideo likesvideo comments+1

video_details

Complete video metadata with duration and links

video IDvideo titlevideo descriptionvideo viewsvideo likesvideo comments+5

+1 more table in this group

HOW IT WORKS

From TikTok Organic 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 Organic in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Engagement dropped this month on TikTok Organic. Show me where.

How did my TikTok Organic audience grow this month?

Which TikTok Organic posts got the most engagement?

Explore the TikTok Organic MCP server

Every TikTok Organic 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

10 metrics

15 dimensions

View TikTok Organic Fields

Get TikTok Organic into your warehouse this week