Which editions make money after advertising?
Net after marketing, per edition, built from your royalty reports and your ad spend rather than from a feeling.
Digital products Publisher Command Center
For self-publishersPublisher Command Center
Run the business side of your publishing catalog. One Excel workbook holding every edition you sell, what each one cost, what each one earned, and whether the advertising is paying for itself.
Editions · Launches · Ads · Economics · Marketing
$39 launch price · $49 regular Coming soon
One-time purchase. Own the file. No subscription, no login, no licence server.
The hard part is not writing the books.
It is that the business around them lives in six places. Royalties are in one Amazon report, advertising is in a different console that does not talk to it, what each book cost to make is somewhere in your email, and what stage each title is at is in your head. By the fourth title, the simplest question — which of these is actually working? — takes an afternoon of tab-switching to answer.
This is one workbook that holds all of it, and does the arithmetic that joining it up makes possible.
It works at edition level rather than title level. Your paperback and your ebook have different prices and different royalties, so an ad that pays for itself on one can quietly lose money on the other. One book, two sets of economics, counted separately.
What you will be able to answer
Is this campaign worth running?
Every campaign period measured against that edition's own break-even ACOS, in that campaign's own marketplace — the number the Ads console does not show you.
What needs to happen next?
One row per edition: the stage it is at, who has it, what is blocking it, and the next action.
Is this edition ready to upload?
Eighteen checks per edition, with critical items that block READY however good the percentage looks.
What did this edition cost me?
Production investment per edition, and how many more sales at your royalty it takes to earn it back.
What is coming up?
Seasonal windows on your dates, surfacing on the dashboard before the deadline rather than after it.
The number the whole thing turns on
Break-even ACOS = royalty per sale ÷ list price
Amazon Ads reports ACOS against attributed sales — the retail price of the books it believes your ad sold. You never receive the retail price; you receive the royalty. So a 60% ACOS is comfortable on a $4.99 ebook returning $3.42, and ruinous on a $14.99 paperback returning $3.59.
The workbook works that line out for every edition and holds every campaign period against it. You can try the same arithmetic on a single edition first, free, in the KDP True Profit Calculator.
It is a floor, not a verdict. It cannot see Kindle Unlimited pages an ad caused, later books in a series the same reader went on to buy, or sales Amazon did not attribute — all three raise the real break-even point, and the workbook says so where it matters.
Twelve sheets
Start Here
What it does, what it does not, and the order to set it up in.
Dashboard
Counts, money, status spread, what needs attention — and a block that reconciles every row of money to where it landed.
Edition Catalog
One row per edition, joined to everything else by an Edition ID rather than by its name.
Edition Economics
Cost, spend, royalties, net, break-even ACOS and break-even CPC per edition. Nothing to type.
Royalties
What Amazon actually paid, KENP kept separate, currencies never silently added together.
Ad Performance
CTR, CPC, conversion, ACOS, ROAS and a deterministic state per campaign period, in that campaign's own marketplace.
Launch Pipeline
Where each edition is, who owns it, what is blocking it, what is overdue.
Release Gate
Eighteen checks, configurable critical items, a readiness figure that cannot flatter you.
Marketing Assets
Which pieces exist per edition, as workflow completion — never as effectiveness.
Seasonal Calendar
Your dates, reading as UPCOMING, APPROACHING, ACTIVE or PAST.
Expenses
What you spent and on what, split into production and promotion automatically.
Settings
Every list and threshold the workbook reads, in one place rather than inside formulas.
Who it is for
- Self-publishers with more than two or three live titles
- Anyone running Amazon Ads who is not certain they are working
- Small presses and imprints with a catalogue to keep straight
- People who would rather own a file than rent a dashboard
Who it is not for
- Anyone wanting an automatic Amazon connection — there is none, and nothing honest can offer one in a spreadsheet
- Writers looking for a manuscript or plotting tool. This does nothing for the writing itself
- Anyone wanting niche research, keyword scraping or bid automation
- Anyone who needs it to do their taxes
- Publishers with one title — the free calculator already answers your question
Questions
Does it connect to Amazon?
No. There is no login, no API and no import. You read a KDP report and type or paste the figures in. Any spreadsheet claiming otherwise is claiming access Amazon does not grant.
What do I need to run it?
Microsoft Excel on the desktop, which is what it was built and tested against. Other spreadsheet applications may open it, but recalculation, data validation and sheet protection behave differently in each and none of them has been tested.
Is it a subscription?
No. One payment, you download the file, it is yours. It works offline and will still open in five years, because it is an ordinary .xlsx with formulas you can read and take apart.
Will it tell me what to bid?
No, and it never will. It shows where each campaign sits against its own break-even and leaves the decision where it belongs.
Can I change the rules?
Yes. Every threshold, status list and critical release-gate item lives on the Settings sheet, not inside a formula. So does the base currency, and changing it relabels every money column in the workbook.
How many books does it hold?
Sixty editions, 150 royalty rows, 150 campaign periods and 120 expense rows. Every edition-level sheet holds the same sixty, so nothing exists economically that you cannot also run through the pipeline and the release gate.
Does it come with example data?
Six fictional titles across seven editions — one of them sold as both a paperback and an ebook — every row labelled DEMO, covering a strong net, an ad-heavy loss, two pre-launch and a paused one. Clear the demo cells and the blank rows underneath are already live.
Not on sale yet. The workbook is built and is being run against a real publishing catalogue before it goes on sale. When the checkout is connected this page will say so and the button will work — there is no waiting list and nothing to sign up for.
Not tax, accounting, legal or financial advice. It does not predict sales, and it cannot guarantee that Amazon will approve any title. Amazon, KDP, Kindle and Kindle Unlimited are trademarks of Amazon.com, Inc.; Pradomation is not affiliated with, endorsed by or sponsored by Amazon.