Connectors

/

Amazon Ads

Data replication

Sync Amazon Ads data anywhere.

Amazon Advertising, or Amazon Pay-Per-Click (PPC) advertising, is becoming a significant threat to both Facebook and Google's monopoly on the PPC market share. Consumers of all sorts use Amazon to check and compare prices, find new products, begin product searches, and make immediate purchases. Amazon itself claims that 76% of its shoppers use the search bar to find an item, opening the door to PPC advertising. This allows sellers and brands to reach a wide range of consumers while they shop, which means they are often already in the buying phase of the consumer journey. With over 300 million active customer accounts, leveraging this powerful advertising channel is undeniably integral to any e-commerce campaign. Not to mention, Amazon is only getting bigger. Amazon Advertising positions your brand ahead of the competition, and your business should be taking full advantage of this platform. Below, we’ve put together a comprehensive guide to further your knowledge and understanding of Amazon Advertising tools, products, and opportunities to equip your brand with the necessary knowledge to maximize its reach and boost results.

  • Certified
  • Generally available
  • 21 streams
  • 11 entities
Sync Amazon Ads dataRead the docs
Amazon Ads

One connector

Everything Amazon Ads can do in Airbyte

  • Sync to your warehouse

    Land 21 Amazon Ads tables in 50+ destinations on a schedule you control.

  • Context store search

    Query synced Amazon Ads data with filters, sorting and semantic search, without spending Amazon Ads API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Amazon Ads once. The same connection powers scheduled syncs and runtime actions.

Specifications

What to know before you sync Amazon Ads

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version9.0.7
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 7 steps

  1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
  2. Click on the "Add Source" button and select "Amazon Ads" from the list of available connectors.
  3. Enter a name for the connector and click on the "Next" button.
  4. Enter your Amazon Ads credentials, including your access key ID, secret access key, and account ID.
  5. Click on the "Test" button to ensure that the credentials are correct and that the connection is successful.
  6. Once the test is successful, click on the "Save" button to save the connector and add it to your list of sources.
  7. You can now use the Amazon Ads connector to extract data from your Amazon Ads account and integrate it with other tools and platforms.

21 streams

Every table you can sync from Amazon Ads

  • Profiles

  • Portfolios

  • Sponsored Brands Campaigns

  • Sponsored Brands Ad groups

  • Sponsored Brands Ads

  • Sponsored Brands Keywords

  • Sponsored Display Campaigns

  • Sponsored Display Ad groups

  • Sponsored Display Product Ads

  • Sponsored Display Targetings

  • Sponsored Display Creatives

  • Sponsored Display Budget Rules

  • Sponsored Products Campaigns

  • Sponsored Products Ad groups

  • Sponsored Products Ad Group Bid Recommendations

  • Sponsored Products Ad Group Suggested Keywords

  • Sponsored Products Keywords

  • Sponsored Products Negative keywords

  • Sponsored Products Campaign Negative keywords

  • Sponsored Products Ads

  • Sponsored Products Targetings

3 actions

Supported Amazon Ads actions

  • List

    Read live records straight from the Amazon Ads API.

  • Get

    Fetch a 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.

Authentication

Authenticate Amazon Ads once

  • API credentials

    Requires Client ID, Client Secret and Refresh Token.

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?

Explore

Related connectors

AppsFlyerMarketing AnalyticsStandard Sources cloudself-managed-enterprise
BigMailerMarketing AnalyticsStandard Sources cloudself-managed-enterprise
Bing AdsMarketing AnalyticsCertified Sources cloudself-managed-enterprise
BitlyMarketing AnalyticsStandard Sources cloudself-managed-enterprise
BloggerMarketing AnalyticsStandard Sources cloudself-managed-enterprise
BrazeMarketing AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

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.

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.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Amazon Ads API provides access to a wide range of data related to advertising campaigns on Amazon. The following are the categories of data that can be accessed through the API:

1. Campaign data: This includes information about the campaigns such as campaign name, start and end dates, budget, targeting options, and bid strategy.
2. Ad group data: This includes information about the ad groups such as ad group name, targeting options, and bid strategy.
3. Keyword data: This includes information about the keywords such as keyword match type, bid, and performance metrics.
4. Product data: This includes information about the products being advertised such as product name, ASIN, and product category.
5. Performance data: This includes information about the performance of the campaigns, ad groups, keywords, and products such as impressions, clicks, conversions, and cost.
6. Audience data: This includes information about the audiences being targeted such as demographics, interests, and behaviors.
7. Inventory data: This includes information about the inventory being advertised such as availability, pricing, and product details.

Overall, Amazon Ads API provides access to a comprehensive set of data that can be used to optimize advertising campaigns and improve performance.

1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Add Source" button and select "Amazon Ads" from the list of available connectors.
3. Enter a name for the connector and click on the "Next" button.
4. Enter your Amazon Ads credentials, including your access key ID, secret access key, and account ID.
5. Click on the "Test" button to ensure that the credentials are correct and that the connection is successful.
6. Once the test is successful, click on the "Save" button to save the connector and add it to your list of sources.
7. You can now use the Amazon Ads connector to extract data from your Amazon Ads account and integrate it with other tools and platforms.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Amazon Ads data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Amazon Ads actions.

Try it freeTalk to sales