Skip to content
+

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

MetricHow it is computed
Blended ROASTikTok Shop net revenue ÷ TikTok Ads spend, same periodRevenue already excludes discounts, cancellations and returns.
Platform-reported ROASConversion value reported by TikTok Ads ÷ ad spendKept for comparison with blended ROAS, not for decisions on its own.
Ad-reported vs actual revenue gapReported conversion value − net revenue
Net profit after fees and adsContribution 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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / 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
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency

Questions you can answer

QuestionTikTok Ads onlyTikTok Shop + TikTok Ads combined
How much do the ads bring in?Reported conversion valueNet revenue after cancellations and returns
Does the campaign make money?Marketplace fees and cost unknownNet profit after fees and ads
How far off is the reported figure?Not visibleAd-reported vs actual revenue gap

Steps

  1. 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. 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. 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. 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