What TikTok Ads metrics can I pull into Google Sheets?

Kondado offers seven pipelines including Campaign Report, Ad Group Report, Ad Report, and Advertiser Report, covering metrics such as impressions, clicks, cost, and performance dimensions. You can also access metadata pipelines for Ads, Campaigns, and Ad Groups to analyze creative attributes alongside performance data.

How often does TikTok Ads data update in Google Sheets?

Kondado supports automated refreshes ranging from every 5 minutes to daily intervals, allowing you to balance data freshness with your reporting requirements. Choose your preferred cadence during setup to ensure your spreadsheets reflect the most recent advertising metrics without manual exports.

Can I combine TikTok Ads data with other marketing platforms in Google Sheets?

Yes, you can replicate data from multiple sources into the same Google Sheets workbook, including TikTok Ads , Facebook Ads, or Google Ads. This allows you to build unified cross-channel reports that compare performance metrics across different advertising platforms in one collaborative environment.

What is the difference between Campaign Report and Ad Group Report pipelines?

The Campaign Report pipeline provides high-level performance metrics organized by campaign ID and date, ideal for budget overview and strategic planning. The Ad Group Report pipeline offers more granular data broken down by specific ad groups, enabling detailed analysis of targeting effectiveness and audience engagement within each campaign.

Do I need coding skills to set up TikTok Ads to Google Sheets replication?

No coding is required to configure this connection. Kondado provides a no-code interface where you authenticate your TikTok Ads account, select your desired pipelines, and specify your Google Sheets destination through a guided setup process.

Can I send TikTok Ads data to destinations other than Google Sheets?

Yes, Kondado supports multiple destinations including BigQuery , PostgreSQL , Power BI , and Looker Studio . You can also send data to MySQL, Excel, Redshift, SQL Server, or Amazon S3 depending on your analytics infrastructure needs.

How is the data structured when it arrives in Google Sheets?

Each pipeline creates a separate sheet within your workbook, with columns representing the 231 available fields such as advertiser ID, report date, impressions, clicks, and cost. The data arrives in a clean, structured format ready for pivot tables, charts, and custom formulas without requiring additional cleaning or transformation.

Send data from TikTok Ads to Google Sheets

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect TikTok Ads to Google Sheets Automatically

How to send TikTok Ads data to Google Sheets? Kondado offers a direct integration that automates the replication of your advertising metrics without requiring technical expertise or manual CSV exports. Simply authenticate your TikTok Ads account, select Google Sheets as your destination, and choose which performance data to replicate. The platform supports automated data refreshes on a configurable schedule, ensuring your spreadsheets always contain the latest campaign insights for analysis and reporting.

Kondado replicates TikTok Ads data to Google Sheets through seven available pipelines including Campaign Report, Ad Group Report, and Advertiser Report, updating automatically every 5 minutes, 15 minutes, hourly, or daily based on your configuration.

Marketing teams use this connection to consolidate performance metrics from video advertising campaigns into collaborative spreadsheets where they can build custom dashboards and share insights with stakeholders. By automating the data flow, analysts save hours previously spent on manual downloads and can focus on optimizing creative performance, budget allocation, and audience targeting across multiple campaigns without switching between platforms or managing complex API connections.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With the Campaign Report pipeline, you can monitor budget efficiency and impression trends across all active campaigns directly within your collaborative spreadsheet environment. The Ad Group Report pipeline delivers granular performance data that helps you compare targeting strategies and engagement rates by audience segment, while the Metadata: Ads pipeline provides detailed creative attributes and advertiser information. Together, these datasets enable you to build custom performance dashboards in Google Sheets that reveal which video formats drive conversions, allowing teams to optimize creative rotation and reallocate budgets toward high-performing content without leaving their preferred analysis tool.

Try out all the features for free for 14 days

TikTok Ads data available for Google Sheets

available pipelines

231

extractable fields

Available integrations

Integration	Description
Ad Group Report	Analyze the performance of ad groups with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.
Ad Report	Examine ad performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.
Advertiser Report	Evaluate advertiser performance with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.
Campaign Report	Monitor campaign performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.
Metadata: Ads	Access detailed information about ads, including advertiser id and performance attributes.
Metadata: Campaigns	Explore data about campaigns, including advertiser id and performance metrics.
Metadata: Ad Groups	Discover information about ad groups, including advertiser id and performance attributes.

Ad Group Report

Analyze the performance of ad groups with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.

Ad Report

Examine ad performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.

Advertiser Report

Evaluate advertiser performance with metrics such as impressions, clicks, and cost, along with dimensions like advertiser id and report date.

Campaign Report

Monitor campaign performance with metrics such as impressions, clicks, and cost, and details like advertiser id and report date.

Metadata: Ads

Access detailed information about ads, including advertiser id and performance attributes.

Metadata: Campaigns

Explore data about campaigns, including advertiser id and performance metrics.

Metadata: Ad Groups

Discover information about ad groups, including advertiser id and performance attributes.

See all available data →

Try out all the features for free for 14 days

How to send TikTok Ads data to Google Sheets

Sync data automatically — no code, no manual exports.

Connect Your TikTok Ads Account

Log into Kondado and add TikTok Ads as a new data source by providing your authentication credentials to establish the connection.

Configure Google Sheets Destination

Select Google Sheets as your destination and specify the target workbook where your advertising data will be replicated.

Select Pipelines and Schedule

Choose from the seven available pipelines such as Campaign Report or Ad Group Report, then set your preferred update frequency from every 5 minutes to daily.

Try out all the features for free for 14 days