Save Time & Stress – Blog Editorial Calendar Template

Save Time & Stress – Blog Editorial Calendar Template
Jamie Lee Wallace - Thu Mar 18, 2010 @ 02:58AM
Comments: 404

Blogging is hard work. You must consistently create and publish great content. Today's post is about saving yourself time and stress by implementing a simple editorial calendar. Sure, it's going to require a little work up front, but - trust me - you'll thank me once you're up and running.

The Editorial Calendar - what is it?
In case you're not sure, an editorial calendar is a content plan that is laid over a publishing schedule. Magazines, for instance, have monthly editorial calendars that start out as a broad list of key topics and eventually evolve into highly detailed outlines of each issue's content.

How do I create one?
I'm an Excel junkie, so I tend to go old school when setting up an editorial calendar. For collaborative projects, however, I find google docs to be very helpful. The "living" nature of a google doc means you never have to worry about version control. Sweet.

My typical calendar has at least three worksheet tabs:

  1. Calendar - Laid out to reflect all my publication dates, this tab gives me a place to schedule each post.
  2. Pending - This is where I capture all (and I do mean all) the ideas I have for posts.
  3. Published - This is an archive of everything I've published. (Yes, I know this is automatically generated in most blogging platforms, but I do have a reason for duplicating the effort.)

Optional tabs:

  1. Guests - If the blog plan includes ingoing and/or outgoing guest posts, I like to track those works-in-progress separately from my core content.
  2. Open Items - Although it can certainly be a separate document, I like to roll my "punch list" of blog upgrade and maintenance items into my editorial calendar.

Here is an Blog Editorial Calendar Template (Excel) that you can use to get started.


Once you've got the framework set up, you're ready to put it to work:

Capture Ideas
Have you ever had a genius idea for a post while standing in the shower, and then - five minutes later as you're toweling off - completely forgotten what it was? Painful. Tragic. Unnecessary. One of the primary rules of blogging: write ALL your post ideas down. Pen and notepad (or smartphone) should accompany you everywhere (or, in the case of a shower situation, at least be close by). Step two - transfer your great ideas to the "Pending" worksheet in your editorial calendar for future inspiration.

Create Your Publishing Plan
Does your content lend itself to monthly themes? Do you have a seasonal sales cycle that will influence the types of topics you cover at various times of the year? Do you need to create specific content for people at different stages in the buying process? The criteria that are important to your business are the criteria you should consider when developing your broad brushstroke publishing plan. You should identify how frequently you'll post, on which days of the week, whether you'll have recurring "columns" or more freeform content. Nothing is written in stone, but it's good to start with some kind of plan.

Schedule Content
Now it's time to get down to the nitty-gritty business of filling in those publishing "slots" with specific topics. You can schedule posts out for a week at a time, or six months - whatever makes you comfortable. It's kind of like a puzzle - your ideas are the pieces and your publishing plan is the picture you're trying to create.


So, what's the payoff for all your hard work?

Reduce Writer's Block
It's 9:40AM and your post is supposed to go live at 10. You have no idea what to write. Panic sets in. With the editorial calendar, you may never face this terrifying situation again. Whether you go with the topic that's scheduled, or switch it up and pull something from the pending list, you will always have a list of ready-made topics to choose from.

Identify Opportunities
Laying your blog's content plan out in an organized way helps you to see and create useful patterns. For instance, you might decide to run a series of posts that correspond to some of the questions most frequently asked by prospects and then package them up in an aggregate post that you can include in your most popular posts list. By planning ahead, you can also identify (and have time to execute) opportunities for relevant guest posts, event-based content, and other collaborative efforts.

Track Engagement
There are literally dozens of ways to track different Web and blog stats, but I like to aggregate some key stats into my editorial calendar on the Published tab. If you do it on a regular basis, it only takes a few minutes and will make later analysis much more impactful. For instance, you might track the following for each post: pub date, title, topic, #/comments, #/tweets, #/facebook shares, #/trackbacks.

Optimize Your Strategy
Once you have a baseline strategy and plan, and you've dutifully collected stats on your post performance, you have everything you need to do a bang-up analysis of what's been working and what's been falling short. Look at the trends and the patterns behind those trends. Is engagement driven by topic, day of the week, tone, type of content? These simple stats can provide valuable insights that will inform a stronger, more successful content plan and editorial calendar.


With all that said, it's important to remember that real life may cause you to change things up at the last minute. Whether your plans are changed because you've become uninspired by a particular topic, or because you've become wildly inspired to write about another, always give yourself the flexibility to go with your gut. Having a plan can help you be more strategic and reduce the stress you feel when it comes time to churn out brilliant content, but sometimes winging it has merit too.

What works (and what doesn't) for you when it comes to wrangling your blog content?


About the Author: Jamie is a freelance consultant and copywriter who partners with small businesses, start-ups, and creative professionals to define and market their brands. Her specialties include brand development, social media strategy, and content marketing. Enjoy more of her posts, or drop her an email.

Related Posts

78 Questions to Ask Before Launching a Blog

How to Set-up and Run a Keyword Blog

Rumors of Death Have Been Greatly Exaggerated

Comments: 404


101. joidiroy   |   Thu Mar 26, 2015 @ 02:57AM

servizi dello Studio, spaziano anche in ambiti pratici tra cui consulenze tecniche per varie pratiche: urbanistiche per ottenere le autorizzazioni, pratiche dell'Agenzia del Territorio, ricalcolo di millesimi in appartamenti, stime immobiliari e altre ancora. <b><a href="">Architetto Roma</a></b>

102. studio dentistico roma   |   Sun Mar 29, 2015 @ 11:59PM

Lo studio Dentistico Roma Dottori Damis Resta Rossi Iommetti è situato nell'elegante quartiere Prati di Roma ed opera nel settore odontoiatrico dal 2005.

103. studio dentistico roma   |   Mon Mar 30, 2015 @ 02:30AM

Lo studio Dentistico Roma Dottori Damis Resta Rossi Iommetti è situato nell'elegante quartiere Prati di Roma ed opera nel settore odontoiatrico dal 2005. <b><a href="">Studio Dentistico Roma</a></b>

104. pakar seo  |  my website   |   Tue Mar 31, 2015 @ 09:59AM

Great article, I hope you can also visit my website :)

105. Bactiar  |  my website   |   Thu Apr 16, 2015 @ 03:45AM

Time suck, make gaming aja. :D

106. annamaria  |  my website   |   Fri May 01, 2015 @ 10:59PM

Nice article, thanks for sharing.

107. amaria  |  my website   |   Sun May 03, 2015 @ 08:10AM

Nice article, it's very important information. Thanks for sharing.

108. eid mubarak 2015  |  my website   |   Thu May 07, 2015 @ 07:39AM

i am very impressed with your blog articles thanks for sharing

109. aanrechtblad  |  my website   |   Thu Jun 11, 2015 @ 05:22AM

I was about to say something on this topic. But now i can see that everything on this topic is very amazing and mind blowing, so i have nothing to say here. I am just going through all the topics and being appreciated. Thanks for sharing.

110. amine   |   Mon Jun 15, 2015 @ 10:50AM

This is the great web site. This theme new personally so i want more information about this theme. I am waiting for new post.

111. khalik  |  my website   |   Tue Jun 23, 2015 @ 11:37PM

niceeee templates

112. khalik  |  my website   |   Tue Jun 23, 2015 @ 11:44PM

niceee templates

113. franklin   |   Wed Jun 24, 2015 @ 07:13AM

ivethis blog site for a while and also have a matter probably you'll be able to support its how can i include your feed to my rss reader as i need to observe you Thanks

114. ari  |  my website   |   Mon Aug 03, 2015 @ 04:26AM

wow. thank the lord after 2 hours of shovelling thru editorial calendar templates that did not fit what i needed.. i found this post. thank you :)

115. anita  |  my website   |   Mon Aug 03, 2015 @ 04:29AM
116. daftarfb  |  my website   |   Tue Aug 25, 2015 @ 09:12AM

Ask Google and you shall receive! I was sitting down about to come up with a Google Doc for a content schedule and here it is. Thanks so much!!!!


117. bhanu   |   Wed Sep 23, 2015 @ 06:45AM
118. opaoapo  |  my website   |   Tue Sep 29, 2015 @ 07:02PM

good one

119. ragnarok online   |   Fri Nov 20, 2015 @ 07:06AM

your article about save time stress blog editorial to me is ver useful article sir. really i want to visit here again if i remember your site here

120. Bernard  |  my website   |   Wed Dec 02, 2015 @ 12:42AM

This article really helped me speed up the learning process. Thank you to the authors, may be happy always!

121. christmas images 2015  |  my website   |   Wed Dec 23, 2015 @ 04:28AM

nice post thanks for sharing.

122. Nick  |  my website   |   Thu Dec 24, 2015 @ 04:05AM
123. ilhamshare  |  my website   |   Sat Jan 02, 2016 @ 12:22PM
124. ilhamshare  |  my website   |   Sat Jan 02, 2016 @ 12:23PM
125.  |  my website   |   Sat Jan 02, 2016 @ 05:49PM

thanks for yout sharing,, i like your web,, please visit my blog

126. ilhamshare  |  my website   |   Sat Jan 02, 2016 @ 06:44PM

veri nice template Thank for your information

<a href="" rel="nofollow">makanan sehat</a>

127. rohit kumar   |   Tue Jan 05, 2016 @ 09:07AM
128. Nantikanalh  |  my website   |   Sun Jan 17, 2016 @ 03:57PM

I am very happy to visit this website, because the article was excellent and outstanding: D

129. melupakan mantan  |  my website   |   Mon Jan 18, 2016 @ 01:02PM

Nice post. I think a level of determination and consistency is need to sign up for something like this.

130. melupakan mantan  |  my website   |   Mon Jan 18, 2016 @ 01:04PM

This is the great web site. This theme new personally so i want more information about this theme. I am waiting for new post.

135. Holi 2016  |  my website   |   Sat Feb 20, 2016 @ 11:17AM

Holi festival of colours has great significance in the life of here we provide some images,saying,wallpapers,wishes and quotes.

<a href="">Happy Holi 2016</a>

<a href="">Holi Greetings</a>

<a href="">Holi Images</a>

136. rohit chaudhary   |   Mon Feb 22, 2016 @ 06:18AM

he Department of Immigration and Border Protection has announced a 50% increase in charges for Partner Visas to take effect from 1st January. This means that a Visa Application Charge for a Partner Visa lodged in Australia will cost nearly $7000. The increase is simply a revenue raising exercise by the Australian government and will not necessarily be accompanied by any improvement in service standards. It is a cynical manoeuvre by a desperate government that has had its other budget ipl 2016 live score thnks ipl today match live streaming on hotstar thnks happy easter greetings thnks happy holi pictures happy holi whatsapp status happy holi wishes happy easter images

137. happy holi  |  my website   |   Mon Feb 22, 2016 @ 06:19AM

thnks for the links

139. ramesh  |  my website   |   Fri Mar 04, 2016 @ 04:05AM
140. Good Friday 2016 Images  |  my website   |   Sun Mar 06, 2016 @ 06:12AM

I love your stuff. But try to keep it simple sir.

141. Easter 2016 Images  |  my website   |   Sun Mar 06, 2016 @ 07:02AM

Easter 2016 Images

142. Easter 2016 Images  |  my website   |   Sun Mar 06, 2016 @ 07:02AM

Easter 2016 Images

143. kurikulum 2013 sd  |  my website   |   Sun Mar 06, 2016 @ 08:10AM

in making the template is not so difficult, you just need a little control of CSS and HTML and java script

144. kurikulum 2013 sd  |  my website   |   Sun Mar 06, 2016 @ 08:10AM

in making the template is not so difficult, you just need a little control of CSS and HTML and java script

145. Movie Info  |  my website   |   Tue Mar 08, 2016 @ 04:57AM

I am very happy to visit this website, because the article was excellent and outstanding :D

147. cute easter pictures  |  my website   |   Sat Mar 12, 2016 @ 11:36PM

thanx for sharing

148. sslc result 2016  |  my website   |   Tue Mar 15, 2016 @ 04:43AM

sslc result 2016

149. Rahul  |  my website   |   Tue Mar 22, 2016 @ 08:17AM

Nice Article

150. Nissan X-Trail Mobil SUV Tangguh dan Sporty Terbaik  |  my website   |   Mon Mar 28, 2016 @ 03:11PM

PT Nissan Motor Indonesia ( NMI ) at the exhibition Indonesia International Motor Show, which took place on location in Kemayoran , Jakarta use it to launch its newest mpbil public audience . Car manufacturer Nissan issued a Type Sport Utility Vehicle ( SUV ) at the prestigious event this high .

powered by Doodlekit™ Free Website Builder