social media how toDo you want a better way to plan, organize, and publish your social media content?

Looking for a solution that doesn’t cost a lot of money?

In this article, you’ll discover how to set up a social media content calendar.

How to Create a Social Media Calendar: A Template for Marketers by Sandra Clayton on Social Media Examiner.

How to Create a Social Media Calendar: A Template for Marketers by Sandra Clayton on Social Media Examiner.

#1: Set Monthly Social Media Goals

It’s important to set an end goal for every piece of content you share on social media so you can track what’s working, which types of content drive your bottom line, and what to change based on campaign performance.

For most social media marketers, goals fall into the categories of generating more leads and sales. If you work backward from your long-term goals, you can create short-term goals that will help you achieve them.

The key to short-term goals is to start small, be specific, and set a realistic time frame to achieve each goal. At the end of each month, you want to be able to track your growth, see what worked, and set new goals for the future. Smaller goals generally fall into one of these categories:

  • Content
  • Followers
  • Traffic
  • Subscribers
  • Sales

Decide what you want to achieve for each category on social media and add it to a goal-setting spreadsheet.

track social media goals spreadsheet

#2: Decide on a Content Mix for Your Social Channels

The purpose of a social media calendar is to provide a framework for sharing content that resonates with your audience and also sells your business. Before creating your calendar, plan content around specific campaigns and goals.

First, determine the types of content that make sense for your business and audience. Some common categories include:

  • Blog posts
  • Quotes and motivation
  • Product promotions
  • Holidays
  • User-generated content
  • Events and announcements

Depending on your business, your categories may look different and can be as broad or specific as you need. For instance, a health club might have categories like free trials, challenges, workout videos, workshops and clinics, recipes and nutrition, and others.

Once you’ve chosen your categories, create a separate spreadsheet to use as a working library so you can plan and gather the original content, products, events, and promotions you plan to share. It’s helpful to color-code each content type so you can easily differentiate them on the calendar.

social media content planning spreadsheet

Include publishing dates, post descriptions, URLs, images, action items, campaigns, and any other details needed for your workflow. If you have weekly or monthly content themes, add a column to the left of the spreadsheet and include your theme.

I recommend you manage user-generated content, RSS feeds, and Feedly subscriptions with a tool such as SmarterQueue (shown below), and use the social media calendar to plan original content, images, and timely promotions that require extensive preparation and coordination. Use the same color codes for each category in your scheduling tool.

SmarterQueue app categories colors

Plan your content on or before the first of each month. Throughout the week, you can fill in by creating content, designing images, manually sharing posts, and adding them to your scheduling tools.

#3: Create the Calendar

You can either create your calendar manually or download this social media calendar template to start using it right away (navigate using the tabs at the bottom of the sheet).

To create your calendar manually, log into Google Drive and click New to create a new spreadsheet. Then click the title to rename it.

social media calendar create new Google spreadsheet

Now you’re ready to customize the spreadsheet and create your calendar template. Because you’ll be working with seven columns (for the seven days of the week), delete columns H-Z. Then select columns A-G and drag the right edge of the selection until the columns fill the screen.

Next, highlight the cells in the first row and select Format > Merge Cells > Merge All. Enter “Month” as a placeholder on your template.  Customize the font style and center the text.

social media calendar merge cells

In the second row, enter the days of the week, beginning with Sunday. If you want, you can freeze these two rows so they remain in view at all times. To do so, highlight the two rows and select View > Freeze > 2 Rows.

content calendar freeze view

In the next row, enter calendar dates. Then select the top three rows and use the border tool (from the top toolbar) to add a bottom border.

Next, add your social media profiles to each date; leave one or two rows between each profile to accommodate your posting frequency. Then select each column and add a right border.

social media calendar add right border to columns

Leave a few extra rows, and add a bottom border to the last row in week one. Then copy week one, change the dates, and complete the calendar template.

social media calendar template

#4: Add Content to Your Calendar

Now that you’ve created your calendar framework, choose the specific days to share each piece of content. Using your same color-coding scheme, add the content from your working library.

social media calendar add content

Customize the calendar to suit your posting frequency. For instance, you may want to include specific times you plan to share each post, or add email and other distribution channels. You might use the additional rows for each day to highlight important events and promotion dates.

If you regularly share the same content on each profile, you may find it helpful to use a simple color-blocked version of your calendar so you can quickly see what pieces of content you plan to share each day.

social media calendar color coding

If you publish a large volume of content each month, it may be helpful to create separate calendars for each social media profile.

#5: Create, Schedule, and Publish Your Social Media Posts

Now that you’ve planned out your content on your calendar, it’s time to research and gather your content, create blog posts, and design images. If you struggle to find the time to execute your social media plan and create the content you need, the tools below will help.

Build Content With PromoRepublic

PromoRepublic is a social media content builder with more than 6,000 templates created by designers, writers, and other industry professionals. This tool lets you create stunning visual content to post to Facebook, Instagram, Twitter, and LinkedIn with the click of a button.

Choose content from PromoRepublic’s extensive library of visuals. In a matter of seconds, you can publish posts that would normally take hours to brainstorm and create.

PromoRepublic pricing starts at $9 per month for up to five social profiles.

PromoRepublic gallery of visuals

Design Graphics With RelayThat

RelayThat is a graphic design platform that makes it easy for non-designers to create beautiful images.

Use the one-click resize function to quickly choose a tall, wide, or square template. Then select a background and add your logo and text. The remix feature lets you rapidly change the position of your text until you find a layout you like.

RelayThat choose graphic template

Check out this tutorial on how to use RelayThat.

Manage Content Creation With Trello

While your Google Docs calendar provides a framework for planning your content, Trello is a great visual tool for managing the content-creation process; it’s like a whiteboard for content.

In Trello, lists are categories and cards are individual pieces of content. You can move cards from list to list, color-code your cards to match your calendar, and add images and descriptions to your cards. Setting due dates for cards will automatically place them on the Trello calendar.

Even the free option is useful for businesses and organizations, and you can easily share boards among team members.

Trello manage social media content creation

Schedule Content With SmarterQueue

SmarterQueue is a go-to scheduling tool, both for sharing evergreen content and user-generated content. It lets you share content from any feed, whether it’s a favorite source, RSS feed, Pinterest feed, Facebook feed, or competitor feed.

If you use Feedly, you can import your Feedly OPML file into SmarterQueue and arrange bookmarks in the left sidebar.

SmarterQueue import Feedly bookmarks

To schedule Feedly content, add a user-generated content category to your social media schedules. Then click the Add Content tab in the top menu and select the piece of content you want to share.

SmarterQueue is an evergreen scheduler and will automatically set your post to recycle. Be sure to select One-Time Post instead.

#6: Track the Dates You Share Content to Your Social Profiles

Now that you’ve planned the content you want to share each day, it’s important to follow through and ensure that you share it.

Use a spreadsheet to track when and where you’ve shared content on each social media channel. The tracking sheet will also help coordinate content promotion with your team. Use notes to add tweet text and descriptions for each post.

social media promotions track on spreadsheet

The promotion spreadsheet is also helpful to keep track of older posts that you’d like to share with any new social accounts.

Conclusion

Using a social media calendar will help you plan your content around smart social media goals and coordinate with campaigns and blog content to achieve them. If you use the tools mentioned above to create and share high-quality posts at the right time on each channel, you’ll likely see better results from social media.

Remember to monitor each channel for engagement and reply to fans and followers daily. Check the analytics of each platform to see what pieces of content resonate with your audience and use that to inform future marketing campaigns.

What about you? Do you use a social media calendar? What methods do you use for creating and scheduling social media posts in advance? Please share your thoughts in the comments below.

Tags:

Get Social Media Examiner’s Future Articles in Your Inbox!

Join 450,000+ of your peers! Get our latest articles delivered to your email inbox and get the FREE Social Media Marketing Industry Report (49 pages, 77 charts)!