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 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.
Why We Made This Free Connector
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 (Community Apps Script Edition) 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 BigQuery to TikTok 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 open 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:
Why Choose OWOX Free Connector for TikTok Ads to BigQuery
For analysts managing TikTok Ads at scale, OWOX offers a script-based connector that’s fully transparent and designed for control, not constraints.
Zero-cost, open-source access: Unlike usage-priced tools, this connector is freely available on GitHub and fully modifiable.
Direct BigQuery write: Data flows straight from TikTok Ads API into your BigQuery project – no CSVs, no staging layers.
Schema flexibility: Define your destination table schema, map fields as needed, and transform the data during load.
Refresh control: Automate updates using scheduled functions and get a fresh dataset every time – append, overwrite, or segment.
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 connectorfrom OWOX Data Marts (Community Apps Script Edition) delivers what most tools don’t — full control without the complexity.
It’s built on a simple Google Sheets template powered by open-source Apps Script, 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 customize the script, define your own schema, and automate refreshes on your terms.
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 Google Sheets – without the manual hassle or expensive tools. Whether you're managing campaigns, optimizing creatives, or building 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 – hourly or daily – to keep your reports up to date without lifting a finger.
Use incremental loading to pull only new or changed data, reducing load time and optimizing performance.
Enjoy built-in error handling that protects against API rate limits and ensures smooth, reliable data imports.
Automatically clean up old data to keep your spreadsheets lightweight and well-structured.
Data Types You Can Import
This connector supports the full spectrum of TikTok Ads data, including:
Advertiser Information: Basic details, balance data, and account-level metadata.
Campaigns: Budget info, targeting options, performance settings, and statuses.
Ad Groups: Bid settings, placements, targeting filters, and group-level controls.
Ads: Creative data, CTAs, status, URLs, and landing pages.
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.
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 Google Sheets
A TikTok Business Account with advertiser access
A TikTok API access token with the right permissions
Step-by-Step: Import TikTok Ads Data to BigQuery
Setting up your TikTok data takes just a few minutes – no dev time, no coding, no friction. Here’s how to go from zero to insights with ease.
Step 1: Copy the BigQuery Template (~1 min)
Start with a ready-made template designed for TikTok Ads – no need to build one from scratch.
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.
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.
Once you’ve got your token, call: https://business-api.tiktok.com/open_api/v1.3/oauth2/advertiser/get/
Include the token in the Access-Token header. The response will list available advertiser IDs.
5. Manage Credentials
Go to the custom menu and click: OWOX → Manage Credentials This confirms your access token is active and tied to your spreadsheet.
6. Enter Your TikTok Business API Credentials
Open the configuration tab in your connector template
Enter the app ID, app secret, access token, and advertiser ID as instructed
Token Validity
TikTok tokens are valid for 24 hours
For daily use, generate a new token or implement a refresh process
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: Run the Source (~1 min)
Let’s bring that data in. You can run it manually or automate it on your schedule.
Manual Run
Select OWOX > Run Import Process from the custom menu
Track progress in the “Logs” sheet
Scheduled Run
Daily: OWOX > Schedule > Set Daily Schedule
Hourly: OWOX > Schedule > Set Hourly Schedule Remove all: OWOX > Schedule > Delete All Schedules
Step 5: Run the Connector & Import Your Data (~30 sec)
Go to the "OWOX" menu and hit "Run Import Process." Your data will flow into BigQuery, separated by table and deduplicated automatically.
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 day by day 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
Authentication Errors
Ensure your TikTok access token is valid.
Tokens expire every 24 hours, generate a fresh one before triggering a new import.
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.
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.
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.
Limits dimensions to 4 or fewer, per TikTok’s API rules.
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.
📊 Real-Time Reporting with OWOX Reports
Already sending your TikTok Ads data to BigQuery? Now it’s time to unlock insights.
Use the OWOX Reports Extension for Google Sheets to turn your raw TikTok Ads data in BigQuery into real-time dashboards and campaign insights, no SQL required.
With OWOX Reports, you can: 📥 Pull data directly from BigQuery into Google Sheets 📊 Build shareable, refreshable dashboards without Looker Studio ✅ Empower your team with real-time access to ad performance metrics
No code, no queries, no delays. Just actionable reports – when and where you need them.
What’s Next?
This free TikTok Ads to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) is another step in our mission to make data ownership straightforward, transparent, and availableto 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 customize 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.
.png
)
