Marketing and ads
Connect Amazon Ads to DataxLand
The Amazon Ads connector reads advertising profiles, campaigns, ad groups and the daily reports of Sponsored Products, Sponsored Brands and Sponsored Display - spend, impressions, clicks and attributed sales. Combined with the Amazon Seller Partner connector, DataxLand puts ad spend next to the real net revenue of your Amazon orders after fees and refunds, so you see true ROAS and the gap between the sales Amazon Ads reports and the revenue you actually keep.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Amazon Ads
- Measure true ROAS of Amazon ads on net revenue, not just the ACOS in the ads console.
- Compare spend and click-through rate across Sponsored Products, Sponsored Brands and Sponsored Display.
- Add Amazon Ads spend to Google, Facebook and TikTok for one total ad spend figure.
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 |
|---|---|
| profiles | Advertising profiles per marketplace, with currency and time zone. |
| sponsored_product_campaigns | Sponsored Products campaigns, budgets and status. |
| sponsored_product_ad_groups | Sponsored Products ad groups. |
| sponsored_products_campaigns_report_stream_daily | Daily Sponsored Products campaign report - spend, impressions, clicks and attributed sales. |
| sponsored_brands_campaigns_report_stream_daily | Daily Sponsored Brands campaign report. |
| sponsored_display_campaigns_report_stream_daily | Daily Sponsored Display campaign report. |
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) |
| Fields to fill in | Client ID, Client Secret, Refresh Token |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector documentation ↗ |
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 |
| 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 Amazon Ads in 3 steps
- 1
Set up API access
Create a Login with Amazon app that has been granted Amazon Ads API access, and get the client ID, client secret and refresh token for your advertising account.
- 2
Add the source
In the workspace choose Add source, find Amazon Ads in the connector library, enter the client ID, client secret, refresh token, region and the profiles to read, then click Test connection.
- 3
Choose streams and review
Pick campaigns and daily reports; Si proposes how spend joins your Amazon channel and products, and you approve before the build.
Limits and caveats
- Your app needs Amazon Ads API access; DataxLand does not run the Amazon sign-in for you.
- Amazon generates ad reports asynchronously and restates them for a few days; the connector re-reads a recent window of days (look-back window).
- True ROAS needs a sales source as well, usually Amazon Seller Partner. This is an Airbyte connector (ELv2) run inside DataxLand.
Frequently asked questions
How is true ROAS different from ACOS?
ACOS is spend divided by the Amazon sales attributed to ads; true ROAS is real net revenue (after refunds) divided by spend, computed from your sales data.
Does it change bids?
No. DataxLand only reads advertising data.
Can I connect several marketplaces?
Yes. Select several profiles; each profile is one marketplace.
Dashboard templates that use this source
Connect Amazon Ads and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes