TikTok Marketing
This page contains the setup guide and reference information for the TikTok Marketing source connector.
For Airbyte Cloud:
- A Tiktok Ads Business account with permission to access data from accounts you want to sync
For Airbyte Open Source:
For the Production environment:
- Access token
- Secret
- App ID
To access the Sandbox environment:
- Access token
- Advertiser ID
- Create a TikTok For Business account: Link
- Create developer application: Link
- For a sandbox environment: create a Sandbox Ad Account Link
- Log into your Airbyte Cloud account.
- Click Sources and then click + New source.
- On the Set up the source page, select TikTok Marketing from the Source type dropdown.
- Enter a name for the TikTok Marketing connector.
- Select
OAuth2.0
Authorization method, then clickAuthenticate your account
. - Log in and Authorize to the Tiktok account
- Choose required Start date
- click
Set up source
.
- Navigate to the Airbyte Open Source dashboard.
- In the left navigation bar, click Sources. In the top-right corner, click + new source.
- On the Set up the source page, enter the name for the connector and select Tiktok Marketing from the Source type dropdown.
- Select
Production Access Token
orSandbox Access Token
Authorization method, then copy and paste info from step 1. - Choose required Start date
- Click
Set up source
.
The TikTok Marketing source connector supports the following sync modes:
- Full Refresh
- Incremental
Stream | Environment | Key | Incremental |
---|---|---|---|
Advertisers | Prod,Sandbox | advertiser_id | No |
AdGroups | Prod,Sandbox | adgroup_id | Yes |
Ads | Prod,Sandbox | ad_id | Yes |
Campaigns | Prod,Sandbox | campaign_id | Yes |
AdsReportsHourly | Prod,Sandbox | ad_id, stat_time_hour | Yes |
AdsReportsDaily | Prod,Sandbox | ad_id, stat_time_day | Yes |
AdsReportsLifetime | Prod,Sandbox | ad_id | No |
AdvertisersReportsHourly | Prod | advertiser_id, stat_time_hour | Yes |
AdvertisersReportsDaily | Prod | advertiser_id, stat_time_day | Yes |
AdvertisersReportsLifetime | Prod | advertiser_id | No |
AdGroupsReportsHourly | Prod,Sandbox | adgroup_id, stat_time_hour | Yes |
AdGroupsReportsDaily | Prod,Sandbox | adgroup_id, stat_time_day | Yes |
AdGroupsReportsLifetime | Prod,Sandbox | adgroup_id | No |
Audiences | Prod,Sandbox | audience_id | No |
CampaignsReportsHourly | Prod,Sandbox | campaign_id, stat_time_hour | Yes |
CampaignsReportsDaily | Prod,Sandbox | campaign_id, stat_time_day | Yes |
CampaignsReportsLifetime | Prod,Sandbox | campaign_id | No |
CreativeAssetsImages | Prod,Sandbox | image_id | Yes |
CreativeAssetsMusic | Prod,Sandbox | music_id | No |
CreativeAssetsPortfolios | Prod,Sandbox | creative_portfolio_id | No |
CreativeAssetsVideos | Prod,Sandbox | video_id | Yes |
AdvertiserIds | Prod | advertiser_id | No |
AdvertisersAudienceReportsDaily | Prod | advertiser_id, stat_time_day, gender, age | Yes |
AdvertisersAudienceReportsByCountryDaily | Prod | advertiser_id, stat_time_day, country_code | Yes |
AdvertisersAudienceReportsByPlatformDaily | Prod | advertiser_id, stat_time_day, platform | Yes |
AdvertisersAudienceReportsLifetime | Prod | advertiser_id, gender, age | No |
AdGroupAudienceReportsDaily | Prod,Sandbox | adgroup_id, stat_time_day, gender, age | Yes |
AdGroupAudienceReportsByCountryDaily | Prod,Sandbox | adgroup_id, stat_time_day, country_code | Yes |
AdGroupAudienceReportsByPlatformDaily | Prod,Sandbox | adgroup_id, stat_time_day, platform | Yes |
AdsAudienceReportsDaily | Prod,Sandbox | ad_id, stat_time_day, gender, age | Yes |
AdsAudienceReportsByCountryDaily | Prod,Sandbox | ad_id, stat_time_day, country_code | Yes |
AdsAudienceReportsByPlatformDaily | Prod,Sandbox | ad_id, stat_time_day, platform | Yes |
AdsAudienceReportsByProvinceDaily | Prod,Sandbox | ad_id, stat_time_day, province_id | Yes |
CampaignsAudienceReportsDaily | Prod,Sandbox | campaign_id, stat_time_day, gender, age | Yes |
CampaignsAudienceReportsByCountryDaily | Prod,Sandbox | campaign_id, stat_time_day, country_code | Yes |
CampaignsAudienceReportsByPlatformDaily | Prod,Sandbox | campaign_id, stat_time_day, platform | Yes |
TikTok Reporting API has some Data Latency, usually of about 11 hours. It is recommended to use higher values of attribution window (used in Incremental Syncs), at least 3 days, to ensure that the connector updates metrics in already presented records.
Reports synced by this connector can use either hourly, daily, or lifetime granularities for aggregating performance data. For example, if you select the daily-aggregation flavor of a report, the report will contain a row for each day for the duration of the report. Each row will indicate the number of impressions recorded on that day.
The connector is restricted by requests limitation. This connector should not run into TikTok Marketing API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.
Config fields reference
Expand to review
Version | Date | Pull Request | Subject |
---|---|---|---|
4.3.6 | 2024-10-12 | 46855 | Update dependencies |
4.3.5 | 2024-10-09 | 46676 | Fix error handling for codes 40100 and 50002 |
4.3.4 | 2024-10-05 | 46164 | Update dependencies |
4.3.3 | 2024-09-21 | 45790 | Update dependencies |
4.3.2 | 2024-09-14 | 45488 | Update dependencies |
4.3.1 | 2024-09-07 | 45270 | Update dependencies |
4.3.0 | 2024-09-03 | 44910 | Migrate to CDK v4 |
4.2.5 | 2024-08-31 | 44954 | Update dependencies |
4.2.4 | 2024-08-24 | 43783 | Update dependencies |
4.2.3 | 2024-08-19 | 44048 | Fix include_deleted toggle |
4.2.2 | 2024-08-03 | 42822 | Update dependencies |
4.2.1 | 2024-07-20 | 42375 | Update dependencies |
4.2.0 | 2024-07-17 | 42005 | Migrate to CDK v3.5.3 |
4.1.0 | 2024-07-17 | 42004 | Migrate to CDK v2.4.0 |
4.0.4 | 2024-07-13 | 41695 | Update dependencies |
4.0.3 | 2024-07-10 | 41370 | Update dependencies |
4.0.2 | 2024-07-09 | 41153 | Update dependencies |
4.0.1 | 2024-07-06 | 40915 | Update dependencies |
4.0.0 | 2024-07-01 | 38316 | Migration to low-code CDK; Support include deleted statuses for Ads, Ad Groups and Campaign streams. |
3.9.10 | 2024-06-25 | 40373 | Update dependencies |
3.9.9 | 2024-06-22 | 40133 | Update dependencies |
3.9.8 | 2024-06-06 | 39253 | [autopull] Upgrade base image to v1.2.2 |
3.9.7 | 2024-05-15 | 38250 | Replace AirbyteLogger with logging.Logger and upgrade to latest base image |
3.9.6 | 2024-04-19 | 36665 | Updating to 0.80.0 CDK |
3.9.5 | 2024-04-12 | 36665 | Schema descriptions |
3.9.4 | 2024-03-20 | 36302 | Don't extract state from the latest record if stream doesn't have a cursor_field |
3.9.3 | 2024-02-12 | 35161 | Manage dependencies with Poetry. |
3.9.2 | 2023-11-02 | 32091 | Fix incremental syncs; update docs; fix field type of preview_url_expire_time to date-time . |
3.9.1 | 2023-10-25 | 31812 | Update support level in metadata , removed duplicated tracking_pixel_id field from Ads stream schema |
3.9.0 | 2023-10-23 | 31623 | Add AdsAudienceReportsByProvince stream and expand base report metrics |
3.8.0 | 2023-10-19 | 31610 | Add Creative Assets and Audiences streams |
3.7.1 | 2023-10-19 | 31599 | Base image migration: remove Dockerfile and use the python-connector-base image |
3.7.0 | 2023-10-19 | 31493 | Add fields to Ads stream |
3.6.0 | 2023-10-18 | 31537 | Use default availability strategy |
3.5.0 | 2023-10-16 | 31445 | Apply minimum date restrictions |
3.4.1 | 2023-08-04 | 29083 | Added new is_smart_performance_campaign property to ad groups stream schema |
3.4.0 | 2023-07-13 | 27910 | Added include_deleted config param - include deleted ad_groups , ad , campaigns to reports |
3.3.1 | 2023-07-06 | 25423 | Add new fields to ad reports streams |
3.3.0 | 2023-07-05 | 27988 | Add category_exclusion_ids field to ad_groups schema. |
3.2.1 | 2023-05-26 | 26569 | Fixed syncs with advertiser_id provided in input configuration |
3.2.0 | 2023-05-25 | 26565 | Change default value for attribution window to 3 days; add min/max validation |
3.1.0 | 2023-05-12 | 26024 | Updated the Ads stream schema |
3.0.1 | 2023-04-07 | 24712 | Added attribution window for *-reports streams |
3.0.0 | 2023-03-29 | 24630 | Migrate to v1.3 API |
2.0.6 | 2023-03-30 | 22134 | Add country_code and platform audience reports. |
2.0.5 | 2023-03-29 | 22863 | Specified date formatting in specification |
2.0.4 | 2023-02-23 | 22309 | Add Advertiser ID to filter reports and streams |
2.0.3 | 2023-02-15 | 23091 | Add more clear log message for 504 error |
2.0.2 | 2023-02-02 | 22309 | Chunk Advertiser IDs |
2.0.1 | 2023-01-27 | 22044 | Set AvailabilityStrategy for streams explicitly to None |
2.0.0 | 2022-12-20 | 20415 | Update schema types for AudienceReports and BasicReports streams. |
1.0.1 | 2022-12-16 | 20598 | Remove Audience Reports with Hourly granularity due to deprecated dimension. |
1.0.0 | 2022-12-05 | 19758 | Convert mobile_app_id from integer to string in AudienceReport streams. |
0.1.17 | 2022-10-04 | 17557 | Retry error 50002 |
0.1.16 | 2022-09-28 | 17326 | Migrate to per-stream state |
0.1.15 | 2022-08-30 | 16137 | Fixed bug with normalization caused by unsupported nested cursor field |
0.1.14 | 2022-06-29 | 13890 | Removed granularity config option |
0.1.13 | 2022-06-28 | 13650 | Added video metrics to report streams |
0.1.12 | 2022-05-24 | 13127 | Fixed integration test |
0.1.11 | 2022-04-27 | 12838 | Added end date configuration for tiktok |
0.1.10 | 2022-05-07 | 12545 | Removed odd production authenication method |
0.1.9 | 2022-04-30 | 12500 | Improve input configuration copy |
0.1.8 | 2022-04-28 | 12435 | Updated spec descriptions |
0.1.7 | 2022-04-27 | 12380 | Fixed spec descriptions and documentation |
0.1.6 | 2022-04-19 | 11378 | Updated logic for stream initializations, fixed errors in schemas, updated SAT and unit tests |
0.1.5 | 2022-02-17 | 10398 | Add Audience reports |
0.1.4 | 2021-12-30 | 7636 | Add OAuth support |
0.1.3 | 2021-12-10 | 8425 | Update title, description fields in spec |
0.1.2 | 2021-12-02 | 8292 | Support reports |
0.1.1 | 2021-11-08 | 7499 | Remove base-python dependencies |
0.1.0 | 2021-09-18 | 5887 | Release TikTok Marketing CDK Connector |