Behind the Curtain: My Blogging Routine, Part Deux

Posted on February 19, 2015 «
Categories: Behind the Curtain «
Join in on the Conversation «
Is this a book review? Jump to the Quick Review

behind the curtain my blogging routine

Last week, I shared my blogging routine which is a post I had scheduled before Brittany over at Book Bumblings issued her Be a Better Blogger Challenge for February. Once the February Challenge was up, I thought, “Well, I have a routine. I have that post scheduled there’s nothing I need to do.” But as I read her posts, I started to feel the need to improve my routine. There are things I do every week that are just in my head and I often wish I could keep track of those things. Is my Google spreadsheet the BEST way for me to keep track my reviews?

After looking at some the Editorial Calendar Tools that Brittany presented, I have decided to pair my Google spreadsheet with Trello. My Google spreadsheet will be an overview of my editorial calendar and Trello will be the step-by-step things I need to do each week.

My Blogging Routine: What’s in My Google Spreadsheet

I should mention that I’m project manager by day. My job depends on timelines and a somewhat regimented schedule. Routine, timelines, checklists and proving something has been done come as second nature to me. When I first started blogging, I was using Google Calendar, but I found it difficult to keep track of what I had done and what was coming up. I also found it difficult to move things around if I needed to change my schedule to accommodate a tour or meme or a discussion post. So I moved away from the calendar and created the spreadsheet.

As you can see from the image above, I’ve got columns for day of the week, month, date, name of the post, post type, number/sequence and then some columns for revision status and whether or not the review has been cross posted. The yellow means it’s a tour.

google spreadsheet filters my blogging routine.png

I’ve created and saved filters so I can easily focus in on certain types of posts. Since I number/sequence my reviews and Scenic Sunday posts this is quite helpful. Another example, I post reviews on Mondays and Wednesdays and can filter by day of the week so I can see where my holes are for upcoming months.

My Blogging Routine: Adding Trello for the Details

I created two boards on Trello—Regular Blogging Tasks and 2015 Blogging Schedule. Next up I created a card for each of the post types that usually appear on my blog and on each card I created a checklist for all the steps I go through when prepping a post. I did some color coding with labels. I created additional cards for other items I’ve been trying to do weekly and want to keep track of.

my blogging routine using trello

The next step was to copy the list and move the list over to my 2015 Blogging Schedule board. I update the titles on the cards to match my Google spreadsheet, delete the cards and tasks I don’t need and set deadlines. My plan is to archive the list once I complete all the cards on is so I don’t have to scroll left and right too much.

My Blogging Routine: The Pitfalls and Anticipated Changes

I’m not 100% sold on Trello. As you can see from the image of above, I’ve completed most of my cards for the week, but there’s no way to mark an entire card as done. This makes me cringe a bit until I look and see that the task count is complete. Right now I can’t figure out how to make a reoccurring card. I want a reminder at the start of the month to create my Rewind Review post. I’m still looking for a solution.

I can see right now there are columns on my Google spreadsheet I may no longer need as a result of moving the details over to Trello. This excites me a bit as I’m bad at updating those columns as I go. As I move away from using those columns in the spreadsheet, I will more than likely remove the final item from my checklist that indicates to update the Google spreadsheet.

I’m looking forward to keeping better track of the Shelf Love and Discussion 2015 posts. I’ve tried to read and respond to many of those posts. From week to week I forget whose site I’ve visited and commented on.

So what about you? What tools do you use to keep track of your blogging schedule? How would you like to improve your routine in 2015? Are there features I’m missing in Trello or Google Spreadsheets that I should be taking advantage of? Let me know in comments!

Tags: , , ,

10 responses to “Behind the Curtain: My Blogging Routine, Part Deux

  1. Julie S.

    We use Asana to keep track of all the posts we need to do. I don’t think there’s a way to duplicate a recurring type task, but we assign each task to the appropriate people and they show up on our shared calendar. Then we can check it off when done and it shows it differently, so you can quickly see what is upcoming on the to do list and what is already scheduled. I might have to do a post like this someday.

    • You should! 🙂

      I’ll have to play around with Asana some weekend and see if I like it better than Trello. I did figure out how to get it add to the calendar on my iPhone.

      Terri M., the Director
      Second Run Reviews

  2. Bec

    I am in awe of your organisational skills!

    Since I coblog, Alise keeps track of most of the scheduling things. Though I do like to have a visual of what’s going up when on a calendar or something.

    Spreadsheets are things I’m really bad at using! I started some to keep track of my TBR and reviews but always forget to update them :/

    • Julie at ChapterBreak mentioned that her team uses Asana. I checked it out over the weekend and it allows you to assign tasks to different team members.

      I am a project manager from 8-5 being organized is second nature to me after 10 years.

      Terri M., the Director
      Second Run Reviews

  3. I’m blown away at the level of detail you get into! This is fantastic. I currently use a table in Evernote to keep track of my posts. It’s ok, but I think I could find something better. You’ve encouraged me to reevaluate the way I plan my posts (which is a good thing). Thanks! 🙂

    • I used Evernote awhile ago, but I find that keep notes electronically doesn’t work well for me. I like the tactile-ness of writing things down in a notebook which I often do after I get done reading a book. Are the tables sortable in Evernote?

      Terri M., the Director
      Second Run Reviews

  4. Bookworm Brandee

    You’re blowing my mind! LOL I think I’d have a lot of trouble with something more tech-y than a google spreadsheet. And as I mentioned in my #ShelfLove post on my book budget, I created a spreadsheet. This was a big deal. I don’t *do* spreadsheets! LOL You’ve given me a lot of food for thought, Terri. Thanks so much for sharing!

    • Yes, I am a project manager by day so planning and plotting does come as second nature to me.
      Take what you learned from your #ShelfLove spreadsheet and apply that to your blogging schedule/editorial calendar!
      Terri M., the Director
      Twitter: @2ndRunReviews

  5. Camille

    Thanks for sharing your blogging routine with us Terri. This inspired me to post and share my own blogging routine as well. I’m going to try Trello and see if that helps organize everything 🙂

    • You are welcome, Camille! Please do share your routine. You might also check out Asana. I’ve been messing around with it and I like it a bit better than Trello.