Skip to content

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
profilesAdvertising profiles per marketplace, with currency and time zone.
sponsored_product_campaignsSponsored Products campaigns, budgets and status.
sponsored_product_ad_groupsSponsored Products ad groups.
sponsored_products_campaigns_report_stream_dailyDaily Sponsored Products campaign report - spend, impressions, clicks and attributed sales.
sponsored_brands_campaigns_report_stream_dailyDaily Sponsored Brands campaign report.
sponsored_display_campaigns_report_stream_dailyDaily Sponsored Display campaign report.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inClient ID, Client Secret, Refresh Token
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector 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.

MetricDefinitionUnit
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / 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
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)

Connect Amazon Ads in 3 steps

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

Ask Si about your Amazon Ads data →Amazon Ads + Amazon Seller Partner →All data sources →

Connect Amazon Ads and get verified dashboards

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