RUPAM.BHAKTA
◆ Client Project · Analytics & Automation / 2026BUILT

KDP Ads Platform

Turn Amazon Ads data into automated, profitable decisions.

One system for a KDP publisher running 100+ book titles across four marketplaces. It pulls the ad and sales numbers every day, shows what is actually profitable, and safely automates the bid and budget work.

n8nAmazon Ads APIPostgreSQLMetabaseOpenAI
4

Marketplaces, one view

100+

Book titles managed

Daily

Hands-off data refresh

0

Manual spreadsheets

Executive summary: royalties, spend, profit, ACOS and TACoS.
Executive summary: royalties, spend, profit, ACOS and TACoS.

One place to see, and to act on, exactly which books are making money.

✳ The problem

Why they needed it

Numbers split apart

Ad spend in one place, royalties in another - joined by hand every week.

No real profit view

ACOS alone hides which titles actually make money.

Too slow to optimise

Hundreds of campaigns, impossible to tune by hand.

✳ What it does

Five jobs, fully automated

Collects the data

Campaigns, keywords and reports pulled from Amazon Ads every day.

Joins ads to sales

Matched by book so every title shows its true cost and profit.

Shows it clearly

Live dashboards for spend, sales and profit by title and market.

Warns in time

Instant alerts for overspend, ACOS drift and spend spikes.

Optimises safely

Rule-based bid and budget changes behind an approval gate.

✳ How it works

From Amazon’s data to a decision.

One loop, running on a schedule: collect, clean, measure, then act.

Amazon Ads

US · UK · EU · AU

Collect

Every day, on time

Store

Clean, one place

Measure

True profit per book

Act

Dashboards · alerts

✳ The engine

Built and running in n8n.

The whole pipeline is orchestrated in n8n - scheduled, self-retrying, and running across every marketplace without anyone touching it.

n8n
The full multi-marketplace pipeline
n8n
One report workflow, end to end

✳ Workflow detail is intentionally blurred - this shows the shape of the automation, not its internals.

✳ The numbers

What it measures

ACOS

Ad cost vs ad sales

TACoS

The real profit test

ROAS

Return on ad spend

CTR · CVR

Clicks and conversions

Net profit

Royalties minus spend

Market mix

Where sales come from

✳ The dashboards

Spend, sales and profit in one look.

Filter by date, marketplace or campaign - summary up top, full detail underneath.

Where royalties come from, and ad-driven vs organic sales.
Where royalties come from, and ad-driven vs organic sales.
✳ Safe by design

Automation that never acts blind.

Every automated change clears the same three-step gate before it touches a live campaign.

Dry run

The rules show exactly what they would change - nothing applied yet.

Approve

A human okays the changes to make, keeping full control of spend.

Apply & log

Changes go live, get logged, and can be rolled back any time.

Guarded byRate-limit awareChange logRollbackHuman approval
Dry run
Applied
✳ The payoff

What changed

Hours back weekly

Reporting that was manual now runs itself.

Real-profit decisions

Budget follows the titles that actually earn.

Nothing slips

Problems caught the day they happen, not month-end.

Consistent tuning

The same logic applied across every campaign.

One source of truth

Ads and sales together, owned by the client.

Safe to trust

Dry-run, approval and rollback on every change.

✳ Under the hood

Built with

n8nPostgreSQLOpenAIAmazon Ads APIMetabase
Design highlight

Analytics first, automation second. The system delivers the full profit picture on its own; the automation layers on top only once the data is trusted, and always behind an approval gate.

✳ In summary

See what is profitable, then let it optimise itself.

Drowning in ad data across marketplaces?

Start a project

Next project

GetParlix