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
| Metric | How it is computed |
|---|---|
| Blended ROAS | Amazon net revenue ÷ Amazon Ads spend, same period |
| Platform-reported ROAS | Ad-attributed sales ÷ ad spendEquivalent to the inverse of ACOS. |
| Marketplace fees | Amazon referral and service fees from financial events |
| Net profit after fees and ads | Contribution 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.
| 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 |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line 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 | Amazon Ads only | Seller + Ads combined |
|---|---|---|
| What is my ACOS? | Yes | Yes, plus blended ROAS |
| Does the product still make money after FBA fees and ads? | No | Net profit after fees and ads |
| How much do Amazon fees take? | No | Marketplace fees ÷ net revenue |
Steps
- 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
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
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
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