TikTok Ads to BigQuery: free connector and setup guide

Ways to export TikTok Ads to BigQuery

The file route is fine for one question. It breaks down the first time someone asks for the same report next week, with yesterday included. If you do go that way, how to upload data to BigQuery covers the upload.

What you get in BigQuery

The connector writes each endpoint to its own table, one Data Mart per endpoint. Names and descriptions are from the connector’s documentation, checked in October 2026.

The data is raw. OWOX Data Marts does not transform it; currency conversion, channel grouping and joins to your other sources are SQL you write on top.

If you only need spend and results by day, start with ad_insights. Add campaigns and ad groups when you need names and settings next to the numbers.

Choose the data level before the first run

The two performance tables have a Data Level setting that decides the grain of each row:

Pick it once. The documentation is explicit: do not change the data level after a run has loaded data into a table, because new rows would merge on a different key.

What you need

• A TikTok for Business account with access to the advertiser accounts you want to load.
• A Google Cloud project with BigQuery, and an account with the BigQuery Data Editor and BigQuery Job User roles.
• An OWOX Data Marts project: OWOX Cloud, or the open-source edition on your own machine.

Set up on OWOX Cloud

Step 1: connect BigQuery

Open Storages, click New Storage and choose Google BigQuery. Enter the project ID and the data location, then authenticate with your Google account through OAuth or with a service account key. The storage guide lists each field.

Step 2: create the Data Mart

Click New Data Mart, give it a title such as “TikTok Ads”, and choose the storage you just added.

On the Data Setup tab, set the definition type to Connector, click Setup Connector and choose TikTok Ads.

Step 3: sign in to TikTok

The connector setup has five steps. On the settings step, click Continue with TikTok, log in with a TikTok account that has advertiser access, and approve the advertiser accounts the connector may read. That is the whole authentication. There is no token to copy and no app to register.

Then fill in:

• Advertiser IDs: the accounts to load.
• Data Level: the grain of the performance tables, as described above. AUCTION_AD is the default.

The rest sits under Advanced settings and is optional for a first run.

Step 4: choose the data and the fields

Choose what to load. Each Data Mart loads one endpoint into one table, so create a Data Mart per endpoint you need.

Select the fields. The key fields for the chosen data level are ticked and locked, so rows merge correctly; take the metrics you will report on and add others later.

Enter the Dataset name and the Table name. Both are created on the first run if they do not exist.

Click Save in the panel, Save on the Data Setup tab, then Publish Data Mart.

Step 5: load history

Open Manual Run and choose Backfill for the first load, with a start and an end date.

A backfill covers up to 31 days per run, so load a long history in several runs. When the run finishes, Run History shows its status.

Step 6: schedule the daily load

On the Triggers tab, click Add Trigger, choose the Connector Run type and a schedule: daily, weekly, monthly or at an interval, with the time and time zone.

From here the tables update themselves. Each run upserts on the table’s unique keys, so re-running a day replaces its rows instead of duplicating them.

Set up self-hosted

The connector and OWOX Data Marts are open source. If your data may not pass through a hosted service, run it yourself. Only two things differ from the steps above.

Install and start it. Install the LTS version of Node.js, install the OWOX CLI and run owox serve. The quick start has the commands. The interface opens in your browser on your own machine.

Authenticate with your own TikTok app, if the sign-in button is not there. Continue with TikTok appears only where TikTok OAuth has been configured. Without it, the connector asks for an Access Token, an App ID and an App Secret from a TikTok developer app. The credentials guide gives the full procedure:

1. Register at the TikTok for Business Developers portal and create an app. Describe your use clearly; approval can take up to seven business days.

2. When the app is approved, open its page for the App ID, the secret and the advertiser authorization URL.

3. Open the authorization URL, approve access, and copy the auth_code from the redirect. It is valid for one hour and one use.
4. Exchange it for an access token with a POST request to https://business-api.tiktok.com/open_api/v1.3/oauth2/access_token/, sending app_id, secret and auth_code. The response contains the access_token and the advertiser_ids it can read.

5. Paste the token, App ID and App Secret into the connector settings.

TikTok’s long-term access tokens do not expire. Treat the token and the secret like a password: anyone holding them can read the account.

TikTok Ads to other warehouses: Redshift, Snowflake, Databricks, Athena

BigQuery is one of five destinations. According to the connector’s documentation (checked October 2026), the same TikTok Ads connector lands raw data in Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks. The steps above do not change; only the storage you add in Step 1 does.

So “connect TikTok Ads to Redshift” or “export TikTok Ads to Snowflake” is this same Data Mart pointed at a different storage.

From the warehouse to reports: Google Sheets, Data Studio, Power BI, Excel

Once TikTok Ads data is in your warehouse, every reporting tool reads it from there, not from TikTok:

• Google Sheets and Data Studio (formerly Looker Studio): build a Data Mart on the loaded tables and deliver it as a report through a Google Sheets or Data Studio destination in OWOX Data Marts. The Sheets route is described step by step in how to connect BigQuery to Google Sheets. There is also a TikTok Ads to Google Sheets guide.
• Power BI, Tableau, Qlik and Excel: connect them to the warehouse with their own connectors and read the TikTok tables, or better, one Data Mart that joins TikTok spend to your other channels.

Going through the warehouse means TikTok numbers sit next to Facebook, Google Ads and revenue in one place, and every tool reads the same rows. A first query on the loaded table:

SELECT
  stat_time_day,
  SUM(spend) AS spend,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks
FROM `your-project.your_dataset.tiktok_ads_ad_insights`
GROUP BY stat_time_day
ORDER BY stat_time_day;

This statement was not run for this guide: it needs a TikTok account with spend. The column names are the TikTok Marketing API’s, as the connector loads them.

What about TikTok organic data?

This connector reads the TikTok Ads (Marketing) API: advertiser, campaigns, ad groups, ads, ad performance and custom audiences. It does not import organic data such as posts, followers or profile views, so “TikTok organic to BigQuery” is not covered by it. TikTok Shop and GMV data are not covered either. If you need those, check the full list of data sources, or request a source on GitHub.

Troubleshooting

• Authentication fails. On OWOX Cloud, sign in again with an account that has access to the advertiser. With your own app, check that the token was generated for the right app and advertiser.
• A table is empty. Check the advertiser ID, the date range of the run, and whether TikTok has data for those days.
• Numbers doubled after a change. The data level was changed after the first load. Load into a new table at the new level.
• Rate limits. Run less often, or split a long backfill into shorter runs. TikTok’s limits vary by app and permission level.

The connector’s troubleshooting page covers import and permission errors in more detail.

More connectors

The same steps work for other ad platforms: Facebook Ads, LinkedIn Ads, Microsoft Ads, X Ads and Reddit Ads. With two or more loaded, one SQL Data Mart can union them into a single spend table. The code is on GitHub.

Data IntegrationHow to connect Facebook Ads to Google Sheets with OWOX Data MartsSeptember 30, 2026→Google BigQueryHow to connect BigQuery to Google Sheets: three waysOctober 6, 2026→Data IntegrationCRM and digital marketing data integration: a practical guideSeptember 30, 2026→

See all articles →