All resources

How to Export Data from TikTok Ads to BigQuery

Don’t overlook TikTok in your ad strategy. While Facebook, Instagram, and Twitter have long dominated digital advertising, TikTok has quickly caught up, despite being much newer. Its massive and growing user base makes it a valuable platform for advertisers. Exporting data from TikTok lets marketers compare its performance against other channels and make smarter decisions about where to spend their budget.

i-radius

This article describes how to upload data from TikTok to data storage, including the best option, a comparison of the manual method and automated solutions for exporting data, and the method our specialists recommend.

Note: This article on exporting data from TikTok ads to BigQuery was published in 2022 and is updated with new context to suit the current state of updates in July 2025.

Understanding TikTok Ads

TikTok has quickly grown from a viral video app into a powerful marketing platform where businesses of all sizes can reach and engage their audience. You’ll need a TikTok Ads account to access ad tools and view performance data. With features like audience targeting, easy ad creation, and performance insights, it offers brands a flexible and creative space to run campaigns, boost sales, and build long-term customer loyalty.

Between January 2024 and January 2025, the platform saw a notable rise in advertising potential - marketers gained access to 31.2 million more users, marking a 2% increase in total ad reach within a year. This steady growth reinforces TikTok’s value as a key channel in the modern digital marketing mix.

Top Reasons to Use TikTok Ads for Your Business 

TikTok isn’t just a platform for trends and dances – it’s become a powerful space for brands to grow, connect, and sell creatively. If your business isn’t exploring TikTok yet, here are seven compelling reasons to get started.

  • Seamless Selling with TikTok Shop: TikTok Shop lets customers browse and buy without leaving the app, making purchases quick and frictionless for users and profitable for businesses.
  • Creative Freedom for Every Brand Type: TikTok’s playful vibe gives businesses the chance to show personality, build relatability, and stand out with fun, short-form content—even in traditionally serious industries.
  • Faster Reach with Smarter Targeting: With its video-first nature and built-in audience tools, TikTok helps brands connect with the right viewers quickly through tailored content and ad targeting.
  • Massive Pool of Influencers to Collaborate With: From mega to nano influencers, TikTok offers creators at every level, making it easy for brands to find authentic partners who can promote products to niche or local communities.
  • Easy Content Repurposing Across Platforms: TikTok videos can be reused in emails, on Instagram, websites, or presentations, saving time while keeping your brand message consistent everywhere.
  • High Engagement with Low Effort: Thanks to TikTok’s algorithm, even small brands can enjoy strong engagement, making it easier to get noticed and spark conversations with your audience.
  • Budget-Friendly Marketing Options: Whether you’re a startup or an established business, TikTok allows you to start small with ads and still see solid results, making it accessible for all budgets.

Why Deliver Data from TikTok to BigQuery 

Sending your TikTok data to BigQuery helps you store, manage, and analyze everything in one place. In this section, we’re covering why this integration matters for marketing teams and how it improves campaign tracking and reporting.

  • Centralized Data for Better Insights: Combine TikTok performance data with other sources like Google Ads or GA4 to get a complete view of your marketing efforts. Sending TikTok data to BigQuery lets you track performance across all channels in one place, making your analysis more complete.
  • Custom Reporting Made Easy: Use SQL in BigQuery to build flexible, in-depth reports tailored to your business goals—without the limits of platform dashboards.
  • Faster Analysis, Less Manual Work: Automate data imports into BigQuery so you don’t have to export spreadsheets or manually copy campaign metrics.
  • Track Performance Over Time: Store historical TikTok data to spot trends, compare campaigns, and make better decisions by refining your strategy based on past results.
  • Prepare Data for Looker Studio Dashboards: BigQuery works seamlessly with Looker Studio, making it easy to turn your TikTok data into clean, shareable dashboards.

BigQuery serves as a powerful business intelligence platform, allowing marketers to leverage advanced analytics tools for comprehensive reporting, data modeling, and actionable insights. This enables data-driven teams to make informed decisions and optimize campaigns with confidence.

How to View TikTok Ads Metrics?

TikTok Ads Metrics helps businesses to track ad performance, revealing views, watch duration, and user actions. Example: Campaign report includes key metrics like Impressions, Reach, Clicks, and Total ad spend for analysis. It’s essential to track TikTok ads metrics as it helps in improving ad performance and cutting down promotional costs.

TikTok Ads Manager Reporting section showing options to create a custom report or use a predefined template for analysis.

You view TikTok ads metrics and statistics on TikTok advertising both in the TikTok application and your TikTok Ads Manager account. Running and analyzing ads in Ads Manager is best if your goal is to boost sales rather than user activity. The advertising account has more technical capabilities and metrics for setting up campaigns and working with data. For deeper analysis, you can export data directly from TikTok Ads Manager using available tools or APIs to access more detailed campaign metrics.

TikTok Ads Manager, by default, provides data about coverage, views, clicks, ad spending, and more. If you install a TikTok pixel on your website and configure event tracking, you can find out how users who have visited the website behave after clicking on the ad in the application.

TikTok Ads Manager dashboard with campaign metrics and a red arrow pointing to the filter menu for refining ad data.

Information stored in Ads Manager only tells you about the effectiveness of the TikTok source. But what if the user came to you from organic traffic, returned to your website, clicked on a link on TikTok, and purchased it after receiving an email?

How can you assess the effectiveness of the TikTok channel in this case? You won’t know how it interacts with other marketing sources and how they mutually impact your business until you merge the marketing data.

In many companies, marketing isn’t limited to TikTok alone; sales can be online and offline. Therefore, it’s necessary to merge data from TikTok Ads Manager with data from the website, other advertising services, and CRM systems. Typically, you start with raw data from TikTok Ads before combining it with other marketing data sources. For marketers to have the whole picture, see how much money is spent on advertising, and determine which advertising channels are most efficient, they need to apply an ETL tool like OWOX BI.

Benefits of Exporting TikTok Ads Data to a Data Warehouse

​​While TikTok Ads Manager provides plenty of useful information, it becomes even more powerful when combined with Extract, Transform, and Load (ETL) tools that allow you to select appropriate destinations for different types of marketing data during the integration process.

By exporting TikTok ads cost data from advertising services to a single data warehouse, you can associate it with user actions on your website, clicks on links in emails, and purchase orders from the CRM system. 

BigQuery serves as the primary destination for TikTok Ads data, ensuring that all relevant information is centralized for analysis and reporting. This helps you set up advanced analytics and assess the impact of all marketing efforts on business metrics, both online and offline.

Data from marketing services uploaded to the repository can be used to perform calculations according to the attribution model, and the results can be used for automatic bid management. You can also create user audiences based on merged data and the results of attribution calculations, then automatically send those audiences to advertising services. Finally, you can build any reports you need without restrictions based on data collected in the data warehouse.

Understanding Google BigQuery

Google BigQuery, a cloud-based Data Warehouse on the Google Cloud Platform, facilitates business analytics. This serverless SaaS solution offers exceptional data management, access control, and Machine Learning functionalities. It’s adept at handling vast data volumes, providing large-scale storage and SQL query capabilities. 

Users can easily load data from various sources for analysis. BigQuery’s application programming interface enables seamless integration with external platforms and data sources. BigQuery uses columnar storage and the Dremel engine for fast queries, while Google’s Jupiter Network ensures quick and reliable data transfers.

Advantages of Using BigQuery Over Other Cloud Platforms for TikTok Ads

Google's BigQuery is a top-tier cloud platform that simplifies the analysis of TikTok Ads. Like its competitors, Amazon Redshift and Microsoft Azure, BigQuery has several key advantages over traditional data storage like-:

  • There’s no need to have servers and connect new ones when the load increases. Cloud storage scales automatically.
  • Cloud platforms run faster than traditional storage and automatically redistribute the load.
  • To get into cloud storage, you don’t need to install a server on your computer. It’s enough to open the browser and enter the cloud.

But, we choose Google BigQuery and recommend it to our customers for the following reasons:

  • Google BigQuery operates as a fully managed Data Warehouse, eliminating the need for in-house setup.
  • Google is the leader in the number of data sources for marketers: Ads, Analytics, Search Console, and YouTube. All of these services seamlessly integrate with BigQuery.
  • BigQuery processes large data arrays at high speed.
  • It’s easy to get started with BigQuery without the help of database administrators. It’s enough to create an account on Google Cloud.
  • You only pay for the services you use.
  • There are ready-made services and solutions for uploading data to Google BigQuery without the help of developers.
  • Its column-based structure offers efficiency advantages such as increased storage efficiency and faster data scans.

Ways to import data into BigQuery from TikTok ads

Google BigQuery doesn’t have a built-in tool for uploading ads data from TikTok Ads Manager. You can solve this problem by uploading data manually, for example, you can upload TikTok Ads data to BigQuery using local files, custom scripts, or automated tools like OWOX BI. Let’s take a look at each of these methods to connect data from TikTok ads to BigQuery.

1. Manually import data or create your solution

You can download cost data from a TikTok ad account to separate files and manually upload them via the BigQuery interface. The disadvantages of this method are obvious: a lot of extra work and no automation.

You can also write your scripts to upload the data you need from TikTok. The downside is that the work of these scripts must be constantly monitored and supported. Building custom ETL pipelines can take a lot of time and developer effort. You’ll need to manage merging data from different accounts and dates, ensure quality, and stay on top of changes in TikTok’s API. 

In addition, the data upload of TikTok ads to BigQuery must be retrospectively updated if it has changed in TikTok Ads, expenses must be converted from all advertising sources into a single currency, etc. If this isn’t done, poor-quality data can lead to erroneous decisions that will cost the business dearly.

2. Connect TikTok Ads to BigQuery through Google Sheets

Utilizing Google Sheets as a medium offers a more interactive way to handle TikTok Ads data before importing it into Google BigQuery. This method involves exporting data from TikTok Ads to Google Sheets, where you can manually adjust and refine the data. Once formatted to your preference, the data can be uploaded to BigQuery using Google Sheets' built-in integration features. While this approach allows for greater data manipulation and is user-friendly, it does require manual effort. It might not be ideal for very large datasets, as it lacks the automation capabilities of more direct integration methods. 

3. Automatically Send TikTok Ads Data to BigQuery with OWOX Data Marts

If you don’t want to deal with manual uploads or write scripts, OWOX Data Marts gives you a free and simple way to send your TikTok Ads data directly into Google BigQuery. Just download the ready-made template from GitHub and follow the instructions with no coding required. It automatically pulls in your raw ad data, checks it for errors, cleans it up, and keeps it up to date, even if your campaigns change later.

You get a clean dataset in BigQuery that’s ready for reporting. Plus, you can combine it with data from other ad platforms to build full-funnel marketing reports and track performance across all your channels in one place.

To see how this works in detail, check out our full guide on the free TikTok to BigQuery connector. It explains how to set it up and start using your TikTok data for better, faster reporting in BigQuery.

Best Practices for Managing TikTok Ads Data in BigQuery

Working with multiple data sources is a big part of getting clear, accurate insights and TikTok Ads is no exception. Here are some best practices to help you manage TikTok Ads data in BigQuery more effectively and make smarter, data-driven decisions.

  • Connect TikTok Ads to Google BigQuery: Combine TikTok Ads data with other marketing data sources such as Google Ads, Google Analytics, and additional advertising platforms.
  • Enhance ROAS Accuracy: Merging sales and marketing data improves accuracy in return on ad spend (ROAS) calculations and helps evaluate true campaign impact.
  • Set Up a Centralized Data Warehouse: Using Google BigQuery as a centralized storage system makes it easier to manage, analyze, and report on your campaigns.
  • Simplify Integration with No-Code Connectors: No-code tools help connect TikTok Ads and other data sources without writing code, ensuring consistent and up-to-date data flow.
  • Uncover Deeper Insights Across Channels: Combining TikTok Ads data with other sources in BigQuery helps you track the full customer journey and understand audience behavior.
  • Maintain Data Quality and Consistency: Ensure accurate reporting by validating data and using automated methods like the TikTok Marketing API for reliable data extraction.
  • Reduce Manual Errors Through Automation: Automation keeps your TikTok Ads data current in BigQuery and removes the risk of errors from manual processes.
  • Implement Robust Data Validation: Monitor API requests and review data regularly to catch discrepancies, missing values, or mismatched data types early.
  • Trust Your Insights for Smarter Marketing: Prioritizing data quality in BigQuery ensures your TikTok Ads analysis leads to effective strategies and better business results.

Unlocking Insights with OWOX Data Marts

OWOX Data Marts (Community Apps Script Edition) is an open-source JS connector library that lets you import marketing, financial, or CRM data into Google Sheets or BigQuery for free, with no vendor lock-in and full control over your data.

Each connector in the Data Marts library pulls data directly from platforms like Facebook, TikTok, LinkedIn, and more, is open-source, customizable, has no third-party vendor lock-in, and is free to use forever. That means data analysts can set up reliable pipelines without engineering help, and business users gain direct access to clean, structured data – all within your existing workflows.

Get started with the free connectors.

FAQ

What are the benefits of integrating TikTok data with Google BigQuery?
Can I customize the data I export from TikTok to Google BigQuery?
How often is data from TikTok updated in Google BigQuery?
What kind of data can I export from TikTok to Google BigQuery?
Is there a direct way to import data from TikTok to Google BigQuery?
What are the steps to connect TikTok Ads data to Google BigQuery?
Can I use Google Sheets to move TikTok Ads data to BigQuery?
How does the free TikTok to BigQuery connector by OWOX work?

You might also like

2,000 companies rely on us

Oops! Something went wrong while submitting the form...