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 |
|---|---|
| advertisers | Ad accounts, currency, time zone. |
| campaigns | Campaigns, objective, budget, status. |
| ad_groups | Ad groups, placements, budget. |
| ads | Ads and status. |
| campaigns_reports_daily | Daily numbers per campaign - spend, impressions, clicks, conversions. |
| ads_reports_daily | Daily numbers per ad. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Ad-reported vs actual revenue gap | Ad-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 revenue | Currency |
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
Connect TikTok Marketing in 4 steps
- 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
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
Choose streams
Keep campaigns, ads and daily reports; reports load incrementally.
- 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
Connect TikTok Marketing and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes