Combine TikTok Shop with TikTok Ads to know whether your ads make money
Shops run TikTok ads to push videos and livestreams to their TikTok Shop cart. Ads Manager reports conversion value, but the money you keep after marketplace fees, payment fees, discounts and returns sits in TikTok Shop settlements. With both sources combined, DataxLand puts daily TikTok Ads spend next to TikTok Shop net revenue and contribution margin, and computes blended ROAS, the gap between what the ads report and the real figure, and profit after ads are subtracted too. You know which campaigns deserve more budget and which only look good in the report.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Livestream orders have higher cancellation and return rates; conversion value reported before cancellations and returns does not reflect that.
- TikTok Shop marketplace and payment fees change with each program; profit after ads must be counted after these fees.
- Both sources belong to TikTok but sit in separate accounts; only combining them gives one shared profit number.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Blended ROAS | TikTok Shop net revenue ÷ TikTok Ads spend, same periodRevenue already excludes discounts, cancellations and returns. |
| Platform-reported ROAS | Conversion value reported by TikTok Ads ÷ ad spendKept for comparison with blended ROAS, not for decisions on its own. |
| Ad-reported vs actual revenue gap | Reported conversion value − net revenue |
| Net profit after fees and ads | Contribution margin − allocated ad spendAllocated by revenue share when a campaign is not tied to a product. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / 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 |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
Questions you can answer
| Question | TikTok Ads only | TikTok Shop + TikTok Ads combined |
|---|---|---|
| How much do the ads bring in? | Reported conversion value | Net revenue after cancellations and returns |
| Does the campaign make money? | Marketplace fees and cost unknown | Net profit after fees and ads |
| How far off is the reported figure? | Not visible | Ad-reported vs actual revenue gap |
Steps
- 1
Connect TikTok Shop
Click Connect with TikTok Shop, sign in to your seller account and grant read access to orders, settlements, returns and products.
- 2
Connect TikTok Ads
Enter the app ID, secret, access token and advertiser ID from TikTok for Business; DataxLand reads campaigns and daily reports.
- 3
Review Si's mapping
Si proposes how ad spend joins the TikTok Shop channel by day, and by product if campaign names carry a SKU code; you approve.
- 4
Build and read the dashboards
The Ads dashboard shows reported ROAS next to blended ROAS and profit after ads by day; set an alert when blended ROAS drops sharply.
Frequently asked questions
Can I get ROAS per video or per livestream?
Yes, when campaigns or ad groups are named with a product code or live session code that Si recognizes during review. Without a code, DataxLand computes by day and channel, then allocates to products by revenue.
Are GMV Max and in-marketplace ads read?
DataxLand reads whatever the TikTok Marketing API returns for your ad account. Campaign types for which the API returns no metrics are not in the warehouse; Si says so clearly when data is missing.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect TikTok Shop →Connect TikTok Marketing →Ask Si about your TikTok Shop data →Ask Si about your TikTok Marketing data →
Other combinations
Combine TikTok Shop and TikTok Marketing in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes