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
- 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.
- 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-Scopeheader, one per advertising account and marketplace. - Request a report with
POST /reporting/reports, onereportTypeIdper ad product:spCampaigns,sbCampaignsandsdCampaigns, withtimeUnitset toDAILY. Generation can take up to three hours: pollGET /reporting/reports/{reportId}until the status isCOMPLETED, then download the gzipped JSON fromurl. - 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.
- Choose
groupByper ad product. Sponsored Products can be grouped by campaign, ad group or placement, Sponsored Brands by campaign only. - 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
- Your Amazon Ads user authorises the connection through your Odins onboarding link. Nothing is sent by email.
- We sync every day, watch the pipeline and maintain it as Amazon's API changes.
- You get spend per campaign per day, in the same structure as every other channel.
- 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
| Report | What it returns | Good 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 table | For Amazon Ads |
|---|---|
| Date | Daily |
| Company and market | Set by your routing rules on campaign names |
| Channel and media | Follows your media plan |
| Source campaign | Campaign |
| Spend | Cost, excluding VAT |
Raw layer
As Amazon returns itDaily 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.
In Odins
Reporting across every channel, and a model that shows what retail media contributes and where more spend still pays.
Through your AI assistant
Connect Claude, ChatGPT or Copilot to Odins with MCP and ask for the numbers in plain language.
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.
-1.png?width=1132&height=292&name=Asset%201@2x%20(12)-1.png)