# Amazon Ads

Amazon Ads is a powerful advertising platform for sellers and vendors on Amazon. With Coupler.io, you can automatically pull campaign performance data, search terms, targeting information, and product reports into your spreadsheets, BI tools, and databases on a schedule.

Why connect Amazon Ads to Coupler.io?

* **Centralized reporting** — Pull data from multiple Amazon Ads accounts into one destination
* **Automated updates** — Schedule daily, weekly, or monthly refreshes without manual exports
* **Flexible report types** — Access campaign, ad group, search term, targeting, and product performance reports
* **Multi-destination support** — Send data to Google Sheets, Excel, BigQuery, Looker Studio, Power BI, or AI destinations like Claude and ChatGPT

## Prerequisites

Before you connect Amazon Ads to Coupler.io, make sure you have:

* An active Amazon Ads account with advertiser access
* Permission to view reports and campaign data in your Amazon Ads account
* A destination ready (Google Sheets, Excel, BigQuery, Power BI, Looker Studio, or an AI destination like Claude)

## Quick start

{% hint style="success" %}
We recommend starting with a **Campaign performance by campaigns** report for a single account and a 7-day date range. This gives you a quick win to test the data flow before scaling to larger date ranges or multiple accounts.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Sign in to Coupler.io** and create a new data flow. Select **Amazon Ads** as your source.
{% endstep %}

{% step %}
**Authorize with Amazon.** Click "Connect" and you'll be redirected to Amazon's login page. Sign in with your Amazon account and grant Coupler.io permission to access your advertising data. You'll be returned to Coupler.io once authorized.
{% endstep %}

{% step %}
**Select your Amazon Ads account(s).** Choose the advertiser accounts from which you want to pull data. You can select one or multiple accounts — if pulling from several, Coupler.io will append the data together.
{% endstep %}

{% step %}
**Choose a report type.** Select from available report types like "Campaign performance by campaigns," "Search terms report," or "Advertised products report."
{% endstep %}

{% step %}
**Set your report period.** Use the date pickers to define your start and end dates. Note: Amazon Ads API allows a maximum of 31 consecutive days per request. For longer periods, set a date range within this limit or use the "Totals only" split option.
{% endstep %}

{% step %}
**Choose your metrics.** Select which metrics to include in your report (e.g., impressions, clicks, spend, conversion value). Different report types offer different metric options.
{% endstep %}

{% step %}
**Pick your destination.** Choose where your data will land — Google Sheets, Excel, BigQuery, Power BI, Looker Studio, or an AI destination like Claude or ChatGPT.
{% endstep %}

{% step %}
**Run your data flow.** Click "Run" to execute a manual test. Once successful, you can schedule the data flow to run automatically on your preferred cadence.
{% endstep %}
{% endstepper %}

{% hint style="info" %}
A successful manual run is required before you can schedule your data flow to run automatically.
{% endhint %}

## Available report types

| Report Type                                 | Best For                             | Key Metrics                                   |
| ------------------------------------------- | ------------------------------------ | --------------------------------------------- |
| Campaign performance by campaigns           | High-level campaign ROI analysis     | Impressions, clicks, spend, sales, ACOS       |
| Campaign performance by ad groups           | Mid-level performance drilling       | Impressions, clicks, spend, conversions       |
| Campaign performance by campaign placement  | Understanding where your ads show    | Placement type, impressions, clicks, CTR      |
| Targeting report                            | Keyword and targeting performance    | Bid, match type, impressions, clicks, ACoS    |
| Search terms report                         | Discovering customer search queries  | Search term, impressions, clicks, conversions |
| Advertised products report                  | Individual product-level metrics     | Product, impressions, clicks, units sold      |
| Sponsored products purchased product report | Products purchased from your ads     | Product, conversion value, units ordered      |
| Sponsored brands purchased product report   | Branded campaign product performance | Product, conversions, revenue attribution     |