---
title: "TikTok Ads to Google BigQuery Connector | OWOX"
canonical: "https://www.owox.com/connectors/free-tiktok-ads-connector-to-google-bigquery"
updated: "2026-10-28"
---

# 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.

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Connected · Ad Groups · Ad Performance · Ad Performance b… · Ads

Data Mart · Published · one definition

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Google BigQuery · Date · Cost · ClicksDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get Started Free](https://www.owox.com/app-signup)

## Endpoints

## TikTok Ads Endpoints

[Documentation](https://docs.owox.com/packages/connectors/src/sources/tik-tok-ads/readme/)

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 fields](/data-sources/tik-tok#schema-ad-groups)

*   [Ad Performance Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement. 39 fields · Time series](/data-sources/tik-tok#schema-ad-performance)

*   [Ad Performance by Country Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views. 40 fields · Time series](/data-sources/tik-tok#schema-ad-performance-by-country)

*   [Ads Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups. 46 fields](/data-sources/tik-tok#schema-ads)

*   [Advertiser Account Advertiser account — name, company, and currency. 4 fields](/data-sources/tik-tok#schema-advertiser-account)

*   [Campaigns Your campaigns — objective, type, status, budget, and schedule. 34 fields](/data-sources/tik-tok#schema-campaigns)

*   [Custom Audiences Custom audiences — type, size, validity status, and expiration. 9 fields](/data-sources/tik-tok#schema-custom-audiences)

## S00 · Why

## 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 [data warehouse](/data-storages) 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

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Video ad spend

Web analytics · Visits, sign-ups

CRM · Deals

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Your data warehouse · BigQuery · Ad · Touch point · DealJoined by id · Video watched or clicked · Deal laterOne query links the ad to the deal.

## S01 · Step 1

## Step 1: Connect TikTok Ads and pick the fields

Create a Data Mart, choose TikTok Ads as the [data source](/data-sources), 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

New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · ![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%20height%3D%2248%22%20viewBox%3D%220%200%2048%2048%22%20width%3D%2248%22%3E%0A%3Cpath%20d%3D%22M16.3343%207.52231C16.7982%206.30445%2017.4362%205.18325%2018.3834%204.2747C22.1723%200.58247%2028.4355%201.51036%2031.0065%206.14981C32.9397%209.66805%2034.9887%2013.109%2036.9798%2016.5886C40.3048%2022.3685%2043.6684%2028.1485%2046.9546%2033.9478C49.719%2038.7999%2046.7227%2044.9278%2041.2327%2045.7591C37.8691%2046.2617%2034.7181%2044.7152%2032.9783%2041.6996C30.0593%2036.6155%2027.121%2031.5314%2024.202%2026.4667C24.144%2026.3507%2024.0667%2026.2541%2023.9894%2026.1574C23.6801%2025.9061%2023.5448%2025.5388%2023.3515%2025.2102C22.0563%2022.9291%2020.7224%2020.6674%2019.4273%2018.4057C18.596%2016.9365%2017.7261%2015.4867%2016.8949%2014.0175C16.141%2012.703%2015.793%2011.2725%2015.8317%209.76471C15.8897%208.99147%2015.9863%208.21823%2016.3343%207.52231Z%22%20fill%3D%22%233C8BD9%22%2F%3E%0A%3Cpath%20d%3D%22M16.3343%207.52246C16.1603%208.21838%2016.0057%208.91429%2015.967%209.64887C15.909%2011.2727%2016.315%2012.7805%2017.1269%2014.1917C19.2533%2017.8452%2021.3797%2021.5181%2023.4868%2025.191C23.6801%2025.5196%2023.8347%2025.8483%2024.028%2026.1576C22.8682%2028.168%2021.7083%2030.1591%2020.5291%2032.1695C18.9053%2034.9725%2017.2815%2037.7948%2015.6384%2040.5978C15.5611%2040.5978%2015.5417%2040.5592%2015.5224%2040.5012C15.5031%2040.3465%2015.5611%2040.2112%2015.5997%2040.0566C16.3923%2037.1569%2015.735%2034.5859%2013.7439%2032.3822C12.5261%2031.0483%2010.9796%2030.2944%209.20114%2030.0431C6.88142%2029.7145%204.83233%2030.3137%202.99588%2031.7636C2.66726%2032.0149%202.45462%2032.3822%202.068%2032.5755C1.99067%2032.5755%201.95201%2032.5368%201.93268%2032.4788C2.86057%2030.8743%203.76913%2029.2699%204.69702%2027.6654C8.52456%2021.0155%2012.3521%2014.3656%2016.199%207.7351C16.2376%207.65778%2016.2956%207.59979%2016.3343%207.52246Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M2.01%2032.5366C2.37729%2032.2079%202.72525%2031.86%203.11187%2031.5507C7.80931%2027.8391%2014.8651%2030.5261%2015.8897%2036.4028C16.141%2037.8139%2016.0057%2039.1671%2015.5804%2040.5203C15.561%2040.6363%2015.5417%2040.7329%2015.5031%2040.8489C15.3291%2041.1582%2015.1744%2041.4868%2014.9811%2041.7961C13.2607%2044.6378%2010.7283%2046.049%207.40336%2045.8363C3.59514%2045.5657%200.598834%2042.7047%200.0768961%2038.9158C-0.174407%2037.0794%200.192882%2035.3589%201.1401%2033.7738C1.33341%2033.4258%201.56539%2033.1165%201.77803%2032.7685C1.87468%2032.6912%201.83602%2032.5366%202.01%2032.5366Z%22%20fill%3D%22%2334A852%22%2F%3E%0A%3Cpath%20d%3D%22M2.00996%2032.5363C1.93263%2032.6136%201.93263%2032.7489%201.79732%2032.7683C1.77798%2032.633%201.85531%2032.5556%201.93263%2032.459L2.00996%2032.5363Z%22%20fill%3D%22%23FABC04%22%2F%3E%0A%3Cpath%20d%3D%22M15.5031%2040.8491C15.4258%2040.7138%2015.5031%2040.6172%2015.5804%2040.5205C15.5998%2040.5398%2015.6384%2040.5785%2015.6577%2040.5978L15.5031%2040.8491Z%22%20fill%3D%22%23E1C025%22%2F%3E%0A%3C%2Fsvg%3E%0A)Google Ads · AuthorizeConnected · Endpoint · Ad Performance · Ad Groups · Ad Performance by… · Ads

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Performance · 39 fields · stat\_time\_dayspendimpressionsclicksconversionvideo\_views

## S02 · Step 2

## Step 2: Load TikTok Ads into a BigQuery table

The dataset and table in your [data storage](/data-storages) 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

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Destination · BigQuery · Dataset · tiktok\_ads · Table · ad\_insights · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)Table · tiktok\_ads.ad\_insights

## S03 · Step 3

## Step 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 [data quality](/product/data-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

![](https://cdn.owox.com/www/webflow/679a01994def1d262136d80a_431.svg/public)tiktok\_ads.ad\_insights · Output schema · Field · Descriptionstat\_time\_day · Statistics Date · spend · Spend · impressions · Impressions · clicks · Clicks · conversion · Conversions · video\_views · Video Views

## S04 · Step 4

## Step 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 [data model](/product/data-modeling).

*   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

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Campaigns · campaign\_id · campaign\_name · objective

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Groups · adgroup\_id · adgroup\_name · optimization\_goal

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ads · ad\_id · campaign\_id · adgroup\_id

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)Ad Performance · ad\_id · spend

## S05 · Step 5

## Step 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

Schedule · Run on a schedule · Daily 09:00

Backfill · Run backfill

Run History · Daily schedule · Manual backfill · Daily schedule

## S06 · Step 6

## Step 6: Reuse the same table everywhere

One table feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-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

![](https://cdn.owox.com/www/webflow/679a0198bca4d1f7b294fed5_34.svg/public)TikTok Ads · Data Mart · Published

Blended ad spend

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets

![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards

![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT

![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email

## Related connectors

[TikTok Ads to Claude](/connectors/tiktok-ads-connector-to-claude)[Facebook Ads to Google BigQuery](/connectors/free-facebook-ads-connector-to-google-bigquery)[Google Ads to Google BigQuery](/connectors/free-google-ads-connector-to-google-bigquery)[TikTok Ads to ChatGPT](/connectors/tiktok-ads-connector-to-chatgpt)[Microsoft Ads to Google BigQuery](/connectors/free-microsoft-ads-connector-to-google-bigquery)[Bank of Canada to Google BigQuery](/connectors/bank-of-canada-connector-to-google-bigquery)[Criteo Ads to Google BigQuery](/connectors/free-criteo-ads-connector-to-google-bigquery)[LinkedIn Ads to Google BigQuery](/connectors/free-linkedin-ads-connector-to-google-bigquery)[LinkedIn Pages to Google BigQuery](/connectors/free-linkedin-pages-connector-to-google-bigquery) · Show 6 more · Show fewer

## Recent updates

*   [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)
*   [0.41.0 · Shared SQL logic stays in one place: build a Data Mart on top of another](https://docs.owox.com/docs/changelog/#shared-sql-logic-stays-in-one-place-build-a-data-mart-on-top-of-another-0410)
*   [0.41.0 · Rotating a connector key is one change: Sources share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-connector-key-is-one-change-sources-share-reusable-credentials-0410)
*   [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog/#connecting-a-plan-from-google-sheets-takes-fewer-guesses-0400)

## Why OWOX

## 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.

[Book a call](/book-a-call)

[Get Started Free](https://www.owox.com/app-signup)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get Started Free](https://www.owox.com/app-signup)
- [Documentation](https://docs.owox.com/packages/connectors/src/sources/tik-tok-ads/readme)
- [Ad GroupsAd groups within your campaigns — bid strategy, optimization goal, placement, and targeting…](https://www.owox.com/data-sources/tik-tok) — /data-sources/tik-tok.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md
- [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [TikTok Ads to Claude](https://www.owox.com/connectors/tiktok-ads-connector-to-claude) — /connectors/tiktok-ads-connector-to-claude.md
- [Facebook Ads to Google BigQuery](https://www.owox.com/connectors/free-facebook-ads-connector-to-google-bigquery) — /connectors/free-facebook-ads-connector-to-google-bigquery.md
- [Google Ads to Google BigQuery](https://www.owox.com/connectors/free-google-ads-connector-to-google-bigquery) — /connectors/free-google-ads-connector-to-google-bigquery.md
- [TikTok Ads to ChatGPT](https://www.owox.com/connectors/tiktok-ads-connector-to-chatgpt) — /connectors/tiktok-ads-connector-to-chatgpt.md
- [Microsoft Ads to Google BigQuery](https://www.owox.com/connectors/free-microsoft-ads-connector-to-google-bigquery) — /connectors/free-microsoft-ads-connector-to-google-bigquery.md
- [Bank of Canada to Google BigQuery](https://www.owox.com/connectors/bank-of-canada-connector-to-google-bigquery) — /connectors/bank-of-canada-connector-to-google-bigquery.md
- [Criteo Ads to Google BigQuery](https://www.owox.com/connectors/free-criteo-ads-connector-to-google-bigquery) — /connectors/free-criteo-ads-connector-to-google-bigquery.md
- [LinkedIn Ads to Google BigQuery](https://www.owox.com/connectors/free-linkedin-ads-connector-to-google-bigquery) — /connectors/free-linkedin-ads-connector-to-google-bigquery.md
- [LinkedIn Pages to Google BigQuery](https://www.owox.com/connectors/free-linkedin-pages-connector-to-google-bigquery) — /connectors/free-linkedin-pages-connector-to-google-bigquery.md
- [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md