Tracking Your Book Launch Day to Day

Why a simple daily spreadsheet beats relying on the KDP dashboard alone

KDP's own dashboard shows cumulative totals and trailing charts, but it doesn't preserve a clean day-by-day breakdown once you're several weeks past a launch, and it doesn't let you annotate which promo site or ad campaign was active on a given day. A basic spreadsheet with one row per day solves both problems and becomes genuinely useful once you're comparing this launch to your next one.

What columns actually matter

At minimum: date, free downloads (per title if you have more than one book live), paid unit sales, KENP pages read, and a notes column. The notes column matters more than it seems — "Freebooksy placement today" or "BookBub Featured Deal, genre: Fantasy" turns an otherwise mysterious spike into a data point you can act on for your next launch.

If you're tracking multiple titles or a series, breaking free downloads and paid sales out per book (rather than one combined total) makes it much easier to see whether a promo on book 1 is pulling readers into the rest of the series, which is often the actual goal of a well-timed series-starter free promo.

Reconciling live numbers vs. official exports

The live KDP dashboard updates same-day but can undercount or overcount slightly compared to the finalized KDP_Orders export, which usually catches up within a day or two. If you need a same-day number for planning purposes, it's fine to log the live estimate — just label it clearly as an estimate in your notes column, and update the row once the official export confirms the final figure. Don't silently overwrite an estimate without a note; if a promo partner or collaborator is also looking at your numbers, an unexplained correction looks like an error rather than normal processing lag.

What to review after the launch window closes

Once the promo or launch window ends, look at the full week or two as a shape, not just a peak day: how fast did downloads ramp up, how long did the tail last, and did KENP or paid sales show any lift in the days after the promo ended. This shape tells you far more about what's worth repeating next time than any single day's total does.

Building a simple launch scorecard

After two or three launches, add a short summary row at the bottom of each launch's tracking sheet: total spend on promo-site bookings and ads, total downloads and sales generated, and a rough return figure. It doesn't need to be precise accounting — the point is having a comparable scorecard across launches so you can see, in plain numbers, whether your promo spend is trending toward better or worse returns as you refine your approach.

Tracking beyond KDP: reviews and rank alongside sales

Sales numbers alone don't tell the whole story of a launch's health — log your Amazon overall and category rank alongside your daily sales figures, and note your review count and average rating each time you check in. A launch that generates modest sales but a strong run of early five-star reviews may be setting up better long-term momentum than one with a bigger initial spike but no reviews to sustain it once the promo traffic fades. Reviewing rank, reviews, and sales together each time gives a much fuller picture than any single metric checked in isolation.

Choosing a tool that fits how you'll actually use it

A basic spreadsheet (Google Sheets or Excel) is genuinely sufficient for this kind of tracking, and the format matters less than the consistency of updating it — an elaborate tracking system that's too tedious to maintain daily during a launch gets abandoned by day three, while a simple five-column sheet that takes two minutes a day to update actually gets used through the whole window. If you're tracking multiple titles or run frequent promos, it's worth eventually building a template you duplicate for each new launch rather than reconstructing the structure from scratch every time, so the format is already sitting there when the next release rolls around.

A handful of third-party analytics tools built specifically for KDP authors also exist, pulling and visualizing your sales and KENP data automatically rather than requiring manual daily downloads — these can save real time once a catalog grows past a book or two, though a simple spreadsheet remains a perfectly capable starting point and many established authors never feel the need to move beyond one.