By far, the most popular post we have ever published at the Content Marketing Institute is “10 Must-Have Templates for Content Marketers.” To that end, we wanted to provide a refresher on the most …
Great collection here.
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.
This is the editorial calendar spreadsheet to beat all editorial calendar spreadsheets. It covers content across different channels, has a tab for each month, and also includes news hooks for the US based events. It was created by Holly Minch at Lightbox Collaborative. You can grab the 2013 spreadsheet here.
This editorial calendar spreadsheet comes from nonprofit blogger Debra Askanase. It helps you organize your content across channels using themes. It includes a success definition which is where you can add your KPIs or metrics or articulate an outcome statement. I like the column for “User-Generated Content,” but would love to see an example of exactly what that might be? If I were adapt this spreadsheet, I might use color coding in the cells to distinguish between different types of content:
-Curated: Content created by others that is relevant to the theme that you have selected because its quality
-Created: Content that you or your organization has created
-Community-Generated: Content that your community creates. Not sure whether you would track the actual content here or the idea for the call to action.
I would also add another worksheet that helps you identify opportunities to create long-form content from short-form content and crossover content..
From Anne Emery
Here’s one of my favorite things to do with spreadsheets - use VBA code to create a bunch of matching dashboards - without having to copy & paste thousands of times back and forth between Excel and Word. Woohoo for spreadsheets!