List
Read live records straight from the Amazon Ads API.
- Source
- Marketing Analytics
- Generally available
- 11 entities
Move Amazon Ads data anywhere it matters.
Pull Amazon Ads profiles, portfolios and sponsored brands ads into any warehouse or AI app.
Source
Amazon Ads
Snowflake
BigQuery
Postgres
Databricks
Claude
- Streams
- 21
- Entities
- 11
- Actions
- 3
- Destinations
- 50+
- Certified support
- 9.2.11
Overview
What is the Airbyte Amazon Ads connector?
The Airbyte Amazon Ads connector extracts data from Amazon Ads and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 21 streams you can select per connection.
- 01
Sync to your warehouse
Land 21 Amazon Ads tables in 50+ destinations on a schedule you control.
- 02
Context store search
Query synced Amazon Ads data with filters, sorting and semantic search, without spending Amazon Ads API rate limits.
- 03
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 04
One authorization
Authenticate Amazon Ads once. The same connection powers scheduled syncs and runtime actions.
21 streams
Every table you can sync from Amazon Ads
Profiles Sync modes FullIncr. Portfolios Sync modes FullIncr. Sponsored Brands Campaigns Sync modes FullIncr. Sponsored Brands Ad groups Sync modes FullIncr. Sponsored Brands Ads Sync modes FullIncr. Sponsored Brands Keywords Sync modes FullIncr.
Setup
Live in seven steps
Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
Click on the "Add Source" button and select "Amazon Ads" from the list of available connectors.
Enter a name for the connector and click on the "Next" button.
Enter your Amazon Ads credentials, including your access key ID, secret access key, and account ID.
Click on the "Test" button to ensure that the credentials are correct and that the connection is successful.
Once the test is successful, click on the "Save" button to save the connector and add it to your list of sources.
You can now use the Amazon Ads connector to extract data from your Amazon Ads account and integrate it with other tools and platforms.
Configuration fields
| Field | Type | Description |
|---|---|---|
| client_id* | string | The client ID of your Amazon Ads developer application. See the docs for more information. |
| client_secret* | string | The client secret of your Amazon Ads developer application. See the docs for more information. |
| refresh_token* | string | Amazon Ads refresh token. See the docs for more information on how to obtain this token. |
| auth_type | string | Not documented. |
| look_back_window | integer | The amount of days to go back in time to get the updated data from Amazon Ads |
| marketplace_ids | array | Marketplace IDs you want to fetch data for. Note: If Profile IDs are also selected, profiles will be selected if they match the Profile ID OR the Marketplace ID. |
| num_workers | integer | The number of worker threads to use for the sync. |
| profiles | array | Profile IDs you want to fetch data for. The Amazon Ads source connector supports only profiles with seller and vendor type, profiles with agency type will be ignored. See docs for more details. Note: If Marketplace IDs are also selected, profiles will be selected if they match the Profile ID OR the Marketplace ID. |
3 actions
Supported Amazon Ads actions
Get
Fetcha single record by ID.Context Store Search
Query synced data with filters and sorting, with no API rate limits.
Full parameter-level details live in the Amazon Ads entity reference.
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
Use cases
What teams build with Amazon Ads
List all my advertising profiles across marketplaces
Show me the profiles for my seller accounts
What marketplaces do I have advertising profiles in?
List all portfolios for one of my profiles
Show me all sponsored product campaigns
List all ad groups in my SP campaigns
Show me all keywords in my sponsored product campaigns
What product ads are currently running?
Show me all targeting clauses for my campaigns
List negative keywords across my ad groups
Show me all sponsored brands campaigns
List ad groups in my sponsored brands campaigns
What campaigns are currently enabled?
Find campaigns with a specific targeting type
Which ad groups have the highest default bid?
What keywords are using broad match type?
FAQ
Amazon Ads connector questions
Do I need more than one Amazon Ads connection?
No. One Amazon Ads authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.
Do Amazon Ads entity actions need a sync to run first?
No. Entity actions read and write through the Amazon Ads API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.
What data can I sync from Amazon Ads with Airbyte?
21 streams, including Profiles, Portfolios, Sponsored Brands Campaigns, Sponsored Brands Ad groups, Sponsored Brands Ads, Sponsored Brands Keywords, Sponsored Display Campaigns, Sponsored Display Ad groups and more.
Does the Amazon Ads connector support incremental sync?
Yes. The Amazon Ads connector supports incremental sync on selected streams, and full refresh on every stream.
Where can I run the Amazon Ads connector?
Run the Amazon Ads connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing Amazon Ads in minutes.
Free 14-day trial. One connection powers your scheduled syncs and your live Amazon Ads actions.