Skip to content

Marketing and ads

Connect TikTok Marketing to DataxLand

The TikTok Ads connector (TikTok Marketing API) reads advertiser accounts, campaigns, ad groups, ads and daily performance reports - spend, impressions, clicks, conversions and the conversion value TikTok reports. Many shops run TikTok ads to drive orders to TikTok Shop or their website; DataxLand puts that spend next to real net revenue after platform fees and returns, so you see true ROAS instead of only the number in TikTok Ads Manager.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with TikTok Marketing

  • Combine TikTok Ads with TikTok Shop for true ROAS by day and campaign.
  • Compare CPM and click-through rate of TikTok with Facebook and Google in one table.
  • See the gap between TikTok-reported revenue and net revenue actually received.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
advertisersAd accounts, currency, time zone.
campaignsCampaigns, objective, budget, status.
ad_groupsAd groups, placements, budget.
adsAds and status.
campaigns_reports_dailyDaily numbers per campaign - spend, impressions, clicks, conversions.
ads_reports_dailyDaily numbers per ad.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Marketing spendTotal cost of marketing campaigns by spend date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)

Connect TikTok Marketing in 4 steps

  1. 1

    Get an access token

    Create an app on TikTok for Business Developers with ads read scope, authorise your ad accounts and get an access token; note the App ID and Secret.

  2. 2

    Add the source

    In the workspace choose Add source, find TikTok Marketing in the connector library, enter App ID, Secret, access token (and Advertiser ID to read one account only), click Test connection.

  3. 3

    Choose streams

    Keep campaigns, ads and daily reports; reports load incrementally.

  4. 4

    Review Si's mapping

    Si proposes how spend joins your TikTok Shop or website channel; you approve and build.

Limits and caveats

  • TikTok Ads is a different source from TikTok Shop; connect both for true ROAS on shop revenue.
  • DataxLand does not run the TikTok for Business sign-in for you; you paste your app's access token into the form.
  • Conversions depend on the attribution window you choose and TikTok may update them for a few days.
  • This is an Airbyte connector (ELv2 license) run inside DataxLand; a paid plan is required.

Frequently asked questions

Are TikTok Shop GMV Max ads included?

The connector reads what the TikTok Marketing API returns for the ad account; numbers only shown in Seller Center are not available here.

Does it change my ad account?

No. DataxLand only reads numbers; it never creates or edits ads.

What about several ad accounts?

Leave Advertiser ID empty to read every account the token is authorised for.

Dashboard templates that use this source

Ask Si about your TikTok Marketing data →TikTok Marketing + TikTok Shop →All data sources →

Connect TikTok Marketing and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes