Tracking Word Count

I’ll be doing my Thursday posts about writing and publishing again, although they’ll be less about changes at the portals now and more about resources and strategies for indie authors. They’ll now be tagged Author Resources instead of Wild West Thursday. We’re in the midst of a fabulous time for writers, filled with both opportunity and challenge. I find it exciting, but sometimes overwhelming, too. So, on Thursdays, we’ll talk a bit more about that.

There’s a new tab on the menu bar called Author Resources. I’ve added two tutorials there, as of now: one explains how to create an Excel spreadsheet for tracking book sales by month, year, etc., and the other explains how to create an Excel spreadsheet to track the results of a shorter promotion. Of course, there are other ways to track both of these items: I’m just sharing my method (mostly because writers in my local group asked me to do so.) You need Excel or another spreadsheet program to set up either or both, and a little bit of time.

Of course, there are more things to track, and one of them is daily word count. How long does it take you to write a book? This is a particularly important piece of information to have when planning a publication schedule. I’m in the middle of planning the next few years of work, since I’m finishing up a lot of series.

Earlier this year, I recognized that my idea of how quickly I write was formed when I was writing for traditional publishers, which meant I didn’t have all the extra jobs of being my own publisher, too. These days, I can spend an entire week updating files or metadata or websites – especially when republishing a backlist series – and not write one word of new content. That happened with the republication of the eight Dragonfire novels and the three Dragon Diaries books. Even on a daily basis, there are publishing crises to solve and jobs to get done, all tasks that distract from the business of creating new stories.

It was clear that I needed to recalibrate my expectations. How fast do I write, in this new situation?

The easiest way to do this is to – surprise! – keep track of daily word count in a spreadsheet, then total the word count of the month. Since there will be variations over time – as I attend conferences or have other obligations outside my office – it’s best to track over a number of months, then average out the results to get a more accurate picture of what’s happening.

I started to keep track in the middle of May, and am pretty tough about counting only net word gain. If I chuck 4K words and write 5K, my count for the day is only 1K.

My results look like this:
May – 37,000 (a half-month)
June – 33,000
July – 43,000
August – 40,000
September – 37,000

That gives me an average word count per month of 38,000 words, and I’ll use that as a working number, even though May was only a half-month. I used to write closer 50,000 words a month – plus I spent a lot less time in my office – so that’s a big difference.

There are two things that shake out of having this number. Let’s talk about the first one today.

1. Now, that I have a number and it looks pretty consistent, I can use it to plan my production and publishing schedule for the year(s) ahead. 38K words a month is about 450K words per year. That’s five 90K novels or nine 50K novels – or eighteen 25K novellas. You get the idea. I can look at my book plan and decide how many titles I can realistically write per year.

I also can balance out my content. I know, for example, that you all prefer my longer books. I know this because they sell better and have better reviews. And the truth is that I’d rather write a short story of 5K to 10K or a book at 90K to 100K, and not mess with the lengths in between. This market is skewed to more frequent publication, so there’s a balance to be struck. If I write five 90K novels and nothing else, will I lose visibility (especially if they’re divided between author brands)? How can I do a fast-release launch of a new series with this productivity level? I’ll have to stockpile books until I have a few completed. Hmm. Can I balance long and short stories in the same fictional world?

Should I write in fewer fictional worlds? This is the inevitable question, but I like writing all the things. I think it keeps me fresh creatively to move between sub-genres, so you can see that there are other considerations as well as raw word count. Planning a publication schedule is not for the faint of heart, but when you know how quickly you write, it’s a lot easier to make a plan you can keep.

The other obvious thing to talk about is how to improve current productivity. I’m going to save that for a separate post, since this one is pretty long already. Next week, I’m going to tell you about an exciting book I’ve just read, so we’ll talk about improving word count in two weeks. Happy writing!

Writer Resources

Once upon a time, I wrote a lot of blog posts about writing and publishing. When I went indie in 2012, though, I wasn’t sure how applicable those posts would be to our new world (which felt a little wild for a few years there.) This past weekend at my local writers’ group, though, we started talking about resources and I realized that a great deal of that information would still be useful to writers.

I’m sifting through it in my spare time (ha) and making it live again.

I will also be doing more teaching next year, and have started to muster my support materials. I use Excel spreadsheets a lot to track results, and I don’t want to spend workshop time walking through the set-up of each one. So, I’m creating some tutorials here on the site. These aren’t the only way to do things: they’re just my way, and might be useful to other writers.

All of this lives under a new tab called Author Resources, which you can find on the menu bar. You can also search in the blog for posts in the categories Wild West Thursday, Indie Publishing, Publishing, and Writing. There is also an archive here of the blog posts I did for the writer-in-residence program at the Toronto Public Library in 2012. You can find those in the Writer-in-Residence category.