I have been doing this site for a dozen years, but the question didn’t occur to me until now. I noticed the three-year anniversary of my Patreon campaign was coming up and I was looking for a way to quantify my overall output. The question is:
How many words do I write in a year?
Of course, this number will go up and down from year to year. Some years my big project is a comic that will naturally be more image than words. Other years I end up posting most of my words on the Escapist. Sometimes I’ll focus on video content and sometimes I’ll lose my mind and write over a hundred thousand words about one videogame franchise.
But still. Even if I don’t have a convenient way to measure stuff I’ve done for other sites, we ought to be able to get some sort of handle on how many words I write on this site, right? I mean, I’ve got the database right here. (You can’t see it, but I’m holding up the database and gesturing with it right now.) That should have all the information we need.
I suppose the first step is to filter out the stuff not written by me. To date, 5,025 posts have been published on this site. (This includes posts you haven’t read yet, like the future entries in my Arkham City and Zenimax vs. Facebook series.) 321 of them have been written by other people, and the remaining 4,704 posts were written by me. So all we need to do is get a word count on those posts and we’ll have what we need, right?
Not all word counts are created equal. In fact, as far as I can tell none of them are. If we look at the textI’m talking about the raw text I see in the editor, which – due to markup – is different from the text you read on the site. of the very first entry of my Final Fantasy X series, we’ll see that WordPress reports it as being 1,930 words long. If I take that exact same text and post it into Google DocsI write most of my long-form stuff in Google Docs. The editor is more comfortable, the spelling and grammar checking is more robust, and I can’t accidentally publish a half-finished article when trying to save my work. it gives me a word count of 2,149. That is not a small difference! If I paste the same text into this word counter it tells me the text is 2,085 words. And if you copy & paste that post somewhere else for a count, you’ll probably get another answer entirely.
I’m assuming the difference comes down to HTML markup. For example, in the paragraph above I’ve got the sentence:
In fact, as far as I can tell <em>none of them are</em>.
One word counter probably counts special characters like < and / as word breaks, and another only counts whitespace. So one will see “
<em>none” as the word “em” followed by “none”, and the other will see it as one big word. From experimenting, it looks like the WordPress counter is actually smart enough to pull out HTML, so “em” won’t get counted at all. Which means the WordPress count is probably the number we’re interested in.
This is still not perfect. I think the WordPress counter gets confused by the shortcode markup I use for images, footnotesLike this one., and YouTube embeds. But this is basically close enough for our purposes.
The more serious problem is that the word count isn’t stored in the database. If I want to know the word count of a post I have to open up the post in the editor and look at it. Not to sound lazy, but I don’t actually want to spend two full work days opening up 4,704 individual posts in the WordPress editor. The editor is not snappy and it does not open quickly. It takes several seconds to open a postYou can see why I prefer to write in Google Docs! and there’s no good way to navigate between published posts chronologically.
About the only thing we have to work with on the database side is a brute-force character count of the text. That’s ugly. I think the best I can do is look at the character counts and compare them to the displayed word count. That should give me a ballpark “characters per word” that I can use to derive the numbers we need.
I gather up the last dozen posts and look up their word counts. I put them in a Google spreadsheet along with their character counts, and it tells me I average about 6.64 characters per word. So if the database tells me a post is 10,000 characters long, it means it was in the ballpark of 1,506 words.
That sounds high. The average in standard English text is 5.1 characters per word. While I’d love to claim that I’ve got one o’ them fancy vocabularies that lets me use a lot of fifty cent words, I think this inflation of word length is more appropriately blamed on all the HTML and shortcode. Still, maybe the last couple of weeks have been atypical? Just for the sake of completeness, I do the same experiment again using every single post I wrote in June of last year. During that time I wrote 37 posts. I open each one in the editor to get the official HTML-free word count. Added together they come to 34,337 words. If I divide the number of characters by this number I get 6.63.
Wow. That’s amazingly consistent. I think I can proceed feeling pretty confident that I wrote a word for every 6.6 characters in a post. In any case, we finally have what we need to answer this stupid question: How many words do I write per year?
All I need to do is get the numbers out of the database. I’ll admit I’m pretty rubbish at SQL. I’m one of those people who knows juuust enough to be dangerous. I never have the guts to perform changes to the database via mySQL. My interactions are strictly read-only. Here is what I come up with:
SELECT SUM(CHAR_LENGTH(post_content)) FROM wp_posts WHERE post_author='1' AND post_status='publish' AND post_date >= '2017-01-01' AND post_date < '2018-01-01' LIMIT 10000;
(The “limit 10000” is because I’m feeding these queries into the database via phpMyAdmin, and if you don’t specify a limit it defaults to 10.)
If I do one of these for every year since the site’s inception, it should give me the character counts. Note that this count is based on the year starting Jan 1st, and not in September when the site was launched. This means the first “year” is just a few months long.
Taking those results and assuming 6.6 characters = 1 word, I get:
That dip in 2010 is when I was making content three times a week for The Escapist. Plus I still had a day job. The Patreon campaign began in 2014, and that’s when I really started treating the site like a full-time job. I wasn’t happy with my output at the end of year one, mostly due to problems in my personal life and some projects that hit a dead end without ever turning into blog posts. But I’m pretty happy with my output since then.
To put these numbers in context, your typical young adult novel is somewhere in the 50k to 90k words ballpark. I think the first Harry Potter book is probably around 75k or so. Hefty adult books are maybe double that. The Two Towers clocks in at 156k words. Which means last year I wrote 4.5 Harry Potters worth of content, or a little more than The Two Towers + Return of the King.
Well, it’s a bit more complicated than that. This is actually a count of what I posted and not what I wrote. For instance, last year I did re-posts of old Escapist content. But I also did some non-trivial edits to those things. I don’t want to haggle over where we draw the line between “writing”, “re-writing”, and “editing”, and so let’s just ignore this while I make dismissive hand-wavey motions.
I’m kind of surprised by my output in 2006. That’s a lot of words. On the other hand, I think those are pretty low-quality words. They’re mostly random dashed-off thoughts. They’re barely proofed, there aren’t any images, and almost no links. The stuff I’m writing now is more analysis. It’s researched, proofread, and annotated. It’s got lots of screenshots with captions. The transformation probably began when DMotR took off and I became aware I was writing for thousands and not just a small group of friends.
While we’re at it, let’s look at how many posts I’ve put up every year:
Again, that is not at all what I would have expected. I don’t remember being nearly that busy in 2006. But I guess I can’t argue with the data. I do remember hearing the advice, “You should make sure to post once every day!” and taking it to heart. Like most blogging advice, this is misleading. It’s true that the most popular blogs have regular content. In the same way, many successful men wear suits every day. But wearing a suit every day will not make me successful. The actual advice you’re looking for is, “Write stuff that other people want to read.” But that’s sort of obvious and nobody knows how to teach other people to do it. So instead we get shallow advice like, “Post every day” and “Check your SEO performance”, because those are things you can quantify.
At any rate, the “Post every day” mindset resulted in me posting a lot of ephemeral dross in the early days of the site. That declining red bar graph is probably a good indicator of an overall rise in quality.
Since I’ve already got the data in a spreadsheet, I might as well look at how long-winded I’m becoming. Here is the average word length of posts:
Poor 2010. I guess I was just posting Spoiler Warning videos and links to my Escapist content.
Well, I don’t know if that was interesting, but it was a fun little project.
And because I know you’ll be curious at this point: According to WordPress, this post is 1,705 words long.
 I’m talking about the raw text I see in the editor, which – due to markup – is different from the text you read on the site.
 I write most of my long-form stuff in Google Docs. The editor is more comfortable, the spelling and grammar checking is more robust, and I can’t accidentally publish a half-finished article when trying to save my work.
 Like this one.
 You can see why I prefer to write in Google Docs!
Secret of Good Secrets
Sometimes in-game secrets are fun and sometimes they're lame. Here's why.
Programming Language for Games
Game developer Jon Blow is making a programming language just for games. Why is he doing this, and what will it mean for game development?
A Lack of Vision and Leadership
People fault EA for being greedy, but their real sin is just how terrible they are at it.
Let's ruin everyone's fun by listing all the ways in which zombies can't work, couldn't happen, and don't make sense.
What was the problem with the Playstation 3 hardware and why did Sony build it that way?