In this blog post, we’ll walk you through How to create an editorial plan step-by-step. How to optimally use HubSpot’s Excel template for your content strategy across platforms.
(Note: HubSpot customers can also plan content via the Social Media Inbox or prepare their content using this spreadsheet and then upload it to the Social Media Inbox.
A Social Media How to create an editorial plan Editorial Calendar
Some time ago, we designed a social media calendar template that allows you to prepare and schedule social media content for the following week on the same day and at the same time each week. Then, when you arrive at the office at 9 a.m., you buy phone number list won’t have to frantically search for content to offer your Facebook fans—you’ll have already done that the week before.
The social media calendar is designed to work regardless of the current year. You can simply enter a month and a year as needed. This will make your new editorial calendar a reliable companion that you can continue to work with for years to come.
When you open the social media calendar, you’ll notice that the Excel spreadsheet contains several tabs. Most of these tabs are assigned to a specific social network:
It’s recommended to use a different worksheet for each social network because each social network is different and has different requirements. While you could simply create a social media post and then use it equally for LinkedIn, Facebook, Twitter, and Instagram, you’d be wasting reach, interactions, traffic, sales—in short, success.
What you can do is promote the same content on all of these networks.
The social media calendar already contains tabs for Twitter, Facebook, LinkedIn, Instagram, TikTok, and Pinterest. If you’re also active on other networks like Snapchat or YouTube, you can easily create additional tabs.
Social Media Calendar & Content Guide
Calendar Template
Content Tips
Help with Selecting the Right Channels
Information on Formats and Image Sizes for Each Channel
Download Now for Free
The Monthly Social Media Editorial Calendar in Excel
The monthly calendar contains an the solution was simple: find overview of your social media posts for the current month. Using the calendar, you can better coordinate with other stakeholders and organize your thoughts. Here’s an example of what the social media editorial calendar looks like:
In the Excel template, you can customize three areas to your liking:
The Color-Coding System: The content types or campaigns that need to be coordinated are color-coded. The predefined color-coding serves only as an example of what types of content can be entered here (although some of the examples may be relevant to your business). Therefore, you should customize the calendar to your own campaigns.
The month and year information at the top of the calendar.
The cells below each weekday. In these cells, you enter the types of content you want to promote on these days. Then, you color-code the cell according to the corresponding campaign.
Instead of deleting the entire text services spreadsheet each month, we recommend copying this worksheet twelve times, creating a text services separate worksheet for each month of the year.
How to create a social media plan with the calendar
Now let’s look at the social media content. The section on Twitter updates is the longest because all subsequent sections build on the explanations in this section. Therefore, it’s recommend that you read it carefully.