<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=9151474&amp;fmt=gif">
Skip to content

Connector · Retail media

Amazon Ads data, collected and structured for you.

Odins pulls your Amazon Ads campaign spend every day and structures it per campaign with the rest of your media data. Use it in Odins, in your own warehouse, or through your AI assistant.

Fully managed · reviewed November 2026

Two ways to get Amazon Ads data out.

The Amazon Ads API covers sponsored ads, streaming TV and display, and Amazon charges no additional fee for it. The work sits in access and reporting: Amazon approves each application, and reports are requested per ad product for a limited number of days.

Build and run it yourself

  1. Create a Login with Amazon application, then apply for Amazon Ads API access. Approval may take up to one business day, and the access is then assigned to your application.
  2. Keep the tokens fresh. An access token is valid for 60 minutes and a refresh token gets you the next one. Each call also carries a profile ID in the Amazon-Advertising-API-Scope header, one per advertising account and marketplace.
  3. Request a report with POST /reporting/reports, one reportTypeId per ad product: spCampaigns, sbCampaigns and sdCampaigns, with timeUnit set to DAILY. Generation can take up to three hours: poll GET /reporting/reports/{reportId} until the status is COMPLETED, then download the gzipped JSON from url.
  4. Split history into windows. One report covers at most 31 days, and Amazon keeps 95 days for Sponsored Products, 65 for Sponsored Display and 60 for Sponsored Brands.
  5. Choose groupBy per ad product. Sponsored Products can be grouped by campaign, ad group or placement, Sponsored Brands by campaign only.
  6. Map campaigns to your own markets and product lines, and line them up with the rest of your media data.

Then monitor it, watch for refresh tokens that expire 365 days after the advertiser gave consent, and move to Amazon's new reporting API before version 3 is deprecated on June 30, 2027.

Have Odins run it

  1. Your Amazon Ads user authorises the connection through your Odins onboarding link. Nothing is sent by email.
  2. We sync every day, watch the pipeline and maintain it as Amazon's API changes.
  3. You get spend per campaign per day, in the same structure as every other channel.
  4. The connection requests the last 59 days. Older history is loaded from an export when you ask: campaign name and spend per day.

The same goes for every other source you use. One team runs all of them. See all connectors

What the Amazon Ads API offers.

Reporting version 3 serves performance data as reports, with one report type per ad product. These are the campaign reports. Amazon's own documentation is the reference.

POST /reporting/reports

ReportWhat it returnsGood to know
spCampaigns Sponsored Products per campaign, with cost, impressions, clicks, purchases and sales among the metrics. Kept for 95 days. Can also be grouped by ad group or placement.
sbCampaigns Sponsored Brands per campaign. Kept for 60 days. Grouped by campaign only. Still in preview.
sdCampaigns Sponsored Display per campaign. Kept for 65 days. Can also be grouped by matched target.
dspCampaign Amazon DSP per campaign, ad or creative. Kept for 95 days.
  • Auth Login with Amazon, access tokens valid 60 minutes
  • Format Gzipped JSON, and CSV for Amazon DSP
  • Window 31 days per report
  • Retention 60 to 95 days by ad product

Worth knowing about Amazon Ads data.

Amazon keeps 60 to 95 days of report data.

Amazon keeps campaign report data for 95 days for Sponsored Products, 65 for Sponsored Display and 60 for Sponsored Brands. Odins requests the last 59 days. Older spend has to come from your exports.

Each ad product is its own report.

Sponsored Products, Sponsored Brands and Sponsored Display have separate report types, each with its own groupings and retention. A total for Amazon Ads means requesting each of them.

Version 3 has an end date.

Amazon's documentation says reporting version 3 will be deprecated on June 30, 2027 and tells developers to migrate to its new reporting API.

Spend arrives without VAT.

Ad platforms report spend excluding VAT, and Amazon Ads spend is handled the same way. Check that the sales you compare it with use the same basis.

What you get back.

Two layers. The raw one mirrors Amazon Ads. The structured one is the table every source lands in, organised by your own markets and product lines.

Structured layer

Per campaign, per day
In the structured tableFor Amazon Ads
DateDaily
Company and marketSet by your routing rules on campaign names
Channel and mediaFollows your media plan
Source campaignCampaign
SpendCost, excluding VAT

Raw layer

As Amazon returns it

Daily campaign report rows as the Amazon Ads API returns them.

Use it where you work.

In your warehouse

Raw and structured tables delivered to BigQuery, Snowflake, Redshift or Databricks. Some customers use Odins for this alone.

How data integration works

In Odins

Reporting across every channel, and a model that shows what retail media contributes and where more spend still pays.

See the platform

Through your AI assistant

Connect Claude, ChatGPT or Copilot to Odins with MCP and ask for the numbers in plain language.

How the Odins MCP works

Questions.

Does Amazon Ads have an API?

Yes. The Amazon Ads API covers sponsored ads, streaming TV and display. To call it yourself, you create a Login with Amazon application and apply for API access, and approval may take up to one business day.

How do I get Amazon Ads data into BigQuery?

Your Amazon Ads user authorises the connection through your Odins onboarding link. Odins syncs daily and delivers raw and structured tables to BigQuery, Snowflake, Redshift or Databricks, with no report jobs for you to build or maintain.

How far back does Amazon Ads data go?

Amazon keeps campaign report data for 60 to 95 days, depending on the ad product. Odins requests the last 59 days. Older history comes from your own exports.

Is Amazon Ads reporting version 3 being deprecated?

Yes. Amazon's documentation says reporting version 3 will be deprecated on June 30, 2027 and tells developers to migrate to its new reporting API.

Your sources

Send us your list of sources.

Tell us which platforms you use. We reply with what is covered, how access works and what you get back.

Send your list
The Odins letter

Where marketing budgets work hardest, once a month.

One short email: a question about marketing investment, answered with numbers, and what it means for the next budget decision.

  • One email a month
  • Written by the team that builds and runs the models

Protected by reCAPTCHA: Google's Privacy Policy and Terms apply.