Tracking my writing goals with Scrivener, Evernote and Google Spreadsheets

I’ve found that the best way to meet goals that I set for myself is to track them. That means that the goal must be measurable, and this years writing goals certainly meet that criteria: write 500 words of new fiction every day. I thought it might be of interest how I go about tracking this goal in case anyone else out there is looking to do the same.

There are generally three tools that combine to help me meet my writing goals each day:

1. Scrivener

Scrivener is my workhorse, and where I do 95% of my fiction-writing1. I’ve recently revised my short story project template2 to automatically have a 500 word/session target. I also have it configured to use Growl to notify me when I’ve met the goal. So I sit down and write and write and then Growl pops up and says that I’ve passed my 500 word target. Sometimes I’ll stop there, and sometimes I’ll keep going. I write in full-screen mode, by the way, so I don’t have other distractions, and so the Growl notification is particularly convenient because it means I don’t have to keep checking how far along I am. If the notification hasn’t popped up, I haven’t met the goal yet.

2. Evernote

I find it interesting to be able to go back and see what I wrote on any given day. I have a Notebook in Evernote called “Daily Fiction Writing.” There is one note for each day I write. That note contains a copy of the fiction I wrote in that day. Usually, when I finish up a Scrivener session, I copy the text that I wrote and paste it into a note in my Evernote notebook. This is not for backup purposes. I have sufficient local and cloud-based backups for my fiction. This is so that I can go back and see what it was I was writing on Thursday, January 12, 2012. Because I’m interesting in that kind of thing. Also, I only do this for first draft material. Here is what that notebook looks like:

Writing Goals 3.PNG

3. Google Spreadsheet

I’ve developed a Google Spreadsheet3 for providing metrics on my performance against my goal. While the formulas the underlie the spreadsheet are rather elaborate (I am a software developer) the spreadsheet itself is simple, requiring only 2 pieces of information each day: what I worked on and how much I wrote. This is for new, first draft material only. Here’s what the daily sheet looks like:

Writing Goals 1.PNG

Once I type in the words for a day, four other numbers are calculated:

  1. Cumulative: the total number of words written since the beginning of the year.
  2. Pace: the total number of words I need to be at on a given date in order to stay on pace.
  3. My Pace: the number of words I am above or below pace. Positive numbers are ahead of pace, negative are behind.
  4. Off Pace Days: the number of days I am ahead or behind pace. Positive numbers are ahead of pace, negative are behind.

You can see that I didn’t get any new fiction writing in yesterday4. That said, I am still ahead of pace on the year. But this early in the year, my concern is more about writing every day. Looking at the data above you can see that in 12 days, I missed three days of writing. So what I really need is some metrics that allow me to measure my consistency. That is where my summary sheet comes in:

Writing Goals 2.PNG

This sheet is entirely computed from data on the previous sheet. I need enter no additional information. You can see it is broken down by month. Here is what I get:

  1. Total words: the total word count, to date, for the month.
  2. Avg Words/Day: the average number of words written to date, including days I don’t write.
  3. Writing Days: the number of days I’ve written that month.
  4. % Goal: the number of days I’ve written as a percentage of the number of days in the month.
  5. % Duration: the current date as a percentage of the overall month.
  6. Max words: the most words I wrote on any given day
  7. Min words: the fewest words I wrote on any given day

What is most important to me on this sheet is the combination of % Goal and % Duration. If I am writing every day, % goal and % duration should be equal. If I have missed a day here or there, % goal will always be less than % duration–it’s just a matter of how much less. My aim is to try and see that those two values are equal.

There is one more metric I’d like to add to the summary, but I’m finding it complicated to produce in Google Spreadsheet (it may require writing a script). I call this metrics, “Streak” and it would represent the number of unbroken days that I’ve written at least 500 words, from the present going backwards into the past. Since I didn’t write yesterday, my streak would be 0.

These are a lot of numbers and for folks who are not really number-oriented, it might seem like overkill. But it only takes me 20 seconds or so to update my spreadsheet each day. I may spent another minute glancing at the numbers. Most of my time and effort is focused on getting those 500 words written.

  1. The other 5% is done on my iPad using Elements.
  2. I’ll be posting a new version of this template for download in the near future.
  3. Why Google Spreadsheet and not Excel? Do you really have to ask?
  4. I have an excuse, although not a particularly good one. On the other hand, I did make progress on my second draft of story #1 for the year.


    1. Jonas, I’m not sitting in front of my Mac at the moment. But, more or less from memory:

      1. You need to install Growl. Their website is
      2. In a Scrivener project, pull up the Word Count dialog.
      3. Here you can set your targets for the project as a whole, and for each session. I set my session goal to 500 words
      4. In the Word Count dialog, there is an “Options” button. Click that.
      5. In Options, you’ll see a whole bunch of things you can do. This is where you can tell Scrivener to reset your session word count every night, for instance. It is also here that you should see a check box for “Use Growl to notify when you’ve reached your target”.

      Again, this is from memory and it is definitely for the latest version of Scrivener for the Macintosh. Hope that helps.

  1. Very detailed. I’ve used similar spreadsheets when tracking novel first drafts; I don’t track word count progress on short stories.

    These days I’m using Bento (by the Filemaker people) to track writing time, since I’ve been concentrating more on putting the time in than on how many words I get out of it.

    1. Elizabeh, I used to track time as well, but my goal this year was to write 500 words/day. I didn’t specify a duration in which to do that so I decided to throw the time tracking out the window. One less thing to worry about. 🙂

  2. I’m a bit confused about step 2, and why you bother to transfer the writing to Evernote… can’t you see what you were writing on those days by having those daily writings in a folder in Scrivner?

    1. Elizabeth, I do the Evernote thing for my own quirky purposes. I use Evernote as a timeline for lots of different events. It makes it easy for me to see: “What did I do on this day” and that includes the writing I did. I could also look in Scrivener, but I may have already expanded or edited what I did and so it won’t represent the actually writing I did on a specific day. I prefer to use Scrivener as a straight writing tool as opposed to a tool to keep track of my daily writing. At this point, I have most of this automated through Apple scripts, so it doesn’t really add much to my effort.

      1. Mm, yeah, makes sense. I’m just getting more into Evernote and quite like it. Can you tell me more about the Apple scripts, or where I can find out more about them?


This site uses Akismet to reduce spam. Learn how your comment data is processed.