Learn how to set up and customize data exports from your TikTok advertising accounts to Google Sheets.
After connecting your TikTok account, you can configure exports to send your advertising data to Google Sheets. This allows you to analyze campaign performance, track video metrics, monitor engagement data, and create custom reports based on your TikTok advertising data.
Before configuring TikTok exports, make sure you have:
Follow these steps to create a new TikTok export:
From your dashboard, go to "Export Builder" and click "Create New Export".
Choose "TikTok Ads" from the list of available data sources.
If you have multiple ad accounts connected, select the ad account you want to export data from.
Select whether you want to export to Google Sheets or BigQuery, and choose your specific destination.
Click "Configure Export" to set up the specific data you want to export.
Once you've selected TikTok as your data source, you can configure the following settings:
Give your export a descriptive name that helps you identify it later. For example, "TikTok Campaign Performance" or "TikTok Video Analytics".
Choose the time period for your data export:
Choose which types of TikTok data you want to export:
Export campaign metadata including:
Export ad creative information including:
Export performance metrics including:
For each data type you select, you can choose which specific columns to include in your export:
After configuring your export, you can set up automatic schedules to keep your data up to date:
Make sure to set the correct time zone for your schedule to ensure data is exported at the right time for your business.
Choose how new data should be added to your destination:
TikTok exports are organized into separate sheets/tabs for different data types:
| Data Type | Description | Key Metrics | Use Cases |
|---|---|---|---|
| Campaigns | Campaign metadata and settings | Campaign ID, name, status, budget, objective | Campaign management, budget tracking |
| Ads | Ad creative information | Ad ID, name, format, creative type, CTA | Creative performance, ad optimization |
| Performance Insights | Performance metrics and analytics | Impressions, clicks, spend, video views, engagement | Performance analysis, ROI tracking |
TikTok data can take up to 24 hours to be fully available. Consider scheduling your exports to run daily to ensure you have the most recent data.
Video-specific metrics like video views and engagement rates are only available for video ads. Make sure to include these metrics if you're running video campaigns.
For performance insights, consider using shorter date ranges (7-30 days) to get more detailed data, while using longer ranges for campaign and ad metadata.
Start with the default columns and add more specific metrics as needed. This helps keep your exports manageable while ensuring you have the data you need.
If your export shows no data:
If your export fails to run:
If some expected data is missing:
Now that you've configured your TikTok export, you can:
