Home > Destinations > Excel > Amazon Ads

Connect Amazon Ads to Excel

The task pane keeps the source query beside the workbook. Choose one or several accounts from Amazon Ads, then set the columns, period, filters, and target cell.

Q3_Marketing_Command_Center.xlsx
Workbook ready
A1fx=Catchr query output · Google Ads · Last 30 days
date campaign spend clicks conv. cpa
2026-07-20Brand · US $— $—
2026-07-20Non-brand $— $—
2026-07-21Retargeting $— $—
2026-07-21Prospecting $— $—
2026-07-22Shopping $— $—
Bring the rows. Keep the workbook.

Decide what the next query run should do.

A saved query knows its output range. Choose the update behavior that matches how the workbook should accumulate or reconcile rows.

Output behavior
Default modeClean snapshot

Clear the previous output and write the current response.

Replace mode resets the query's stored output range before writing the new result. Use it when the worksheet should reflect the latest complete response for the selected date window.

Before · stored range
DateSpendClicks
Jul 20
Jul 21
After · current response
DateSpendClicks
Jul 21
Jul 22
Workbook guardrail: use a dedicated raw-data sheet or bounded output area. Keep formulas, notes, and manual inputs outside the stored query range so a later run cannot replace them.

Choose the marketing rows your workbook needs.

Start with a dedicated connection page for the platform you use. Each route explains the source data, useful fields, query setup, and workbook applications for that connector.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

How to connect Amazon Ads to Excel ?

Configure the source once, then build and rerun focused queries from the Excel add-in whenever your workbook needs new rows.

Step one

Add every account once.

Authenticate all the platforms used, then choose the exact accounts your team needs for reporting and analysis.

Client A · Connected sources
5 sources ready
Meta Ads 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Install and open the Catchr add-in.

Install Catchr from Microsoft Marketplace, open the task pane in Excel for web or desktop, then sign in to your Catchr workspace.

Step three

Build the query at a selected cell.

Choose the source, accounts, fields, dates, and filters. Select the starting cell in a dedicated raw-data sheet, then use Get Data to write the response.

Your next Excel spreadsheets should not start with five exports.

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources