Create a social media calendar to help you plan and track your business’ social media activity and never again ask "Hey guys, what goes on Facebook today?"
You will never again ask any of the following questions: "Hey guys, what goes on Facebook today?" "Where do we post this?" "Guys, does anyone remember where we posted that super-funny GIF about our new product?" "Why are we posting only on Facebook?" "Do we even have any other social media accounts?" "Was this approved?" "Who approved this?" "Why is there a monkey eating a banana posted on our LinkedIn?"
Why it matters
All digital marketing efforts should be accounted for. They should be planned, they should be numbered, they should all be aligned with your brand’s
Before you start
Just social media accounts and access to Google Sheets. Patience and diligence are quite great to have too
Key steps
19 steps
What is inside
22 headings
1Environment setup2
Go to the Template 015: Social Media Calendar (web version).
Make a copy of the template to use from hereon.
2Adjust the template to your needs3
Select the range of cells you want to edit.
Go to Data → Data Validation.
Add/ Remove categories as you find necessary.
3Fill in the template14
Publish Date. Self-explanatory, the date at which you want to publish a particular social media update.
Content Type. For the purpose of this example, we added the following options:
Topic/ Title. Add here a general topic for the post, or even a specific title (if you have one).
Content/ Details. What is the content about, and what is its purpose? Add this kind of detail in this cell.
Social Network. Again, this is a drop-down option. For the purpose of this example, we added Facebook, Twitter, Instagram, YouTube, and Pinterest. As mentioned before, you can add more or you can remove from these options if they are not suitable for your social media strategy.
Post Type. This section is very important because it dictates how the post and copy will look. For the purpose of our example, we included the following options:
Content Type. Again, this is very important because it might dictate the tone, style, and length of the copy itself. Our example includes these options:
Copy. Enter the actual copy you will post.
Asset. Copy and paste the asset you will share with the post. If it’s a picture, upload it into the spreadsheet and minimize it to fit the cell.
Link. Add the link you will use in the post, if applicable.
Shortened Tracked Link. If you shorten your links and track them (with a service like Bitly), add them here.
Publishing Time. Self-explanatory. You should add this for further reference, to see what time your visitors are more active.
Approval 1 and Approval 2. If your post needs to be approved before it goes live, keep these columns (or just one of them if it only needs one approval).
Live Link. Add here the live link of each post. Doing this will help you organize better, knowing exactly where each post was published and when.
learn.llmdecode.com