Now That's A Spreadsheet!

@fuckyeahnpspreadsheets

A blog to showcase nonprofit social media, marketing, and measurement spreadsheets and tips.

19 posts

Does your board of directors know how to measure fundraising success? (Hint: Just counting cash this year, although it seems like the way to do it, exposes you…

This is the best nonprofit oriented editorial calendar - and it is free! Get yours now!

Need an editorial calendar to plan out your content? Use this ultimate list to weigh your options.

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

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/

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.

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.

Here's a quick timeline and history of the development of the spreadsheet from "visicalc" in 1979 to Excel to online spreadsheets.

Blog Dashboard Spreadsheet and Metrics Tracker

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

#carielewis #hsus #report template #measurements #AAR

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

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.

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. The 2014 spreadsheet is here.

Social Media Calendar: Concepts and Ideas Across Channels

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

#content calendar #debraasknase

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!

#video #how-to #dashboard #tips

Check Your Spreadsheet Math!

I shared this blog on my FB profile and David Geilhufe asked a super smart question:

If 88% of spreadsheets have serious errors, how do we get folks to take the next step of operating their organizations based on the actual data the spreadsheet should be displaying?

Rebecca Krause-Hardie recommends always cross-checking your formulas and totals as part of the cleaning process.

What about you?

Now That's A Spreadsheet! @fuckyeahnpspreadsheets - Tumblr Blog | Tumgag