TikTok Ads Connector

Q: What TikTok Ads data can I export with Windsor.ai?

954 fields, grouped roughly like this: Delivery and cost: spend, impressions, reach, frequency, clicks, CTR, CPC, CPM. Conversions: conversions, cost per conversion, completed payments, payment ROAS, checkouts. Video: 2-second and 6-second plays, plays at 25%, 50%, 75% and 100%, focused views at 6 and 15 seconds, average play time. Breakdowns: campaign, ad group, ad, video, call to action, placement, country, age, gender and date. The TikTok Ads field reference lists every field.

Q: Why does CTR show as 0.0026 instead of 0.26%?

TikTok’s ctr field is a fraction. Multiply by 100, or set the column format to percent in your spreadsheet or BI tool.

Send TikTok Ads data to Data Studio, Google Sheets, Power BI, Excel, BigQuery, Snowflake and other destinations, or ask about it in Claude and ChatGPT. Windsor.ai reads campaigns, ad groups and ads from every TikTok advertiser account you connect, with 954 fields.

No CSV exports and no code. Set up in a few minutes.

Try It for Free View documentation

Free forever plan

No credit card needed

Make the most out of your TikTok Ads data with Windsor.ai

Choose from 954 TikTok Ads fields (801 metrics and 153 dimensions), or create custom fields from them.

804 metrics153 dimensions

Clicks Conversion rate Cost per registration

Data fields documentation

Leverage our pre-built, customizable TikTok Ads dashboard templates for a comprehensive performance overview tailored to your data needs.

View all templates

Send your TikTok Ads data to any destination

Import your TikTok Ads data into any destination using Windsor.ai.

Data Studio

Learn more

Google Sheets

Learn more

ChatGPT

Learn more

Claude

Learn more

Power BI

Learn more

Excel

Learn more

Tableau

Learn more

Google BigQuery

Learn more

Amazon S3

Learn more

Azure Blob Storage

Learn more

Snowflake

Learn more

MySQL

Learn more

PostgreSQL

Learn more

Python

Learn more

Azure SQL

Learn more

Amazon Redshift

Learn more

Databricks

Learn more

Windsor MCP

Learn more

Microsoft Fabric

Learn more

Copilot Agent

Learn more

Perplexity

Learn more

Lovable

Learn more

Antigravity

Learn more

Supabase

Learn more

Gemini Enterprise

Learn more

Cursor

Learn more

Manus

Learn more

Grok

Learn more

Extract and load TikTok Ads data with Windsor.ai’s connector

Windsor.ai connects to the TikTok Marketing API with your TikTok for Business login and reads every advertiser account you select. You choose where the data goes: a scheduled transfer to a warehouse such as BigQuery or Snowflake, a data source in Data Studio, Google Sheets, Power BI or Excel, or questions in an AI assistant such as Claude or ChatGPT.

We tested the connector on Windsor.ai’s two TikTok test advertiser accounts, which were set up for this and have not run real campaigns. Their one campaign with spend returned $14.34 of spend, 13,610 impressions, 10,166 people reached, 35 clicks, $0.41 per click and $1.05 per 1,000 impressions. Three details stood out:

CTR comes back as a fraction. The ctr field returned 0.0026 for a test campaign, which is 0.26%. Format it as a percentage in your report.
Video plays come at several depths. play_first_quartile, play_midpoint, play_third_quartile and play_over count plays at 25%, 50%, 75% and 100% of a video, next to 2-second and 6-second plays (play_duration_2s, play_duration_6s) and average_video_play. Instant Experience videos have their own ix_ fields. On our test campaign every video field returned 0, so check the video fields against Ads Manager for one ad before you build a report on them.
Campaigns with no spend are included. Filter on spend above zero when you only want the campaigns that ran.

With Windsor.ai’s TikTok Ads connector, you can:

Report on spend, impressions, reach, frequency, clicks, CPC, CPM and conversions by campaign, ad group, ad, placement, country, age, gender and date.
Rank ads by hook rate (play_duration_2s divided by impressions) and average play time, next to cost per conversion.
Compare TikTok Ads with Meta Ads, Google Ads and GA4 in one report or one AI chat.
Pause or enable campaigns, ad groups and ads and set campaign or ad group budgets from an AI assistant connected through Windsor.ai, after you approve each change (write actions).
Start from ready-made TikTok Ads report templates.

Join 40,000+ businesses that trust Windsor.ai to streamline TikTok Ads data integration

How to export TikTok Ads data with the Windsor.ai connector

Sign up and start for free

Create a Windsor.ai account. The free forever plan (no credit card) covers 1 data source with the last 30 days of data.

Select TikTok Ads as a data source

Choose TikTok Ads, sign in with your TikTok for Business account and select the advertiser accounts to connect.

Choose report fields and metrics

Pick fields from the 954 available, for example campaign, ad_name, spend, impressions, clicks, conversion and cost_per_conversion. The field reference describes each one.

Select a data destination

Choose where the data goes: a spreadsheet, a BI tool, a data warehouse, or an AI assistant such as Claude.

FAQs

What TikTok Ads data can I export with Windsor.ai?

954 fields, grouped roughly like this:

Delivery and cost: spend, impressions, reach, frequency, clicks, CTR, CPC, CPM.
Conversions: conversions, cost per conversion, completed payments, payment ROAS, checkouts.
Video: 2-second and 6-second plays, plays at 25%, 50%, 75% and 100%, focused views at 6 and 15 seconds, average play time.
Breakdowns: campaign, ad group, ad, video, call to action, placement, country, age, gender and date.

The TikTok Ads field reference lists every field.

Does the connector include video completion rates?

It includes the counts to calculate them: plays at 25%, 50%, 75% and 100% of the video (play_first_quartile, play_midpoint, play_third_quartile, play_over), 2-second and 6-second plays, focused views at 6 and 15 seconds and average play time. Divide play_over by impressions or by plays to get a completion rate.

Can I send TikTok Ads data to Claude or ChatGPT?

Yes. Windsor.ai is a connector in Claude’s directory and a plugin in ChatGPT. See how to connect TikTok Ads to Claude and how to connect TikTok Ads to ChatGPT. TikTok also has its own connector in Claude’s directory, TikTok for Business, which can create Smart+ campaigns; the Claude guide compares the two.

Can Windsor.ai change my TikTok Ads campaigns?

Through an AI assistant, yes, within eight actions: pause or enable a campaign, an ad group or an ad, and set a campaign or ad group budget. The assistant asks you to approve each change. Windsor.ai cannot create campaigns or ads, or change targeting, bids or creatives; see the write actions documentation.

Why does CTR show as 0.0026 instead of 0.26%?

TikTok’s ctr field is a fraction. Multiply by 100, or set the column format to percent in your spreadsheet or BI tool.

Is the TikTok Ads connector free?

Windsor.ai’s free forever plan (no credit card) covers 1 data source and 1 account with the last 30 days of data. More sources, more accounts or longer history need a paid plan from $19 a month (annual billing, 3 sources); see pricing.