Spreadsheet aerobics is a blog post from Beth that talks about how to measure your Facebook work and experiments. I took her advice, but I am doing it one step at a time.
We have created a set of trainings, materials and steps to rapidly deploy our social media sites. Our first effort is Facebook for our membership centers. Our first goal is to establish our presence and provide the foundation to begin to connect with our members. We want to be where our communities are and communicate with them they want to.
Once we have the basics working, authors trained and a presence established we will work to equip our YMCA staff as authors to begin to create engagement with purpose. But we have to start somewhere, which for us will be creating the presence, training our staff and just getting it rolling!
In that effort, we will just be tracking the basic stats straight from Facebook Insights. Each our Facebook page administrators will download the interactions stats into Excel and send it to us. We will then copy those numbers straight into this report format. Our hope is to be able to show the correlation between those actively interacting on their page with the increase in participation of fans.
Anyway, here is spreadsheet report, based on concepts from Beth Kanter.