Free TikTok Ads to BigQuery Connector by OWOX: Complete Campaign Insights Without Manual Exports

Running TikTok campaigns is easy. But syncing TikTok Ads to BigQuery for scalable reporting? That’s where it gets complicated. From limited APIs and nested JSON to rate limits and expensive ETL platforms, the data pipeline often becomes the bottleneck.

‍

That’s why we built a free, no-code connector to send TikTok Ads data to BigQuery, which is fast, reliable, and fully analyst-friendly. You control the data. And when needed, you can even sync data from BigQuery to TikTok for advanced workflows.

At OWOX, we believe analysts shouldn’t have to rent access to the data they generate. That’s why our TikTok Ads to BigQuery connector from OWOX Data Marts is 100% free – no paywalls, no restrictions, no surprises.

Built for data teams, this tool removes black-box barriers so you can send TikTok Ads to BigQuery on your terms. You gain full transparency, flexible configuration, and the freedom to sync data from TikTok to BigQuery if needed.

Whether you're managing performance metrics, campaign analytics, or reporting systems, this connector gives you the control you’ve been missing.

Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of data and marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further. 

Why Bring TikTok Ads Data into BigQuery?

Managing TikTok ad performance across campaigns can get messy, especially when you’re stuck downloading raw CSVs or navigating TikTok’s limited reporting UI. For analysts who need scalable, structured access to campaign metrics, this free TikTok to BigQuery connector changes everything.

Here’s why it’s a must-have for data teams:

✅ Automatically load TikTok Ads to BigQuery – no manual steps or third-party ETL required
✅ No-code setup with a simple, open-source spreadsheet template
✅ Full-funnel data access: impressions, clicks, CTR, video engagement, conversions, and more
✅ Schedule recurring imports and incremental updates
✅ Pull granular data across campaigns, ad groups, creatives, and audiences

Stop wrestling with exports. With this TikTok Ads to BigQuery integration, your data is clean, complete, and ready for advanced analysis – right where you need it.

Explore our other free connectors
Liking the freedom of custom reports? Take it further with these plug-and-play integrations:

TikTok Ads → Google Sheets
Facebook Ads → BigQuery
Twitter Ads → BigQuery
Reddit Ads → BigQuery

No fees, no code—only faster, smarter reporting across every ad channel.

Why Choose OWOX Free Connector for TikTok Ads to BigQuery

For analysts managing TikTok Ads at scale, OWOX offers a connector built on OWOX Data Marts that’s fully transparent and designed for control, not constraints.

• Zero-cost and open-source: Unlike usage-priced tools, this connector is available free on GitHub as part of OWOX Data Marts. You can review, customize, and run it on your own terms.
  
  
• Direct BigQuery write: Data flows straight from the TikTok Ads API into your BigQuery project – no CSVs, no staging layers, and no 3rd-party services in between.
  
  
• Schema flexibility: Define your destination table schema, set up field aliases for clarity, and adapt the structure to match your reporting needs.
  
  
• Refresh control: Automate data loads using scheduled jobs and keep your dataset updated when you need it – whether you want to append new rows or overwrite existing tables.

How the Connector Works

Built for modern data stacks, this connector puts your team in charge of how TikTok Ads data lands in BigQuery, enabling better joins, modeling, and analysis. 

This TikTok Ads to BigQuery connector from OWOX Data Marts delivers what most tools don’t – full control without the complexity.

It’s built on an open-source framework you run yourself, so there’s no need for extra platforms, paid ETL services, or CSV workarounds.

Here’s how it works:

• Connects directly to the TikTok Ads API to fetch campaign, ad group, creative, and performance data.
• Sends that data straight into your BigQuery tables – with no intermediate storage or black-box logic.
• Lets you define your own schema, set up field aliases, and automate refreshes on your schedule.

If you're tired of overpriced connectors and want to manage TikTok Ads reporting inside BigQuery with full transparency, this tool is built for you.

What You Can Do With This Connector

This free connector gives you powerful, flexible access to your TikTok data in BigQuery – without the manual hassle or expensive tools. Whether you're managing campaigns, optimizing creatives, or building warehouse-ready reports, this connector puts everything you need right at your fingertips.

Key Features

• Import account-level data from your TikTok Business account, including advertiser info, balances, and currency.
• Access full campaign structures – campaigns, ad groups, and individual ads – with all relevant settings and targeting.
• Track performance metrics like impressions, clicks, CTR, video views, spend, conversions, and more.
• Work with custom audiences to analyze targeting, sizes, types, and expiration dates for remarketing strategies.
• Schedule automated refreshes - to keep your datasets up to date without manual effort.
• Use incremental loading to pull only new or changed data, reducing load time and optimizing performance.
• Manage your data lifecycle in BigQuery with overwrite or append options to keep tables accurate and efficient.

Data Types You Can Import

This connector supports the full spectrum of TikTok Ads data, including:

1. Advertiser Information: Basic details, balance data, and account-level metadata.
2. Campaigns: Budget info, targeting options, performance settings, and statuses.
3. Ad Groups: Bid settings, placements, targeting filters, and group-level controls.
4. Ads: Creative data, CTAs, status, URLs, and landing pages.
5. Performance Metrics: All the KPIs you care about: clicks, conversions, views, engagement, and advanced video metrics,  including support for TikTok organic data to Google Sheets.
6. Custom Audiences: Insights into size, type, creation dates, and validity for audience segmentation.

What You’ll Need to Get Started

• A Google Account with access to your BigQuery project‍
• A TikTok Business Account with advertiser access

💡Check out this video for a quick guide on setting up the free TikTok Ads to BigQuery connector using OWOX’s template. It shows the full process in just a few steps.

Step-by-Step Guide: Import TikTok Ads Data to BigQuery with the OWOX Data Marts

Set up a fully self-managed, SaaS-free pipeline to import TikTok Ads data directly into BigQuery using the OWOX Data Marts and a local server.

Step 1: Install Node.js and OWOX CLI ( ~2 min)

To run OWOX Data Mart locally, you’ll need to install Node.js and the OWOX CLI. This setup allows you to start a local server and work with the OWOX Data Marts effectively.

To get started, install the LTS version of Node.js from nodejs.org and use a version manager like nvm or nvm-windows to avoid permission issues. Once Node.js is set up, you can install the OWOX CLI globally and run ‘owox serve’ to launch the local server. 

💡 For detailed setup instructions and troubleshooting, check the official documentation.

Step 2: Connect Google BigQuery and Set Up Your Data Mart ( ~3 min)

To manage and process your data, you need to set up a storage and link it to a new TikTok Ads data mart.

1. Open your browser and go to http://localhost:3000.

💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.

2. Create your Service Account JSON Key.

• Follow our guide to create your service account JSON Key.

‍

3. Paste it into the ‘OWOX Service Account JSON Field’

• Don’t forget to click ‘Save’.

4. Once storage is added, click on the Data Mart Tab, then on ‘New Data Mart’

• Now, create the Data Mart, name the title as ‘TikTok Data’, as the data source
• Choose the storage named ‘TikTok Ads Storage’ you just created
• Click ‘Create Data Mart’.

Now we will do the Data Setup

5. Set up your Data Mart

• Go to the  Data Setup Tab and then select Connector

• Click on Setup Connector and Choose TikTok Ads Connector

Step 3: TikTok Ads Source Authentication Guide (5 minutes)

To connect your TikTok Ads account, you’ll need an access token. Let’s make sure you’ve got the right access credentials in place. 

Prerequisites

• A TikTok for Business account
• Advertiser-level access to the accounts you want to pull from
• Developer access to create an app

Steps to Obtain Credentials

1. Create a Developer App
   
   • Visit the TikTok for Business Developers portal
     Log in with your TikTok Business credentials
   • Click “Become a Developer” and fill out the form:
     
     • First & Last Name
     • Communication Email
     • Company Type
   • Click “Next” and complete your application

2. Configure the App
   
   • Under “My Apps”, click “Create an App.”
   • Enter:
     
     • App name
     • App description
     • Redirect URL (you can use a placeholder like http://localhost:8080)
   • Select the following scopes:
     
     • Read Ad Account Information
     • Read Campaigns
     • Read Ad Groups
     • Read Ads
     • Read Custom Audiences
   • Click “Submit”

App approval can take up to 7 business days. If your submission isn’t approved the first time, try updating your app description to make it clearer, then resubmit. Once approved, you’ll receive a confirmation email like the one shown below. 

3. Generate an Access Token
   
   • Copy the Advertiser Authorization URL and open it in your browser

• After login, you’ll receive an auth_code in the redirect URL
• Send a POST request to the TikTok API to exchange the auth_code for an access_token.

https://business-api.tiktok.com/open_api/v1.3/oauth2/access_token/

•  Include:
  
  • app_id – Your app’s ID
  • auth_code – The received code
  • secret – Your app secret 

• Once the request is successfully processed, you'll receive:
  
  • An access_token to authenticate future API calls.
  • A list of advertiser_ids associated with your TikTok Business account.

Security Notes

• Keep your access token and app secret secure
• Don’t share credentials
• For production environments, always implement secure token refresh logic 

Step 4: Configure TikTok Ads Connector and Run Your First Import ( ~2 min)

Now that you have all of the TikTok Ads access tokens & credentials, it’s time to configure the connector in OWOX.

1. Paste the Access Token

2. Add your App ID and App Secret: 

• It is found in the Basic Information section of your TikTok for Business Developers dashboard.
• Paste the App ID and App Secret

3. Advertiser ID: 

• Found in the user profile in the TikTok Ads dashboard.

‍

• Paste the Advertiser ID (you can add different advertiser IDs here separating them with coma)

4. Start Date: 

• Set the reporting start date (e.g., 2025-08-01). This determines how far back data will be fetched.

5. When you scroll down, you’ll see some more fields with parameters. For your first run, they are optional, and you can always come back and adjust them later.

6. Click 'Next'
7. Endpoint: Choose from the following valid endpoints:
   • advertiser – Information about your TikTok Ads account.
   • campaigns – Campaign-level details such as objectives and budgets.
   • ad_groups – Ad group-level data including targeting and bidding settings.
   • ads – Information on individual ads and creatives.
   • ad_insights – Performance metrics like impressions, clicks, spend, and conversions.
   • audiences – Data on custom or saved audiences and their sizes.
   ‍

👉 Tip for first-time setup: If you’re just getting started, begin with the ad_insights endpoint. It gives you the core performance metrics (impressions, clicks, spend, conversions) that most teams need for reporting. Later, you can add campaigns, ad_groups, or ads to enrich your data model with structural details and targeting context.

8. Select Fields for the chosen endpoint. 

• Select all available fields or choose specific metrics based on your reporting needs.

9. Dataset Name: 

• Enter the BigQuery dataset name where the imported data should be stored.

Note: If the dataset doesn't exist, OWOX will create it automatically during the import process.

10. Click ’Finish’

11. In the Data Setup Tab, Click 'Save'.

12. Click 'Publish Data Mart'.

13. Click the 'Manual Run' or select it from the 3-dot menu.

14. A configuration panel will appear to choose a Run Type. Select Backfill or Incremental Load. Then add the required start and end dates, then click Run to load the data. 

Please Note: If you are setting up this connector for the first time, you need to go with the Backfill Run Type.

15. Go to 'Run History' and see the message: 'Success'.

Step 5: Schedule Automated Imports ( ~1 min)

Set up a trigger to pull data on a recurring schedule.

1. Go to the 'Triggers' tab in the new Data Mart

• Click 'Add Trigger'.

2. Configure:

• Choose the Trigger Type as Connector Run and the Schedule Settings: Daily / Weekly / Monthly / Interval. 
• Set the Time (hour, minute, or second), days of the week, and choose your time zone.

3. Click 'Create Trigger'.

4. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

Data Import & Troubleshooting

This connector is designed to provide fast, structured, and reliable access to your TikTok Ads data in BigQuery. However, like any API-based solution, a few technical nuances may arise. Here’s how the data import works and how to troubleshoot issues effectively.

How Data Import Works

• Catalog data (like advertisers, campaigns, ad groups, and ads) is fetched as soon as the connector runs.
• Time-series data (such as ad_insights) is retrieved daily using your configured lookback window.
• Each object type is written into a separate BigQuery table (e.g., advertiser, campaigns, ad_insights).
• The connector performs upserts, updating existing records based on unique keys and inserting new ones, so your datasets stay current without duplicates.

Troubleshooting Common Issues

1. Authentication Errors
   
   • Ensure your TikTok access token is valid. 
   • Tokens expire every 24 hours. Generate a fresh one before triggering a new import.
2. Missing Data
   
   • Review your date range configuration.
   • Double-check that advertiser IDs are correctly entered.
   • Verify that TikTok has performance data available for the requested dimensions and metrics.
3. Rate Limiting
   
   • If you hit API rate limits, reduce the import frequency or split your requests. 
   • TikTok’s rate limits vary by app type and permission level.
4. Ad Insights Data Level Errors

• Set the correct DataLevel parameter (required for ad_insights).
• Supported values:

• AUCTION_ADVERTISER
• AUCTION_CAMPAIGN
• AUCTION_ADGROUP
• AUCTION_AD

• Each level changes how your metrics are aggregated and which dimensions are allowed.
• The connector automatically:

• Adjusts dimensions based on the selected data level.
• Filters out incompatible metrics.
• Limits dimensions to 4 or fewer, per TikTok’s API rules.

5. Metric Restrictions
   
   • TikTok’s API requires a strict separation between metrics and dimensions.
   • Fields like date_start, date_end, and stat_time_day are treated as dimensions, not metrics.
   • The connector removes conflicting fields, uses a curated list of supported metrics, and falls back to safe defaults like spend, impressions, and clicks if necessary.

This setup ensures that your TikTok Ads data is loaded into BigQuery cleanly, ready for querying, modeling, and analysis.

What’s Next?

This free TikTok Ads to BigQuery connector from OWOX Data Marts is another step in our mission to make data ownership straightforward, transparent, and available to all. 

Explore the additional resources below:
🔗 More free connectors – including Microsoft Ads and LinkedIn Ads Connector for BigQuery, and other key platforms you’ve been asking for.
🎥 Step-by-step video tutorials – built for analysts, so you can confidently deploy and manage each integration.
📊 Prebuilt dashboard templates – designed to help you extract actionable insights from BigQuery faster than ever.

Check out our GitHub repo, leave us a ⭐ star, and help shape the next generation of open, analyst-friendly marketing tools.

‍