How to get your TikTok Marketing data ready for agentic AI
Sync TikTok Marketing campaigns, ads, and hourly or daily reports with Airbyte, then let AI agents read and search ad data through the Airbyte MCP.

Airbyte syncs TikTok Marketing campaigns, ad groups, ads, creatives, and performance reports into your warehouse, and the Airbyte context layer lets agents read and search TikTok ad data directly through the Airbyte MCP.
TikTok has become a core paid channel for many brands, and the questions marketers ask about it are the same ones they ask about every other channel. Which creatives are working? Where is spend going? How does TikTok compare with Meta and Google for the same audience? Agents can answer those questions quickly, but only if the data is complete, consistent, and next to the other channels.
That argues for a centralized, governed copy. Reading TikTok's reporting API on demand for every question is slow, subject to per-token and per-advertiser rate limits, and hard to compare with other platforms. A warehouse copy gives agents stable history and a place to join channels. Airbyte also lets agents read the current campaign structure directly when a question is about what is live now.
Why TikTok Marketing data matters for agentic AI
- Metrics settle late. TikTok reporting data arrives with a delay and attributed conversions keep updating after the day ends, so an agent needs a copy that rereads recent days.
- Creative is the lever. Performance on TikTok depends heavily on the video and image assets, which makes creative data as important as spend data.
- Granularity matters. Hourly, daily, and lifetime reports answer different questions, and mixing them produces wrong totals.
- Structure changes. Ads and campaigns are paused, edited, and deleted, which affects historical reporting.
What agents can do with TikTok Marketing data
- Creative performance summaries. Rank ads and creative assets by spend, clicks, or conversions over a period and describe what the top performers have in common.
- Pacing checks. Compare hourly or daily spend with expectations and flag campaigns that are under or over pacing.
- Audience breakdowns. Report performance by age and gender, country, or platform from the audience report streams.
- Cross-channel comparisons. Join TikTok results with Facebook Marketing, Google Ads, and Bing Ads in the warehouse for one view of paid media.
How Airbyte gets TikTok Marketing data ready
Authentication
- Airbyte Cloud: OAuth2.0. You authorize a TikTok Ads Business account that has access to the advertisers you want to sync.
- Self-managed (Core): OAuth2.0 with an access token, secret, and app ID for production, or a Sandbox Access Token with an advertiser ID for a sandbox ad account. With OAuth2.0, leaving the advertiser ID empty syncs every advertiser the token can reach.
Streams marked Prod only, such as advertiser-level reports, Spark Ads, and Pixels, appear only with OAuth2.0.
Streams
- Structure: Advertisers, Campaigns, Ad Groups, Ads. The Campaigns stream covers Auction, TopView, and Reach & Frequency buying types.
- Performance reports: hourly, daily, and lifetime reports for ads, ad groups, campaigns, and advertisers, plus by-country reports for ads and ad groups.
- Audience reports: daily reports by age and gender, country, and platform at several levels, and by province for ads.
- Creative assets: images, videos, music, and portfolios.
- Other: Audiences, Spark Ads, Pixels, and pixel event statistics.
Report streams carry composite keys such as ad_id with stat_time_day, which keep daily rows unique when deduplicated.
Sync modes and settings
The connector supports Full Refresh and Incremental. Lifetime reports and some structure streams are full refresh only.
- Start date and optional end date set the range of data replicated.
- Attribution window (default 3 days, range 0 to 364) rereads recent days in incremental report streams so updated metrics replace earlier values. Airbyte recommends at least 3 days.
- Daily Reports Date Step (default 30 days) sets how many days each daily report request covers.
- Include deleted data syncs deleted ads, ad groups, and campaigns in report streams.
Errors and rate limits
TikTok enforces rate limits per access token and per advertiser. The connector backs off and retries when TikTok throttles a request, and retries transient errors such as service maintenance. If a daily report request is too large (error 40067), it splits that advertiser's date range and retries. If a resource no longer exists, it skips it. A permission error (40001) fails the sync, which means the app's permissions don't cover a selected stream.
One known gap: the Ads stream uses modify_time as its cursor, and TikTok can omit that field on Smart+ ad records, so those records don't appear in the Ads stream.
How agents reach TikTok Marketing data
TikTok Marketing is an agent connector in Airbyte Cloud, so it works with both parts of the context layer:
- Agent access (direct reads). Agents can list advertisers, campaigns, ad groups, ads, audiences, image and video creative assets, Spark Ads, and catalogs, plus daily reports for advertisers, campaigns, ad groups, and ads, and hourly and lifetime ad reports. Direct reads use credentials stored in Airbyte, are read-only, and count toward TikTok's rate limits.
- Search. When a connection syncs TikTok to an agent-connector destination, Airbyte can index selected streams. The open-source Airbyte agent SDK lists semantic search for ads.
Agents connect through the hosted Airbyte MCP at https://mcp.airbyte.com/mcp. Direct reads and searches are free up to 100,000 combined per organization per month.
Direct reads use the connector's stored TikTok authorization, so anyone who can use the connector through an agent sees the advertisers that authorization can reach.
What this unlocks
- Creative and spend analysis from a complete history of TikTok reports.
- Metrics that stay accurate as attribution settles.
- Deleted ads and campaigns kept in reporting.
- Live lookups of current campaign structure.
- TikTok joined with other paid channels in one warehouse.
Getting started
- Create a TikTok Marketing source in Airbyte Cloud and authorize with OAuth2.0.
- Select structure, report, and creative streams at the granularity you need.
- Keep the attribution window at 3 days or more and enable deleted data if you report on history.
- Sync to BigQuery or Snowflake, then connect your agent to the Airbyte MCP.
Try Airbyte free or talk to sales about ad data for agents.
Frequently asked questions
What does the TikTok attribution window do?
It sets how many days back incremental report streams reread so updated metrics replace earlier values. The default is 3 days and it can range from 0 to 364. Airbyte recommends at least 3 days because TikTok reporting data arrives with a delay.
Which report granularities does Airbyte support for TikTok?
Hourly, daily, and lifetime reports at the ad, ad group, campaign, and advertiser level, plus daily audience reports by age and gender, country, platform, and for ads, province.
Can Airbyte sync deleted TikTok ads and campaigns?
Yes. Enable Include deleted data to sync deleted ads, ad groups, and campaigns in report streams, so historical spend still adds up.
Why does a TikTok sync fail with a permission error?
TikTok error 40001 means the access token can't call an endpoint that a selected stream needs. The connector fails the sync instead of retrying. Check the developer application's permissions and reauthorize, or deselect the stream.
Can an agent change TikTok campaigns through the Airbyte context layer?
No. Direct reads and searches through the context layer are read-only. Agents can list and search TikTok data, but cannot change campaigns, budgets, or ads through these tools.
Integrate with 700+ apps using Airbyte
Move data from 700+ sources into warehouses, lakes, and beyond. Set up pipelines in minutes with pre-built connectors and the Connector Builder.
