Pin It

Organize Your Blogging with a Blog Marketing and Editorial Content Calendar {Downloadable Template Included}

editorial calendar template

In my post on 15 ways to build a kickass blog, I’d talked about the importance of a content or editorial calendar that works for you.  Trust me, it is one of the best ways to have a blog that grows, engages, interests and inspires.

Over the years, I’ve dabbled with several versions of an editorial calendar template, nearly all of them in Excel spreadsheets.

This year, with the site growing by leaps and bounds {thank YOU, all of you!}, I’ve yet again reworked my calendar to make it more robust and inclusive. I like having everything in one place and not have to open 3 different files for checking content, guest posts or potential product launches. Yeah, I know! Lazy me. **laughing**

So, I decided to put everything in one place, in one easy-to-use and review Excel spreadsheet to help me plan the entire month’s content and marketing efforts.

And since all of YOU on Facebook asked me to share it, here it is.

Click here to download the customizable Excel marketing and editorial calendar template.

It will save directly on your computer.

If you like it, I’d love for you to click here to tweet it. You can also share it, pass it along and of course, post about it.

I’d really appreciate it if you could leave my logo and the link to this site in the spreadsheet intact when you’re sharing it. I’ll be happy to have some new readers pop over, thanks to that! **smiling**

Here’s an explanation of the different fields in this editorial and marketing calendar, and how I will be using it:

  •  Month: Self-explanatory. The name of the month for which you’ll be creating the sheet.
  • Theme of the month:  I usually have themes for each month. For instance, January is Productivity, Feb maybe Relationships and so on.
  • Weeks: The spreadsheet is divided into 4 weeks.
  • Date/Day: Again, self-explanatory.
  • Post Topic:  The tentative title of your blog post
  • Post Series: If you’re planning a series, jot its title down.
  • Post Author: Name of the author who’ll be writing the post, especially if you have more than one author or plenty of guest authors.
  • Blog Collaborations: This section can be used to note down any linkups, or collaborative series that you may participate in with other bloggers.
  • Sponsors to Pitch: I approach sponsors based on content, so if you want, you can do the same. Alternatively, you can just note sponsors who may be a good fit for your site.
  • Affiliate Programs: Are there any affiliate programs you’d like to share or promote in a particular week or month. Note those here.
  • Product/Service Launches: Note down any products or services that you may like to launch on your blog. This will help you tailor content accordingly as well.
  • Freebies: I love giving freebies {like this one!} and planning for them makes it easier to well, create them. So, if you want to share free downloads, printables and more, note those here.
  • Guest Post Publishing: Here I note when a guest post of mine is being published and also on which site. This helps me keep a record and also, share it.
  • Guest Blogs to Pitch: Note down blogs you’d like to guest post on over here, so that you get time to learn more about their content and posting style so that you can pitch them successfully.
  • Email Campaigns to be Sent: This includes any emails other than the blog posts that I’ll be sending out. You can include your newsletter topics in this section as well.
  • Autoresponders: Starting this month, I’ll be adding autoresponders to increase engagement with all you, awesome folks, so this is where I’ll note down autoresponder subjects.
  • Product/Service Specials: This is where you can note down any offers or specials you’d like to offer your readers on the products and services you offer on your site.
  • Special Events to Attend Online: Twitter parties, Facebook chats, webinars, all these online events go here.
  • Reader Survey: Polling readers to know what they’d like to read, learn, see is an excellent way of creating content that adds value. If you have a poll to run, note that here.
  • Website Messaging: I use Quick Notice {that bar you see at the top of my site} to direct readers to anything special that I’m offering online at the moment. You may use Hello Bar or just a banner ad for website messaging. The message gets noted here.
  • SEO Terms To Focus On: SEO is key for traffic. Knowing which terms you need to broadly target helps you keep your content reader-centric AND search engine-friendly.
  • Bloggers to Connect With: One of my goals always, is to expand my network and discover newer blogs to read and bloggers to connect with. That goes here. Seeing them here will remind me to visit them regularly and stay connected with them.
  • Pageviews: This is to track pageviews since setting goals for them is not what I’m focusing on. That is a happy by-product.
  • Subscribers: Again, to keep track of subscribers so that I can review my content accordingly.
  • FB Fans/Twitter Followers/Pinterest: To track my social networking efforts and see what needs more work.

I’ve not turned this into a .PDF download since I wanted the editorial calendar to be totally customizable. For instance, you may not want autoresponders, just delete. Or you may want to add another column for social media content, just insert. **smiling**

I hope you find this practical and useful in planning your blog’s content and marketing strategies. How do YOU think this will help you? What fields will you add/remove?

Would you like more such downloadable, customizable spreadsheets for either blogging or your business? What would you like? Let me know and I’ll try and create them for you?


Related Posts with Thumbnails
The following two tabs change content below.


  1. Awesome Prerna! Can’t wait to use it!

  2. Thanks, Prerna – this is just what I need! I plan to be more organized with my blogs this coming year and I appreciate you sharing the results of your extensive calendar testing.

    • The Mom Writes says:

      You are most welcome, Crystal.. Do let me know your feedback when you use it.. Would really appreciate that!

  3. This is exactly what I’ve been looking for! Thank you so much. I do have a question, though. What are autoresponders?

    • The Mom Writes says:

      Thank you, Connie! I am so glad you liked it.. To answer your questions, autoresponders are emails that go out automatically when a reader performs a certain action and at a predetermined time period.. I hope I’m making sense.. This article may help

  4. Wow Prerna! I’ve recently started guest blogging, besides taking up some writing assignments and to keep up with my schedule I was just planning to make something like this, so that I can keep track of my writing and deadlines! This is the just the thing I was planning to make for myself!


    • The Mom Writes says:

      Thank you, Rituparna.. SO glad i could save you from the trouble of creating it.. Hope you find it useful and that it helps you boost productivity as well..

  5. Sara Vartanian says:

    Wow Prerna-This is such a comprehensive calendar! You have pieces in hear I hadn’t even considered and I cannot wait to start using this! Thank you for making this editable and all in one place!

    • The Mom Writes says:

      Thank you SO much Sara.. I am so glad you’ll be using it.. Do keep me posted about the tweaks you made and how the calendar helped you:-)

  6. What a great tool. Thanks for sharing.

  7. Thanks so much for sharing with us! I can’t wait to start trying it out! (And I tweeted it so my followers can jump on the bandwagon as well.)

    • The Mom Writes says:

      Thank YOU Stephanie for sharing and liking the post.. Hope you use the calendar to boost your blog and your productivity!

  8. This is great! I tend to write so randomly, and this will really help me organize my thoughts into better-sequenced posts. Thanks for sharing!

    • The Mom Writes says:

      Hi Patty! I’m so glad you found this useful.. You’re right, it will help you organize your thoughts and create a cohesive strategy. All the best!

  9. I love the idea of it but , how sad, I am far too disorganised to stick to a schedule like this.
    I should try though.
    Maybe I’ll make it a new year’s resolution!

    • The Mom Writes says:

      Hi Yee Mei! Thanks for stopping by.. You should definitely give this a go.. You’ll be surprised at how much time you’ll end up saving:-)

  10. I’ll have to give this a shot. Thanks for sharing Prerna!

    • The Mom Writes says:

      You’re most welcome, Charity! It’s been quite awesome at keeping me and my clients organized and sorted with content needs and strategy:-) Hope you enjoy using it too!

Speak Your Mind