Skip to content
+

Combine Amazon Seller with Amazon Ads to see profit after advertising on Amazon

When you sell on Amazon, revenue and Amazon fees (referral fees, FBA fees) live in Seller Central, while Sponsored Products and Sponsored Brands spend lives in Amazon Ads. The two accounts are separate, so the ACOS report only compares spend with the sales the ads console attributes to ads. DataxLand reads orders, financial events and sales reports from the Selling Partner API together with Amazon Ads reports, puts spend next to real net revenue and real fees, and computes blended ROAS and net profit after fees and ads by day, and by product when the ad report includes the ASIN.

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

Why combine

  • ACOS only looks at ad-attributed sales and ignores Amazon fees and cost of goods.
  • FBA and referral fees differ by product, so profit after ads can look very different from ACOS.
  • Joining on ASIN shows which products need their ads cut even when ACOS looks fine.

Metrics you only get by combining

MetricHow it is computed
Blended ROASAmazon net revenue ÷ Amazon Ads spend, same period
Platform-reported ROASAd-attributed sales ÷ ad spendEquivalent to the inverse of ACOS.
Marketplace feesAmazon referral and service fees from financial events
Net profit after fees and adsContribution margin − allocated ad spendWhen the ad report has the ASIN, spend is allocated by product; otherwise by revenue share.

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
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
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

QuestionAmazon Ads onlySeller + Ads combined
What is my ACOS?YesYes, plus blended ROAS
Does the product still make money after FBA fees and ads?NoNet profit after fees and ads
How much do Amazon fees take?NoMarketplace fees ÷ net revenue

Steps

  1. 1

    Connect Amazon Seller

    Enter the LWA client ID, client secret, refresh token, region and seller account type of your Selling Partner API app.

  2. 2

    Connect Amazon Ads

    Enter the client ID, client secret and refresh token of the Amazon Ads API, and pick the profiles and region to read.

  3. 3

    Review Si's mapping

    Si proposes how ASINs and SKUs match across the two sources and how financial events are read as fees; you approve.

  4. 4

    Build and read the dashboards

    The Ads, Products and P&L overview dashboards show reported ROAS, blended ROAS and profit after ads by product.

Frequently asked questions

Do I need my own Selling Partner API app?

Yes. The Amazon Seller connector needs the LWA client ID, client secret and refresh token of an SP-API app that you register and authorize for your seller account. DataxLand only reads.

Are Amazon reports delayed?

Some Amazon reports are generated asynchronously and arrive with a delay, so the last few days can still change. DataxLand reloads the recent window on every refresh to keep them up to date.

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 Amazon Seller Partner →Connect Amazon Ads →Ask Si about your Amazon Seller Partner data →Ask Si about your Amazon Ads data →

Combine Amazon Seller Partner and Amazon Ads in minutes

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