Skip to content

Latest commit

 

History

History
150 lines (128 loc) · 15.9 KB

amazon-ads.md

File metadata and controls

150 lines (128 loc) · 15.9 KB
Raw

Amazon Ads

This page contains the setup guide and reference information for the Amazon Ads source connector.

Prerequisites

  • Client ID
  • Client Secret
  • Refresh Token
  • Region
  • Start Date (Optional)
  • Profile IDs (Optional)

Setup guide

Step 1: Set up Amazon Ads

Create an Amazon user with access to Amazon Ads account.

For Airbyte Open Source: To use the Amazon Ads API, you must first complete the onboarding process. The onboarding process has several steps and may take several days to complete. After completing all steps you will have to get Amazon client application Client ID, Client Secret and Refresh Token.

Step 2: Set up the Amazon Ads connector in Airbyte

For Airbyte Cloud:

  1. Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select Amazon Ads from the Source type dropdown and enter a name for this connector.
  4. Click Authenticate your Amazon Ads account.
  5. Log in and Authorize to the Amazon account.
  6. Select Region to pull data from North America (NA), Europe (EU), Far East (FE). See docs for more details.
  7. Start Date (Optional) is used for generating reports starting from the specified start date. Should be in YYYY-MM-DD format and not more than 60 days in the past. If not specified today's date is used. The date is treated in the timezone of the processed profile.
  8. Profile IDs (Optional) you want to fetch data for. See docs for more details.
  9. Click Set up source.

For Airbyte Open Source:

  1. Client ID of your Amazon Ads developer application. See onboarding process for more details.
  2. Client Secret of your Amazon Ads developer application. See onboarding process for more details.
  3. Refresh Token. See onboarding process for more details.

Supported sync modes

The Amazon Ads source connector supports the following sync modes:

  • Full Refresh
  • Incremental

Supported Streams

This source is capable of syncing the following streams:

Connector-specific features and highlights

All the reports are generated relative to the target profile' timezone.

Campaign reports may sometimes have no data or not presenting in records. This can occur when there are no clicks or views associated with the campaigns on the requested day - details.

Report data synchronization only cover the last 60 days - details.

Performance considerations

Information about expected report generation waiting time you may find here.

Data type mapping

Integration Type Airbyte Type
string string
int, float, number number
date date
datetime datetime
array array
object object

CHANGELOG

Version Date Pull Request Subject
3.1.1 2023-08-28 29900 Add 404 handling for no assotiated with bid ad groups
3.1.0 2023-08-08 00000 Add T00030 tactic support for sponsored_display_report_stream
3.0.0 2023-07-24 27868 Fix attribution report stream schemas
2.3.1 2023-07-11 28155 Bugfix: validation error when record values are missing
2.3.0 2023-07-06 28002 Add sponsored_product_ad_group_suggested_keywords, sponsored_product_ad_group_bid_recommendations streams
2.2.0 2023-07-05 27607 Add stream for sponsored brands v3 purchased product reports
2.1.0 2023-06-19 25412 Add sponsored_product_campaign_negative_keywords, sponsored_display_budget_rules streams
2.0.0 2023-05-31 25874 Type portfolioId as integer
1.1.0 2023-04-22 25412 Add missing reporting metrics
1.0.6 2023-05-09 25913 Small schema fixes
1.0.5 2023-05-08 25885 Improve error handling for attribution_report(s) streams
1.0.4 2023-05-04 25792 Add availability strategy for basic streams (not including report streams)
1.0.3 2023-04-13 25146 Validate pk for reports when expected pk is not returned
1.0.2 2023-02-03 22355 Migrate products_report stream to API v3
1.0.1 2022-11-01 18677 Add optional config report_record_types
1.0.0 2023-01-30 21677 Fix bug with non-unique primary keys in report streams. Add asins_keywords and asins_targets
0.1.29 2023-01-27 22038 Set AvailabilityStrategy for streams explicitly to None
0.1.28 2023-01-18 19491 Add option to customize look back window value
0.1.27 2023-01-05 21082 Fix bug with handling: "Report date is too far in the past." - partial revert of #20662
0.1.26 2022-12-19 20662 Fix bug with handling: "Report date is too far in the past."
0.1.25 2022-11-08 18985 Remove "report_wait_timeout", "report_generation_max_retries" from config
0.1.24 2022-10-19 17475 Add filters for state on brand, product and display campaigns
0.1.23 2022-09-06 16342 Add attribution reports
0.1.22 2022-09-28 17304 Migrate to per-stream state.
0.1.21 2022-09-27 17202 Improved handling if known reporting errors
0.1.20 2022-09-08 16453 Increase report_wait_timeout 30 -> 60 minutes
0.1.19 2022-08-31 16191 Improved connector's input configuration validation
0.1.18 2022-08-25 15951 Skip API error "Tactic T00020 is not supported for report API in marketplace A1C3SOZRARQ6R3."
0.1.17 2022-08-24 15921 Skip API error "Report date is too far in the past."
0.1.16 2022-08-23 15822 Set default value for region if needed
0.1.15 2022-08-20 15816 Update STATE of incremental sync if no records
0.1.14 2022-08-15 15637 Generate slices by lazy evaluation
0.1.12 2022-08-09 15469 Define primary_key for all report streams
0.1.11 2022-07-28 15031 Improve report streams date-range generation
0.1.10 2022-07-26 15042 Update additionalProperties field to true from schemas
0.1.9 2022-05-08 12541 Improve documentation for Beta
0.1.8 2022-05-04 12482 Update input configuration copy
0.1.7 2022-04-27 11730 Update fields in source-connectors specifications
0.1.6 2022-04-20 11659 Add adId to products report
0.1.5 2022-04-08 11430 Add support OAuth2.0
0.1.4 2022-02-21 10513 Increasing REPORT_WAIT_TIMEOUT for supporting report generation which takes longer time
0.1.3 2021-12-28 8388 Add retry if recoverable error occured for reporting stream processing
0.1.2 2021-10-01 6367 Add option to pull data for different regions. Add option to choose profiles we want to pull data. Add lookback
0.1.1 2021-09-22 6367 Add seller and vendor filters to profiles stream
0.1.0 2021-08-13 5023 Initial version