Make sense of your KDP report: by book, by store, free promos and read-through
-
R. S. Breed Founder
KDP's report spreadsheet has everything in it, spread over nine sheets with a row for every book, store and day. It's hard to see what actually happened.
Drop it in here: https://bervet.com/tools/kdp-report-reader
You get:
- The totals: copies sold (ebook, paperback, hardcover), Kindle Unlimited pages read, free downloads and refunds, with royalties in each store's currency and roughly added up in one.
- By book and by store: what sold where. You can save the book table as a CSV.
- Day by day: charts of sales, pages read and free downloads, so you can line them up with what you did that week.
- Free promotions: each run of free days, with what all your books sold and had read in the days before and after. That's the honest answer to "did my free promo do anything?"
- Series read-through: number your books in order and see how many readers go on to book 2, 3 and so on. Add each book's KENP page count and Kindle Unlimited readers are counted too.
The Dashboard, Orders, KENP Read and Royalties Estimator pages in KDP's Reports all download the same spreadsheet, so any of them works. Drop several at once and overlapping days are only counted once, which means you can piece together a longer stretch than one download gives you.
Two things that trip people up. Goodreads giveaway copies show as free in the rows, but KDP's own summary counts them as paid units, so they're shown separately here. And Kindle Unlimited money isn't in the report at all: KDP works it out after the month ends, so you'll see pages, not dollars.
It's read in your browser. The spreadsheet isn't uploaded and nothing is kept. Free for members.