Hello everyone! I hope you’re having a great week. I haven’t recorded a video in a while and I wanted to show you our Content Planning Spreadsheet. We’re having people request this as a tool they can use for themselves, and it’s something you can opt in to use.
I’m going to walk you through how to set this up for yourself, and a few examples of how we use it for ourselves and other clients. The spreadsheet itself is a template for your content for a year. When you download it, you won’t be able to edit it, so you will have to make a copy and either work with it in your own Google Drive, or download it as an Excel spreadsheet.
On the first tab, you will see the instructions, which are very straight forward. You might not use the first few tabs in the spreadsheet, they are places to store links to different content such as videos or blog posts.
On each month’s tab, there are also instructions. If you go to the first month, you’ll drop your vision and mission into the top. This is useful because sometimes people have these statements, but never look back on them! This will remind you that all the content should relate back to these statements.
The first step is to choose a theme for each month. You’re going to do nothing else until you have a theme for each month. The month is what we call Tier 1, so we will go through and fill this in for every month. The next step is to look at Tier 2, which is your weekly themes. This is smaller chunks of information about your monthly theme, maybe questions you get asked often. This is just a way to break it down before you start creating your daily content. Next is Tier 3, which is the actual content itself. You’re going to fill out the daily themes with questions or topics relating to each weekly theme, then plot these into your calendar.
When you look at the calendar, you’ll see exactly what you’re going to post
about on that day. A hack we use to come up with our daily content is Google search suggestions. We type in the monthly theme and it will give you a bunch of suggestions that people are looking for, which will give you tons of ideas for posts and blog topics.
The last thing you see on your monthly tab is your static content. If you don’t have the time to come up with a brand new post every day or turn your daily content into blogs, and that’s okay! We have a static theme that we create branded posts for in monthly batches (Monday Motivation, Mid-Week Marketing Tip, and Friday Funny) and schedule those out in advance, so if we don’t have a Tier 3 post going out, we know that we will always have these static posts going out. How easy is that to have a calendar telling you exactly what you’ll post!
You could also use the calendar for promotions you have running if you don’t have much content going out. That way, you can also look back and see what promos ran each month and how they did. If it did well, you could run it again, and if not, it can be removed from the calendar. It’s also useful if you have several people needing to know what’s going on, everyone can look at what types of things are posted each day.
You can create stunning graphics even if you’re ‘design challenged’ CLICK HERE for a free Canva account trial.
Brittany Hardy ⎜ Owner
Brittany Hardy is the Owner of Empty Desk Solutions, a boutique marketing company located in Port Moody B.C.
Brittany is passionate about helping small businesses achieve their growth goals with marketing solutions that are both effective and affordable.
After many years of working in retail management, Brittany went on to become the Marketing Manager for Dominion Lending, Canada’s largest mortgage company. Brittany then decided it was time to pursue a life-long goal of creating her own business. Inherently, Brittany likes to help people and decided there was no better way to do this than to use her creative talent to lift up others who want to do the same thing.
The mother of three young children, Brittany believes in balancing work and home life and continues to find new ways to support and employ other mothers who want to start their own businesses or stay at home with their children.
Social media marketing continues to evolve, and Brittany and her team are passionate about helping small businesses navigate how they can benefit from these networks.
Brittany has been a finalist for the Women of Worth awards, the Tri-Cities Business Excellence awards, and has most recently been featured in Small Business BC and the Huffington Post.