Amazon Ads
Use the Amazon Ads connector to sync Sponsored Products, Brands, Display, and related advertising data into your Athena lakehouse. Blotout runs the Airbyte Amazon Ads connector inside your deployment.
For connector reference (streams, regions, changelog), see the Airbyte Amazon Ads docs.
Prerequisites
Section titled “Prerequisites”- A tag with Blotout Cloud set up (green checkmark in the Tags table)
- An Amazon user with access to an Amazon Ads account
- Amazon Ads API credentials from the Amazon Ads API onboarding process:
- Client ID
- Client Secret
- Refresh Token
API onboarding can take several days. After it completes, Amazon provides the Client ID, Client Secret, and Refresh Token used below.
Create the pipeline
Section titled “Create the pipeline”Follow the shared Create a pipeline steps until the source catalogue appears, then select Amazon Ads.
Source configuration
Section titled “Source configuration”On the Source step, configure the connector:
| Field | Purpose |
|---|---|
| Schedule Type | How the pipeline runs — typically Scheduled |
| Sync Frequency | How often Airbyte syncs (for example, Every 24 hours) |
| Source Name | Name for this pipeline — used in the Athena schema <SOURCE_NAME>_<ENV> |
Authentication
Section titled “Authentication”Blotout Cloud authenticates Amazon Ads with OAuth developer credentials:
- Under Amazon Ads Configuration, enter Client ID, Client Secret, and Refresh Token from your Amazon Ads API application.
- Open Optional if you need to set:
- Region — North America (NA), Europe (EU), or Far East (FE)
- Start Date — report start date (
YYYY-MM-DD); defaults to yesterday UTC if omitted. Amazon Ads retains report data for about 60 days - Profile IDs — seller or vendor profiles to sync (agency profiles are ignored)
- Marketplace IDs — marketplaces to include
- Look Back Window — days to re-sync for late-arriving data (default 3)
Complete Schema and Summary
Section titled “Complete Schema and Summary”Continue through the Schema and Summary steps to choose streams and confirm the connection. Save and run the first sync.
After a successful sync, Airflow creates an organization-scoped DAG for the pipeline.
Related documentation
Section titled “Related documentation”- Data Pipelines overview — Tags-first create flow
- Airflow — DAG schedules and monitoring
- Airbyte Amazon Ads — streams and connector reference