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:
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:
- 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:
- 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.
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.
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.
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
- Marketing in 2019 & New Marketing Campaign & Content Planning Template
- 2018 Marketing Campaign & Content Planning Template
- 2018 Social Media KPI Tracking Spreadsheet
- 2017 Annual Social Media Content Calendar Spreadsheet
- Daily Social Media Post planning Spreadsheet – Old Version
- The Complete Social Media Profile Creation Checklist (Downloadable)
- Instagram Post Performance Tracking Template (coming soon)
- Blog Content Calendar Planning Template (coming soon)
- Blog Post SEO Checklist (coming soon)
- Productivity: Weekly Tasks Template (coming soon – meanwhile, you can check out this blog post on productivity – dumb vs. smart productivity hacks 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!