For the past two-plus years I’ve taken part in an hours tracking time study for work. The first year of the study was organization-wide, while the second included a few employees who were either new…
Download Spreadsheet Here
Given that Facebook reach is down, measuring your content and engagement here is really important. Here’s some great tips from Mari Smith that identify what aspects of your content or FB presence you should measure. These are great for designing controlled experiments.
Whether you pay to play or focus on content that resonates more with your fans, you want to measuring what works here.
Mari Smith: Tips on What To Measure
How To Do Controlled Experiments on Facebook
Here’s a mini-case study about using Google Calendar as part of your editorial calendar to manage content.
I think you need a suite of tools that mimic professional content management tools. The google calendar is not enough. It is great for coordinating content and reminding content, but I believe you also need a trusty spreadsheet of this information that also includes your metrics so you don’t forget to link your data to actual decisions.
The ideal editorial calendar suite might include:
1: Google Calendar: To coordinate content creation, posting with a team of people and for reminders.
2: Google Spreadsheet: To help you plan the month and it should also include columns for metrics.
3: Google Documents: To serve as an idea dashboard - where you come up with ideas for your content from meetings and archive potential ideas.
You also need a set of content curations tools to help you with curated content.
Blog post and Excel download: http://www.bobangus.com/free-editorial-calendar-template/
Another Excel template to download.
This awesome spreadsheet comes from the Community Foundation of Santa Cruz. It is used to track the progress of their blog against goals of increased traffic, subscribers, and engagement on a monthly basis. The spreadsheet was inspired by another organization, Compass - both are participants in my “Measuring the Networked Nonprofit” peer learning group.
Extra credit for their visualization of the results too which was done with extreme customization of the charts feature in Excel.
If you want a copy of this spreadsheet, it’s here
HSUS Social Media Report Template
This is the report template that the Humane Society of the US uses for every social media infused campaign. It summarizes the top line metrics, results, and what could be improved for every campaign. It is developed by a cross-disciplinary team that meets to look at the spreadsheet and a report is generated. Then, when they go back to plan a similar campaign, they have these reports to look at what happenned and avoid replicated mistakes in the past.
Download the word document here
This spreadsheet was featured in my book, Measuring the Networked Nonprofit. It is for beginners - to help them plan content, gather two metrics, and make sense of them!
The trick is for beginners to use this for several months and slowly add other channels. The two pre-selected metrics are reach and engagement. The sole purpose of this spreadsheet is to create a good habit of measurement and to understand how content is resonating on one channel.
Download spreadsheet here