How to export TikTok Ads data to BigQuery (and a faster alternative)

Admaxxer is a marketing analytics and attribution platform for DTC brands and SaaS companies. This guide is the honest, end-to-end answer to a question a lot of ecommerce teams ask once their TikTok spend gets serious: how do I get my TikTok Ads data into BigQuery? Usually the real goal underneath that question is to join ad spend against actual orders and revenue, build dashboards, and stop living inside the TikTok Ads Manager UI.

We'll cover every legitimate route — the native export, TikTok's reporting API, and generic third-party connectors — with the trade-offs of each, citing TikTok's and Google's official documentation. Then we'll show you the route most teams actually want: skip the pipeline entirely and get attribution plus live dashboards without a warehouse to build or babysit.

This is an ECOM/DTC guide (orders, AOV, ROAS, Shopify). If you run a SaaS product, the same export mechanics apply — you'll just be joining TikTok spend against subscriptions, MRR, and trial-to-paid instead of orders and order value. SaaS deltas are flagged inline.

First, the honest truth about "TikTok Ads to BigQuery"

There is no native, first-party connector that streams TikTok Ads data into BigQuery on its own. Google's BigQuery Data Transfer Service ships managed connectors for a set of sources — most relevantly a native Google Ads transfer — but TikTok is not one of its native sources. So getting TikTok data into BigQuery always means one of three things: export it yourself, pull it through TikTok's reporting API and load it, or pay a third-party connector to do the pulling and loading for you.

Knowing that up front saves you from searching for a "TikTok → BigQuery transfer" toggle that doesn't exist. Here are the three routes that do.

Route 1: Native export from TikTok Ads Manager (CSV)

The simplest route needs no code at all. Inside TikTok Ads Manager, the reporting view lets you build a custom report — pick your dimensions (campaign, ad group, ad, date) and metrics (spend, impressions, clicks, conversions, value) — and export it to a file you can download.

When this is the right call: a one-off analysis, a monthly board export, or a quick sanity check. You download the CSV and either open it in a spreadsheet or load it into a BigQuery table manually.

The catch: it's manual and it doesn't scale. You're re-exporting every time you want fresh data, BigQuery has no idea the file exists until you upload it, and there's no automatic refresh. For a recurring dashboard this becomes a chore you'll quietly stop doing after a few weeks.

Route 2: TikTok's reporting API + your own pipeline

For automated, recurring loads, TikTok exposes its advertising data through the reporting endpoints documented in the TikTok API for Business reporting documentation. You request a report by specifying the level (campaign / ad group / ad), the dimensions, the metrics, and the date range, and TikTok returns the rows.

The shape of the work looks like this:

1. Register a developer app and complete TikTok's authorization flow to get an access token for the ad account, per the TikTok API for Business documentation.
2. Call the reporting endpoint on a schedule (say, every morning) for the metrics and date window you care about.
3. Handle pagination and rate limits — large accounts return paged results, and you must respect TikTok's request limits.
4. Write a loader that lands those rows into BigQuery — typically by streaming inserts or by writing files and running a load job, both documented in Google's BigQuery docs.
5. Schedule and monitor it — something has to run this every day, alert you when TikTok changes a field or your token expires, and backfill when a run is missed.

When this is the right call: you have an engineering or data team, you want full control over the schema, and TikTok is one of several sources flowing into a warehouse you already operate.

The catch: you are now the owner of a data pipeline. Tokens expire, TikTok evolves its API, schemas drift, and a silent failure means your dashboards quietly go stale. The build is the easy part; the maintenance is the cost.

SaaS note: the API mechanics are identical — the difference is purely in what you join the spend against downstream (subscriptions and MRR rather than orders).

Route 3: A generic third-party connector

Several off-the-shelf connector products (described here generically — evaluate them on their own merits and current pricing) will pull TikTok Ads data on a schedule and load it into BigQuery for you, so you don't write or maintain the extraction code. Some load into a spreadsheet instead; some do both.

When this is the right call: you want automation without building it, you're comfortable adding another paid tool to the stack, and your only goal is to land raw TikTok rows in BigQuery for your own analysts to model.

The catch: a connector lands raw ad-platform rows. It does not, on its own, join those rows to your orders, deduplicate conversions, or tell you which channel actually drove revenue. You still have to build the attribution model on top — which is the part that was hard in the first place.

Or skip the pipeline entirely

Step back and ask what you actually wanted. Almost nobody wants TikTok rows sitting in a warehouse for their own sake — they want to know what TikTok spend returned in real orders and revenue, see it on a live dashboard, and compare it fairly against Meta, Google, and the rest. The warehouse was a means to that end, not the end itself.

That's the job Admaxxer does without any pipeline. Connect TikTok once on the TikTok Ads integration page, connect your store on the Shopify integration page, and your spend, orders, and revenue line up automatically in one place — no warehouse to build, no spreadsheet to refresh, no extraction code to maintain.

What you get instead of raw rows:

• Attribution, not just data. TikTok spend joined to real orders, so you see ROAS and blended MER — not impressions and clicks you still have to model.
• Live dashboards out of the box that update on their own, instead of a report you re-export.
• A fair cross-channel view — TikTok next to Meta, Google, Pinterest, and Amazon on one screen, which a single-source BigQuery export can't give you. (See why platform-reported numbers differ from your true orders.)
• Server-side conversion delivery so TikTok keeps optimizing even as browser tracking degrades — see server-side tracking explained.

If you still want the raw warehouse for a data-science use-case, keep one of the routes above for that — but for measuring and steering spend, the connect-once path gets you to the answer faster. See pricing for what's included, browse the documentation, or read how we think about marketing acquisition.

Choosing your route

• Need a one-off number? Use the native CSV export (Route 1).
• Have a data team and a warehouse already? TikTok's reporting API (Route 2) or a connector (Route 3) to land raw rows.
• Want to actually measure and steer TikTok spend against revenue, fast, without owning a pipeline? Connect it to Admaxxer and skip the warehouse.

Most DTC teams discover they were chasing the warehouse when what they needed was the answer. Pick the route that matches the real goal, not the one the search box suggested.

FAQs