Datapipe
Paid media managers
Check spend and return by campaign every morning.
Read & reportOwner-approved writesBeta
Bring Amazon Ads Sponsored Products and Brands performance into your reports.
Track advertising spend, attributed product sales, ACOS, ROAS, and keyword target performance.
- Spend, results and return by campaign in one sheet
- Find the campaigns that cost more than they return
- A fresh campaign report before your morning check
Sheets
Looker Studio
BigQuery
Drive
CSV
Claude
ChatGPTUpdated November 2026
| Campaign name | Targeting type | Campaign state |
|---|---|---|
| Sponsored Products - Ergonomic Chairs | manual | Spring sale |
| Retargeting | 640 | Retargeting |
| Brand search | 210 | Brand search |
- SetupPaste a key or token
- Reads8 metrics and 8 ways to split them
- Changes1 owner-approved action
- RefreshDaily to every 15 minutes
Who uses Datapipe with Amazon Ads
Ecommerce owners
See which ads actually bring orders.
Agencies
Send each client a clear ad report every month, without exporting.
What you can do with Amazon Ads
Read and report
Read Sponsored Products campaigns, keyword target bids, media spend, and attributed sales using your Amazon Ads token and profile ID.
- Sponsored campaign reports
- Keyword targets and bids
- Product ad inventory
Change with owner approval
- Update campaign state or daily budget
The owner reviews the exact values and approves every proposed change before it is applied to Amazon Ads.
Full read details
Sales reflect marketplace currency.
Examples for your team
Monitor advertising cost of sales and return on ad spend
Review product campaign performance, ACOS percentages, and attributed revenue alongside seller catalog inventory.
- Scheduled refresh
- Latest Amazon Ads data
- Updated report
Update campaign state or daily budget
A team member proposes pausing an ad campaign or adjusting its daily budget cap.
- Proposed
- Owner approves
- Applied and logged
Limit: The owner verifies the target campaign and budget values before approving.
Fix things in Amazon Ads without opening it
Spot it, fix it
See the problem in your report, then propose the fix in Datapipe instead of opening Amazon Ads, finding the record and retyping it.
More people can help
Teammates and AI tools can suggest changes without getting edit access to Amazon Ads.
Nothing changes without your yes
You see the current and proposed value side by side, and every change is logged.
Jobs you can stop doing by hand in Amazon Ads
Update campaign state or daily budget
Scale daily media spend on Sponsored Products campaign with profitable ACOS
TodayOpen Amazon Advertising console, select campaign, adjust daily budget field, and save.
With DatapipeSpot campaign performing at 12.5% ACOS in your morning sales report, propose raising daily budget from $80 to $150, and brand manager approves after review.
Pause sponsored product campaign during catalog inventory stockout
TodayNavigate to campaign manager in Amazon Advertising, find product campaign, and click pause.
With DatapipeDetect low inventory alert in fulfillment reporting, propose pausing the SKU campaign to preserve ad spend, and operations lead approves after review.
Exactly what this can change
Pauses, enables, or adjusts the daily budget of one Amazon Sponsored Products campaign. Product targets and ad groups remain untouched. Every change requires owner approval.
Supported fields: Campaign state, Daily budget (e.g. $80.00).
Update campaign state or daily budgetCampaign · Sponsored Products - Ergonomic Chairs (#amz_cmp_301) · proposed by Avery Chen
| Field | Current value | Proposed value |
|---|---|---|
| Daily budget | $80.00 | $150.00 |
Every team member's change needs owner approval
- Owner turns on an action
- A teammate or AI tool proposes
- Check the current and proposed values, then approve that individual change
- Applied once and logged
Source changes use the separate Actions & approvals workflow in Datapipe. AI tools such as ChatGPT can propose changes but never approve them. Who can turn this on?
Provider rules and limits
Provider permissions still apply, and automations in Amazon Ads may react to approved changes.
Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.
Before you connect
What you need
Enter your advertising access key and Profile identifier.
Read and write
Read access for reports. The change action needs edit access in Amazon Ads and stays off until the owner turns it on.
Limits and exclusions
Anything your connected account cannot see in Amazon Ads.
Full details and limits
Sponsored Products and Brands performance, advertising spend, attributed product sales, ACOS, and ROAS.
Reporting reads campaign performance and product ad metrics. Campaign state and daily budget updates require owner approval.
Reports you can build
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Sponsored campaign reports
- Keyword targets and bids
- Product ad inventory
What each dataset reports
- Sponsored campaign reports
Sponsored Products and Brands media spend, sales, ACOS, ROAS, and clicks.
- Keyword targets and bids
Search keyword bids, match types, impressions, clicks, spend, and sales.
- Product ad inventory
Promoted ASIN and SKU ad listings, clicks, ad spend, and attributed orders.
Metrics and dimensions
8 metrics and 8 ways to split them.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send Amazon Ads data anywhere
Google SheetsA sheet that refreshes every morning.Looker StudioCharts that read the same numbers.BigQueryA warehouse table for the same columns.Excel / CSVA Drive file you can open in Excel.ClaudeAsk Claude about these numbers in a sentence.ChatGPTAsk ChatGPT about these numbers in a sentence.APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
AI tools can also propose a Amazon Ads change. Only the owner can approve it.
Which Sponsored Products keyword targets generated the highest revenue with an ACOS below 15% this week?
The target 'ergonomic office desk chair' delivered $640.00 in sales at a 12.5% ACOS (8.0 ROAS), generating 24 orders across the catalog.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
- Spend sits next to results, so a costly campaign is obvious.
- Orders and sales stay in the report, ready each morning.
- Products can be listed with the price and the status.
Start from a goal
Sponsored campaign reports
Sponsored Products and Brands media spend, sales, ACOS, ROAS, and clicks.
Use this template →Keyword targets and bids
Search keyword bids, match types, impressions, clicks, spend, and sales.
Use this template →Product ad inventory
Promoted ASIN and SKU ad listings, clicks, ad spend, and attributed orders.
Use this template →How it works
Create a project and choose Amazon Ads in Data sources.
Enter your advertising access key and Profile identifier.
Pick where it goes. Choose campaign reports, keyword targets, or product ads and a destination.
Sample report
Sample range Oct 1–Oct 29. Each row is one campaign.
| Campaign name | Targeting type | Campaign state | Ad spend | Attributed sales | ROAS | Keyword query | Match type |
|---|---|---|---|---|---|---|---|
| Sponsored Products - Ergonomic Chairs | manual | Spring sale | $80.00 | $640.00 | 5.3 | winter coats | 1,240 |
| Retargeting | 640 | Retargeting | $125.50 | $980.00 | 7.8 | canvas tote | 640 |
| Brand search | 210 | Brand search | $42.00 | $160.00 | 3.8 | brand name | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Amazon Ads
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Amazon Ads + Shopify“Is ad spend rising faster than orders?”See Shopify →
Amazon Ads + Google Analytics“Do ad clicks show up as site visits?”See Google Analytics →
Amazon Ads + HubSpot“Did the new campaign bring more deals?”See HubSpot →
Amazon Ads + Stripe“How does ad spend compare with the revenue you collected?”See Stripe →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
Only the workspace owner. Writes start disabled. The owner enables permitted actions and eligible teammates: owner only, all project operators and managers, or selected teammates. The owner can change this at any time, and saving new settings cancels pending proposals.
No. Teammates propose in Datapipe, and approved changes are applied through the connected Amazon Ads account. Nobody else gets a Amazon Ads login from this.
They can propose a change through Datapipe, the same way a teammate can. They can never approve it. Only the owner approves, in Actions & approvals.
Datapipe sends each approved change once and logs the result. If it cannot confirm that Amazon Ads received it, the request is marked Uncertain and is never retried automatically, so you can check Amazon Ads first.
Yes. Datapipe reads the reports on this page and can make one kind of change: update campaign state or daily budget. Each one stays off until the owner turns it on, and every proposed change needs the owner's approval. Provider permissions still apply.
This page lists 8 metrics and 8 ways to split them. You pick the columns when you build the report.
Sponsored Products and Brands performance, advertising spend, attributed product sales, ACOS, and ROAS. Account permissions and the records available from the provider determine which rows can be read.
One for each Amazon Ads account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try Amazon Ads with sample data first
Build the report first, then add Amazon Ads when you are ready.