Advertising, Communication, Google, Marketing, Productivity, Social Media

Social media content planning made easy with this collaborative Google Sheets template (great for one man schoolPR shops!)

If you’re a one man schoolPR shop, you know how important it is to find ways to work smarter, not harder. One of the easiest ways to do that is to collaborate with key staff members who can help you develop great content. Share the love, right?!

Last summer I developed this Google Sheet and employed the help of our district content specialists, instructional specialists and instructional technology specialists to plan social media content for the summer using the themes below. (I try to update the themes regularly, so you’ll see different hashtags in the document linked above.) It was awesome to have a diverse range of posts and it really made my job a lot easier to have quality, targeted content ready to go.

Motivational Monday
Technology Tuesday
Wellness Wednesday
Thinking Thursday
Focus Friday
Safety Saturday
Stay in School Sunday

It’s no secret that I love all things Google, so a Google Sheet felt like the obvious choice for this task. Plus, it’s so easy to give access to staff who can help me and I know the document is always live and up-to-date. I even built in a little character counter to keep our posts “Twitter friendly.” It’s simple and basic, but it works!!

Do you have a social media content planner that is working for you? Share it in the comments below!

1 thought on “Social media content planning made easy with this collaborative Google Sheets template (great for one man schoolPR shops!)”

  1. Thanks Jessica for a good prompt! I could do with getting my plans in place for social media. We tend to be a little less planned here based on what happened the previous day or when we have space in our diaries. We do not to get more proactice so I am going to share your Google Sheet idea with my team as we have a lot of marketing related areas to cover.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s