This page shares One Community’s open source and replicable annual social media strategy. It shares how to replicate our strategy, how to use it as a template to create your own, and how to contribute your own strategy. We discuss all of these with the following sections:
NOTE: GoogleDocs and GoogleSheets work best with the GoogleChrome browser. If something described below isn’t working for you, start your troubleshooting by making sure you are using the GoogleChrome browser. If you find you are still having problems, Google Search for the solution to your specific problem or challenge.
This open source social media strategy is purposed to provide a tool and content for world-change individuals and groups involved in, desiring an easy way to contribute to, and/or wanting an easy starting place for positive global change. It is open source so it can be used and/or added to by simply copying the existing template (instructions below) and modifying it and/or adding to it as desired. It is also designed to be easily sortable (click for instructions) so people can easily access the types of content they are most interested in. Lastly, it is designed with clear organizational statements at the top for easy review of the values of each organization and the structure of each organization’s strategy to make finding agreeable content as easy as possible.
As an all-volunteer organization working towards a better world for everyone, we spend an immense amount of time vetting and then sharing content we feel is supportive of positive global change. This content is a combination of our own work, positive industry developments, articles by and about other world changing organizations, articles about sustainable products, etc. Some of this content is timely and only shareable once, much of it though is high enough quality (and timeless enough) to share annually.
We created a template to make organizing, sharing and resharing, and management of the complete process simpler and more efficient. Using and sharing this open source strategy we can:
Once something is added to our annual strategy, it is there to be shared year after year until we have a reason to remove it. The more we develop it, the more great ideas and organizations we support and the more useful it becomes for us and anyone else interested in using it too. The more others contribute, the better it becomes for everyone. Our hope in creating this is that we’ve made something immediately usable by anyone interested in having a comprehensive, forward-thinking, and immediately ready to launch social media strategy.
This open source strategy is meant to simplify the process of providing ongoing and quality social media content. It supports forward-thinking ideas and organizations, is replicable in whatever way works best for others, will evolve indefinitely with the work and research we and others are already doing, and should save time for anyone who decides to use it. We discuss how to use it with the following sections:
Once you’ve accessed the social media template, the following outline and description of sections will help you to understand and use it.
The first and most important thing to realize is that you can easily make a copy of the document so you can edit and modify it however you like. To do that, use the “File” dropdown in the top left corner of the page (right under the page title) and choose “Make a copy…”.
The picture (at right) shows what this dropdown looks like, how it can be found right below the title of the GoogleSheet, and where you’ll find “Make a copy….” in the dropdown once you’ve clicked on it.
Next is understanding how the content is organized. Columns on the left include the dates that items are scheduled. To the right of that are times spread out throughout the day for posting. Then comes the text we’ve written for the post, then the associated link, post-category the post falls into, a column for indicating if the post has been posted or scheduled to post, and last is the post-type the post falls into.
Here’s a summary from left to right:
Once you’ve made your own copy, you can sort by any one of these columns.
At the top of any tab is where you can get to know the strategies for an organization. The purpose of sharing the specific strategies used is to help a person understand the organization who created the strategy, their goals, and selection process used when deciding whether or not something should be added to this annual social media strategy.
Tabs at the bottom are where you can select and review the different strategies from anyone who has created and submitted on that has been improved. The tabs for making these selections look like this:
The posting Dates and Times include every day of the year and at least 7 different post times for each day. These are spread throughout the day, based on research for the best Pacific Standard Time times to post content in the United States, and slightly different for each week.
For creating your own strategy, you can use our times or make up your own.
On the top right of the sheet are 4 columns that indicate the different post Categories and Types. The ones we use are shown here. The two columns on the left are the Categories of the posts we create. The two columns on the right are the Types of posts we add. See the “Sorting” section for how to sort by these Categories or Types.
Once you understand each column, sort the entire document using whichever column is of interest. You do this by right clicking on the column top and choosing “Sort sheet A–> Z” or “Sort sheet Z–>A.”
From left to right, here’s why you might want to sort by each column:
In addition to sorting for what you want. You can also use the “Find” function to find a specific word, URL or part of a URL, Type, Category, etc. To use the “Find” function, just click on any cell in the document and then press Command (Mac) or Control (PC) + F. This will open up the “Find in sheet” option where you can type in whatever you are looking for and then hit “Enter” to bounce through all the instances found on the page for your search term.
This open source social media strategy is also meant to be contributed to and expanded with the strategies of others. Through this open source template, our hope is that more and more forward-thinking and progressive world-change organizations will create and add their social media strategies sharing their own work and the work of others. The more it grows, the more we can all support each other by using these strategies to add to and further develop our own.
With this in mind, if you use our GoogleSpreadsheet as a template to create your own strategy and would like your strategy added to the template, use our Contacts Page to let us know. We’ll then review it to make sure all the sections are filled out and complete. If they are, we’ll copy your tab to the main GoogleSpreadsheet using the “Copy to…” function shown at right.
Benefits for you doing this are primarily these two:
One Community initially created our social media template to make organizing, sharing and resharing, and management of the complete social media process simpler and more efficient. We already spend a lot of time each week managing our social media accounts and we realized many of our posts could be reposted year after year to support our organization and many of the others we share about too. By open sourcing it all, we hope to help and save others time too while also inviting others to contribute their own strategies to further help us, them, and anyone else viewing the template.
Q: What if I’d like to contribute my own social media strategy to the open source template?
Great! Just follow the instructions in the Contributing to the Social Media Template section.
Q: What if I don’t like something in the existing social media strategy?
You can delete and/or change whatever you want once you make your own copy using the instructions in the Making Your Own Copy section.
Q: How do I understand how One Community’s (or any included organization’s) social media strategy is created?
At the top of each social media strategy is an overview of the person or organization that created it and what they include.
Q: What if I want to take parts from different social media strategies? How do I do that?
To do this, use the instructions in the Making Your Own Copy section of this page. Then follow the instructions for Sorting for What you Want. From there, just copy and paste what you want into your own strategy.
Q: What if I make a copy and then do something wrong?
You can revert a GoogleSpreadsheet (or Doc) to any past point in time like this:
Q: Why are there so many columns in the strategy?
This is so the entire strategy can be sorted by each of those columns. This allows for easy finding of duplicates, certain types of posts, etc.