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

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.

How to connect

1

Sign in to Coupler.io and create a new data flow. Select Amazon Ads as your source.

2

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.

3

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.

4

Choose a report type. Select from available report types like "Campaign performance by campaigns," "Search terms report," or "Advertised products report."

5

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.

6

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.

7

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.

8

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.

A successful manual run is required before you can schedule your data flow to run automatically.

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