![]() ![]() Then, Sort the "INCLUDED" column so that the tags you want to include are listed at the top. By using the Sort feature in Excel and Google Sheets, you can categorize your tags, and mark which ones you want to include. I've found this to be extremely useful for keeping track of the hashtags I want to use for Instagram posts. HASHTAG ORGANIZER: One of the worksheets not shown in the screenshot above is a table for organizing your hashtags. IMAGES/VIDEOS: You can create a shared folder in Google Sheets to store your draft and final images used for your social media content.ĭESCRIPTION LENGTH: Social media posts often prefer a short description, so the Length column uses the LEN() function to count the characters in the Description column. You are unlikely to forget the common holidays, so note that it is the FIRST holiday in the list that shows up on the calendar, and reorder the list as needed.ĬOLLABORATION: To use the content calendar in collaboration with other people on your team, you'll either need to ALL be using Office 365 (to use Excel with real-time collaboration), or you can use the Google Sheets version. However, the calendar view only shows up to one of these events per day. holidays and observances in the Settings worksheet. HOLIDAYS: A lot of social media posts are themed based on upcoming holidays, so that is why our calendar includes some of the common U.S. One of the main things to realize is that you edit the titles, descriptions and dates in the Content worksheet and only use the Calendar worksheet to view the publish dates within a monthly calendar (up to 3 per day). The help worksheet provides some guidance on how to use the spreadsheet. Note: This spreadsheet does not actually schedule your posts to be published. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |