New Facebook Measurement Spreadsheet

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
https://www.facebook.com/marismith/posts/10151836686065009


How To Do Controlled Experiments on Facebook
http://www.socialmediaexaminer.com/how-to-test-your-facebook-posts/

1 note

Content Calendar for Alumni Engagement

Here’s a mini-case study about using Google Calendar as part of your editorial calendar to manage content.  

http://darimonline.org/blog/leveraging-internal-editorial-and-social-media-calendar

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.

1 note

Great collection here.

Blog Dashboard Spreadsheet and Metrics Tracker

imageThis 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.

 

image

If you want a copy of this spreadsheet, it’s here

1 note

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

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

2 notes

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 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

1 note

I don’t think I’ll ever see a Facebook editorial calendar that looks like a tree.  Well here ya go.  This one is created by John Haydon.  It isn’t exactly a spreadsheet, but it makes me curious about the how you can create more graphical spreadsheets. You can get your copy here.

I don’t think I’ll ever see a Facebook editorial calendar that looks like a tree.  Well here ya go.  This one is created by John Haydon.  It isn’t exactly a spreadsheet, but it makes me curious about the how you can create more graphical spreadsheets. You can get your copy here.

1 note