A Hands-on Social Media Calendar

Gus Orellana
October 20, 2020
Communication Skills
Social Media
Organization
Planning
Back to blog

A good social media calendar will have more than one month of content, and ideally it will also have history of what you have done in the past. The tool that we have chosen to create our social media calendar is Excel. The workbook contains 12 tabs for each year, one for each month. This format will allow you to track what you have done and prevent duplication. This is also a guide to what you have to do and for each of your social media platforms and when it needs to be posted. We limited each tab to one month to make it easier to read and check what we have done. Could we have designed the spreadsheet to have one quarter in each tab? Yes, we could, however, the more rows you have the harder it is to see and read.

How often should you plan to post to your social media? Some advisers will tell you every day, some once a week. The truth is you know your audience better than any expert possibly could, and if you are new to the game, you will have to experiment to see how often you should post items.

Each month or week should have a common theme for your media posts, and depending on your line of business, you may have different themes in each social media platform as each one appeals to a different set of people.

This is how we have our media calendar set up:

Columns:   Date Day of Week Holiday Topic Social Media Statement Lead in Statement on Post Hashtags

Now that we have explored the control tool we need to look at, why a quarter at a time? A quarter is a good time frame to use for planning, we plan for many things by quarter, so this method falls into the same routine that we should have for planning other periodic tasks that we already have in our business.

Keep your post’s frequency consistent, don’t change form daily to once a week and back, this is a sure-fire way of losing people following your posts, we humans need order to our lives, and that includes every day and everything that we do.

About the Author

Gus Orellana

Gus started his adult career wanting to be a structural engineer, however, opportunities propelled him to the world of information technology. He began as a programmer for the IBM-402 tabulating machine, and also had a stint as a department manager for a high-end retail store in Mexico City. After emigrating to the United States in 1972 and a three-year job grinding and polishing lenses while learning English, he started working for a bank in Southern California as a programmer. He later progressed to other banks and positions in the information systems area, including systems programming business analyst and management. And since his ordination in 11-03-2017 a Permanent Deacon for the Catholic Archdioceses of Oklahoma City.