Digital Marketing, Resources, Social Media

How To Plan Your Daily Social Media Posts Fast, Easy and Efficiently! (Free Spreadsheet)

(Last Updated On: January 19, 2019)

Daily Social Media posts planning could easily turn into a huge mess

What to publish today? But did I publish it already yesterday? Should I post a link or a photo this time? Should I be publishing this more intensively? Am I posting too much on this channel? What about my UTM codes.. am I setting them consistently and correctly?

If you have found yourself in any of the above mentioned situations, then I believe my new social media posts planning template will help you out!

A few months ago I shared with you a similar version of this resource. The feedback was great, however, after I used it for a while, I realized it can be improved so that it increases my efficiency and productivity even more.

That is why I am happy to share with you, the new and improved daily social media posts planning template:

Click here to access the Daily Social Media Posts Planning spreadsheet.  (Say thank you for sharing this blog post on Twitter or liking my Facebook page!)

What’s Inside The Daily Social Media Posts Planning Spreadsheet?

Below I have listed the columns from the spreadsheet and their purpose.

When Will The Post Be Published

The first three columns are:

  • Month;
  • Date;
  • Time;

Although all of these columns are rather self explanatory, here is why I have included them:

Month and Date (Day of the Month) are in separate columns so that you can simply duplicate the sheet and have a separate sheet for each month of the year by simply changing the values of only one column.

“Time” is the time of the day for when you would like to plan and publish your post.

I have pre-entered sample “time of the day” values.

However, I would advice you to customize it to your own needs and based on your experience post performance during different hours of the day.

Post Type And Category

The next two columns are:

  • Category;
  • Post type;

I love both of these columns because they help me manage to publish different types of posts, serving different purposes.

In “category” you can either categorize your posts, for example “product post” “giveaway post” “fun post” “news post” etc. or you could categorize them by their purpose: “sell” “entertain” “educate” etc.

Post types is where you can fill in whether the post will be a link, a photo, video, presentation, infographic and so on. I really like this one, as it motivates me to publish different types of posts, instead of my posts being only “links”.

The Post Elements

The next four columns ares:

  • Media;
  • Link;
  • Post Caption;
  • Copy length;

In the “media” column you can enter the file name of the image or video you would like to use in your social media post.

I usually have all my media in folders on my computer, so this column helps me distribute them evenly throughout the month. And thus avoiding the risk of posting the same visuals too frequently.

The link column is where you will fill in the URL that you would like people to click on in your post.

The post caption is the copy you will use for your post. And the “copy length” column right next to it will count the characters used in the copy.

For most social media (besides Twitter where the maximum characters allowed are 140) there are no specific character limitations. However, it is always good to know how long your post captions are.

Most social media managers tend to avoid publishing posts with too long captions. For other social media experts longer posts work a lot better.

Check out these practices for crafting successful social media posts.

Important: UTM tagging

The last 6 columns are for campaign tagging.

The first column called ” campaign source (social media channel)” can be used just to give you a hint for which social channel you are planning your posts.

However, the rest of the columns, I would advice you not to use unless you have experience with UTM codes or you read Annielytics comprehensive guide on campaign tagging

The formula used for the UTM code creations is adapted from Annie Cushing’s formula that you can find here.

>>>>Click here to access the Daily Social Media Posts Planning spreadsheet<<<<. (Let me know you got it by sharing this blog post on Twitter or liking my Facebook page!)

How To Fill It In?

Your daily social media posts need to support your weekly, monthly and annual goals. Thus, they need to support your weekly and monthly campaigns and your general strategy.

That is why, before I start planning my daily posts, I always first have my general monthly content plan ready.

If you are looking for ideas on how to properly plan your content, you can take a look at my free to download 2017 social media content calendar spreadsheet, my 2018 campaign and content planning template and the 2019 marketing campaign planning spreadsheet .

Having a general monthly content strategy will help you avoid publishing posts blindly.

Your posts always need to have a clear purpose and KPIs!

Once you have your monthly content plan ready, you can start filling in the daily social media post planning spreadsheet.

I usually start with planning out the posts for my most important campaigns or projects.

Social Media posts planning template - Categories distribution - DoraSeeks

I pick the best time slots (day of the week and time of the day) for my most important posts.

Then I continue with filling in the rest of the posts by category. And I always use color coding.

I do it by first filling in the column for “post categories” for the full months.

Then I continue with planning out the different “post types”  to ensure I will be posting different kinds of posts throughout the day, the week and the month. I usually do this by filtering out each post category separately.

Social Media post types planning - DoraSeeks

Afterwards, I start planning the specific media that I will use.

One I have all of these ready, I start adding the links and copies I will use. Last but not least, I always use UTM codes to track and evaluate my social media efforts easily in Google Analytics.

Click here to access the Daily Social Media Posts Planning spreadsheet. (Let me know you got it by sharing this blog post on Twitter or liking my Facebook page!)

Tools You Can Use To Easily Schedule Your Social Media Posts Across Many Channels

Once you have your social media posts planned for a period like a week or a month, you can start scheduling them.

On Facebook and Twitter you can schedule your posts without using a third party tool. On Facebook you can use the “Publishing tools” tab, and on Twitter you can use TweetDeck.

Luckily for us all, there are many third party tools that can be used for scheduling posts across all major social media networks.

Two of my favorite such tools are:

  • Buffer – it has a free plan with limitations (you are allowed to have connected one account per social media, and you are only allowed to have up to 10 scheduled posts)
  • HootSuite – it has a free plan with limitations ( you are allowed to connect only three social accounts)

Although I love both of these tools, HootSuite won me over with the social listening features it has.

Other Free Templates and Resources For Marketers

Don’t forget to follow me on social media or share this template with your followers by using the social sharing buttons below.

If you would like to stay tuned for the upcoming marketing templates and spreadsheets, make sure you subscribe to my monthly newsletter.

Thank you for reading!

-Dora

Spread the word!

8 Comments

    1. Hi Marie, thank you for liking my Facebook page. I have sent you the Daily Social Media Posts Planning spreadsheet via email.

      Happy planning!
      Dora

Leave a Reply

Your email address will not be published. Required fields are marked *