Ready to start planning for 2018?
I’ve put together my trusted year-long planner spreadsheet so I can start preparing my content, promotions, themes and more for next year. And I’ve done a version for you too!
This is not a pretty printable. It’s a workhorse of a spreadsheet. It’s designed to show you a year at a glance. You can use it for:
- Planning an overview of your blogging year: monthly areas of focus, affiliate promotions, product launches and more.
- Planning every blog post so that you can be confident you’ve got enough content to fill the coming months.
- Planning your email marketing calendar for promotions and your engagement sequences or general newsletters.
I find that having everything on one spreadsheet makes it easy to search for what I’ve already done and plan forward. I publish an article twice a week, so having a calendar that I can colour code lets me see the gaps at a glance.
Here’s how I use it.
I share my version through Dropbox with my VA so that she can see upcoming posts, find them in our shared file structure and load them into WordPress. Then when I check the calendar I can see she’s added a note to say that it’s with me to do and I can hit the Schedule button once I’ve given it a quick check.
I used to plan my emails separately, but I kept forgetting to look at the other list, double-booking advertisers and making mistakes, so now I have blog content and emails all on one planner.
What’s Inside The 2018 Blog Content Planner
There are 3 worksheets:
- 2018 Overview, for you to plan themes and promotions at a month-by-month level
- 2018 Blog Post and Email Planner, with all the dates down the side, ready for you to populate blog post titles and email newsletter topics on a daily basis
- 2019 Forward Planner, for the ideas that you can’t use this year but don’t want to forget!
Plus there’s a worksheet with some notes – feel free to delete those once you’ve read them.
If you like beautiful PDFs that you can fill in by hand each month, this isn’t for you! This is a highly functional but basic spreadsheet to give you confidence in your content planning.
Of course, if you want to prettify it, you can! Add colours, borders and whatever, and you can format it for printing inside Excel too, but I’ve never done that as I don’t work with an offline planner.
I’ve been using this spreadsheet for years and it’s only now, working with some blog coaching clients, that I realised no one else seems to do it like this! Trust me, it’s efficient, it’s simple and it works.