Year-End Publishing Playbook (Part 1): Audit and Insights
The last mug of the day sits warm by your elbow as the early dark collects at the window. Tabs blink open across your screen—dashboards, receipts, a stubborn spreadsheet—while a dog sighs in the next room. It smells like cinnamon and paper and a year you actually lived.
This is Part 1 of the Year-End Publishing Playbook, and we’re keeping it simple: an honest audit and the insights tucked inside it. Not a judgment, not a test—just a clear-eyed look at what happened so we can plan what’s next. Think of this as laying out puzzle pieces on the table; the picture gets clearer when they’re side by side.
There’s a strange tenderness to numbers when they belong to your books. Every line—every unit, every note—carries a memory. The Sunday you hit publish. The night you refreshed and saw nothing… then suddenly, something. When we gather those notes, we’re not chasing perfection; we’re tracing the shape of the year.
“Numbers are just stories in rows.” If that feels untrue, stay with me. We’ll start with the stories that matter most.
What to Audit (Sales, Read-Through, Refunds)
Before we talk charts or color-coding, we start with three simple snapshots. These aren’t about catching you out; they’re a way to see the trail your readers took through your world. Sales, read-through, refunds. How many joined you, how many kept walking, how many turned back.
Sales are the easiest place to begin. Pull monthly totals for each format you sell—ebook, print, audio, signed copy, direct—and keep them in the same currency if you can. If you sell in more than one store, add a column for the store name so you can group them later without losing the big picture.
Don’t worry if your tidiest numbers are only for the last six months. Whatever you have is the right place to start. If you’re missing a month, add a note like “est. based on bank deposit” so future-you knows why the number looks round. We’re building a bridge, not a museum exhibit.
Now, read-through. If you write in series, read-through is the simple measure of how many readers go from Book 1 to Book 2, and then on to Book 3. You can estimate it by dividing total sales of the next book by total sales of the first book within the same broad window. If Book 1 sold 1,000 copies this year and Book 2 sold 600, your read-through from 1 to 2 is about 60%.
That estimate doesn’t need to be perfect. New readers can take weeks to move, and launches create odd spikes. If you published mid-year, compare the months following that launch for both books to keep timeframes fair. The goal isn’t a lab-grade statistic; it’s a useful clue about the path people take through your series.
If you write standalones, you can still track a kind of read-through: how many readers came back for another book with your name on it. Look at the months when you released something new—did backlist sales lift too? That echo is a kind of loyalty signal, and it matters.
Last, refunds. Returns happen for lots of reasons: accidental clicks, a mismatch in expectations, a formatting hiccup, or a print issue that slipped past. Gather the count and dollar value of refunds by month if your storefront shows it. If you can, include any notes or reasons when they’re provided. One week of higher-than-usual returns can point to a fixable issue—misaligned margins, a broken link, or a blurb that promised one vibe and delivered another.
You might be tempted to skip refunds because it feels uncomfortable. But refunds are feedback, and feedback is just another kind of map. We read it gently and look for patterns, not perfect lines.
If you’re wondering what to pull first, keep it small and doable:
- Monthly sales by format and store
- Read-through between books (or the backlist echo after a launch)
- Refund counts and any visible reasons
Once these three snapshots are on the table, we can make sense of the year. Takeaway: a clear monthly view of sales, read-through, and refunds reveals your year’s shape.
Tagging and Cleaning Data
Now we turn those snapshots into a tidy, friendly sheet you can refer to—and trust. Not a complex system. Just enough structure so January doesn’t look like June wearing a hat.
Start by making a copy of whatever data you pulled. Call it “2025 Audit Working Copy” or something you won’t be afraid to open. Keep the raw exports safe in a separate folder. Knowing there’s a clean starting point makes the work lighter.
Standardize names. If your Book 2 shows up as “Book Two,” “The Second Book,” and a nickname you used for fun, pick one and change the others to match. Do the same for store names, formats, and series titles. Tiny mismatches multiply confusion when you’re tired and trying to see.
Set a single currency. If your reports mix dollars and pounds, convert them with a rough rate and keep going. Perfection can wait. The goal is to make columns comparable so your eye can scan and your brain can breathe.
Add a few simple tags as new columns. This is where the magic happens. Think in plain language, not codes. It’s okay to be homespun, as long as it’s consistent. Add Series (the world or arc this book belongs to, or “Standalone”), Format (ebook, paperback, hardcover, audio, direct, signed), and Source (where the sale likely began—newsletter, store feature, ad, event, promo stack, or organic).
If you ran promotions, add a “Promo” column and write what you called it—“Summer Cozy Sale,” “Halloween Collab,” or “Book 1 Free, Book 2 Discounted.” The point is to be able to sort and say, “Ah, that was the week we tried X.” You’re leaving practical breadcrumbs for future-you.
For read-through, it helps to tag “Book Position” with numbers—1 for series starter, 2 for the next, and so on. Then you can filter your sheet to look only at follow-on titles and compare their movement side by side. A quick glance becomes an actual insight.
If you did any price changes, note the date and the new price in a simple “Price Notes” column. Price shifts often ripple through sales and read-through, and you’ll want to remember when and why you tried them. A sentence is enough: “Dropped to 2.99 on Sep 15—autumn sale.”
As you clean, watch for zero-dollar entries. Freebies, reader magnets, and giveaways deserve their own tag. They’re not “sales,” but they are a trackable step in how readers meet you. Keeping them visible but separate avoids inflating totals while honoring how discovery actually works.
If you have refunds listed against specific orders or dates, add a light tag for the reason when it’s visible. “Format issue,” “Wrong book,” “Expectation mismatch,” or “Damaged print.” You’re not assigning blame. You’re spotting fixable doors that squeak.
What if your current reports are sparse? Use what you do have. Your email service shows when you sent a newsletter. Your calendar shows when you did that bookstore event. Your bank statement shows deposits by store. Put them in the month they happened and add a note. Puzzle pieces don’t mind arriving late.
A cramped spreadsheet can make you feel like you’re not a “numbers person.” That’s okay. You’re a story person. These tags are story threads, and once they’re in place, you can tug one and see what moves. Takeaway: a few human tags and a clean working copy turn scattered numbers into a sheet you’ll actually use.
Identify Outliers and Wins
With clean columns and simple tags, we can start spotting what surprised us. Not with complicated math. With a reader’s eye for the moments that stand out.
Scan month by month and ask: where did the line jump? A launch month might spike, sure—but look for the quiet bump two months later. Did a cozy midweek newsletter lift your backlist when the days got colder? Did audio sneak up on you in May after you joined a friend’s listening club?
Compare formats. Maybe ebooks carried you most of the year, but paperbacks doubled in the month you did a library talk—or when you shared photos of your annotated copies. Those are connections worth repeating. If a format suddenly dipped, trace back through your notes. A shipping delay? A price change that nudged you past a sweet spot?
Now turn to read-through. Sort your sheet by “Book Position” and look at Book 2 and Book 3 across the year. Where did they lose momentum relative to Book 1? A steep drop between 1 and 2 might point to an expectation gap. Did the cover of Book 2 signal a different mood? Did the description promise a trope the story only brushes?
When read-through is strong, lean closer. What did you do around that time? A backmatter link that was hard to miss? A series page refresh? A short free prequel that acted like a warm handshake? Wins leave breadcrumbs you can follow.
Refunds can feel tender, but they’re a generous teacher. If you see a cluster in a single week, check what changed. A new file upload? A missing chapter header that confused e-readers? A print batch with a blurry cover? These aren’t failures. They’re small, fixable knots in the ribbon.
Let yourself celebrate. Maybe a collaboration brought a wave of new readers who kept going. Maybe a price promo on Book 1 blossomed into steady sales of Book 2 and 3. Maybe a single podcast interview sent a trickle that never quite stopped. Write down the story behind each win while it’s fresh. “Readers loved the grumpy/sunshine pairing; keep that copy line.” “The map in the paperback got photos—keep maps.” “Launch on Thursdays seemed to catch weekend readers.”
You might find an outlier that isn’t a win. A spike in returns after a newsletter with a mismatched blurb. A book that underperformed because it didn’t fit the series promise, even though you love it. This is hard—and it’s also good news. Now you know. You can phrase the description differently next time, or tuck a quirky project into a “Novel from the Attic” lane with a clear note, which can become a charm rather than a surprise.
When you see an outlier, name what made it different. Timing, art, price, placement, partnerships—choose one or two that feel likely and write it down. That way, when you look back in March, future-you doesn’t have to guess. Leave a trail for yourself in plain words.
If you’re ready for a tiny bit of simple math, you can look for the months that were roughly 30–40% above or below your average. Those are the months to investigate first. But you don’t have to. Your gut, paired with your tags, will find the loud signals.
What matters is this: you’re not just tallying. You’re listening. The year is telling you where your readers found you, where they stayed, and where the path needs a lantern. Takeaway: outliers and wins are your compass—note what created them so you can repeat the good and soften the rough edges.
A last word for Part 1. None of this is meant to pin you down. It’s meant to set you free to choose with eyes open. You’re not chasing perfect metrics; you’re gathering gentle truths so the next step fits your feet.
In Part 2, we’ll use these insights to shape a quiet, sustainable plan for releases and promotions that feel like you. For now, let the numbers settle into stories. Notice what surprised you, what delighted you, and what you’d love to try again.
If you feel like taking one small step tonight, open your sheet and add a single note to one month: “What happened here?” Then close it, and let your mind wander toward the answer.
Related reading in Publishing & Launch
Metadata That Sells: Titles, Subtitles, and Keywords · Why My First Launch Flopped (and What Fixed It)