TikTok Ads Source

This source allows you to import data from the TikTok Ads platform into Google Sheets / Google BigQuery. It provides access to advertiser information, campaigns, ad groups, ads, performance metrics, and custom audiences.

Features

• Account Data: Import advertiser account information
• Campaign Structure: Access campaigns, ad groups, and ads data
• Performance Metrics: Import impressions, clicks, spend, conversions, and more
• Custom Audiences: Access audience data for targeting and remarketing
• Scheduled Imports: Set up daily or hourly data refreshes
• Selectable Objects: Choose which data objects to import (advertisers, campaigns, ad groups, etc.)
• Incremental Loading: Update only the latest data to optimize performance
• Error Handling: Robust error handling with rate limit protection
• Data Cleanup: Automatic cleanup of old data

Documentation

• Getting Started Guide - Instructions for setting up and using the source
• Authentication Guide - How to obtain and set up TikTok API credentials

Data Available

The source provides access to the following data types:

1. Advertiser Information

   • Account details
   • Basic information about the advertiser
   • Balance and currency information

2. Campaigns

   • Campaign structure
   • Budget information
   • Status and targeting
   • Performance optimization settings

3. Ad Groups

   • Ad group settings
   • Bidding and budget information
   • Targeting criteria
   • Placement information

4. Ads

   • Creative information
   • Status and settings
   • Landing page URLs
   • Call-to-action elements

5. Performance Metrics

   • Impressions, clicks, CTR
   • Spend and conversions
   • Video views and engagement metrics
   • Advanced metrics like video completion rates

6. Custom Audiences

   • Audience details and size
   • Audience type information
   • Creation and expiration dates
   • Validity status

Requirements

• A Google account with access to Google Sheets
• A TikTok Business account with advertiser-level access
• For the Google BigQuery template:
  • A Google Cloud project with access to BigQuery
• An API access token with the necessary permissions to retrieve TikTok Ads data

Setup

1. Make a copy of the TikTok Ads Source template
2. Configure your API credentials and desired fields
3. Run the source manually or set up a schedule

For detailed setup instructions, see the Getting Started Guide.

Support & Feedback

• Having issues? Check the Q&A Section first.
• Found a bug? Open an issue
• Want to suggest a feature or a new integration? Submit a request

Other Data Sources

Looking for other data sources? Check out our full list of data sources.

License

This source is part of the OWOX Data Marts project and is distributed under the ELv2 license. See the LICENSE file for details.