The Social Media Content Calendar Template Every Marketer Needs [Free Template]

“We have a 9 a.m. meeting? Hold on — let me just click around the internet like a maniac to find something for the morning tweet.”

Sound familiar? Scrambling for social content is nothing new. We have meetings. We run late. Things come up. And it’s really hard to get any meaningful amount of work done when you have the next social media update looming over your head every 30, 60, or 90 minutes. Social media content moves so fast that you might occasionally feel thrown for a loop, which is why pre-scheduled social media content should be your new best friend.

To make social media content easier for companies to plan and schedule across the accounts they manage, we created a social media content calendar template. And, we’re always updating this template to help you share your content strategy at a tactical level.

But first…

What is a content calendar?

A content calendar organizes your publishing schedule by date so you can keep track of deadlines, better manage your content creation team, and create transparency with all parties.

What’s in this content calendar template?

Every content calendar is different and should be adjusted for your unique process. However, in this one, you’ll find a general schedule tab, your monthly planning calendar, a repository for website content, and updates for each of the top social media platforms:

• Twitter
• Facebook
• LinkedIn
• Instagram
• Pinterest

The great thing about this template is that as new social media platforms become popular and part of your content strategy (looking at you Tik Tok and Clubhouse), you can simply copy the spreadsheet and repurpose it for that new channel.

This blog post will walk you through exactly how to use the template to stay on top of your social media content planning for each channel.

Note: HubSpot customers can also schedule content through HubSpot Social Media Management Tool, or use this spreadsheet to organize their content and subsequently upload it to Social Inbox. Detailed instructions for doing this exist in the cover sheet of the template.

How to Use the Social Media Calendar Template

When you open up the social media content calendar template, you’ll notice the bottom of the Excel spreadsheet has several different tabs, most of which are dedicated to a specific social network.

The reason you’ll want a different worksheet for every social network is simply because each one is a little bit different. You can’t just craft one, single social media update and use it across LinkedIn, Facebook, Twitter, Instagram, and Pinterest.

Why?

A few reasons. Image sizes vary across all platforms, the types of content that work well on Facebook might tank on Twitter, and external links are great for Twitter but nearly impossible to use effectively on Instagram.

You can certainly promote the same piece of content across those networks, but that doesn’t mean you’ll craft your update the same way for every single one of them. (In fact, you may even want to add additional tabs if you’re active on other networks, like Quora or YouTube.)

The following subsections will show you how to fill out each of the tabs you see in this template — the updates for Twitter, Facebook, LinkedIn, Instagram, and Pinterest. But before we get to that, let’s start with the Monthly Planning Calendar.

Monthly Social Media Schedule

The tab Monthly Planning Calendar provides an overall snapshot of your monthly social media campaigns. It’ll help you coordinate with other stakeholders, not to mention keep all the moving parts aligned in your own mind. Here’s what it looks like:

There are three sections to take note of when you edit this template. First, the color-coding key: These are the types of content or campaigns around which you might coordinate, like ebooks, webinars, blog posts, product launches, and so on. Though only some of these might be relevant to you, they’re just the beginning of what you may want to put in there — so be sure to add and remove categories to align with your own types of content.

The other two sections you’ll need to edit are the Month and Year at the top of the calendar, as well as the cells below each day of the week. In those cells, you should enter the type of content you’ll be promoting that day and color-code it to align with the campaign it’s supporting.

Instead of deleting all the content in this spreadsheet each month, I recommend copying this worksheet twelve times over, and creating a separate sheet for each month. (If that gets to be too overwhelming, you can always save those tabs as a separate workbook.)

Planning Your Social Content Calendar for Twitter

Alright, now let’s get to the social media content part of the calendar. This section will be the longest because all subsequent sections will draw on the instructions we go through here. So, if you only read one section in this whole post, make it this one.

Let’s say you want to add some tweets to your scheduling template. Scroll over to the Twitter Updates tab in the content calendar spreadsheet, where you’ll see this:

The first four columns, Day, Date, Time, and Date & Time are there for your convenience, and if you choose to use a third-party app for pre-scheduling your tweets (like HubSpot’s Social Media Management Software), then these columns will be useful. For now, just fill in the date for when you’ll publish updates to Twitter, and the time at which you’d like them to go out. The Date & Time column will automatically change based on what you input in the previous two columns.

Now, let’s move over to the Message column. Here, input the copy you’d like to appear in your tweet, bearing in mind you should cap it at 116 characters to allow enough room for a link, and at 115 characters to allow room for an image. (Read this blog post for a full character count guide.) This spreadsheet will auto-calculate the number of characters you’ve entered to keep you on-point, turning yellow when you’ve reached 95 characters, and red when you’ve reached 116.

After you’ve composed your tweet, paste the URL you’d like to include in your tweet in the Link column. Be sure to include UTM parameters so you’ll know whether all of these tweets are actually driving traffic, leads, and customers. This is an important step to remember if you’d like to demonstrate ROI from social media. You can also use the Campaign column to add an associated campaign which helps with more detailed tracking and reporting.

Finally, in the Image column, attach the tweet’s image (if you have one). For Twitter, we recommend images that are 1200 x 675 pixels. (Click here for a full cheat sheet of social media image sizes.) If you’re having trouble attaching your image to the spreadsheet, follow these steps:

Step 1: Right-click the cell in which you’d like your image.

Step 2: Click Hyperlink, then click the Document button, and finally, click Select to choose your image.

Step 3: In the Choose a File window, select the image from your computer and click Open.

Step 4: You’ll now see the image attached to the Insert Hyperlink screen. Feel free to edit the Display text to change the file name, then click OK.

Note: This process is simply for organizational purposes. If you decide to upload the spreadsheet to your social media publishing software, it will not attach — you’ll have to do that with your marketing software. If you’re a HubSpot customer, details for how to bulk upload your Twitter content to the HubSpot Social PublishingTool can be found within the downloaded template.

Planning Your Social Content Calendar for Facebook

Now, let’s talk about how to plan your Facebook marketing content with this template. First, navigate to the tab in your template labeled Facebook Updates.

Facebook updates work similarly to Twitter updates with the exception being bulk uploading your content is not possible in HubSpot’s Social Publishing Tool.

The first three columns, Day, Date, and Time are there for your convenience. Scroll over to the column labeled Message and input the copy you’d like to appear in your status update, corresponding to the days and times you’d like those updates to run. Then, move to the Link column and input the link you’ll be, you know, linking to in the update. (Don’t forget that UTM parameter.) If you’d like the update to be tagged to a certain campaign, include this in the Campaigns column. Finally, attach an image just like you did with your Twitter updates — if you’re using one, we suggest you edit it to be 1200 x 628 pixels. (And here’s that full cheat sheet of social media image sizes.)

Planning Your Social Content Calendar for LinkedIn

LinkedIn updates are the most unique, because you have both Company Pages and Groups to consider. To demonstrate the difference between Company Page updates and Group updates, let’s navigate over to the column labeled Title (For Group Discussions Only).

LinkedIn Groups let you post a few kinds of updates, one of which is called a Discussion. You will only fill out the Title (For Group Discussions Only) column if you’re looking to post a Discussion to your LinkedIn Group — because Discussions are the only update you’ll be posting that requires a title. If you’re not posting a Discussion to a LinkedIn Group, you don’t need to fill out this field, because your update will not have a title.

You’ll fill out the next column, Message, for every type of update you post, whether it’s for a Company Page or for a Group. Simply enter your copy into this column, and then navigate to the next two columns, Link and Campaign. Here, you’ll input your URL with its UTM parameter that you’ll use to track activity, and the associated campaign if one exists. If you’d like to use an image for an update, attach it per the instructions laid out in the Twitter section. We recommend editing the image to 900 x 600 pixels.

Planning Your Social Content Calendar for Instagram

Now, let’s move on to setting up your Instagram photos and videos. Scroll to the tab in your template labeled Instagram Updates.

Instagram updates work similarly to Facebook updates in that content can’t be uploaded in bulk to the Social Publishing Tool — like it can with Twitter.

The first three columns, Day, Date, and Time are there for your convenience. Head on over to the column labeled Message, and input the copy you’d like to appear in your post’s caption, corresponding to the days and times you’d like those updates to run. Keep in mind that although Instagram captions can be up to 2,200 characters long, they cut off in users’ feeds after three lines of text. The exact length of these three lines depends on the length of your Instagram handle. (Read this blog post for a full character count guide.)

Next, move to the Link for Bio column and input whichever link you plan to put in the bio when you publish the accompanying Instagram post. (The reason you’d put a link in your bio and not the photo caption is because clickable URLs aren’t allowed anywhere except the single website box in your bio.) Oh, and don’t forget the UTM parameter.

If you’d like the update to be tagged to a certain campaign, include this in the Campaigns column. Finally, attach an image just like you did with your other social media updates — we suggest you edit it to be 1080 pixels x 1080 pixels. (Here’s the cheat sheet of social media image sizes.)

Planning Your Social Content Calendar for Pinterest

Alright, now let’s go over how to set up your Pinterest pins in advance with this template. Navigate on over to the tab in your template labeled Pinterest Updates.

Pinterest updates work similarly to Facebook and Instagram updates in that content can’t be uploaded in bulk to HubSpot’s Social Publishing Tool — like it can with Twitter.

For your convenience, we’ve added Day, Date, and Time columns, but you can skip them if you don’t need them. Next, go to the column labeled Message, and enter the information for the pin’s description. Then, scroll to the Link column and add the link you’ll be including in the update. (And seriously, don’t forget the URL Parameter.)

If you’d like the update to be tagged to a certain campaign, include this in the Campaigns column. Finally, attach an image the same way you did with your other social media updates — we suggest you edit it to be 222 pixels x 130 pixels for thumbnail posts and no more than 600 pixels wide (Pinterest length is scaled so you can make your post as lengthy as is reasonable for your audience.)

Content Repository (Or, Where to Source Social Media Content)

This template also provides you with a tab called Content Repository, which should help you keep track of all your content and maintain a healthy backlog of fodder to make sourcing social media content easier.

As you create more assets, you’ll likely want to resurface and re-promote those pieces down the line, too. To ensure you don’t lose track of all of that content, record it on this tab so you’re never at a loss for what to publish on social. If the content you’re promoting isn’t evergreen, be sure to include an expiration date in the column marked Expiration so you don’t promote it when it’s jumped the shark.

This tab will also help you maintain a healthy balance of content: A mix of your own content and others’, a mix of content formats and types, and mix of lead generation content vs. MQL-generating content vs. traffic-friendly content.

Components of the Social Media Content Calendar

Perfecting your social media content calendar doesn’t have to be a chore. With these essential components, you’ll have a foundation to organize your social media strategy at a tactical level.

Key

As you noticed in earlier sections, your stakeholders appreciate having an easy-to-read key that they can use to understand the information in the calendar. We’ve color-coded our example here, but you don’t have to go that extra step if you have fewer channels and types of content to differentiate between. As long as your key is clear, virtually anyone in your organization can view your social media content calendar and understand exactly what’s happening on all platforms.

URLs and UTM Parameters

We’ve harped on these UTM parameters throughout this post for good reason. They’re critical to tracking the success of your campaign — otherwise you won’t know what’s working and what isn’t.

URLs and UTM parameters are similar, but they’re not the same things. URLs are the links you’ll want to share from your website (or even another website if you’re curating content) on your social media platforms.

On the other hand, a UTM parameter is an extension of your URL. It’s a string of tracking code that’s appended to the end of the URL and it helps social media marketers track how well their posts are driving traffic to their website. By tracking and analyzing UTM parameters, you’ll be able to see what content is meeting your conversion goals and what content is better for engagement on social media platforms.

Date and Time

If you have stakeholders or other teams that rely on your social media content, you’ll quickly see the benefit of including dates and times in your social media calendar. When teammates can view the calendar and identify exactly when a post was or will be scheduled, they’ll be able to quickly proceed with their workflow which is beneficial for you, too. You won’t be interrupted as much to give status updates on every Tweet that’s on the docket for the day.

Message

Transparency and context are invaluable when it comes to social media content calendars. Giving a brief synopsis of the message or even sharing the caption for a post can go a long way in helping others within and outside your team understand what the intent of the post will be.

Pro tip: if you’re adding a video to your social media content calendar that isn’t finished, consider adding a short Loom video that gives an overview of what the video will be about.

Campaign

When it comes to tracking, it’s too late to start when the campaign is over. Start tracking your social media campaigns in your content calendar. You can make this prescriptive by having a dropdown list of predetermined campaign names, or if your campaigns are few and far between, simply copy and paste the names next to the corresponding content.

Pro tip: Align your campaign name with the campaign section of your UTM parameter for seamless tracking.

Image

Your social media content calendar will become just another spreadsheet without some imagery. Since much of your social media content will probably be visual, add a thumbnail-sized version of the image that will be included in the published post. Coupled with the message, stakeholders who view the calendar images will have a pretty good idea of what will be shared and when. To make editing your images for each platform easier, check out this cheat sheet for ideal image dimensions on each platform.

Don’t Forget to Interact With Your Followers

Whether you use this spreadsheet to plan your content or upload it to a third-party app, you’ll still need to supplement these updates with on-the-fly content. Breaking news hits? Whip up a quick update to share it with your network. Someone in your network tweets something interesting? Give it a retweet with some commentary. Got a fascinating comment on one of your updates? Respond with a “thank you” for their interaction or an additional follow-up comment.

Coming up with and scheduling your social media content in advance is a huge time-saver, but it should go without saying that you still need to monitor and add to your social presence throughout the day.

Finally, we encourage you to experiment with your social media publishing. This template provides publishing dates and times for each social network, but you may find those are way too many updates for you to fill, or perhaps too infrequent for your booming social presence. If this is the case, you should adjust your social media publishing frequency as needed. Now that you’ve got the ins and outs of a social media content calendar, download the one below for free and start planning your content.

Editor’s note: This post was originally published in January 2020 and has been updated for comprehensiveness.

from Irvine Business Signs https://ift.tt/2j637rw
via Irvine Sign Company