TikTok Ads Source

Use this connector to import TikTok Ads data into your data warehouse.

You can:

• Land raw TikTok Ads data in your own warehouse — BigQuery, Snowflake, Redshift, Athena, or Databricks.
• Report at the grain you need: advertiser, campaign, ad group, or ad.
• Break daily performance down by country.
• Pull campaign, ad group, ad, and custom audience metadata alongside the numbers.
• Backfill history in runs of up to 31 days, then schedule the connector once and let it run.

Prerequisites

• A TikTok for Business account.
• A TikTok advertiser account you can access.
• An OWOX Data Marts storage.

Connect with OAuth, or with an access token from your own TikTok developer app. See Credentials.

See the OWOX guide to add a storage.

If you create your first connector, read the OWOX guide to create a connector-based Data Mart.

Choose a Reporting Grain

Data Level sets the reporting grain for the two performance endpoints. Choose it before you select fields. The field selector pins the matching unique-key fields, so rows merge correctly. The default is AUCTION_AD.

⚠️ Do not change Data Level after a run has loaded data into a table. New rows would merge on a different key structure. Use a new Data Mart or a new destination table instead.

For the unique keys per level, see Endpoints and Fields.

Table of Contents

• Credentials: connect with OAuth or an access token.
• Getting Started: create and run the Data Mart.
• Endpoints and Fields: choose endpoints and fields.
• Troubleshooting: fix import, permission, and destination table errors.
• Q&A: check community answers.

Support & Feedback

• Check Troubleshooting first.
• Search Q&A for existing answers.
• Open an issue to report a bug.
• Submit a feature request to request a change.

Other Data Sources

Looking for other data sources? See the full list of data sources.

License

This source is part of the OWOX Data Marts project and is distributed under the MIT license.